Asset Management, Banking, Financial Model, Financial Services, Loans & Lending Businesses, Microfinance, Peer to Peer Lending (P2P)

10-year Financial Projections, 5-year Financial Projections, Accounting, Amortization, Break-Even, Budget, Cap Table, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, Chart, Cost Calculation, Cost Projections, Dashboard, Debt Amortization, Debt Schedule, Debt Security, Debt Service Coverage, Dividends, Excel, Financial Analysis, Financial Debt, Financial Due Diligence, Financial Model, Financial Modeling, Financial Projections, Financial Ratios, Financial Statements, Financing, Forecast, Forecasting, Gross Yield, Hedge Fund, Income Statement, Interest Accrual, Investment Multiple, Investor Cash Flows, Investor Presentations, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Levered Yield, Loans, Net Yield, Private Equity, Pro-Forma, Profitability Analysis, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Uses and Sources of Funds, Venture Capital, WACC (Weighted Average Cost of Capital)

 

Overview

The financial model offers a thorough set of assumptions and outputs necessary when evaluating either the acquisition or raising of a new credit fund.  It provides a thorough output and analysis of a full loan portfolio by breaking it into three segments: commercial, consumer, and existing (if more lending products are needed, they can be added). 

It details the overall fund cash flows, including a full overview of operating expenditures (i.e., headcount, travel, meals, etc.). It breaks out management fees and includes a toggle to value the management entity in addition to the standalone portfolio. It depicts a full ramp-up over time of originations and maps it to necessary capital calls from LPs. In addition to a comprehensive breakout of equity cash flows (i.e. capital calls, distributions, and redemptions), it provides assumptions around a fund-level debt instrument.

Structure

• Input and Output
  • Inputs
    • Waterfall Assumptions
    • Capital Assumptions
  • Company Structure
    • Specialty Finance Deal Structure
    • Existing Portfolio

• Outputs
  • Company Output
    • No Sale Scenario
    • Portfolio Sale After 7 Years
  • Deal Output
  • Annual Rollup of Fund Inflows/Outflows

• Charts
  • Debt-to-Asset Ratio
  • Cumulative Called Capital and Total Equity
  • Portfolio Size by Market Type
  • Total Equity and Total Debt
• Fund Cash Flows
  • Monthly breakout of the fund level cash flows
• Commercial Portfolio
  • Monthly breakout of the loan cash flows from the “commercial loans” product bucket
• Consumer Portfolio
  • Monthly breakout of the loan cash flows from the “consumer loans” product bucket
• Existing Portfolio
  • Monthly breakout of the loan cash flows from the existing or acquired loan portfolio
• Expense Budget
  • Assumption inputs for ramp-up of headcount, salaries, bonuses, benefits, travel, meals, professional expenses, and other miscellaneous expenses.
• Annual Results
  • Annual roll-up of loan balances by segments, total equity and debt, total active facilities, total assets by segment, total commitments by segment, cumulative capital called, and more.

File Types: .xlsx and .pdf