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
- Inputs
- Outputs
- Company Output
- No Sale Scenario
- Portfolio Sale After 7 Years
- Deal Output
- Annual Rollup of Fund Inflows/Outflows
- Company Output
- 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
Similar Products
Other customers were also interested in...
Fintech Financial Models Bundle
Financial technology (better known as fintech) is used to describe new technology that seeks to impr... Read more
Buy Now Pay Later (BNPL) Platform – 5 Year F...
Financial Model presenting an advanced 5-year financial plan for a startup BNPL Platform which provi... Read more
Loan Tape Analysis / KPI Dashboard
A framework that makes it easy to drop in your loan data and automatically generate analytical insig... Read more
Lending Business Financial Projection 3 Statement ...
3 Statement 5 year rolling financial projection Excel model for existing/startup business borrowing ... Read more
Collateralized Mortgage Obligations Model
Collateralized Mortgage Obligations Model presents a simple model where mortgage backed securities a... Read more
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Crowdlending (P2P) Platform – 5 Year Financi...
Financial Model providing an advanced 5-year financial plan for a startup Crowdlending (Peer-to-Peer... Read more
Buy Now Pay Later DCF Model & Valuation (10 Ye...
The Buy Now Pay Later (BNPL) Company financial model is a comprehensive tool designed to analyze the... Read more
Leasing Company Financial Model – 5 Year Forecas...
Financial leasing companies engage in financing the purchase of several types of assets. Though a le... Read more
You must log in to submit a review.