| Going-in cap rate (T-3 NOI / purchase price) | 5.72% | Purchase CAP Rate |
| Exit, year 6: sale at a 5.97% cap rate | $12,620,000 | Expected Sale Proceeds |
| Cash-on-cash by year: Y1 3.9%, Y2 4.5%, Y3 5.5%, Y4 6.2%, Y5 6.4%, Y6 6.8% | Projected Returns - Yearly (1-10?) | |
| Levered IRR | 16.6% | Expected IRR - Hold |
| Equity multiple | 2.30x | Expected Equity Multiple - Hold |
| Hold period | 6 years (exit 2029) | Expected Hold |
| Refinance in 2027 at 65% LTV on stabilized value | Expected Refi Year | |
| Refinance proceeds: new loan $7,910,000, less payoff $6,452,000 = $1,460,000 to equity | Expected Refi Proceeds |
| Rate type | Fixed | Loan #1 - Floating or Fixed |
| Interest rate | 5.41% fixed | Loan #1 - Rate |
| Amortization | Amortizing (30-year schedule) | Loan #1 - I/O or Amortizing |
| Term | 7 years | Loan #1 - Term |
| Maturity | July 17, 2030 | Loan #1 - Maturity Date |
| Program | Freddie Mac Optigo | Loan #1 - Agency (if applicable) |
| Renovation program complete | 2024 | Last Renovated |
| Capital budget: Roof $169,400, Unit renovations $605,000, Amenities $72,600; total $847,000 | Budgeted Capex (by category) | |
| Interior upgrades on 48 of 120 units as they turn, $12,604 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.