Evaluates real estate investment opportunities through comparable sales analysis, financial modeling (cap rate, cash-on-cash, GRM), area profiling, and due diligence checklists. Trigger: "evaluate this property", "run comps", "rental yield", "cap rate analysis", "property due diligence", "neighborhood research", "investment property". Do NOT use for general market-trend research without a specific property or area (use market-research), commercial lease negotiation, or mortgage broker advice.
Provides a structured, repeatable framework for evaluating residential or small commercial real estate. Covers property scoring, financial viability, comparable sales analysis, area profiling, and risk assessment so that buy/hold/pass decisions are grounded in evidence rather than gut feeling.
market-researchspreadsheet-analysiscompetitor-teardownCalculate each metric and show the formula used:
| Metric | Formula |
|---|---|
| Gross Rent Multiplier (GRM) | Purchase Price ÷ Annual Gross Rent |
| Cap Rate | Net Operating Income (NOI) ÷ Purchase Price × 100 |
| Cash-on-Cash Return | Annual Pre-Tax Cash Flow ÷ Total Cash Invested × 100 |
| Price per Sq Ft | Purchase Price ÷ Livable Sq Ft |
| Gross Yield | Annual Gross Rent ÷ Purchase Price × 100 |
| Net Yield | (Annual Gross Rent − Annual Expenses) ÷ Purchase Price × 100 |
Expense line items to include in NOI calculation:
Work through each item; mark as ✅ verified, ⚠️ needs attention, or ❌ blocker:
Research and score each factor on a 1–5 scale with evidence:
| Factor | Data sources |
|---|---|
| Crime stats | Local police data, CrimeMapping, NeighborhoodScout |
| School ratings | GreatSchools, Ofsted (UK), state education dept |
| Transport links | Walk Score, Transit Score, proximity to highway/rail |
| Employment | Major employers, unemployment rate, job growth trend |
| Development pipeline | Council/city planning applications, new permits, infrastructure projects |
| Demographics | Population growth, median income, age distribution, renter vs owner ratio |
| Amenities | Grocery, healthcare, parks, restaurants within 1 mile |
Build a complete acquisition budget:
Deliver these sections in order:
| Dimension | Score (1–5) | Key evidence |
|---|---|---|
| Location | ||
| Condition | ||
| Financial return | ||
| Risk profile | ||
| Area fundamentals | ||
| Overall |
Table of 3–6 comps with adjustments and derived fair market value range.
Full income/expense breakdown, all six metrics calculated, sensitivity table showing returns at ±5% purchase price and ±10% rent assumptions.
Scored factor table from Step 5 with data sources cited.
Checklist from Step 4 with status markers and notes on any open items.
Itemized budget from Step 6 with total cash required and contingency.
Top 3–5 risks ranked by likelihood × impact, with mitigation actions.
Clear Buy / Negotiate / Pass / Needs More Data verdict with reasoning.
market-research — broader market trend analysis that feeds into area profilingspreadsheet-analysis — build and audit the financial model workbookfinancial-tracker-ops — ongoing tracking of rental income and expenses post-acquisitioncompetitor-teardown — analyzing competing listings or investment opportunitiesdocument-to-structured-data — extracting data from property listings, inspection reports, or title documents