{"product_id":"rental-property-spreadsheet-excel-deal-analyzer-cash-flow-cap-rate-cash-on-cash-dscr-calculator","title":"Rental Property Spreadsheet Excel | Deal Analyzer, Cash Flow, Cap Rate, Cash on Cash \u0026 DSCR Calculator","description":"\u003cp\u003eKnow the deal before you buy.\u003c\/p\u003e\n\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003cp\u003eUSE IT TO ANSWER:\u003c\/p\u003e\n\n\u003cp\u003e• What is the estimated monthly cash flow after operating expenses and mortgage payments?\u003cbr\u003e\n• What are the cap rate and cash-on-cash return?\u003cbr\u003e\n• Does the modeled net operating income cover the debt payment?\u003cbr\u003e\n• What occupancy level is required to break even?\u003cbr\u003e\n• Which assumptions need more review before making an offer?\u003c\/p\u003e\n\n\u003cp\u003eWHAT THE SPREADSHEET CALCULATES:\u003c\/p\u003e\n\n\u003cp\u003e• Loan amount\u003cbr\u003e\n• Initial cash invested\u003cbr\u003e\n• Estimated principal-and-interest mortgage payment\u003cbr\u003e\n• Gross scheduled income\u003cbr\u003e\n• Vacancy and credit loss\u003cbr\u003e\n• Effective gross income\u003cbr\u003e\n• Operating expenses\u003cbr\u003e\n• Net operating income\u003cbr\u003e\n• Monthly and annual cash flow\u003cbr\u003e\n• Cap rate\u003cbr\u003e\n• Cash-on-cash return\u003cbr\u003e\n• Debt service coverage ratio or DSCR\u003cbr\u003e\n• Break-even occupancy\u003cbr\u003e\n• Strong, Review or Weak screening status based on five editable targets\u003c\/p\u003e\n\n\u003cp\u003eWHAT YOU RECEIVE:\u003c\/p\u003e\n\n\u003cp\u003e• Rental Property Deal Analyzer BLANK workbook\u003cbr\u003e\n• Rental Property Deal Analyzer DEMO workbook with a fictional completed example\u003cbr\u003e\n• Quick Start and Formula Guide PDF\u003cbr\u003e\n• Digital Product License PDF\u003c\/p\u003e\n\n\u003cp\u003eBUILT FOR A FOCUSED DECISION:\u003c\/p\u003e\n\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003cp\u003eHOW IT WORKS:\u003c\/p\u003e\n\n\u003cp\u003e1. Open the DEMO workbook to see the completed example.\u003cbr\u003e\n2. Save a copy of the BLANK workbook.\u003cbr\u003e\n3. Enter the property and financing assumptions in the highlighted cells.\u003cbr\u003e\n4. Review the dashboard and five decision checks.\u003cbr\u003e\n5. Stress-test the deal by changing rent, vacancy, expenses, repairs, interest rate or price.\u003c\/p\u003e\n\n\u003cp\u003eCOMPATIBILITY:\u003c\/p\u003e\n\n\u003cp\u003e• Designed for Microsoft Excel 365 or Excel 2021 and later\u003cbr\u003e\n• XLSX files\u003cbr\u003e\n• No macros\u003cbr\u003e\n• No subscriptions\u003cbr\u003e\n• No external data connections\u003cbr\u003e\n• Features may display differently in Google Sheets, Apple Numbers or older spreadsheet software\u003c\/p\u003e\n\n\u003cp\u003eIMPORTANT INFORMATION:\u003c\/p\u003e\n\n\u003cp\u003eThis is an instant digital download. No physical item will be shipped.\u003c\/p\u003e\n\n\u003cp\u003eThe 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.\u003c\/p\u003e\n\n\u003cp\u003eDue 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.\u003c\/p\u003e","brand":"MetricForgeHQ","offers":[{"title":"Default Title","offer_id":52372991410464,"sku":"MFHQ-RPDA-001","price":9.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1021\/7360\/6176\/files\/il_fullxfull.8535239780_qb5b.jpg?v=1789685360","url":"https:\/\/metricforgehq.com\/products\/rental-property-spreadsheet-excel-deal-analyzer-cash-flow-cap-rate-cash-on-cash-dscr-calculator","provider":"MetricForgeHQ","version":"1.0","type":"link"}