Real Estate Analyst

---
name: Real Estate Analyst
slug: real-estate-analyst
description: Property analysis, investment evaluation, and market research for real estate professionals and investors
category: domain
complexity: complex
version: "1.0.0"
author: "ID8Labs"
triggers:
  - "analyze this property"
  - "real estate investment"
  - "property valuation"
  - "market analysis"
  - "rental income analysis"
  - "cap rate calculation"
tags:
  - real-estate
  - investment-analysis
  - property-valuation
  - market-research
  - financial-modeling
---

# Real Estate Analyst

Comprehensive real estate analysis system designed for investors, agents, property managers, and developers evaluating residential and commercial properties. This skill provides detailed financial modeling, market analysis, property valuation, investment return calculations, and risk assessment to support informed real estate decisions.

The Real Estate Analyst excels at analyzing rental properties for cash flow and appreciation potential, comparing investment opportunities, evaluating market trends, calculating key metrics (cap rate, cash-on-cash return, IRR), performing comparative market analysis, and building detailed financial projections. It's valuable for buy-and-hold investors, fix-and-flip projects, commercial property evaluation, and portfolio optimization.

**Important Note:** Real estate analysis requires current market data, local market expertise, and on-the-ground property inspection. This skill provides analytical frameworks and financial modeling; always verify assumptions, gather local market data, conduct physical inspections, and consult with real estate professionals before making investment decisions.

## Core Workflows

### Workflow 1: Rental Property Investment Analysis

**Purpose:** Comprehensive financial analysis of income-producing properties to evaluate investment viability.

**Required Inputs:**
- Purchase price
- Down payment percentage
- Loan terms (interest rate, amortization period)
- Estimated rental income (monthly)
- Operating expenses (property tax, insurance, HOA, utilities, maintenance, property management, vacancy rate)
- Property details (beds, baths, square footage, year built, location)

**Analysis Components:**

**1. Purchase & Financing**
- Purchase price and closing costs
- Down payment and loan amount
- Monthly mortgage payment (P&I)
- Loan-to-value (LTV) ratio
- Debt service coverage ratio (DSCR)

**2. Income Analysis**
- Gross rental income (monthly/annual)
- Market rent comparison
- Vacancy rate adjustment (typical 5-10%)
- Other income sources (laundry, parking, storage)
- Gross operating income

**3. Operating Expenses**
- Property taxes
- Insurance (property, liability, landlord policy)
- HOA/condo fees
- Utilities (landlord-paid)
- Property management (typically 8-12% of rent)
- Repairs and maintenance (typically 1-2% of property value)
- CapEx reserves (roof, HVAC, appliances)
- Marketing/vacancy costs
- Total operating expenses

**4. Cash Flow Analysis**
- Net operating income (NOI) = Income - Operating Expenses
- Debt service (mortgage payment)
- Cash flow before taxes (NOI - Debt Service)
- Monthly and annual cash flow
- Cash flow per unit/door

**5. Investment Returns**
- **Cap Rate** = NOI / Purchase Price
  - Measure of property's unlevered return
  - Compare across similar properties
  - Typical residential: 4-10%, commercial: 5-12%
- **Cash-on-Cash Return** = Annual Cash Flow / Total Cash Invested
  - Measure of actual cash return on equity invested
  - Target: 8-12% for good deal
- **Gross Rent Multiplier (GRM)** = Purchase Price / Annual Gross Rent
  - Quick screening metric
  - Lower is better; compare to market average
- **1% Rule** = Monthly Rent / Purchase Price
  - Monthly rent should be 1%+ of purchase price
  - Quick screening tool
- **50% Rule** = Operating expenses ≈ 50% of gross rent
  - Rough estimate for screening

**6. Long-Term Projections**
- Rental income growth (2-3% annually typical)
- Expense growth (2-4% annually typical)
- Property appreciation (varies by market)
- Equity buildup from mortgage paydown
- 5-year and 10-year projections
- Exit scenarios (sale, refinance, 1031 exchange)

**7. Risk Assessment**
- Vacancy risk (local market vacancy rates)
- Expense surprises (deferred maintenance, special assessments)
- Interest rate risk (if ARM or future refinance)
- Market risk (economic downturn, oversupply)
- Tenant risk (eviction costs, property damage)
- Liquidity risk (time to sell if needed)

**Deliverables:**
- Investment summary one-pager
- Detailed financial model (5-10 year projections)
- Key metrics dashboard
- Sensitivity analysis (best/base/worst case)
- Comparison to investment criteria
- Go/no-go recommendation with rationale

### Workflow 2: Comparative Market Analysis (CMA)

**Purpose:** Determine fair market value of property by comparing to similar recently sold properties.

**Steps:**

**1. Subject Property Profile**
- Address and basic details
- Square footage, lot size
- Bedrooms, bathrooms
- Year built, condition
- Features and upgrades
- Current listing status

**2. Comparable Property Selection**
- **Location:** Within 0.5-1 mile (urban) or 1-3 miles (suburban/rural)
- **Property type:** Same type (SFR, condo, townhouse, etc.)
- **Size:** Within 10-20% of square footage
- **Bed/bath:** Same or similar configuration
- **Age:** Within 10-15 years if possible
- **Condition:** Similar condition and quality
- **Sold date:** Within last 3-6 months preferred

**3. Comparable Adjustments**
- **Square footage:** Price per SF basis
- **Bedrooms/bathrooms:** Add/subtract per bed ($5-15K) or bath ($3-10K)
- **Garage/parking:** $5-20K per space
- **Lot size:** Adjust for significantly larger/smaller lots
- **Condition:** Adjust for updated vs. dated
- **Location:** Premium for better street/view/school district
- **Sale terms:** Adjust for non-arms-length transactions

**4. Valuation Range**
- Low estimate (most conservative comp)
- Mid estimate (weighted average of comps)
- High estimate (most optimistic comp)
- Price per square foot range
- Recommended listing/offer price

**5. Market Context**
- Days on market average
- List-to-sale price ratio
- Inventory levels (months of supply)
- Market trend (appreciating, stable, declining)
- Seasonal factors

**Deliverables:**
- CMA report with 3-5 comparable sales
- Adjusted values showing calculation methodology
- Price recommendation with supporting data
- Market trends summary
- Agent presentation-ready format

### Workflow 3: Fix-and-Flip Analysis

**Purpose:** Evaluate profitability of purchasing, renovating, and reselling a property.

**Key Inputs:**
- Purchase price
- Renovation/repair costs (itemized)
- Holding period (months)
- After-repair value (ARV)
- Financing terms (hard money, private, conventional)
- Transaction costs (buying and selling)

**Analysis:**

**1. Acquisition Costs**
- Purchase price
- Closing costs (2-3% of purchase)
- Inspection/appraisal fees
- Due diligence costs

**2. Renovation Budget**
- Detailed scope of work
- Material costs
- Labor costs
- Permits and fees
- Contingency (10-20% of renovation budget)
- Total renovation costs

**3. Holding Costs**
- Loan payments during renovation
- Property taxes (prorated)
- Insurance
- Utilities
- HOA fees (if applicable)
- Estimated holding period: acquisition + renovation + marketing/sale

**4. Selling Costs**
- Real estate commission (5-6% typical)
- Closing costs/concessions
- Staging costs
- Final cleaning/touch-ups

**5. Profit Calculation**
- After-repair value (ARV) - based on CMA
- Total project costs (acquisition + renovation + holding + selling)
- Gross profit = ARV - Total Costs
- Return on investment (ROI) = Gross Profit / Total Investment
- Annualized ROI (adjusting for holding period)

**6. 70% Rule Check**
- Maximum purchase price = (ARV × 0.70) - Renovation Costs
- Ensures minimum 30% margin for costs and profit
- Industry standard for fix-and-flip screening

**7. Risk Factors**
- Scope creep (renovation exceeds budget)
- Timeline delays (holding costs increase)
- ARV overestimation (market softens)
- Unforeseen repairs (foundation, mold, structural)
- Permit delays or inspection failures
- Market timing (selling in slow season)

**Deliverables:**
- Deal analyzer one-sheet
- Detailed cost breakdown
- Profit projection with sensitivity analysis
- Renovation budget template
- Timeline with key milestones
- Go/no-go recommendation

### Workflow 4: Market Research & Trends Analysis

**Purpose:** Understand local real estate market conditions, trends, and investment opportunities.

**Research Areas:**

**1. Market Overview**
- Geographic area definition (city, neighborhood, zip code)
- Population and demographic trends
- Economic indicators (employment, income, growth)
- Major employers and industries
- School ratings and quality

**2. Housing Market Metrics**
- Median home prices (current and 1/3/5/10 year trends)
- Price per square foot trends
- Inventory levels (months of supply)
- Days on market (average)
- List-to-sale price ratio
- New construction activity
- Foreclosure/distressed sale rates

**3. Rental Market Analysis**
- Average rent by property type and size
- Vacancy rates
- Rent growth trends
- Rent-to-income ratio
- Demand drivers (job growth, universities, tourism)
- Competition analysis

**4. Investment Opportunity Identification**
- Emerging neighborhoods (gentrification indicators)
- Value-add opportunities (underperforming assets)
- Development potential (zoning, infill sites)
- Market inefficiencies (mispriced assets)
- Distressed opportunities (foreclosures, estate sales)

**5. Macro Trends**
- Interest rate environment
- Local/regional economic outlook
- Policy changes (zoning, rent control, tax incentives)
- Infrastructure projects (transit, highways, developments)
- Migration patterns (in-migration vs. out-migration)

**Data Sources:**
- MLS data (via agent access)
- Zillow, Redfin, Realtor.com
- County assessor/recorder offices
- Census data and demographic reports
- CoStar, LoopNet (commercial)
- Local economic development agencies

**Deliverables:**
- Market report with key statistics and trends
- Neighborhood comparison matrix
- Investment opportunity heat map
- Market cycle assessment (recovery, expansion, hyper-supply, recession)
- Strategic recommendations for investors

## Quick Reference

| Action | Command/Trigger |
|--------|-----------------|
| Analyze rental property | "Analyze rental at [address/details] for [price]" |
| Calculate cash flow | "Calculate cash flow for [property details]" |
| CMA/valuation | "What's the market value of [property details]?" |
| Fix-flip analysis | "Flip analysis for [purchase price], [renovation cost], [ARV]" |
| Cap rate calculation | "Calculate cap rate for [NOI], [price]" |
| Compare investments | "Compare [Property A] vs [Property B]" |
| Market research | "Research [neighborhood/city] real estate market" |
| Rental income estimate | "What's market rent for [property type] in [area]?" |
| Mortgage calculation | "Calculate payment for [loan amount], [rate], [term]" |
| Investment screening | "Does this meet 1% rule? [rent], [price]" |

## Best Practices

### Due Diligence Excellence
- **Physical inspection is mandatory** - Never buy sight unseen; hire professional inspectors
- **Verify rent assumptions** - Call comparable properties to confirm actual rents, don't trust online estimates
- **Underwrite conservatively** - Use realistic vacancy rates (8-10%), maintenance (1-2% of value annually)
- **Build in contingencies** - Expect unexpected costs; budget 10-20% contingency for renovations
- **Check zoning and permits** - Verify intended use is permitted and no code violations exist

### Financial Modeling Standards
- **Use consistent assumptions** - Document all assumptions and sources
- **Run sensitivity analysis** - Test best case, base case, worst case scenarios
- **Include all costs** - Don't forget closing costs, HOA, CapEx reserves, property management
- **Be realistic about timeline** - Renovations take longer than expected; factor holding costs
- **Account for taxes** - Consider income tax on rental income and capital gains on sale

### Market Analysis Rigor
- **Use recent comps** - Properties sold 6+ months ago may not reflect current market
- **Quality over quantity** - 3 excellent comps better than 10 mediocre ones
- **Adjust systematically** - Document why each adjustment is made and methodology
- **Know the micro-market** - Same zip code can have vastly different submarkets
- **Trust data, not emotions** - Don't fall in love with a property; let numbers guide you

### Risk Management
- **Maintain reserves** - 6 months of expenses minimum for rental properties
- **Diversify** - Don't put all capital into one property or one market
- **Insurance adequacy** - Proper coverage for property, liability, loss of income
- **Legal protection** - LLC or other entity structure to protect personal assets
- **Exit strategy** - Know how you'll get out before you get in

### Investment Criteria (Set Your Standards)
**Rental Properties:**
- Minimum cash-on-cash return: 8-12%+
- Minimum cap rate: 6-10%+ (varies by market)
- Maximum price: Meets 1% rule or local equivalent
- Debt service coverage ratio: 1.25+ (income covers debt by 25%+)
- Location: B or better neighborhoods (A=best, D=worst)

**Fix-and-Flip:**
- Minimum ROI: 15-20%+
- Maximum purchase: 70% rule or better
- Holding period: <6 months ideal
- ARV confidence: High (multiple solid comps)
- Renovation scope: Within your expertise/contractor capability

## Key Metrics Explained

### Cap Rate (Capitalization Rate)
**Formula:** Cap Rate = Net Operating Income (NOI) / Purchase Price
**Meaning:** Unlevered return on property; what you'd earn if bought with cash
**Use:** Compare similar properties; higher cap rate = higher return but often higher risk
**Ranges:** Residential 4-10%, commercial 5-12%, varies greatly by market and property quality

### Cash-on-Cash Return
**Formula:** Cash-on-Cash = Annual Cash Flow / Total Cash Invested
**Meaning:** Actual cash return on the money you put in (down payment + closing costs)
**Use:** Measure leveraged return; shows power of financing
**Target:** 8-12%+ for strong deal; lower acceptable in high-appreciation markets

### Internal Rate of Return (IRR)
**Meaning:** Time-weighted return accounting for all cash flows over holding period
**Use:** Compare investments with different holding periods and cash flow patterns
**Calculation:** Complex; requires financial calculator or spreadsheet
**Target:** 15-20%+ for value-add deals; 10-15% for stable cash flow

### Gross Rent Multiplier (GRM)
**Formula:** GRM = Purchase Price / Annual Gross Rent
**Meaning:** How many years of rent to pay back purchase price
**Use:** Quick screening tool; compare to market average GRM
**Interpretation:** Lower is better; GRM of 10 = 10 years of rent = purchase price

### Debt Service Coverage Ratio (DSCR)
**Formula:** DSCR = Net Operating Income / Annual Debt Service
**Meaning:** How well income covers mortgage payments
**Use:** Lender requirement; risk assessment
**Standard:** Lenders typically require 1.20-1.25+ (income 20-25% higher than debt)

### Return on Investment (ROI)
**Formula:** ROI = (Net Profit / Total Investment) × 100
**Meaning:** Total return as percentage of invested capital
**Use:** Overall profitability assessment
**Annualized:** Adjust for holding period to compare different durations

## Property Types & Considerations

### Single-Family Residences
**Pros:** Easy to finance, broad buyer pool, low management complexity
**Cons:** Vacancy = 100% loss, single point of failure, slower to scale
**Best for:** First-time investors, long-term buy-and-hold

### Multi-Family (2-4 units)
**Pros:** Residential financing, vacancy diversification, easier to scale
**Cons:** More management intensive, higher purchase price
**Best for:** Growing portfolio, investors wanting cash flow and scale

### Apartments (5+ units)
**Pros:** Best for scaling, commercial appraisal (valued on income), professional management
**Cons:** Commercial financing, higher capital requirement, complexity
**Best for:** Experienced investors, syndications, full-time operators

### Condos/Townhouses
**Pros:** Lower price point, amenities included, limited exterior maintenance
**Cons:** HOA fees and restrictions, special assessments, harder to finance for investors
**Best for:** High-demand urban areas, limited capital

### Commercial (Retail/Office/Industrial)
**Pros:** Longer leases, tenant pays expenses (NNN), higher cap rates
**Cons:** Economic sensitivity, specialized knowledge required, larger capital
**Best for:** Sophisticated investors, diversification from residential

## Market Cycles & Timing

**Phase 1: Recovery**
- Characteristics: High vacancy, low rents, distressed sales
- Strategy: Buy aggressively, value-add opportunities

**Phase 2: Expansion**
- Characteristics: Decreasing vacancy, rising rents, increasing values
- Strategy: Buy and hold, rental income focus

**Phase 3: Hyper-Supply**
- Characteristics: Overbuilding, peak prices, rising vacancy
- Strategy: Sell or refinance, reduce risk exposure

**Phase 4: Recession**
- Characteristics: Falling prices, high vacancy, foreclosures
- Strategy: Preserve capital, wait for recovery, opportunistic buys

**Timing Indicators:**
- Rent growth rates (slowing = late cycle)
- Months of inventory (increasing = buyer's market)
- New construction starts (high = potential oversupply)
- Interest rates (rising = pressure on prices)
- Local job growth (negative = recession risk)

## Confidence Signaling

**High Confidence Areas:**
- Financial modeling and metric calculations
- Standard investment analysis frameworks
- Comparative analysis methodologies
- Cash flow and return projections

**Medium Confidence Areas:**
- Market-specific cap rates and valuation ranges
- Renovation cost estimation
- Local market trends and dynamics
- Property appreciation forecasts

**Requires Local Expertise:**
- Specific neighborhood quality and desirability
- Micro-market price variations
- Local regulations and permit processes
- School district rankings and impact
- Future development and infrastructure plans
- Contractor pricing and availability
- Property management fee norms
- Actual market rents and vacancy rates

**Always Verify:**
- Property condition through professional inspection
- Zoning and permit compliance
- Title and legal issues
- Actual rent comps (call properties)
- HOA financials and restrictions
- Tax assessment and potential changes
- Insurance availability and cost

## Resources & Data Sources

**Property Search & Comps:**
- MLS (via real estate agent)
- Zillow, Redfin, Realtor.com
- PropStream, REIPro (investor tools)
- Auction.com (distressed properties)

**Market Data:**
- Local MLS market reports
- Zillow Research, Redfin Data Center
- Census.gov (demographics)
- BLS.gov (employment data)
- Local economic development agencies

**Analysis Tools:**
- BiggerPockets calculators (free)
- REI Blackbook, Property Evaluator
- Excel/Google Sheets (custom models)
- Rentometer (rent estimates)
- PadMapper, Craigslist (rent comps)

**Education:**
- BiggerPockets forums and podcast
- Local REIA (Real Estate Investors Association)
- Real estate investing books (Rich Dad Poor Dad, The Book on Rental Property Investing)

---

**Final Reminder:** Real estate investing involves significant capital, risk, and local market knowledge. This skill provides analytical frameworks and financial modeling support. Always conduct thorough due diligence, inspect properties in person, verify all assumptions with local data, and consult with real estate professionals, attorneys, CPAs, and lenders before making investment decisions.