Tier 02 / Assume the In-Place Loan.

Assumption Loan Underwriter

Who it's for

Real estate investors and sponsors evaluating a multifamily acquisition where you plan to assume the seller's existing mortgage rather than obtain new financing — ideal when the existing loan carries a below-market rate worth preserving.

A 17-tab Excel workbook built specifically for loan assumption deals: carry the seller's outstanding balance, rate, and remaining term forward through a full 9-step underwriting workflow — 10-year proforma, IRR sensitivity, LP waterfall, disposition stress-test, and investor dashboard — plus the companion guide and everything in Tier 1.

Compare Tiers
one-time license · Excel + Google Sheets
Specification
TABS17
FORMATXLSX / Sheets
SUPPORTEmail
+Everything in Tier 1
+17-tab Assumption Loan Underwriter workbook
+Holy Trinity traffic-light (CoC, Cap Rate, DSCR)
+10-Year Proforma with rent & expense growth
+IRR Sensitivity Analysis grid (5×5 matrix)
+LP Investor Waterfall (3-tier preferred return)
+Disposition UW — Buyer-Price IRR vs. trended exit
+Tax Estimates with reassessment calculator
+Loan Assumption Edition User Guide (PDF · 8 pages)
+Excel + Google Sheets
+Email support
MODULE 01

The 17-Tab Assumption Workbook

A complete 9-step workflow built for loan assumption deals — enter the seller's T-12, carry the existing loan balance, rate, and remaining amortization forward, project a 10-year hold, stress-test your exit with Buyer-Price IRR vs. your trended exit, run IRR sensitivity across a 5×5 cap rate / rate grid, and model LP distributions through a 3-tier waterfall. The Holy Trinity traffic light evaluates every deal on Cash-on-Cash, Cap Rate, and DSCR at Year 1.

TABS17
The 17-Tab Assumption Workbook
MODULE 01 — Module detail
MODULE 02

Loan Assumption Edition User Guide

An 8-page companion guide covering the full 9-step workflow, every tab's conventions and key cells, all return metrics defined in plain language (NOI, Cap Rate, CoC, DSCR, IRR, AAR, Equity Multiple, Buyer-Price IRR), and troubleshooting for the most common questions — including why Buyer-Price IRR is intentionally conservative.

PAGES8
Loan Assumption Edition User Guide
MODULE 02 — Module detail
MODULE 03

New Financing Underwriter Included

Tier 2 ships with the full New Financing Edition so you can run both financing paths on the same deal and choose the cheaper cost of capital. Community support and mentorship are not included.

MODELS02
New Financing Underwriter Included
MODULE 03 — Module detail