Real Estate Financial Modeling Tools

Standard Version: Distressed First Lien Mortgage Note Acquisition Pro-Forma Template



Academic / U.S. Military Price

To get discounted pricing, click Credentials Verification in the header and follow the instructions. Once you are approved, the discounted pricing will show.

SKU: SKU-107 Category:

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)


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

Support Level

Standard Support, Priority Support

The February Bootcamp Webinars Are Here! Register Now
left to take 50% off with coupon code: yearend50