Home / Templates / Real Estate

Real Estate · Excel + Google Sheets

Rental Property ROI Calculator

Run the numbers before you make an offer. Cap rate, cash-on-cash return, NOI, DSCR, monthly cash flow and a 5-year total return for rentals up to 14 units, with property tax and insurance rates by state and county.

What's inside

  • Pro forma vs. actual income and expenses, side by side
  • Built-in mortgage calculator with FHA 3.5% or commercial 20% down
  • Property tax and insurance rates that fill in by state and county
  • Up to 14 units with current and market rent for each
  • Loan qualification check with DSCR (lenders usually want 1.25)
  • 5-year debt paydown, depreciation and tax deduction summary
  • Amortization table for the full loan

Real screenshots

Rental Property ROI Calculator: Pro forma vs. actual, with the mortgage calculator and loan check
Pro forma vs. actual, with the mortgage calculator and loan check
Rental Property ROI Calculator: 5-year total return, ROI on paydown and tax deductions
5-year total return, ROI on paydown and tax deductions

Try the free rental property calculator

Run a quick version in your browser, then get the template for the full analysis.

Open calculator →

Questions

Does it work in Google Sheets?

Yes. Your download includes the Excel file and a PDF with a link that makes your own private Google Sheets copy in one click. Both versions work the same way.

Which version of Excel do I need?

Excel 2016 or later on Windows or Mac, or Excel for the web. No macros, add-ins or subscriptions are needed.

How do I get it after I buy?

You check out on Etsy and download the files right away from your Etsy purchases page. Etsy also emails you the download link.

Is there a Spanish version?

Yes. Calculadora ROI para Propiedades de Renta is the same template, fully in Spanish.

Is this financial advice?

No. The template is an educational tool that organizes and calculates your own numbers.

More real estate templates

Real Estate

Landlord Income and Expense Tracker

Rent roll1,000-row ledgerSchedule E10 properties

Log rent and expenses for up to 10 rental properties in one ledger. The dashboard shows income vs. expenses by month, and the Schedule E summary…

$19Excel + Google Sheets
Real Estate

BRRRR Deal Analyzer

Cash left in dealCash-out refi70% ruleWhat-if tables

Buy, rehab, rent, refinance, repeat. See how much cash you need, how much comes back at the refinance and how much stays in the deal, with hard…

$17Excel + Google Sheets