Worked example
| Line | Result |
|---|---|
| Purchase price | $1,500,000 |
| Units (4 × 1BR, 6 × 2BR, 2 × 3BR) | 12 |
| Monthly rent | $20,300 |
| Effective gross income / yr (5% vacancy) | $235,980 |
| Total expenses / yr | $97,859 |
| NOI | $138,121 |
| Cap rate | 9.21% |
| Monthly P&I (75% LTV, 6.75%, 30 yr) | $7,297 |
| DSCR | 1.58 |
| Cash flow / month | $4,213 |
| Cash-on-cash | 11.0% |
| Price per unit | $125,000 |
Worked example: the calculator's own starting figures, run through its formulas. Replace them with your deal.
Frequently asked
What does the multi-unit calculator ask for?
Purchase price, closing costs and repairs; a rent roll of studio, 1-, 2- and 3-bedroom and commercial units with their rents; other income and vacancy; expenses for taxes, insurance, water, heat, repairs, management (percent of income), super, landscaping, legal, reserves per unit and other; and the loan's LTV, rate and amortization.
What results does it show?
Gross and effective gross income, total expenses and expense ratio, NOI, cap rate, loan amount, monthly P&I, annual debt service, DSCR, cash flow per month and per unit, cash-on-cash return, total cash needed, price per unit, gross rent multiplier and break-even occupancy.
How is the cap rate calculated?
NOI divided by the purchase price.
Can I share or save the analysis?
Yes. Download it as an Excel file or copy a shareable link.