0 ITEMS
Credit Facility Model
The Credit Facility model breaks down the financing structure where consumers borrow against a pre-approved credit line through a credit facility. This includes a third-party lender that provides the credit line through the credit facility. This calculates the credit schedule, lender cash flows and the revenue share to the credit facility.
The Credit Facility model breaks down the financing structure where consumers borrow against a pre-approved credit line through a credit facility. This includes a third-party lender that provides the credit line through the credit facility. This calculates the credit schedule, lender cash flows, and the revenue share to the credit facility.
At the top is the assumptions section that drives the model. Information can be entered in this section, including Credit Line assumptions, Consumer assumptions, Lender assumptions, and Revenue Share. Payback period can be adjusted using the drop-down box associated with each month for variability.
This flows into the next section where the credit schedule is calculated. This amortizes the total credit balance and breaks out the 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 credit facility. From the lender cash flows, the revenue share is calculated. At the bottom of the model, there is the IRR for the lender and the average monthly revenue for the credit facility.
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 ProductsOther customers were also interested in...
Eastwich Advisors
Debt Fund Excel Model
Explore the Debt Fund Excel Model, a comprehensive tool for evaluating new credit fund opportunities... Read more
Giorgos
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
Commercial Bank Financial Model – Dynamic 10...
Financial model presenting an operating and valuation scenario for a Commercial Bank. The model c... Read more
Andreas
Commercial Bank Financial Model
Commercial Banking Financial Model presents the case of a commercial bank with regulatory thresholds... Read more
David
Lending Business Financial Projection 3 Statement ...
3 Statement 5 year rolling financial projection Excel model for existing/startup business borrowing ... Read more
Fintech Financial Models Bundle
Financial technology (better known as fintech) is used to describe new technology that seeks to impr... Read more
Finmodelhub
Comprehensive 3-Statement Financial Model for Bank...
The Comprehensive financial model for Banking is an interactive, flexible, easy to update and unders... Read more
You must log in to submit a review.