Rental Property Deal Analyzer Spreadsheet: Cash Flow, Cap Rate, Cash-on-Cash, DSCR & 10-Year Projection (Excel + Google Sheets)

Know whether a rental makes money before you make an offer. Enter up to 3 properties side by side and see the numbers that matter in one place.

Deal Analyzer (3 deals side by side)

• Inputs: price, closing costs, upfront repairs, down payment, interest rate, term, rent, other income, vacancy, taxes, insurance, HOA, utilities, repairs, CapEx, property management and other costs

• Results: loan amount, monthly payment, NOI, monthly and yearly cash flow, cash flow per door, cash needed to close, cap rate, cash-on-cash return, DSCR, the 1% rule, break-even occupancy and gross rent multiplier

• Your targets: set minimum cash flow per door, cash-on-cash and DSCR. Each deal shows green or red and a clear "YES: meets targets" or "NO" with the reason.

• Max offer price: the most you could pay and still hit your target cap rate or target cash flow

10-Year Projection

Pick a deal and set rent growth, expense growth and appreciation. See cash flow, loan balance, property value, equity and total return for each year, with a chart.

Works in Excel, Google Sheets and LibreOffice. Three example deals are filled in so you can see how it works. The example interest rate is an example only, not a quote.

Not legal advice. Not tax or investment advice. These are estimates; your real costs, rents, rates and taxes will differ.

Estimates only, based on the numbers you enter. Not investment, tax, legal, or lending advice, and not a loan offer or rate quote. Verify figures with qualified professionals.