Real Estate

Real Estate Investment Analyzer

Input property numbers and get a complete investment analysis with cash flow projections, cap rate, ROI, and risk assessment.

By The Prompt Black Magic Team

Paste into any LLM with your property financials. Get back a comprehensive investment analysis.

You are a real estate investment analyst who has underwritten over $500M in residential and commercial deals.

Property address/description: [PROPERTY]
Purchase price: [PRICE]
Down payment: [AMOUNT OR PERCENTAGE]
Interest rate: [RATE]
Loan term: [YEARS]
Monthly rent (expected): [RENT]
Property taxes (annual): [TAXES]
Insurance (annual): [INSURANCE]
HOA/condo fees: [IF APPLICABLE]
Expected repairs/capex: [ESTIMATE]
Property management: [SELF-MANAGED OR % FEE]
Vacancy assumption: [PERCENTAGE]

Deliver a complete investment analysis:

**1. Cash Flow Analysis**
- Monthly income breakdown
- Monthly expense breakdown (PITI + all operating expenses)
- Net operating income (NOI)
- Monthly cash flow after debt service
- Annual cash flow
- Cash-on-cash return

**2. Return Metrics**
- Cap rate
- Cash-on-cash return
- Gross rent multiplier
- Debt service coverage ratio (DSCR)
- Break-even occupancy rate

**3. 5-Year Projection**
- Year-by-year cash flow (assuming 3% rent growth, 2% expense growth)
- Equity buildup from mortgage paydown
- Appreciation scenarios (conservative 3%, moderate 5%, optimistic 7%)
- Total return including all sources (cash flow + equity + appreciation)

**4. BRRRR Analysis (if applicable)**
- After-repair value estimate
- Refinance potential
- Cash recaptured after refi
- Infinite return scenario viability

**5. Risk Assessment**
- Stress test: what if rent drops 10%, 20%?
- Stress test: what if vacancy doubles?
- Stress test: what if rates rise at refi?
- Major capex timeline (roof, HVAC, etc.)
- Market risk factors

**6. Verdict**
- Buy / pass / negotiate recommendation
- What price would make this a strong deal
- Comparable properties to look at

Show all math. No hand-waving.

When to Use This Prompt

Expected Results

How to Customize This Prompt