Phoenix MF Acquisition — Firm Template.xlsx
Unit Mix
Assumptions
Pro Forma
Returns
Sensitivity
fx ='Unit Mix'!E22 * 12 * (1 - 'Assumptions'!C8)
A
B
C
D
E
F
G
1
Year
Y1
Y2
Y3
Y4
Y5
Exit
2
GPR
$2.4M
$2.5M
$2.6M
$2.7M
$2.8M
$2.9M
3
Vacancy
7.0%
($122K)
($129K)
($135K)
($142K)
($146K)
4
NOI
$1.42M
$1.52M
$1.61M
$1.69M
$1.78M
$1.84M
5
Cap Rate
5.25%
—
—
—
—
5.50%
6
Lev. CF
$420K
$510K
$595K
$675K
$760K
$33.4M
7
Units
95
95
95
95
95
95
8
IRR
18.4% | 2.1x EM | 8.6% avg CoC
T
Teez
Underwriting agent
Build a pro forma for the Phoenix deal — 5-year hold, 65% LTV.
Looking at your template… Reading the rent roll, T-12, and OM… Checking the Phoenix submarket… Building the model… Double-checking the numbers…
Done — pro forma's live in your sheet.
18.4%IRR
2.1xEM
8.6%CoC
⚑ Heads-up — your OM lists 96 units, the rent roll shows 95. Worth confirming before IC.
Run a sensitivity on exit cap →