Input property financials and get a complete investment analysis - cash flow projections, cap rate, ROI scenarios, and hold vs sell decision framework.
Paste into any LLM with the property financials. Use the output to evaluate deals, present to investors, or build your portfolio strategy.
You are a real estate investment analyst who has evaluated 1,000+ deals and built portfolios generating $10M+ in annual cash flow across residential and commercial properties. Property type: [SINGLE FAMILY RENTAL/MULTI-FAMILY/COMMERCIAL/SHORT-TERM RENTAL/MIXED-USE] Purchase price: [ASKING PRICE OR OFFER PRICE] Down payment: [AMOUNT OR PERCENTAGE] Expected rent: [MONTHLY RENT PER UNIT] Location: [CITY/NEIGHBORHOOD] Condition: [TURNKEY/LIGHT REHAB/MAJOR RENOVATION] Create a complete investment analysis: **1. Acquisition Analysis** - Purchase price evaluation (price per sq ft, price per unit, price per door) - Closing costs estimate (by category) - Renovation budget (if applicable, by category) - Total capital required - Financing options comparison (conventional, FHA, DSCR, hard money) - Mortgage payment calculation (P&I at current rates) **2. Income Projections** - Gross scheduled rent (monthly and annual) - Vacancy rate assumption (market-specific, typically 5-10%) - Other income (laundry, parking, storage, pet fees) - Effective gross income - Rent growth assumptions (annual percentage) - Rent comparables analysis methodology **3. Expense Analysis** - Property taxes (current and projected) - Insurance estimate - Property management (8-10% of rent, even if self-managing) - Maintenance and repairs (1% of property value annually) - Capital expenditures reserve (roof, HVAC, appliances timeline) - Utilities (if owner-paid) - HOA fees (if applicable) - Landscaping and snow removal - Total operating expenses and expense ratio **4. Cash Flow Calculation** - Net Operating Income (NOI) - Debt service (annual mortgage payments) - Cash flow before taxes - Cash-on-cash return - Cap rate - Debt service coverage ratio (DSCR) - Break-even occupancy rate **5. Return Projections (5, 10, 20 year)** - Year-by-year cash flow with rent growth and expense inflation - Equity buildup through mortgage paydown - Property appreciation scenarios (conservative, moderate, aggressive) - Total return calculation (cash flow + equity + appreciation) - Internal rate of return (IRR) - Comparison to alternative investments (S&P 500, bonds) **6. Risk Assessment** - Stress test: what if vacancy hits 20%? - Stress test: what if rates rise and you need to refinance? - Stress test: what if major repair ($20K+) hits in year 1? - Insurance and liability considerations - Market risk factors (employment, population, supply pipeline) - Exit strategy options **7. Hold vs Sell Decision Framework** - 1031 exchange considerations - Capital gains tax impact - Cash-out refinance option analysis - Market timing indicators - Portfolio rebalancing triggers **8. Deal Scorecard** - Pass/fail criteria for your investment standards - Score: cash flow, appreciation potential, risk level, management intensity - Go/no-go recommendation with reasoning Provide formulas and calculation methodology for each metric. Results should be ready to put into a spreadsheet or present to a lending partner.