Rental Property Calculator

Find out in minutes whether a rental deal works. Type the price, financing, rent and expenses, and get a deal dashboard with PASS or REVIEW checks, a what-if stress test and a 5-year projection with charts.

WHAT YOU GET (8 files)

- Excel workbooks in 3 color themes (Navy, Sage, Charcoal), each as a Sample (a $400,000 duplex) and a Blank edition

- A Google Sheets edition (Sample and Blank) and a "How to open in Google Sheets" PDF guide

5 TABS

- Start Here: how it works and key terms

- Dashboard: monthly cash flow, cap rate, cash-on-cash return, DSCR, mortgage payment, break-even occupancy, equity after 5 years and 5-year total return; 5 deal checks against targets you set; where every dollar of rent goes; 2 charts

- Calculator: purchase, financing, income and expenses, with results updating as you type

- What-If: monthly cash flow if rent moves up to 10% either way and the rate moves up to 1 point either way. Red cells lose money, and the steps are editable.

- 5-Year Projection: rent and expense growth, loan balance, principal paid, property value, equity, cumulative cash flow and total return, with 2 charts

WHY IT IS DIFFERENT

- Percent-based expenses are calculated on rent actually collected after vacancy

PLEASE NOTE

- Digital download. No physical item will be shipped.

- An estimating tool, not financial or investment advice. Results are before income tax and selling costs.

- Built for Microsoft Excel and tested in LibreOffice. Google Sheets: import the Google Sheets edition using the included guide.

- Designed by our shop with the help of AI tools, then tested by us.

- For your personal use. Please do not resell or share the files.