Rental Property Analyzer Spreadsheet | Real Estate Investment Calculator | Cap Rate and Cash Flow Deal Analyzer | Excel & Google Sheets

Know if it's a good deal — before you make an offer.

This Rental Property Analyzer turns any listing into a clear yes-or-no. Enter the price, rent and a few expenses, and every number a real-estate investor cares about is calculated instantly — with an automatic verdict.

WHAT YOU GET
• Deal Dashboard — cap rate, cash-on-cash return, monthly cash flow, NOI, DSCR and the 1% rule, all at a glance with a STRONG BUY / GOOD / ANALYZE verdict.
• Inputs tab — purchase price, down payment, rate, rent, vacancy and operating expenses. Down payment, loan and mortgage (P&I) are auto-calculated.
• Mortgage & amortization — full 30-year schedule plus interest-vs-principal breakdown.
• Cash flow — gross rent down to the dollar in your pocket, nothing forgotten (vacancy, management, maintenance, CapEx).
• Returns — cap rate, cash-on-cash, DSCR, GRM, 1% and 50% rules, each with a pass/fail.
• 10-year projection — rent growth, equity from loan paydown and appreciation, total return.
• Compare deals — stack properties side by side and let the numbers pick the winner.

PERFECT FOR
• Buy-and-hold and BRRRR investors analyzing rentals and small multifamily.
• Anyone who wants to stop guessing and run the numbers in minutes.

WORKS WITH
Microsoft Excel · Google Sheets · LibreOffice Calc. Desktop and mobile.

INSTANT DIGITAL DOWNLOAD
You'll get the spreadsheet immediately after purchase. Because this is a digital product, all sales are final (no refunds). A built-in Instructions tab walks you through everything.

Note: this is an analysis and organizing tool only. It does not provide financial, investment, tax or legal advice. Figures are estimates based on your inputs.