AI Prompts for Real Estate Analysts: Valuation, Feasibility, Market Studies

Published: July 2026 | 8 min read

Real estate analysts bridge the gap between raw data and investment decisions. AI can accelerate valuation models, market studies, and feasibility analysis, but only when prompts define the property type, market context, valuation methodology, and required outputs. Structured prompts turn AI into a junior analyst who never sleeps.

Below are production-ready AI prompts, organized by workflow. These are adapted from Skillent's AI Prompt Library.

Property Valuation

1. Sales Comparison Approach

Role: Real estate valuation analyst
Task: Perform a sales comparison valuation for [property].
Subject: [address, type, beds/baths, SF, lot size, year built, condition]
Comparable sales (5-8): [list addresses, sale prices, dates, specs]
For each comp:
1. Sale price and $/SF
2. Adjustments needed (size, condition, location, time, features)
3. Net adjusted price
4. Weight (closer comps weighted higher)
Indicated value range: $[X] to $[Y]
Point estimate: $[X]
Output: Sales comparison grid with adjustments and concluded value.

2. Income Approach Valuation

Role: Real estate income analyst
Task: Value [property] using the income approach.
Property: [address, type, units, current rents]
Gross potential rent: $[X]/year
Vacancy rate: [X]%
Operating expenses: $[X]/year (itemized)
NOI: $[X]
Cap rate: [X]% (based on market comps)
Value = NOI / cap rate = $[X]
Also calculate:
1. GRM (Gross Rent Multiplier) approach
2. DCF (10-year, [X]% discount rate, [X]% exit cap)
3. Value per unit / value per SF
Reconcile: Weight the approaches and conclude value
Output: Income approach valuation with both methods reconciled.

3. Cost Approach Estimate

Role: Real estate cost estimator
Task: Estimate value using the cost approach for [property].
Property: [address, type, SF, land SF]
Land value: $[X] (from land comps)
Building replacement cost: $[X] (based on $/SF construction cost for type)
Or reproduction cost: $[X] (for unique/historic)
Depreciation:
1. Physical deterioration: $[X] (deferred maintenance, systems age)
2. Functional obsolescence: $[X] (layout issues, outdated design)
3. External obsolescence: $[X] (neighborhood decline, zoning change)
Total depreciation: $[X]
Depreciated building value: $[X]
Value = Land + Depreciated building = $[X]
Output: Cost approach summary with depreciation breakdown.

Feasibility & Development Analysis

4. Development Feasibility Study

Role: Real estate development analyst
Task: Conduct a feasibility analysis for [project type] on [site].
Site: [address, size, zoning, entitlements]
Project: [describe — multifamily, retail, mixed-use, office]
Program: [number of units/SF, parking ratio, amenities]
Development budget:
- Land: $[X]
- Hard costs: $[X] ($/SF construction)
- Soft costs: $[X] (design, permits, legal, financing)
- Contingency: [X]%
- Total: $[X]
Revenue projections:
- stabilized NOI: $[X]/year
- stabilized value at [X]% cap: $[X]
Feasibility metrics:
1. Development yield (stabilized value / total cost)
2. Development spread (development yield vs. market cap rate)
3. Profit margin (stabilized value - total cost) / stabilized value
4. Cost per SF / cost per unit
5. Break-even rent (what rent makes this work?)
6. IRR over [X]-year hold
Output: Feasibility summary with go/no-go recommendation.

5. Highest and Best Use Analysis

Role: Real estate land use analyst
Task: Determine highest and best use for [site].
Site: [address, size, zoning, current use]
Possible uses: [list 4-6 alternatives — residential, retail, office, mixed, industrial]
For each use, test 4 criteria:
1. Legally permissible (zoning, codes, entitlements)
2. Physically possible (site constraints, soil, access, utilities)
3. Financially feasible (does revenue exceed costs?)
4. Maximally productive (which use produces highest value?)
For each feasible use:
- Development cost estimate
- Stabilized value
- Profit potential
- Risk level
Output: Highest and best use determination with ranking.
Include: What entitlement changes would be needed for the top use.

6. Pro Forma Cash Flow Model

Role: Real estate financial modeler
Task: Build a 10-year pro forma for [property].
Property: [address, type, RSF, current occupancy]
Year 0 assumptions:
- Purchase price: $[X]
- Initial NOI: $[X]
- Financing: $[X] debt at [X]% rate, [X]-year amortization
For years 1-10:
1. Gross potential rent (growth: [X]%/year)
2. Vacancy loss ([X]%)
3. Other income (parking, storage, escalators)
4. Operating expenses (growth: [X]%/year)
5. NOI
6. Debt service (fixed)
7. Cash flow before taxes
8. Principal balance at year end
Exit assumptions:
- Year 10 sale at [X]% exit cap rate
- Selling costs: [X]%
- Payoff remaining balance
Calculate:
1. IRR (levered and unlevered)
2. Equity multiple
3. Cash-on-cash return (year 1 and average)
4. DSCR (year 1 and minimum)
Output: Full pro forma table with return metrics.

Market Analysis

7. Demographic & Economic Analysis

Role: Real estate market researcher
Task: Analyze demographics and economics for [market] relevant to [property type].
Market: [MSA/city/submarket]
Property type: [residential/retail/office/industrial]
Analyze:
1. Population trends (5-year growth, projections, age distribution)
2. Household income (median, growth, distribution)
3. Employment (major industries, growth sectors, unemployment trend)
4. Migration patterns (in-migration vs. out-migration, source/destination)
5. For residential: homeownership rate, household formation, renter demographics
6. For retail: consumer spending, retail sales, trade area capture
7. For office: employment by sector, office-using employment, job growth
8. For industrial: logistics employment, port/rail access, warehousing demand
Output: Demographic and economic profile (1,500 words) with investment implications.

8. Supply & Demand Analysis

Role: Real estate market analyst
Task: Analyze supply and demand for [property type] in [market].
Current inventory: [X] SF or [X] units
Vacancy rate: [X]%
Under construction: [X] SF or units (list projects)
Planned/pipeline: [X] SF or units
Demand drivers:
- Annual absorption (last 3 years): [X] SF/year
- Employment growth: [X] jobs/year
- Household formation: [X]/year
Forecast:
1. Projected supply additions (next 3 years): [X]
2. Projected demand (based on employment/household growth): [X]
3. Will supply exceed demand? When?
4. Impact on vacancy rates and rents
5. Submarket differences (where is demand strongest?)
Output: Supply-demand balance analysis with 3-year forecast.

Investment Memorandum & Reporting

9. Investment Memo Summary

Role: Real estate investment analyst
Task: Write a one-page investment memo for [property].
Property: [address, type, size]
Purchase price: $[X] ($/SF)
Cap rate: [X]%
Key metrics: IRR [X]%, equity multiple [X]x, DSCR [X]
Structure:
1. Investment thesis (3 sentences — why this deal makes sense)
2. Property overview (2 sentences — what it is)
3. Market overview (2 sentences — why this market)
4. Financial highlights (bullet list — price, cap rate, IRR, DSCR, cash-on-cash)
5. Value creation strategy (3 bullets — how we make money)
6. Key risks (3 bullets — what could go wrong)
7. Recommendation (buy/pass with rationale)
Output: One-page memo, 500 words max, executive-ready.

10. Quarterly Asset Report

Role: Real estate asset manager
Task: Write a quarterly asset report for [property].
Property: [name, type, size]
Q[X] [Year] performance:
- Occupancy: [X]% (vs. [X]% last quarter)
- NOI: $[X] (vs. budget $[X])
- Cash flow: $[X] (vs. budget $[X])
Sections:
1. Executive summary (3 sentences — how the quarter went)
2. Occupancy report (lease-ups, move-outs, rollover schedule)
3. Financial performance vs. budget (variance analysis)
4. Capital projects status (what's being built/repaired, % complete, budget vs. actual)
5. Market update (rent trends, competitor activity, economic indicators)
6. Tenant issues (delinquencies, complaints, renewals in progress)
7. Next quarter priorities (3-5 action items)
Output: 2-3 page quarterly report ready for investor distribution.

11. Comparable Sales Database Builder

Role: Real estate data analyst
Task: Organize these raw comparable sales into a structured database.
Raw data: [paste 20-30 comp sales with varying detail levels]
For each comp:
1. Property address
2. Sale date
3. Sale price
4. $/SF
5. Property type
6. Size (SF or acres)
7. Cap rate (if investment sale)
8. Year built
9. Occupancy at sale
10. Buyer/seller (if known)
11. Notes (special terms, condition, etc.)
Sort by: Sale date (most recent first)
Flag: Comps older than 12 months, comps outside [submarket], comps with unusual terms
Output: Cleaned database table, ready for Excel import.
Include: Summary statistics (median $/SF, median cap rate, count by type).

12. Zoning & Entitlement Analysis

Role: Real estate land use analyst
Task: Analyze zoning and entitlement requirements for [site] with [proposed use].
Site: [address, current zoning, lot size]
Proposed use: [describe — multifamily, mixed-use, commercial, etc.]
Current zoning analysis:
1. Permitted uses (is proposed use permitted by-right, conditional, or prohibited?)
2. Development standards (setbacks, height limit, FAR, density, parking)
3. Does proposed project comply? If not, what variances needed?
4. Entitlement process:
   - By-right (administrative approval, timeline [X] months)
   - Conditional use permit (public hearing, timeline [X] months)
   - Rezoning (legislative, timeline [X] months, political risk)
   - Variance (board of adjustment, timeline [X] months)
5. Required studies (traffic, environmental, fiscal impact)
6. Community engagement requirements
7. Estimated timeline and cost to entitlement
Output: Zoning and entitlement analysis with recommended path.

Best Practices

1. Always define the role and context — professional prompts produce professional output

2. Specify output format — table, checklist, narrative, or structured document

3. Include industry-specific parameters — regulations, market conditions, jurisdiction

4. Set constraints — what to avoid, word limits, prohibited content

5. Always human-review — AI output is a first draft, not a final product.

Related: Check out our guides on ChatGPT prompts for real estate investors and AI prompts for commercial real estate.