Rental Property Cash Flow & Cap Rate Calculator
Run the numbers on a rental before you make an offer — cash flow, cap rate, cash-on-cash return and DSCR in one spreadsheet.
What you get
- A Deal Analyzer that turns price, loan terms, rent and expenses into NOI, monthly cash flow, cap rate, cash-on-cash return, DSCR, a 1% screen and break-even occupancy
- A Compare 3 Properties tab that puts three deals side by side on the same assumptions
- A Rehab Budget with estimate vs. actual and variance for up to 30 repair lines
- Separate inputs for vacancy, maintenance, CapEx reserves and management, so thin deals show up before you buy
- A plain-English Start Here tab explaining what every result means
- Colour-coded cells so you always know what to type in and what calculates itself
Why it exists
Listings show the rent. They rarely show what is left after vacancy, repairs, reserves, taxes, insurance and the mortgage. This calculator makes you put a number on every one of those lines, so a deal that only works on the listing's projected rent looks like what it is.
Format
Microsoft Excel (.xlsx) — opens in Excel, Numbers, LibreOffice and Google Sheets. Instant download after checkout.
Rental Property Cash Flow & Cap Rate Calculator
Price: $27 · one-time
Get the Rental Property Cash Flow & Cap Rate Calculator — $27Educational tool only. Not investment, tax or legal advice, and not a recommendation to buy any property. Results depend on the numbers you enter. Smart Money Financial is not a real estate broker, agent or lender.