Spruce Sheets

Home › Free calculator

Free Rental Property Cash Flow Calculator

Will this rental pay for itself? Find out in 2 minutes.

Enter the price, loan, rent and expenses. The free calculator does the rest. Works in Excel and Google Sheets.

Gumroad asks for your email address to send the download link; enter $0 as the price. You may get an occasional email about our templates and can unsubscribe at any time.

Free Rental Property Cash Flow Calculator for Excel and Google Sheets

What it calculates

  • Monthly mortgage payment, NOI and monthly cash flow
  • Cash-on-cash return, cap rate, DSCR: plus break-even occupancy and the 1% rule
  • What-if grid: cash flow at 5 rent levels × 5 interest rates

Not sure what the numbers mean? Read how to calculate rental property cash flow and what cash-on-cash return tells you.

When you outgrow it

The free calculator checks one property at a time. To compare up to 5 deals with BRRRR and short-term rental modes, a 10-year projection and what-if grids, see the Rental Property Analysis Calculator.

Estimates only, based on the numbers you enter. Not financial, tax or investment advice.

Screenshot of the free calculator with cash flow, cash-on-cash return, cap rate and DSCR