A clean, professional spreadsheet model for single-family and small multifamily rentals. Type a deal into the blue cells and read the verdict — NOI, cap rate, cash-on-cash, DSCR, a 10-year projection, and your return when you sell. Includes a bonus income & expense tracker for tax time.
Two spreadsheets · One-time purchase · Instant download · Excel, Google Sheets & Numbers · No subscription · Free updates
NOI, cap rate, cash-on-cash return, DSCR, gross rent multiplier, and the 1% rule — calculated the moment you enter a deal.
One set of blue input cells drives the whole model. Change the price or rent and every result and projection updates instantly.
Year-by-year rent, expenses, NOI, cash flow, property value, loan balance, and equity — with your own growth assumptions.
Projected sale price, loan payoff, net proceeds, total profit, equity multiple, and annualized return over your hold period.
A real spreadsheet you own and can customize — not a web app that disappears or a subscription that renews.
Runs entirely on your computer. No account, no upload, no one watching which deals you analyze.
A second spreadsheet to log rent and expenses month by month, with IRS Schedule-E categories and an automatic annual P&L — ready to hand your accountant at tax time.
| Purchase price | $200,000 |
| Down payment (20%) + closing | $46,000 invested |
| Gross monthly rent | $2,100 |
| Loan (30yr @ 7.0%) — monthly P&I | $1,064.48 |
| Net operating income (NOI) | $16,031 |
| Cap rate | 8.02% |
| Cash-on-cash return | 7.08% |
| DSCR | 1.26 |
| Annual cash flow | $3,257 |
| 5-year equity multiple | 1.89× |
| 5-year annualized return | 13.6% |
Every number above is live in the file — change any blue input and watch it recalculate.
.xlsx spreadsheet. It opens in Microsoft Excel, Google Sheets (File → Import, or open directly), Apple Numbers, and LibreOffice.