Advanced

DIY Comparative Market Analysis (CMA) Calculator 

DIY Home CMA (3 Comps)

Subject Property
Adjustment Settings
Tip: Positive coefficients add value to the comp when the subject has more; negatives reduce value. Time adjustment applies to comp sale date → as-of date.
Comparable Sales (3)
Field Comp 1 Comp 2 Comp 3
Address
Sale Date
Sale Price ($)
Beds
Baths
Sq Ft
Lot (sq ft)
Year Built
Condition (1–5)
Distance (mi)

How to Use the DIY Home CMA Tool

1. Enter Subject Property (the home you’re valuing)

Fill in the Subject Property box:

  • Address – e.g. 123 Main St
  • Beds/Baths – total bedrooms and bathrooms
  • Sq Ft – interior living area
  • Lot (sq ft) – lot size
  • Year Built
  • Condition (1–5) – 1=poor, 5=excellent
  • As-of Date – the effective valuation date (defaults to today)

2. Set Adjustment Settings (the rules for adjustments)

This tells the calculator how much value to assign for differences between your subject and comps:

  • $/Sq Ft – how much each extra square foot is worth
  • $/Bed – value for 1 additional bedroom
  • $/Bath – value for 1 additional bathroom
  • $/1,000 Lot Sq Ft – adjustment for lot size difference
  • $/10 Years (Age) – adjustment for age difference (negative if newer homes sell for more)
  • $/Condition Step (1–5) – difference in home condition
  • Time Adj %/Month – monthly market trend (e.g., 0.3 = 0.3% per month appreciation)
  • Distance Penalty $/mile – optional penalty for comps farther away

💡 Tip: Positive numbers add value to the comp when the subject has more; negatives subtract.

3. Enter Comparable Sales (up to 3)

For each comp:

  • Address
  • Sale Date
  • Sale Price
  • Beds, Baths, Sq Ft, Lot Size
  • Year Built
  • Condition (1–5)
  • Distance (mi) from subject

4. Run the CMA

  • Click Run CMA →
    You’ll see:
    • Estimated Value (median of adjusted comps)
    • A table showing:
      • Original Sale Price
      • Months since sale & time adjustment
      • Feature adjustments
      • Final Adjusted Price
      • Notes explaining the adjustments

5. Export / Print

  • Export CSV → downloads a spreadsheet of results
  • Print → creates a clean printable report
  • Reset → clears everything

🔍 How It Works

  • Each comp’s price is adjusted to the as-of date using time adjustment %.
  • Then differences in size, beds, baths, lot, age, condition, and distance are adjusted.
  • Final Adjusted Price = comp’s sale price + all adjustments.
  • The subject property’s estimated value = median of adjusted comp prices (avoids outlier distortion).

Disclaimer
This Comparative Market Analysis (CMA) tool is provided for educational and informational purposes only. The values produced are estimates based on user inputs and assumptions and should not be considered an appraisal or a substitute for professional valuation advice. Real estate values can vary due to market conditions, neighborhood characteristics, unique property features, and other factors not captured by this calculator. For buying, selling, or financing decisions, you should consult a licensed real estate professional, appraiser, or financial advisor.

Compare listings

Compare