Commercial Underwriting
Full pro forma for multifamily, retail, office, and industrial deals.
NOI · Cap Rate · DSCR · Cash-on-Cash · IRR · Exit Analysis · 5/10/15-Year Projection
THE PROPERTY
$
INCOME
$
$
%
$
OPERATING EXPENSES
$
$
%
%
%
$
$
$
$
%
FINANCING
%
$
%
%
$
Live Results
NOI Snapshot
Gross Scheduled Income$171,600
(-) Vacancy & Credit Loss$12,012
(-) Operating Expenses$77,038
Net Operating Income$82,550
(-) Annual Debt Service$95,415
Annual Cash Flow-$12,865
Investment Returns
5.50%
Cap Rate
-3.06%
Cash-on-Cash
0.87
DSCR
7.34%
Debt Yield
100.50%
Break-Even Occ.
44.89%
Expense Ratio
$125
Price / Sq Ft
$187,500
Price / Unit
Exit Analysis (5-Year Hold)
Exit Value (reversion)$1,455,113
Exit Equity$353,194
Total Profit-$101,543
Equity Multiple0.76x
IRR-5.10%
This deal is cash-flow negative. The NOI doesn't cover debt service at these terms. Renegotiate price or improve income.
Numbers work?
Rob sources on and off-market commercial deals in Central Texas.
$82,550
NOI
-$12,865
Cash Flow
0.87
DSCR