Rental Property Deal Analyzer

Rental Property Deal Analyzer

Analyze a potential rental property before you invest with a practical spreadsheet designed to help you run the numbers and understand the deal.

Enter the property price, financing information, expected rental income, and operating expenses. The analyzer automatically calculates important investment metrics and gives you a simple deal scorecard to help organize your decision.

WHAT YOU CAN ANALYZE

Purchase price and down payment

Closing costs and initial repairs

Loan amount and estimated payment

Monthly rent and other income

Property taxes and insurance

Utilities and other expenses

Property management costs

Vacancy allowance

Repairs and maintenance

Capital expenditures

AUTOMATIC CALCULATIONS

Net Operating Income (NOI)

Monthly and annual cash flow

Cap rate

Cash-on-cash return

Debt Service Coverage Ratio (DSCR)

Break-even occupancy

Total cash needed

DEAL SCORECARD

The spreadsheet compares your results against editable target thresholds and provides a quick Strong / Review / Weak deal indication.

You can adjust the targets to better match your market, financing, investment strategy, and risk tolerance.

SCENARIO COMPARISON

Compare Conservative, Base, and Optimistic scenarios to see how changes in rent, vacancy, repairs, and other assumptions can affect the potential deal.

WORKS WITH

Microsoft Excel

Google Sheets

Some formatting or visual details may vary slightly between Excel and Google Sheets.

IMPORTANT

The spreadsheet includes starter assumptions so you can see how the calculations work. Replace the input values with the actual numbers for the property you are analyzing.

This is a digital spreadsheet product. No physical item will be shipped.

For personal or internal business use by the purchaser. Not for resale, redistribution, or commercial reproduction.

This tool is provided for educational and organizational purposes and does not constitute financial, investment, tax, accounting, or legal advice. Calculations and scorecard results are decision aids, not guarantees of investment performance