Multifamily Underwriter
Pro forma, leverage, exit, and levered returns for small multifamily acquisitions.
Inputs
Loan
Levered IRR
12.04%
Equity Multiple
2.06x
Avg Cash-on-Cash
5.8%
Exit Value
$3.8M
Going-in Cap
6.94%
Stabilized Cap
8.28%
Total Cost
$3.2M
Equity $1.1M
Loan / DS
$2.1M
$163.4K / yr
Year-by-year pro forma
| Year | GPR | Vacancy | Other | EGI | OpEx | NOI | Debt Service | Cash Flow | CoC | DSCR |
|---|---|---|---|---|---|---|---|---|---|---|
| Y1 | $360,000 | ($25,200) | $24,000 | $358,800 | ($150,696) | $208,104 | ($163,447) | $44,657 | 4% | 1.27x |
| Y2 | $370,800 | ($25,956) | $24,720 | $369,564 | ($155,217) | $214,347 | ($163,447) | $50,900 | 4.6% | 1.31x |
| Y3 | $381,924 | ($26,735) | $25,462 | $380,651 | ($159,873) | $220,778 | ($163,447) | $57,331 | 5.2% | 1.35x |
| Y4 | $393,382 | ($27,537) | $26,225 | $392,070 | ($164,670) | $227,401 | ($163,447) | $63,954 | 5.8% | 1.39x |
| Y5 | $405,183 | ($28,363) | $27,012 | $403,833 | ($169,610) | $234,223 | ($163,447) | $70,776 | 6.4% | 1.43x |
| Y6 | $417,339 | ($29,214) | $27,823 | $415,948 | ($174,698) | $241,250 | ($163,447) | $77,803 | 7% | 1.48x |
| Y7 | $429,859 | ($30,090) | $28,657 | $428,426 | ($179,939) | $248,487 | ($163,447) | $85,040 | 7.7% | 1.52x |