An Excel-based analysis tool for the acquisition and eventual extinguishment of a non-performing or a performing Mortgage Note. The model is monthly in nature, and it is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit the particulars of your transactions.
User-Friendly Features
- Compatible with both PC and Mac
- Includes instructions for use, with detailed annotations tied to select cells
- One-page assumptions input and reporting screen optimized for dashboard-style viewing
- Persistent calculation checks and data validation protections to prevent faulty inputs
Model Functional Highlights
The model supports the following:
- Use of debt to purchase the Note
- Legal and carry cost modeling
- Ultimate foreclosure on the collateral and subsequent disposition of collateral
- Up to two joint venture equity partnership players with a Preferred Return and a residual split.
Model Tabs
1 Assumptions Inputs
2 Capital Structure Exhibit
3 Cash Flow
4 Annual Cash Flow Exhibit
5 Partnership Structure Inputs
6 IRR Waterfall Exhibit
7 JV Returns Summary Exhibit
8 Acquisition Loan Monthly Amortization Schedule
9 New Loan Monthly Amortization Schedule
10 Refi Loan Monthly Amortization Schedule
Model Timeline
11 years (expandable)
Reports
Print-ready, brandable reports are included in the model.
License Type And Multiple-User Pricing
Licenses are sold on a per-user basis
Multi-user pricing quotes are available here
Included With Purchase
- Blank template (inputs are all set to zero) and a version of the template with a sample deal loaded in
- 1 year of online ticket-based support