The Consumer Loan model breaks down the financing structure
of a bundle of consumer loans absorbed by a lender. This calculates 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 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.

Reviews Add a review
No reviews yet

More From D'Errico Financial Services LLC

Browse our top rated business templates. See All
Multi-Family Housing Rental Renovation Model
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovation and rental of a multi-family housing…
Real Estate Development Model
 The Real Estate Development model projects monthly future cash flows from a development property from the purchase of the land…
Venture Capital Financial Model
The Venture Capital Returns Model is used to provide an analysis into an investment return for a VC fund. This…
DCF Valuation Financial Model
The DCF Valuation Model builds on the 3 Statement model by adding a business valuation component for investment through the…
Private Equity Financial Model
The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model…
Mergers & Acquisitions (M&A) Financial Model
The Mergers & Acquisition (M&A) Model provides a projection for a company looking to potential merger or acquire another company.…
See All