Asset Management, Financial Model, Investment |
Amortization, Bonds, Debt Amortization, Debt Schedule, Debt Security, Excel, Investors, Mortgage |
The Debt Securitization is the process of packaging debt into a Securitization Vehicle sold to a Fiduciary where it is converted into bonds sold to investors. These bonds are usually sold in tranches with varying pay-out schedules and risk levels. This model goes through the debt securitization process from the initial debt to the bonds sold to investors. The tabs included are:
• Loan Amortization Table
• Mortgage Pass-Through Table
• Sequential Pay CMO with up to 4 Tranches
• Debt Security Valuation using discounted cash flows
In the first tab, you have the Loan Amortization Table where the details of the Originator’s loan are outlined. Here you can enter the terms of the loan such as length, interest rate, and dollar amount. The next tab is the Mortgage Pass-Through, where the debt is bundled into an SPV and sold to a Fiduciary Trust. This breakdown the portion of the mortgage payments that are interest and the pay-out to the investors. There is also a rate allotted for conditional prepayments (CPR) by the originator for the debt. The Sequential-Pay CMO tab models the pay-out to the investors as bonds. This is modeled for four tranches with varied portions of the debt, coupon rates, and different pay-out schedules depending on the risk. Lastly, the Debt Security Valuation is a DCF valuation based on the estimated cash flow of the pay-out to investors. This is set to calculate cash flows for Tranche A by default.
All cells in black font are input cells where custom information can be entered. All cells in blue font are formulas set to streamline the model.
Similar Products
Other customers were also interested in...
Investment Fund Preferred Return Tracker: Up to 30...
Track preferred returns for investors in a fund with this template. Premium joint venture tracking t... Read more
Multi-Family Housing Rental Renovation Model
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovat... Read more
Real Estate Investment Fund – Development Pr...
This model projects monthly future cash flows from development properties in a Real Estate Investmen... Read more
Real Estate Investment Fund – Rental Propert...
This model projects monthly future cash flows from the renovation and rental of a multi-family housi... Read more
Storage Facility Development Model
The Storage Facility Development model projects annual future cash flows from a storage facility fro... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Commercial Real Estate Valuation Model Template
A commercial real estate valuation model template assists in running a professional DCF Valuation fo... Read more
Airbnb Financial Model
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties wi... Read more
Real Estate Portfolio Template – Excel Spreadshe...
The Real Estate Portfolio Template forecasts the financial performance when building a real estate p... Read more
Mixed-Use Real Estate Model: Leverage / JV Options
A general real estate model to plan all assumptions for up to 7 'uses' for a given property. Include... Read more
Reviews
For the price you pay, you’d expect instructions. Also the Prepayment mulitpliers are not linked to the model anywhere. Could be a good model, but without instructions you are just left searching for answers online.
221 of 428 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
-
Hi Bob, I appreciate your feedback on the template and this is something I will look into improving. If you do need any additional assistance with the template, I am more than happy to help. Thank you!
Thank you for your feedback.
222 of 427 people found this review helpful.
You must log in to submit a review.