Asset Management, Banking, Debt Fund, Financial Model, Financial Services, General Excel Financial Models, Loans & Lending Businesses, Microfinance, Peer to Peer Lending (P2P)

10-year Financial Projections, 5-year Financial Projections, Accounting, Amortization, Break-Even, Cap Table, Cash Flow Analysis, Cash Flow Projections, 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, Investing Cash Flows, Investment Multiple, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Loans, Pro-Forma, Profitability Analysis, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Uses and Sources of Funds, 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

You must log in to submit a review.