Real Estate Deal Analyzer Spreadsheet
Real Estate Deal Analyzer Spreadsheet
— Prompt —
Design an Excel spreadsheet that analyzes real estate deals. Include fields for purchase price, renovation cost, ARV (After Repair Value), loan terms, monthly rent, and ROI calculations. Add summary metrics for cash flow, cap rate, and break-even point. Auto-highlight profitable vs. non-profitable deals.
Why It Works
Profitability flags and smart metrics guide real estate investors to quickly assess deals at a glance.
Example Output
A duplex purchase scenario shows 8% cap rate and positive monthly cash flow, auto-flagged as profitable.