Build the CMA around properties buyers would reasonably compare with the subject. Document why each sale belongs, label uncertain inputs, support adjustments with market evidence and explain a range before recommending a list-price strategy.
In this guide
A polished comparative market analysis can still leave a seller with the wrong impression if it hides how the agent selected the sales. The useful question is not whether the report has enough pages. It is whether another professional could follow your reasoning from the subject property to the recommended range. This worksheet helps listing agents make that reasoning visible before the presentation. It is an original business process, not a substitute for an appraisal or a forecast of a lender’s conclusion.
1. Write the subject brief before searching for a price
Start with a verified description of what is being priced. Record property type, location influences, usable space, condition, site characteristics, access and material features. Separate what you observed from what an owner reported and what documents establish. A finished room described in an old listing is a lead to investigate, not an automatic addition to verified living area. Keep unresolved measurement or permit questions visible instead of making the subject appear more certain than it is.
- Record the analysis date, intended use and source of each material property fact.
- Distinguish above-grade space, other finished space and storage using verified records and the applicable reporting conventions.
- Describe condition through observable features, maintenance and dated finishes rather than vague labels.
- Identify the buyer’s realistic alternatives: similar homes, competing layouts, access limitations and usable land.
2. Build a selection log that includes rejected sales
Search broadly enough to understand the competitive market, then explain your exclusions. A nearby sale may be a poor substitute because its site, construction, condition or setting appeals to a different purchaser. A more distant sale may help when the immediate area lacks a meaningful match. Fannie Mae’s Comparable Sales guidance discusses competitive market areas for appraisers. That is useful context for disciplined research; it does not convert your agent CMA into an appraisal or impose a universal radius on it.
| Candidate | Reason to consider | Question to resolve | Role in CMA |
|---|---|---|---|
| Sale A | Similar layout and usable lot | Confirm reported condition | Potential anchor |
| Sale B | Recent contract activity | Different access and setting | Secondary context |
| Sale C | Same subdivision | Substantially upgraded interior | Condition comparison |
| Sale D | Similar size only | Different competitive market | Exclude with explanation |
Retain a short reason for every important exclusion. This keeps the analysis from becoming a search for whichever sales support a hoped-for price. Include contrary evidence when it is relevant. A lower sale with similar constraints deserves investigation even if it makes the conversation harder. Selection quality depends on competitive relevance, verified facts and transparent judgment, not simply on the number of rows.
3. Separate evidence from assumed adjustments
Create an adjustment ledger with four fields: feature difference, proposed treatment, supporting evidence and confidence. Evidence might include comparable paired observations, a broader competitive set or a documented specialist input. Do not silently turn replacement cost into market contribution. A contractor’s invoice answers what work cost, while the CMA asks what buyers appear to pay for that difference. If you cannot defend a dollar amount, describe the difference qualitatively and explain the resulting uncertainty.
Fannie Mae’s Adjustments to Comparable Sales guidance calls for market-based adjustments in appraisals and rejects arbitrary rules of thumb. It also distinguishes a concession’s market effect from its face amount. For this agent worksheet, the practical lesson is to show the reasoning instead of applying a generic price-per-square-foot increment or subtracting every seller credit automatically. Review material uncertainty with your managing broker before presenting a confident numerical conclusion.
- Mark facts as verified, reported or unresolved.
- Mark dollar adjustments as supported, provisional or not quantified.
- Avoid counting one condition difference twice under separate feature labels.
- Explain any change in market conditions using the relevant competitive segment.
- Use price per square foot as a diagnostic, not a substitute for property comparison.
4. Reconcile a range before selecting a list price
Consider a hypothetical exercise in which three analyzed sales indicate $690,000, $705,000 and $725,000 after explicitly assumed adjustments. Those figures are invented teaching inputs, not local sales or recommended adjustment amounts. The $705,000 indication comes from the closest competitive substitute, while the $725,000 sale requires uncertain treatment of superior renovation. Simply averaging the three would conceal that difference in evidence quality.
You could explain that the middle indication has the strongest support and that the upper indication is less persuasive until its condition difference is resolved. Do not mechanically declare the entire spread the market-value range. Investigate outliers and decide which observations deserve weight. Then discuss a list-price strategy in light of current verified competition, seller timing and the property’s presentation. A pricing strategy is a decision about entering the market; it is not a promise of a final sale price.
Example seller script: “These are the sales I believe buyers would reasonably compare with your home. This one carries the most weight because its layout, condition and site are closest. The higher sale needs a larger judgment about renovation, so I am not treating it as equally strong evidence. Here is the range the better-supported comparisons suggest, and here is how I recommend positioning the asking price.”
5. Answer the seller’s strongest contrary comparison
Ask which property or value estimate the seller considers most persuasive. Put it beside your selection criteria and examine it respectfully. Explain why tax assessment, an automated estimate and a lender appraisal can serve different purposes rather than treating any one as a guaranteed financing value. When a seller has information you missed, investigate and revise the report. Defending a recommendation means being willing to improve the evidence, not winning an argument.
Example response: “Let’s include that property in the comparison log. Which features make it the best substitute in your view? I will verify those details, then show you whether it strengthens our range or helps explain a difference.”
6. Run a five-question presentation review
- Can I explain the subject facts and unresolved questions?
- Can I explain why each primary comparison belongs?
- Can I identify the evidence behind each material adjustment?
- Can I discuss contrary sales without dismissing them?
- Can the seller distinguish the supported range from the list-price strategy?
First action: take one upcoming CMA and add a one-page selection log before changing its design. If your bottleneck is repeatedly explaining pricing under pressure, use Elite Agent Accelerator to practice that conversation and build a repeatable listing process. The Elite Agent Operating System offers a broader diagnostic for finding the missing business habit. Cory Williams brings 500+ career transactions and $275M+ in career sales as practitioner experience; those figures are not a promise of your results.
