Rental Property Spreadsheet Excel | Deal Analyzer, Cash Flow, Cap Rate, Cash on Cash & DSCR Calculator

Know the deal before you buy.

This Rental Property Deal Analyzer is a focused Microsoft Excel spreadsheet for evaluating one long-term rental property. Enter the purchase price, financing, rent, vacancy and operating costs; the workbook calculates the key decision metrics and compares them with your editable targets.

USE IT TO ANSWER:

• What is the estimated monthly cash flow after operating expenses and mortgage payments?
• What are the cap rate and cash-on-cash return?
• Does the modeled net operating income cover the debt payment?
• What occupancy level is required to break even?
• Which assumptions need more review before making an offer?

WHAT THE SPREADSHEET CALCULATES:

• Loan amount
• Initial cash invested
• Estimated principal-and-interest mortgage payment
• Gross scheduled income
• Vacancy and credit loss
• Effective gross income
• Operating expenses
• Net operating income
• Monthly and annual cash flow
• Cap rate
• Cash-on-cash return
• Debt service coverage ratio or DSCR
• Break-even occupancy
• Strong, Review or Weak screening status based on five editable targets

WHAT YOU RECEIVE:

• Rental Property Deal Analyzer BLANK workbook
• Rental Property Deal Analyzer DEMO workbook with a fictional completed example
• Quick Start and Formula Guide PDF
• Digital Product License PDF

BUILT FOR A FOCUSED DECISION:

This product analyzes one potential acquisition at a time. It is intentionally different from a portfolio-management system. Use the analyzer before purchase; use a full rental-property command center after purchase for ongoing multi-property operations and reporting.

HOW IT WORKS:

1. Open the DEMO workbook to see the completed example.
2. Save a copy of the BLANK workbook.
3. Enter the property and financing assumptions in the highlighted cells.
4. Review the dashboard and five decision checks.
5. Stress-test the deal by changing rent, vacancy, expenses, repairs, interest rate or price.

COMPATIBILITY:

• Designed for Microsoft Excel 365 or Excel 2021 and later
• XLSX files
• No macros
• No subscriptions
• No external data connections
• Features may display differently in Google Sheets, Apple Numbers or older spreadsheet software

IMPORTANT INFORMATION:

This is an instant digital download. No physical item will be shipped.

The workbook is an educational screening and planning tool. It does not provide investment, legal, tax, accounting, lending, appraisal, insurance or property-management advice. Results depend on the assumptions entered and do not predict future performance. Verify all assumptions independently and consult qualified professionals before making an offer or financial commitment.

Due to the digital nature of this product, marketplace refund terms apply. If a file is technically defective, contact MetricForgeHQ through Etsy with your order information and a description of the issue.