$75.00 USD
Recent updates: Added a fully integrated 3-statement model (monthly and annual), a cap table, and better global assumptions layout.
In order to properly forecast out the cash flows of this lending business, there are various risk grades you can define and within those risk grades there are various avg. term amounts. For simplicity sake, I just put in terms of 3,6,9,12 months but you can enter whatever number you want for that and the model takes it into account.
For each of the risk grades, you can define the average annual interest rate you think they will have (based on investors bidding) as well as average % default rates. This will be fairly arbitrary, but through research you can probably get fairly close on the figures.
All of that is necessary so you can see how much total loan volume your LaaS platform is projected to achieve as well as the gross interest. The template solves for that and then based on whatever % fee the platform takes as a fee from investor interest earned, a net interest revenue line will populate for the platform. You will be able to see granular data for the interest / closing fees generated on each risk grade as well visualizations.
The closing fee % is manually input as well as the % of that fee the platform gets.
One of the more interesting pieces of logic I have added to this is a % of any defaults the platform will cover. This could be 0% if you don't plan on having such logic, but if you do, that would deduct from the platform's gross interest revenue.
One of the more complex pieces of logic I implemented into the financial model is the ability to run sensitivity analysis on 3 of the key revenue drivers (avg. interest rates, avg. loan amounts, and settled loans). You can individually assign a Low, Base, High input for each and determine the magnitude that Low/High will mean for each independently. The benefit of that is that you will be able to set a base case and then with the turn of a dropdown button, adjust all figures up or down for those revenue driving variables.
There is a monthly and annual proforma / cash flow summary that populates based on all the assumptions as well as an executive summary. The executive summary will show how much capital has been required in order to cover all startup/net negative cash flows as well as the IRR of the entire projection.
One of the more in-depth pieces of this model is the control tab. On that, you will choose a given month of exit (if you plan on selling the LaaS platform before the 10th year) as well as financing assumptions and exit valuation assumptions. This all will be in the same area as the sensitivity drivers.
For each of the risk grades, you can define the average annual interest rate you think they will have (based on investors bidding) as well as average % default rates. This will be fairly arbitrary, but through research you can probably get fairly close on the figures.
All of that is necessary so you can see how much total loan volume your LaaS platform is projected to achieve as well as the gross interest. The template solves for that and then based on whatever % fee the platform takes as a fee from investor interest earned, a net interest revenue line will populate for the platform. You will be able to see granular data for the interest / closing fees generated on each risk grade as well visualizations.
The closing fee % is manually input as well as the % of that fee the platform gets.
One of the more interesting pieces of logic I have added to this is a % of any defaults the platform will cover. This could be 0% if you don't plan on having such logic, but if you do, that would deduct from the platform's gross interest revenue.
One of the more complex pieces of logic I implemented into the financial model is the ability to run sensitivity analysis on 3 of the key revenue drivers (avg. interest rates, avg. loan amounts, and settled loans). You can individually assign a Low, Base, High input for each and determine the magnitude that Low/High will mean for each independently. The benefit of that is that you will be able to set a base case and then with the turn of a dropdown button, adjust all figures up or down for those revenue driving variables.
There is a monthly and annual proforma / cash flow summary that populates based on all the assumptions as well as an executive summary. The executive summary will show how much capital has been required in order to cover all startup/net negative cash flows as well as the IRR of the entire projection.
One of the more in-depth pieces of this model is the control tab. On that, you will choose a given month of exit (if you plan on selling the LaaS platform before the 10th year) as well as financing assumptions and exit valuation assumptions. This all will be in the same area as the sensitivity drivers.
A similar template in the lending industry: Loan Tape Analyzer.
- SaaS CFO Dashboard
- Data-as-a-Service (DaaS)
- Function-as-a-Service (FaaS)
- Subscription Box
- B2B/B2C SaaS with 3 Pricing Tiers
- Marketplace
- 5 Tier SaaS Driven by Traffic Conversion
- Freemium
- Customer Cohort Modeling (historical data analysis)
- Marketplace + Subscription
- Product + Service Subscription
- SaaS Pricing and Margin Simulator
- Product-as-a-Service (PaaS)
- Basic 4 Tier SaaS with One-time Onboard Fee Option
- Security Monitoring Service: 3 Tiers
- Ratio-Driven SaaS
- General Mobile App
- Property Management Business
- Professional Services Firm / Talent Agency
- Mobile App / SaaS Ad Spend Guide
- SaaS MRR Calculator
- SaaS Rolling Revenue Forecast
- Ad Network
- Car Wash - With Membership Option
- Private Golf Course - Membership Fees
- Customer Spend Patterns
