Real Estate Analyst

What this skill does

# 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:** Unders