The Consumer Loan model Template helps breaks down the financing structure of a bundle of consumer loans absorbed by a lender. This template allows the calculation of the Lender cash flows before and after Senior Debt is paid.
In the top left of the model in the gray area, there is the assumptions section that drives the model. Information can be entered in this section, including Default Rate and Default Recovery, Prepayment Rate, Advance on Senior Loan, and Senior Loan Rate. There are also calculations for IRR before and after Senior loan debt is paid. The first table to the left breaks down the amortization of the collection of loans with the principal paid, interest paid, and amount of defaults based on the assumption. This calculates the total collected by the lender, including any portion of defaults that are recovered.
This flows into the next table where the lender cash flows are calculated. This breakdowns the total collections into interest and principal repaid to the lender. This provides the Lender cash flows for each payment period that is used to calculate the IRR of the consumer loan. This now flows into the last table where cash flow is calculated after any senior debt if present. Since senior debt takes priority, this will reduce cash flow to the lender in this situation. This table is used to calculate the IRR after Senior Debt.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.
Similar Products
Other customers were also interested in...
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
Lending Platform Financial Model (LaaS)
Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (... Read more
Lending Company Financial Model – 5 Year Forecas...
This Financial model template presents a business scenario of a corporation engaged in granting loan... Read more
Lending Model Startup Forecast: 10-Year Scaling &#...
This is a full 10-year startup lending business financial model, including a 3-statement model. Accu... Read more
Flat Fee Lending Business: Operating Model
10-year financial model directly built for a flat fee / fixed fee lender. Includes leverage for orig... 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
Amortization Schedules Template (Loans, Mortgages,...
User friendly template including Amortization Schedules for Loans, Mortgages, Operating and Finance ... Read more
You must log in to submit a review.