All spreadsheet tools

Rental Property Deal Analyzer

Rental Property Deal Analyzer: preview of the example data

Compare up to 25 buy-and-hold rental deals side by side: monthly cash flow, cap rate, cash-on-cash return, DSCR and a clear verdict against your own targets.

Most rental deals that lose money looked fine on a back-of-the-envelope calculation: rent minus mortgage. The costs that sink them are the ones that arrive later and irregularly: vacancy, repairs, capital expenses, management.

This analyzer puts every deal through the same full calculation: financing, operating costs, reserves for vacancy, maintenance and capital expenses, then net operating income, monthly cash flow and the standard return measures lenders and investors use, so you can compare deals on the same terms.

Each property is one row, so you can line up 25 candidates and see in seconds which ones meet your targets and which only work if nothing goes wrong.

What is included

Who it is for

How it works

1) On Targets, set the minimum cash-on-cash return and DSCR you require (8% and 1.25 are common starting points). 2) On Deals, replace the three example properties with your own: price, closing costs, rehab, financing, rent and costs. Use annual figures where the column says annual, monthly where it says monthly, and percentages as percentages. 3) Read the grey columns: cash flow, cap rate, cash-on-cash, DSCR and the verdict. 4) Change one input at a time (rent, rate, down payment) to see what the deal needs to work. 5) The Summary shows how many deals meet your targets and the best return in the list.

Limits

Related tools

Price: $24, one-time. Download: rental_property_deal_analyzer.xlsx (Targets, Deals, Summary) and this guide. Works in Excel 2016 or later, Excel for Mac and Excel on the web; opens in Google Sheets and LibreOffice.

Buy on Gumroad ($24)

New product, listed 2026-10-23: no sales or reviews yet. Example figures in the workbook are illustrative.

This workbook is an analysis aid, not investment, lending, legal or tax advice. Results depend entirely on the figures you enter; verify rents, taxes, insurance and loan terms with local professionals before buying.