Good Columns
Shop all

Products / Rental Property Deal Analyzer

Put the rentals you are considering side by side.

Regular price US$14.99 Launch price US$9.99

Excel .xlsx, instant download

Buy on Gumroad, US$9.99

Type each property's price, loan, rent and running costs into one column. The Compare tab works out the same measures for all of them and checks each one against the targets you set.

Who it's for

Small landlords and first-time investors weighing up to 10 potential purchases with their own figures.

It does the arithmetic. It makes no buy or sell call: the targets are yours, and so is the decision.

Try the free rental property cash flow calculator

A look at the actual file

Compare tab with three example properties side by side: purchase costs, monthly income and expenses, cash flow, cap rate and DSCR against your targets
Screenshot of the Compare tab with the example data that ships in the file.

What's inside

One workbook, 7 tabs, in this order.

TabWhat it does
Start hereFive-step how-to, colour key and the checks status.
DealsOne column per property: price, closing costs, rehab, down payment, rate, term, rent, vacancy, tax, insurance, HOA, maintenance, CapEx, management and utilities.
CompareEvery property side by side: mortgage payment, NOI, cash flow, cash-on-cash, cap rate, gross rent multiplier, DSCR, rent-to-price, break-even occupancy and cash needed. Your own targets sit at the top.
AnalysisOne property in detail, monthly and annual.
ProjectionTen years for the selected property using your own rent growth, expense growth and appreciation rates, with a chart.
SensitivityMonthly cash flow across 7 rent levels and 7 interest rates.
ChecksInput and consistency checks over every figure you type, which should all say OK.

A look at the file

Compare tab, three example propertiesMade-up figures from the file, not market data
MeasureMaple St duplexOak Ave housePine Ct condo
Purchase price285,000.00168,000.00178,000.00
Total cash needed91,750.0045,100.0049,700.00
Monthly rent2,700.001,795.001,550.00
Results
Cash flow per month23.77210.58(81.71)
Cash-on-cash return0.3%5.6%-2.0%
Cap rate6.1%7.8%5.6%
Debt service coverage (DSCR)1.021.240.91
Rent-to-price (1% rule)0.91%1.03%0.87%
Break-even occupancy93.1%82.2%100.3%
Your targets met1 of 65 of 60 of 6

The file ships with example targets (for example, at least 200.00 a month cash flow and a DSCR of 1.2). They are placeholders, not recommendations: replace them with your own. The count only says how each property compares with the numbers you typed.

Format

File
1 Excel workbook (.xlsx), 7 tabs
Software
Microsoft Excel. Designed to open in Google Sheets.
Limits
10 properties. Three example properties, marked (example), to overwrite or delete.
Delivery
Instant download after purchase. Nothing is shipped.
Price
US$9.99, one-time. Launch price until 15 Nov, then US$14.99. No subscription.

What it does not do

  • It makes no buy or sell recommendation. Results depend entirely on the figures you enter.
  • Figures are before tax: no depreciation, income tax or capital gains.
  • It is not investment advice. Check your numbers with a qualified professional before you decide.

Questions

Which version of Excel do I need?

Excel 2010 or later on Windows, Excel 2016 or later on Mac, or Excel for the web. We checked every formula in this workbook against the version of Excel that first supported it: the newest thing it uses arrived in Excel 2007, so it needs no Microsoft 365 subscription. There is nothing in it that only newer Excel can run, such as XLOOKUP, LET, IFS or TEXTJOIN, and there are no macros or add-ons. Excel 2003 and earlier are not supported.

The totals look blank when I open it. What is wrong?

Nothing. Excel opens a downloaded file in Protected View and does not calculate until you click Enable Editing. The figures appear as soon as you do.

Does it work on a Mac?

Yes, in Excel for Mac. There are no macros, so nothing in the file is Windows-only. It is also designed to open in Google Sheets in a browser.

Can I use it in Google Sheets?

The workbook is made in Excel and designed to open in Google Sheets: upload it to Drive and open it with Google Sheets. It uses no macros, scripts or add-ons. If something does not work as described there, email hello@goodcolumns.com and we fix it or refund you.

What if I want a refund?

No change-of-mind refunds on digital files. If a file is faulty or not as described, email hello@goodcolumns.com within 30 days and we fix it or refund you.

Is this tax, legal or financial advice?

No. It does the arithmetic on the figures you enter and compares them with targets you set. It makes no buy or sell call and is not investment advice.

The small print

Good Columns templates help you organise records. They are not tax, legal, accounting or financial advice, are not endorsed by the IRS or any government body, and may not suit your situation. You are responsible for the figures you enter.

The Deal Analyzer is not investment advice and makes no buy or sell call. Results depend entirely on the figures you enter.

Licence: use within your own business; no resale or redistribution.

No change-of-mind refunds on digital files. If a file is faulty or not as described, we fix it or refund you.

Full terms: Terms and refunds.