This model goes out 10 years and provides in-depth inputs for a correct and comprehensive projection of a startup Lending platform model where the platform facilitates lending/borrowing between peers.. This type of business model has become populate with the cashless lending user friendliness.
You will be able to adjust various risk grades, loan amounts per grade, avg. interest rates per grade, and % of loan counts falling into each risk grade per a given term (up to 4 term lengths).
There is logic to show an exit valuation at any month within the 10 year forecast as well as IRR, cash requirements, and net cash returns / ROI figures. The model goes as granular as possible but then comes out to a high level view for the primary revenue and expense forecasts.
Sensitivity analysis is possible and you can change up to 3 revenue driving variables to run a low/base/high scenario. The magnitude of how much the base assumption is effected can also be input.
Charts and visuals have also been included to show the revenue share the platform receives from gross interest, closing costs, and/or a coverage of a certain % of defaults. If anything does not apply, you can simply enter a 0 in the field.
Another nice feature is the break even month and break even year for accumulated cash. This includes the pay-back of debt upon exit.
See the overview here: