Spreadsheet · Excel + Google Sheets

Rental Property Analyzer

Know if a rental makes money before you buy it, and the most you should offer.

$14.99

Works in Microsoft Excel and Google Sheets
8 tabs, compares up to 5 properties
Blank analyzer plus a filled example
7-page Getting Started guide (PDF)
Instant digital download

The problem

A good price isn't always a good rental

A rental can look affordable and still lose money every month once you add taxes, insurance, vacancy, repairs, and the loan payment. Most beginners only find out after they buy. This analyzer runs the numbers on each property the same way and checks them against your own targets. You see the cash flow and the most you should offer before you make one.

Who it's for

First-time and small investors looking at their first rental
Buyers planning to house hack a duplex or fourplex
Anyone considering a mobile home on land as a rental
Investors comparing several properties at once

What you'll be able to do

Run the numbers before you make an offer

Know your cash flowMonthly cash flow and cash flow per unit after every cost and the loan payment.
See the key ratiosCash-on-cash return, cap rate, DSCR, the 1% rule, GRM, and break-even occupancy.
Check against your targetsSet your own minimums, and every property shows Met or Not met with a deal check.
Find your max offerThe highest price that still hits your cash flow and cash-on-cash targets.
Check the house hackSee your monthly cost to live in one unit and your savings.
Look aheadRent comps, a rehab budget, and a 10-year projection of cash flow and equity.

What's included

Everything in your download

Rental Property Analyzer (.xlsx, blank) with 8 tabs: Start Here, Dashboard, Deal Inputs, Deal Results, My Targets, Rehab Budget, Rent Comps, and 10-Year Projection. Starter targets and common percentages are filled in.
Filled example with 4 sample properties: a house-hack duplex, a single-family home, a mobile home on land, and a fourplex
Getting Started guide (7-page PDF): how to open the file, the color key, and what every number means

How it works

From listing to decision

Set your targetsEnter the minimum cash flow, returns, and DSCR a deal has to hit, and the most cash you can bring.
Enter each propertyType the price, loan, rents, and costs into the beige cells for up to 5 properties.
Read the resultsDeal Results shows every number, a deal check, and your max offer.
Compare and decideUse the Dashboard to see all properties side by side before you make an offer.

Delivery

How you get it

This is a digital download. After checkout you get your download link right away and by email. Open the workbook in Excel, or upload it to Google Drive and open it with Google Sheets. Nothing ships.

For personal use. See the license and refund policy. The analyzer is a planning tool. It does the math on the numbers you enter and does not guarantee a return. It is not financial, tax, legal, or lending advice. Confirm loan terms with your lender, taxes with the county, and insurance with an agent before you buy.

Questions

Frequently asked

Does it work in Google Sheets?

Yes. Upload it to Google Drive and open it with Google Sheets (a free Google account works). It also works in Microsoft Excel. It has not been tested in Apple Numbers.

I don't know what cap rate or DSCR means. Can I still use it?

Yes. The Start Here tab and the Getting Started guide explain every number in plain words.

Does it work for mobile homes and multifamily?

Yes. Each property can have up to 4 units, and there's room for HOA or lot rent.

How many properties can I compare?

Up to 5 at a time. Save a copy to analyze more.

How do I get the files?

Right after checkout you get a download link on screen and by email.

Reviews

What customers say

No reviews yet. If you've used this tool, we'd love to hear how it went.

Write a review

Know your numbers before you buy

$14.99

Buy now · $14.99