Rental Property Deal Analyzer — Cash Flow, DSCR, Cap Rate, Stress Test & Deal Score (Excel, 12 tabs)

This is the model I built to analyse rental property deals — the same one I used to review more than 100 deals before buying two.

What's inside (12 tabs):

• Start Here — guided inputs, nothing hidden
• Deal Summary — the one-page view a lender or partner expects
• Cash Flow — monthly and annual, with vacancy, capex reserve and management fees
• Return Metrics — cash-on-cash, cap rate, DSCR, GRM, total return
• Renovation Budget — line-by-line, with contingency
• 5-Year Projection — rent growth, expense inflation, equity build-up
• Stress Test — vacancy spikes, rate increases, rent drops, capex shocks
• Deal Score — a weighted score turning the numbers into a GO / NO-GO verdict
• Red Flags — automatic warnings on the ratios that kill deals
• Compare Deals — put several properties side by side
• Formulas Explained — every calculation, in plain English
• Due Diligence — the checklist to run before signing
  
  

182 live formulas. No macros, no black boxes, no locked cells. Every formula is visible and editable.

Who it's for: first-time and small-portfolio rental investors, real estate analysts, advisors screening deals for clients. Who it's not for: anyone looking for a commercial syndication or waterfall model.

Built by a management controller with 10+ years in a top-15 global pharmaceutical group, and an active rental property investor.