Products / Rental Property Deal Analyzer
Put the rentals you are considering side by side.
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.
What's inside
One workbook, 7 tabs, in this order.
| Tab | What it does |
|---|---|
| Start here | Five-step how-to, colour key and the checks status. |
| Deals | One column per property: price, closing costs, rehab, down payment, rate, term, rent, vacancy, tax, insurance, HOA, maintenance, CapEx, management and utilities. |
| Compare | Every 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. |
| Analysis | One property in detail, monthly and annual. |
| Projection | Ten years for the selected property using your own rent growth, expense growth and appreciation rates, with a chart. |
| Sensitivity | Monthly cash flow across 7 rent levels and 7 interest rates. |
| Checks | 14 input and consistency checks that should all say OK. |
A look at the file
| Measure | Maple St duplex | Oak Ave house | Pine Ct condo |
|---|---|---|---|
| Purchase price | 285,000.00 | 168,000.00 | 178,000.00 |
| Total cash needed | 91,750.00 | 45,100.00 | 49,700.00 |
| Monthly rent | 2,700.00 | 1,795.00 | 1,550.00 |
| Results | |||
| Cash flow per month | 23.77 | 210.58 | (81.71) |
| Cash-on-cash return | 0.3% | 5.6% | -2.0% |
| Cap rate | 6.1% | 7.8% | 5.6% |
| Debt service coverage (DSCR) | 1.02 | 1.24 | 0.91 |
| Rent-to-price (1% rule) | 0.91% | 1.03% | 0.87% |
| Break-even occupancy | 93.1% | 82.2% | 100.3% |
| Your targets met | 1 of 6 | 5 of 6 | 0 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$12.99, one-time. 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, a current Excel for Mac, or Excel for the web. The workbook uses ordinary functions such as SUMIFS and INDEX/MATCH, and no macros, so nothing is locked to one version.
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.