Free Rental Cash Flow Calculator

Free (or pay what you want) one-deal spreadsheet: cash flow, NOI, cap rate, cash-on-cash, DSCR, GRM, 1% rule and break-even occupancy.
A free rental property calculator spreadsheet for one deal: enter the price, loan, rent and expenses and see if it cash-flows.
Calculated for you: monthly and annual cash flow, NOI, cap rate, cash-on-cash return, DSCR, gross rent multiplier, the 1% rule, break-even occupancy and the operating expense ratio.
Includes a blank calculator, a worked SAMPLE (2-unit duplex) and a short PDF guide with every formula.
Free, or pay what you want. Enter $0 to download it free.
Works in Excel 2010+, Google Sheets and LibreOffice. No macros.
Tested: recalculated in LibreOffice for 9 deals (including 0% interest and all-cash) and matched an independent implementation to the cent.
Need to compare 3 deals, see a 10-year IRR or find your max offer price? See the Rental Deal Analyzer and Rental Property Calculator Pro in the store.
Not tax, legal or investment advice.
Built with AI assistance and tested by running it end to end (details in the guide).
Refunds: 30-day refund if it doesn't work as described (refund policy).
Related free tools
- Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR
Instant rental deal math in your browser: monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule and break-even occupancy.
Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.