DU
Deal Underwriter
Excel-style underwriting • Sensitivity + Tornado • Exports + Deal Library
No splitsExit = NOIₙ₊₁ / CapDebt + Payoff
NOI (Y1)
$434,160
Go-in cap 0.38%
DSCR (Y1)
0.09
Debt svc $4,713,963
Cash-on-Cash (Y1)
-8.57%
Equity $51,075,000
Levered IRR
Levered NPV $-92,749,018
Exit Price
$8,214,801
Payoff $56,403,768
Property & timing
Core underwriting assumptions.
Rent roll (by unit type)
Year-1 rent derives from rent roll, then grows annually.
Unit Type# UnitsMonthly RentAnnual Rent
$
$345,600
$
$297,600
Totals20$643,200
Operating expenses
Match Excel with Percent of Revenue, or use line-items/per-unit for real underwriting.
Line items (optional)
Used in Line Items / Hybrid mode.
ExpenseAnnual ($)
$
$
$
Exit & debt
Exit = NOIₙ₊₁ / Exit Cap. Debt = PMT + payoff at exit.