⚡ Promptolis Original · Money & Finance
📊 Home-Buying Comparative Market Analysis (CMA)
CMA methodology grounded in USPAP appraisal standards + Appraisal Institute adjustment framework — sold comps only, 90-day freshness, systematic per-comp adjustments, offer-range estimation.
Why this is epic
Most buyers trust their agent's 'market value' estimate without validation. Agent CMAs are often optimistic (agent wants the sale). Real CMA methodology — sold comps only, 90-day freshness, systematic adjustments — produces honest offer ranges. This prompt teaches the methodology.
Systematic adjustment framework: $70/sqft, $15-20K per updated bathroom, $25-35K updated kitchen, $25K per 0.05 acre lot size, $20-40K for renovation quality. Instead of 'comps say $525K', you get 'adjusted comp values $528K, $549K, $479K = range $515-545K with confidence'.
Prevents the two biggest buyer mistakes: (1) paying agent's quoted value as an offer anchor when comps don't support it, (2) missing walk-away threshold when seller won't negotiate to fair value. Saves buyers $10-30K on typical home purchase.
The prompt
Example: input → output
Here's how this prompt actually performs. Real input below, real output from Claude Opus 4.
Target property: 123 Oak St, 4BR 2.5BA, 2,400 sqft, 0.25 acre lot, built 2005, updated kitchen, original bathrooms List price: $550,000 Market trend: Flat last 6 months (was appreciating 5% in prior year) Comparable sales: - Comp 1: 125 Oak St (same street!), sold 30 days ago, $535K, 4BR 2.5BA 2,350 sqft, 0.22 acre, built 2003, updated kitchen + bathrooms - Comp 2: 45 Maple Dr (same subdivision), sold 60 days ago, $520K, 4BR 2BA 2,200 sqft, 0.28 acre, built 2008, original kitchen + baths - Comp 3: 78 Oak St, sold 45 days ago, $565K, 5BR 3BA 2,600 sqft, 0.30 acre, built 2006, fully renovated Unique features: Corner lot (slightly larger), mature landscaping Known concerns: Bathrooms original (circa 2005, functional but dated) Analyze.
Your Home-Buying CMA Analysis — 123 Oak St
Comp Quality Assessment
Comp 1 (125 Oak St): EXCELLENT comp. Same street, sold 30 days ago, virtually identical size (2,350 vs 2,400 sqft = +2%), same age (2003 vs 2005), only difference is updated bathrooms vs your original. Weight heavily.
Comp 2 (45 Maple Dr): GOOD comp. Same subdivision, recent sale. Smaller (2,200 sqft vs 2,400 = -8%) and original kitchen + baths vs your updated kitchen. Useful but needs adjustments.
Comp 3 (78 Oak St): FAIR comp. Same street, recent, but 5BR (extra bedroom) + fully renovated + larger (2,600 sqft = +8%) + larger lot. Useful as upper bound but needs significant downward adjustment.
All 3 comps are valid — same street/subdivision, within 60 days, similar era. Good comp set.
Per-Comp Adjustments
Using standard adjustment methodology:
- Square footage: ~$70/sqft in this market
- Updated bathroom: $15-20K each ($30K for 2.5 baths fully updated)
- Updated kitchen: $25-35K (you have this, so removes)
- Bedroom: $15-20K for extra bedroom
- Lot size: $25K per 0.05 acre difference
- Renovation quality: $25-50K for fully renovated
Comp 1 (125 Oak St, sold $535K)
- Size: +50 sqft smaller than target = +$3,500 (add)
- Lot: 0.22 vs 0.25 = slightly smaller lot = +$7,000 (add)
- Bathrooms: updated vs your original = -$15-20K (subtract because yours are dated)
- Kitchen: both updated = neutral
- Adjusted value contribution: $535K + $3.5K + $7K - $17.5K = $528K
Comp 2 (45 Maple Dr, sold $520K)
- Size: -200 sqft = +$14,000 (add, yours is bigger)
- Bathrooms: 2 vs 2.5 = +$5,000 (add, you have half-bath)
- Bathrooms condition: original vs original = neutral
- Kitchen: original vs your updated = +$25,000 (add, yours has updated)
- Lot: 0.28 vs 0.25 = -$15K (subtract, they have bigger lot)
- Adjusted value contribution: $520K + $14K + $5K + $25K - $15K = $549K
Comp 3 (78 Oak St, sold $565K)
- Size: -200 sqft = +$14K (add, yours is smaller)
- Extra bedroom: -$17K (subtract, they have 5BR you have 4)
- Bathrooms condition: fully renovated vs original = -$20K (subtract)
- Kitchen: both fully renovated vs updated = -$10K (subtract, theirs higher quality)
- Lot: 0.30 vs 0.25 = -$25K (subtract, they have bigger lot)
- Adjusted value contribution: $565K - $14K - $17K - $20K - $10K - $25K = $479K
Target Property Estimated Value Range
Adjusted comp values: $528K, $549K, $479K
- Average: $519K
- Weighted average (Comp 1 heavy, Comp 3 light): ~$530K
- Range: $515K-545K
Your corner lot + mature landscaping = slight premium (~$5K) — bringing range to $520K-550K.
Target Value: ~$530K-540K
Offer Strategy
List price: $550,000
Your estimated value: $530-540K
List price premium: $10-20K above adjusted value
Recommended Opening Offer: $525,000-528,000
Why:
- 4-5% below list price is normal + reasonable in flat market
- Anchors near your estimated value
- Leaves room for seller counter (they'll likely counter around $540K)
- You can meet at $535-540K, which is your fair-value range
Negotiation Plan
If seller counters $545K: Counter $535K. 'Based on recent comps on Oak St and same subdivision, fair market value is around $535K. We're prepared to close at that price.'
If seller counters $540K: Accept or split at $537-538K.
If seller refuses anything below $548K: Walk. You'd be paying 2-4% above fair market value. In flat market, that's 1-2 years of appreciation you're pre-paying.
If seller accepts $525K: You got a great deal. Proceed to inspection immediately.
Market Trend Layer
Flat last 6 months + 5% appreciation prior year: No trend-based premium justified. Use adjusted comp values directly. If this were rapidly appreciating (10%+ YoY), add 2-4% premium. If declining (-5% YoY), subtract 3-5%.
Your market = use comps as-is.
Red Flags / Due Diligence Items
1. Verify list price vs prior sale: Check public records for purchase price + date of current owner. If they bought at $425K in 2019 and listed at $550K in 2026 = reasonable appreciation. If they bought at $520K in 2024 and listed at $550K now = aggressive.
2. Days on market: Listed 45+ days without offers = priced too high; you have more leverage. Listed 7 days with offers = less room to negotiate.
3. Original bathroom condition: Your $15-20K bathroom adjustment assumes functional-but-dated. If inspection reveals tile issues, tub problems, or water damage, bathroom could need $25-40K work. Re-negotiate if inspection reveals.
4. HOA/taxes for subdivision: Is this HOA? Annual dues? Property tax rate? These affect your total monthly cost beyond mortgage.
5. School district verification: Confirm the specific schools for this address — sometimes school zoning changes. Schools are huge price drivers.
6. Upcoming assessments/developments: Any planned neighborhood developments? Rising property taxes? Special assessments? HOA reserves health?
Confidence Level + Caveats
Confidence: HIGH for range, MEDIUM for specific dollar
Your comp set is strong (same street, same subdivision, recent sales, similar age). Range estimate $520-550K is reliable.
Specific offer price within range is judgment call. $525K is moderately aggressive, $535K is middle, $540K is accommodating.
When to use a professional appraiser (beyond this analysis):
- Offer above $500K in most markets
- Unique property features (waterfront, historic, custom)
- Rural or small-town markets with thin comp data
- Investment property (appraiser adds credibility for lender)
Your lender will REQUIRE an appraisal before closing regardless. Their appraisal is the final word for loan purposes.
Key Takeaways
- Estimated fair market value: $530-540K. List price $550K is $10-20K above market.
- Opening offer: $525-528K. 4-5% below list is reasonable in flat market.
- Target landing zone: $535-540K (fair value + slight seller-accommodation).
- Walk away above $548K — paying 2-4% premium in flat market is mistake.
- Comp 1 (125 Oak St) is strongest comp — same street, similar size, 30 days old. Weight heavily.
- Original bathrooms = your main negotiation lever ($15-20K value differential). Use in negotiation if seller pushes back on your offer.
- Verify DOM + prior sale history before finalizing offer. Longer DOM = more leverage for you.
- Professional appraisal required by lender anyway. Your CMA analysis helps with offer; appraisal validates for loan.
NOT appraisal advice. This is pre-offer market analysis. Professional USPAP-compliant appraisal required for loan closing. Work with licensed agent + real estate attorney for specific transaction needs.
Common use cases
- First-time homebuyers validating their agent's CMA before offering
- Experienced buyers in unfamiliar markets needing independent analysis
- Buyers in appreciating markets wanting to avoid overpaying
- Investors running quick CMA on multiple potential deals
- Anyone considering a list-price offer (is list price actually fair?)
- Buyers negotiating after multiple price reductions (has it hit fair value yet?)
- Those comparing multiple homes in same neighborhood
- Anyone in thin-data markets (rural, luxury) needing systematic approach
- Buyers whose lender appraisal came in lower than offer (why + next steps)
- Those wanting a second opinion before waiving appraisal contingency
Best AI model for this
Claude Opus 4 or GPT-5 Thinking for multi-comp detailed adjustment. Any LLM for basic CMA range estimation.
Pro tips
- Sold comps only. Active listings are aspirational; sold prices are real market data.
- 90-day freshness maximum. Markets move — 6-month-old comps are stale.
- Same school district. 2-block boundary shift can mean 10-20% value difference.
- Systematic adjustments: +/-$70/sqft, $15-20K updated bathroom, $25-35K updated kitchen, $25K per 0.05 acre.
- Range > single number. 'Value $515-545K' is honest; '$527,500' is false precision.
- Market trend layer: flat market = comps as-is. Appreciating = slight premium. Declining = subtract 3-5%.
- Your offer range = (adjusted comp avg) ±5%. Higher in seller's markets, lower in buyer's.
- Walk-away threshold = 8-10% above adjusted CMA. Overpaying that much rarely recovers.
- Days-on-market signal: 7 days with offers = less leverage; 45+ days no offers = more leverage.
- Distressed sales (foreclosure, estate) as comps need +10-20% adjustment for below-market pricing.
Customization tips
- For NEW CONSTRUCTION comps, adjust carefully. Builder incentives (closing cost credits, upgrades) reduce effective sold price by 3-8%. Always ask: 'Were incentives or concessions included?' before using as comp.
- For LUXURY HOMES ($1M+), standard comp methodology breaks down — fewer comps, more unique features. Consider: 3-5 mile radius if needed, 180-day window if limited recent sales, add 'feature adjustments' more carefully (view, pool, custom kitchen).
- For RURAL / THIN-DATA MARKETS, CMA is harder. Expand to: 5-10 mile radius, 180-day window, even different subdivision if necessary. Professional appraisal more important.
- For DISTRESSED SALES (foreclosure, short sale, estate) as comps, adjust +10-20% for below-market pricing. These sales don't reflect normal market value.
- For LISTINGS WITH PRICE DROPS, current list price is misleading. Use original list price minus typical buyer discount (3-5%) to estimate where market-serious comps would land.
- For OFF-MARKET or POCKET LISTINGS (not on MLS), comp methodology still works but data harder to find. Agent network + neighborhood conversations matter more.
- For MULTI-FAMILY or INVESTMENT property comps, add income-based analysis: GRM (Gross Rent Multiplier), cap rate for the comp. A 4-unit that sold at $850K renting $6,500/mo is different comp than one renting $8,000/mo.
- For CONDOS, HOA/assessment matters significantly for comp comparison. A $500K condo with $800/mo HOA is different effective price than one with $300/mo HOA. Add HOA capitalization: ($500/mo HOA difference × 12 × 20 years = $120K effective price differential).
- If comps consistently sell within 7 days at or above list, you're in a seller's market — adjust your offer strategy. Under-offering in true seller's markets just means you lose the house to another buyer.
- If a specific comp sold way below expected range (e.g., 20%+ below other comps), investigate before using. Possible reasons: distressed sale, major undisclosed issues, family sale at below-market price. Don't average it in without understanding why.
Variants
Standard Residential
Typical SFR with 3-5 valid recent comps
Luxury Home ($1M+)
Fewer comps, more feature adjustments, wider radius
New Construction
Builder incentives adjustments (-3-8% from nominal sale price)
Rural / Thin-Data Market
180-day window, 5-10 mile radius, more professional appraisal weight
Condo / Townhouse
HOA capitalization adjustments ($500/mo HOA = $120K effective price diff)
Multi-Family Investment
Income-based comparison (GRM + cap rate) alongside sqft-based
Distressed Sale Analysis
Foreclosure / short-sale / estate — adjusted for below-market pricing
Frequently asked questions
How do I use the Home-Buying Comparative Market Analysis (CMA) prompt?
Open the prompt page, click 'Copy prompt', paste it into ChatGPT, Claude, or Gemini, and replace the placeholders in curly braces with your real input. The prompt is also launchable directly in each model with one click.
Which AI model works best with Home-Buying Comparative Market Analysis (CMA)?
Claude Opus 4 or GPT-5 Thinking for multi-comp detailed adjustment. Any LLM for basic CMA range estimation.
Can I customize the Home-Buying Comparative Market Analysis (CMA) prompt for my use case?
Yes — every Promptolis Original is designed to be customized. Key levers: Sold comps only. Active listings are aspirational; sold prices are real market data.; 90-day freshness maximum. Markets move — 6-month-old comps are stale.
Explore more Originals
Hand-crafted 2026-grade prompts that actually change how you work.
← All Promptolis Originals