Skip to content
Rental Property ROI Calculator cover: a sample sheet with properties compared and cash flow a month, total and a column chart, beside the Dashboard tab

Rental Property ROI Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Landlords and first-time investors use this sheet to compare rental properties before they make an offer. The Properties tab takes one row per property, with the purchase price, down payment, loan rate and term, rent, vacancy allowance and monthly costs. Each row works out the loan amount, the mortgage payment, cash flow a month, cash invested and cash-on-cash return. The Dashboard totals the cash flow and compares property types on a column chart.

Use real quotes and rents for each property rather than round guesses, because small changes to rent and vacancy move the result a lot. Add property tax, insurance, HOA fees and expected repairs to the monthly costs, since they are easy to forget. Try a few vacancy rates to see how the return holds up in a slow season. The mortgage payment covers principal and interest only, so confirm the loan terms with your lender.

Useful for

  • Compare two or three duplexes before making an offer
  • Check whether a condo covers its mortgage each month
  • Show a lender or partner the numbers behind a purchase

What's included

  • 3 tabs: Dashboard, Properties, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Properties: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Properties tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is cash-on-cash return?

Cash-on-cash return is a year of cash flow divided by the cash you put into the property, which includes the down payment and closing costs. It shows the income return on your own money. It leaves out loan paydown and any rise in the property's value, so treat it as one measure among several.

Does the calculator include taxes on rental income?

No. It counts rent, vacancy, the costs you enter and the mortgage payment. Income tax on rent depends on your situation and the rules change, so confirm the details with a tax adviser before relying on any after-tax figure.

What vacancy rate should I use?

Base the figure on local rental listings and the property's own history. The sample uses five percent as a placeholder. Test a higher rate as well, which shows whether the monthly cash flow holds up when a unit sits empty for longer.

  • #financial-calculator
  • #rental-property-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…