How to build a CMA that wins the listing
A comparative market analysis is an argument. The number at the end is only as good as the sales you chose to support it and the adjustments you made to those sales — and the seller sitting across the table will test both.
Most CMAs fall apart in the same place. The agent pulls six recent sales, averages them, and arrives at a number they cannot defend when the seller asks why the house on the next street sold for forty thousand more. This is the method that survives that question.
1. Define the subject before you look at anything else
Write down what you are pricing before you go looking for support: living area, bed and bath count, lot size, year built, garage, basement, condition, and anything the market in your area pays for specifically — a view, a finished attic, a corner lot, a school attendance boundary a street away.
Doing this first matters more than it sounds. An agent who searches before defining the subject unconsciously selects the sales that flatter the price the seller wants, and every adjustment afterwards inherits that bias.
2. Choose comparables that need the fewest adjustments
The best comparable is the one you barely have to touch. Work outward in this order, and stop as soon as you have four to six sales you would defend:
- Same subdivision or immediate block, sold in the last three to six months, within roughly 15% of the subject's living area.
- Same school attendance area and same style — a split-level does not comp a ranch cleanly even at identical square footage.
- Widen the date range before you widen the geography. A nine-month-old sale two doors down is usually more informative than last week's sale a mile away across a boundary that matters.
Active and pending listings are not comparables — nobody has paid those prices. They belong in the report as competition, in their own section, because they tell the seller who they are bidding against this month. Keep them separate from the sales that set the number.
3. Adjust toward the subject, not away from it
The direction confuses people constantly. You are adjusting each comparable to answer one question: what would this house have sold for if it were the subject? If the comp has a third bathroom and the subject does not, the comp's price comes down. If the comp has a smaller lot, its price comes up.
Adjust for the differences the market actually pays for — living area, bed and bath count, lot, condition, garage, and the date of the sale if the market has moved since. Which adjustments are worth making, and which are noise, is a longer conversation and has its own guide.
4. Bracket the subject
This is the step that separates a defensible CMA from a plausible one. Your comparables should bracket the subject: at least one superior, at least one inferior, on the characteristics that matter most. If every comparable is larger and newer than the subject, your adjusted range is a downward extrapolation and a seller is entitled to distrust it.
Bracketing is also what makes the report readable. "Two houses better than yours sold for this, two worse sold for that, and you sit here" is an argument a seller follows without training.
5. Reconcile — do not average
Averaging the adjusted prices treats your worst comparable as equal to your best. Weight instead: the sale that needed the fewest adjustments carries the most, the one you stretched to include carries the least. State the range the adjusted sales imply, then name your recommended list price inside it and say in one sentence why it sits where it does.
A range with a recommendation is honest and useful. A single number with no range hides how much judgment went into it, and sellers can smell that.
6. Present the evidence, not just the conclusion
The seller wants to see the houses. Photographs, addresses, sale dates, what each one had that theirs does not, and the arithmetic that got from that sale price to the adjusted figure. A CMA that shows its working survives the conversation with the seller's brother-in-law who saw a different number online; a CMA that shows only a conclusion does not.
Put your name, licence and brokerage on every page. Six months later it is the document that reminds them who priced the house correctly.
What this looks like in practice
The method is unchanged whether you assemble it by hand or not. What takes the time is the mechanical part: pulling recent sales, matching them against the subject, computing the adjustments, and laying it out so a seller can read it. That is the part CompAgent does in about a minute — it finds the candidate sales near an address, suggests each adjustment with its arithmetic visible, and prints the whole thing under your branding. The judgment stays yours; the typing does not.