How to Create a CMA Report That Holds Up
The test of a CMA is whether the number survives when a seller argues with it. That comes down to what you show, not what you claim.
A comparative market analysis is where your comp work stops being an opinion and becomes a document. The test is simple: does the number survive when a seller argues with it? A CMA that holds up shows its work, so the conversation moves from "I think it is worth more" to "which of these adjustments do you disagree with".
Closed sales carry the value conclusion
Actives and pendings tell you what you are competing against. They do not tell you what the house is worth, because nobody has agreed to those numbers yet.
Keep them in their own section and label them that way. A CMA that blends asking prices into the value conclusion is the one that falls apart under questioning.
A seller will always point at the highest active listing on the street. That listing is evidence of what one owner hopes for, not of what a buyer paid. Having it present but clearly separated is what lets you answer the objection instead of absorbing it.
Condition is where most CMAs stop
Most reports adjust for bedrooms, baths, and square footage, then stop. Two houses that are identical on paper are not worth the same money if one has an original kitchen and the other was renovated last year.
Grade the condition of every comp and put the grade in writing. That single column is usually the difference between a number that holds and a number that gets argued down.
Pull the closed sales
Three to six, close by, inside six months, same property type, within about twenty percent of the subject's size.
Grade each one on condition
Open the photos. Kitchen, baths, flooring, roofline. Write the grade next to the comp.
Adjust, and show every adjustment
Size, condition, garage, lot. The reader should be able to follow each line without asking you what happened.
Separate the market context
Actives and pendings in their own section, labelled as competition rather than as evidence of value.
Include rent and neighborhood context
This is the part most agents skip. A lot of sellers are quietly deciding between selling and holding, and they have not said so out loud.
A market rent figure answers the question they have not asked yet, and neighborhood demographics tell them who the next buyer or tenant actually is. Both belong in the same document as the value.
If a seller can read your CMA without you in the room and reach the same number, it holds up. If it needs your narration to make sense, it is a printout, not an analysis.
Run a CMA report on an address you know. Check that the closed sales are separated from the actives, that every comp carries a condition grade, and that the rent and neighborhood sections are filled in. Then hand it to somebody and see whether they reach your number on their own.
Put this lesson to work on a live address.
Run a CMA report on any address
