Used to calculate column N (Adjustments ($)) in Sheet 2.
| Feature | Adjustment per Unit | | --- | --- | | Per Sq Ft (GLA) | $100 – $150 | | Per Bedroom | $8,000 – $12,000 | | Per Bathroom | $5,000 – $8,000 | | Garage (per space) | $3,000 – $5,000 | | Pool | $15,000 – $25,000 | | Basement (finished) | $20/sq ft | | Lot size (per 0.1 acre diff) | $5,000 | cma data report in excel format new
Example formula for Cell N2 (adjustments):
=(D2 - (E2 + (M2*4000) + ( (C2 - $E$2)*100 ))) (simplified) Progress indicator and download link (XLSX)
Better to use manual adjustment logic:
Adj Value = Sold Price + (Subject SqFt - Comp SqFt)*$125 + (Subject Bed - Comp Bed)*$10,000 + (Subject Bath - Comp Bath)*$7,000 Used to calculate column N ( Adjustments ($) ) in Sheet 2
| Date | Event | Price | Source | | --- | --- | --- | --- | | 01/10/2026 | Listed | $465,000 | MLS #12345 | | 02/15/2026 | Price decrease | $450,000 | MLS | | 04/01/2026 | Off market | – | Agent remark |
Once you download the CMA_Export_YYYYMMDD.xlsx file, you cannot send it to a client raw. You must perform the "Excel Triage."