Rental Property Spreadsheet Excel | Deal Analyzer, Cash Flow, Cap Rate, Cash on Cash & DSCR Calculator
Rental Property Spreadsheet Excel | Deal Analyzer, Cash Flow, Cap Rate, Cash on Cash & DSCR Calculator
Digital download. Review the actual preview, included files, software and license before checkout.
Know the deal before you buy.
Watch the 20-second product preview
Check the deal before making an offer. This captioned overview combines product previews with a practical setup workflow. Examples are illustrative; this is not a live system connection.
Start with this workflow
- Enter purchase, rent and loan assumptions.
- Review cash flow, returns and coverage.
- Change assumptions to stress-test the deal.
Scope to check: One acquisition at a time; not a portfolio-management system.
After purchase: Open the supplied instructions first and save a working copy of the files. For file or download help, contact MetricForgeHQ with your order number and product name. Please omit confidential information.
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.
For purchases made on this website, the MetricForgeHQ Digital Product Refund Policy applies. For a defective file or download issue, contact MetricForgeHQ support with your order number, product name, software version and a description of the issue. Do not send confidential information. Nothing in the policy limits rights or remedies that cannot be excluded under applicable law.