| Going-in cap rate (T-3 NOI / purchase price) | 5.75% | Purchase CAP Rate |
| Exit, year 6: sale at a 6.00% cap rate | $18,250,000 | Expected Sale Proceeds |
| Cash-on-cash by year: Y1 4.6%, Y2 5.7%, Y3 6.7%, Y4 7.8%, Y5 8.0%, Y6 8.2% | Projected Returns - Yearly (1-10?) | |
| Levered IRR | 16.8% | Expected IRR - Hold |
| Equity multiple | 2.32x | Expected Equity Multiple - Hold |
| Hold period | 6 years (exit 2028) | Expected Hold |
| Refinance in 2026 at 65% LTV on stabilized value | Expected Refi Year | |
| Refinance proceeds: new loan $11,440,000, less payoff $9,331,000 = $2,110,000 to equity | Expected Refi Proceeds |
| Rate type | Floating | Loan #1 - Floating or Fixed |
| Interest rate | SOFR + 2.10% (6.73% all-in) | Loan #1 - Rate |
| Amortization | I/O 36 months, then 30-year amortization | Loan #1 - I/O or Amortizing |
| Term | 10 years | Loan #1 - Term |
| Maturity | May 9, 2032 | Loan #1 - Maturity Date |
| Program | Fannie Mae DUS | Loan #1 - Agency (if applicable) |
| Renovation program complete | 2023 | Last Renovated |
| Capital budget: Roof $245,000, Unit renovations $875,000, Amenities $105,000; total $1,225,000 | Budgeted Capex (by category) | |
| Interior upgrades on 73 of 184 units as they turn, $11,986 per unit | Units to Rehab |
Nothing is read from this document for the fields below: having it on file is the answer.
A static rendering for this demo: the passages each deal-sheet value was read from, highlighted where they sit. In the application this link opens the filed document itself. Every name and figure on it is invented.