A real estate CMA template is a worksheet — spreadsheet or software form — that walks you through pricing a home by comparing it to similar properties that recently sold nearby. You enter the subject property’s details at the top, list three to five recent comparable sales in side-by-side columns, adjust each comp’s sale price up or down for every meaningful difference, and read off a value range at the bottom. Agents run these through their MLS tools; homeowners can do the same work in Google Sheets or Excel. The template is only as good as the comps you feed it and the adjustments you make, so most of the effort sits in those two steps.
Where To Get a Template
Your options split by whether you hold a real estate license.
Free and Low-Cost Options for Homeowners
A spreadsheet works fine. Google Sheets or Excel lets you build columns for each comparable, rows for each feature, and formulas that calculate adjustments automatically. Several real estate websites offer free downloadable CMA spreadsheet templates that come pre-formatted with the standard adjustment categories. Look for one that includes a summary row showing adjusted sale prices and a field for your final estimated range; those two features save the most time.
A usable template has four zones: a section at the top for the subject property’s details, side-by-side columns for each comparable, line-item rows for every adjustment category, and a bottom section that displays the adjusted prices together so you can compare them at a glance.
Licensed Agent Platforms
Licensed agents typically access CMA tools through their Multiple Listing Service subscription or dedicated software. Realtors Property Resource (RPR), available at no extra cost to National Association of Realtors members, includes AI-assisted CMA generation that pulls MLS and public-record data into a formatted report.1National Association of REALTORS. Realtors Property Resource (RPR) Cloud CMA runs roughly $60 per month per agent. ToolkitCMA ranges from about $25 to $45 per month depending on the plan. These platforms auto-populate comps and generate a client-ready PDF; the underlying logic is the same as the spreadsheet approach.
What To Gather Before You Open the Template
Pull together the basic facts about the home you’re pricing: gross living area in square feet, bedroom count, bathroom count, lot size, year built, and garage capacity. Your county tax assessor’s website is the fastest source for most of these. The assessed value itself is less useful, but the physical characteristics recorded there are usually accurate. A warranty deed or title report can confirm lot dimensions if the tax records seem off.
Write down every significant upgrade completed in the last ten to fifteen years — a remodeled kitchen, replaced roof, new HVAC system, updated electrical panel, or added bathroom. You don’t need receipts at this stage, but you need a rough sense of what each project cost and when it was done. These improvements will factor into the adjustment section later. Note anything that detracts from value as well: deferred maintenance, an outdated layout, or a location quirk like backing up to a busy road.
Picking the Comparable Sales That Go in the Template
Choosing the right comparables is the single most important step. A template built on poorly matched comps produces a number that looks precise but means nothing. You want properties that would compete for the same pool of buyers as your subject — similar size, style, age, and condition in the same general area.
How Many and How Recent
Use at least three comparable sales, ideally four or five. Sold listings carry the most weight because they reflect what a buyer actually paid, not what a seller hoped to get. Focus on sales that closed within the last 90 days. In a fast-moving market, tighten that window to 30 or 60 days. In a slower rural market where transactions are sparse, you may need to stretch to six months. The more recent the sale, the more reliable the data point.
How Far Away
There is no universal mile-radius rule. Fannie Mae’s guidance for appraisers, which sets the standard most agents follow, says comparables should come from the subject property’s market area, meaning the geographic zone where most competing properties are located, rather than from a fixed distance.
In a dense urban neighborhood, that might mean staying within a half-mile. In a suburban subdivision, one to three miles is common. In rural areas you may need to expand well beyond those distances. When you cross school-district lines, municipal boundaries, or highway corridors, note the difference and plan to make a location adjustment. Expanding your search a quarter-mile at a time helps you find relevant comps without reaching so far that the comparison breaks down.
Matching Physical Characteristics
Fannie Mae expects comparables to share similar physical and legal characteristics with the subject property, including site size, room count, finished living area, architectural style, and condition.2Fannie Mae. Comparable Sales – Fannie Mae Selling Guide A 1,400-square-foot ranch should not be compared to a 2,800-square-foot colonial just because they share a zip code. If the best available comps are noticeably different, you’ll need larger adjustments, and larger adjustments mean less confidence in the final number. When you find yourself making more than five or six adjustments to a single comp, that property probably isn’t a good match.
Filling In the Adjustment Grid
The adjustment grid is the engine of the template. You’re answering one question for each comparable: what would this property have sold for if it were identical to my subject? Every difference between a comp and the subject gets a dollar adjustment, positive or negative, until you’ve equalized them on paper.
Which Way the Adjustment Goes
Adjustments always apply to the comparable, not to the subject. If a comp has something the subject lacks (a finished basement, for example), subtract that feature’s value from the comp’s sale price. If the subject has something the comp lacks (a pool, an extra garage bay), add that value to the comp’s price. You’re asking what the comp would have sold for without its advantage, or with the subject’s advantage.
Sizing the Dollar Amounts
Fannie Mae’s guidelines confirm that adjustments should be market-based rather than tied to arbitrary rules of thumb.3Fannie Mae. Adjustments to Comparable Sales – Fannie Mae Selling Guide A finished basement might add $20,000 in one market and $40,000 in another. The best way to derive local adjustment values is to find pairs of similar sold properties that differ by only one feature and measure the price gap. Local MLS data makes this feasible if you have access. If not, a local agent or appraiser can usually share the adjustment ranges they use for your area.
Common Adjustment Categories
Most templates include rows for these features:
- Square footage. Calculate a per-square-foot rate from your comps, then multiply by the difference. A common starting point is roughly one-third of the average price per square foot of your comparables, though local data should override any rule of thumb.
- Bedroom and bathroom count. Each additional or missing bedroom or bathroom gets a flat dollar adjustment based on what the market pays for that difference.
- Garage capacity. A two-car garage versus a one-car garage, or no garage at all, is one of the more straightforward adjustments to quantify from paired sales.
- Lot size. Significant differences in lot area warrant an adjustment, especially in markets where land is a large component of value.
- Age and condition. A recently renovated comp selling against a dated subject, or vice versa, needs a condition adjustment. This is the most subjective category and the one most often underestimated.
- Location. Even within the same neighborhood, proximity to a park, a busy intersection, or a commercial zone affects value. If your comp is across a school-district boundary, the adjustment can be substantial.
- Special features. Pools, fireplaces, solar panels, outbuildings, or waterfront access. Adjust only if the feature demonstrably affects sale prices in your market.
Keeping Adjustments in Check
Fannie Mae does not impose fixed caps on net or gross adjustments.3Fannie Mae. Adjustments to Comparable Sales – Fannie Mae Selling Guide The practical rule is simple: the fewer adjustments a comp needs and the smaller those adjustments are, the more reliable that comp is as a value indicator. If your total net adjustments on a single comp exceed 15 to 20 percent of its sale price, treat that comp as a secondary data point rather than a primary anchor. A comp that needs no adjustment at all, rare as that is, is your strongest evidence of value.
Adding Active and Pending Listings for Context
Sold comparables are the backbone, but active and pending listings add useful context. Active listings represent your competition and show what buyers will see alongside your property. Pending listings (under contract but not yet closed) signal where the market is heading, though final sale prices aren’t available yet.
If active listings similar to your subject are priced noticeably lower than your adjusted value from sold comps, the market may have shifted since those sales closed. If comparable inventory is thin and pending sales are moving quickly, the market may support pricing at or above the top of your range. Sold comps are the foundation; active and pending listings are the reality check layered on top.
Note the average days on market for recent sales too. A neighborhood where homes sell in 10 days is behaving differently from one where they linger for 60. High days-on-market figures suggest pricing toward the lower end of your range; low figures give you room to be more aggressive.
Turning the Adjusted Numbers Into a Price Range
Once you’ve completed the adjustments for each comparable, the template should display an adjusted sale price for every comp. These adjusted prices represent your best estimates of what each comp would have sold for if it matched your subject property exactly.
Don’t just average them. Weight the comps by reliability. Give the most weight to the comp that required the fewest and smallest adjustments, sold most recently, and sits closest to the subject. A comp that needed only two minor adjustments and closed last month deserves more influence than one that required six adjustments and sold five months ago. Some templates have a weighting field; if yours doesn’t, you can assign percentages manually (for example, 50 percent to your best comp, 30 percent to the second, 20 percent to the third) and calculate a weighted average.
Present the result as a range rather than a single number. A tight range (say $385,000 to $395,000) communicates confidence while acknowledging that no two buyers value a home identically. If your adjusted prices are scattered, with one at $360,000 and another at $410,000, that spread suggests your comps aren’t well-matched or the market is genuinely uncertain. Revisit your comparable selection before settling on a listing price.
Mistakes That Undermine a CMA
A few errors show up repeatedly:
- Cherry-picking comps. Selecting only the highest-priced sales to justify an aspirational number. Include the full range of legitimate comparables, even ones that pull the average down.
- Ignoring condition differences. Two homes with the same square footage and bedroom count can differ by tens of thousands of dollars if one has original 1980s finishes and the other was recently renovated. Skipping the condition adjustment is the fastest way to overprice.
- Using stale data. A comp from eight months ago reflects a market that may no longer exist. Prioritize recent sales and supplement with active listings to confirm the trend.
- Over-valuing personal improvements. Homeowners routinely assume a $50,000 kitchen remodel adds $50,000 in value. It rarely does. Use paired-sales data from your market, not renovation cost, to set the adjustment.
- Crossing market boundaries without adjusting. Pulling a comp from a higher-rated school district or a more desirable subdivision inflates your estimate unless you subtract a location adjustment.
The best hedge is transparency. Show your work, include comps that don’t flatter the price, and let the adjustments speak for themselves. A buyer’s agent or appraiser will run the same analysis; if your CMA can’t survive that scrutiny, the listing price it produced won’t survive the negotiation.
Shelf Life and Delivering the Finished Report
Export or save the completed template as a PDF so the formatting stays intact regardless of how it’s opened. If you’re presenting the CMA to a client or co-owner, put a summary page up front showing the subject property, the adjusted comp prices, and the recommended listing range, then let the adjustment details follow.
A CMA is a snapshot. The data behind it ages quickly, especially in volatile markets. Plan on the report remaining reliable for roughly 30 to 90 days. If the home hasn’t gone under contract within that window, pull fresh comparable sales and update the adjustments before making any price changes. Reducing a listing price without updated comps is guessing, and guessing in the wrong direction costs real money.
A CMA Is Not an Appraisal
One boundary worth knowing before you rely on your finished template: a CMA and a formal appraisal use similar data, but they carry different weight. An agent or homeowner prepares a CMA to set a listing price. A licensed appraiser performs an appraisal, typically ordered by the buyer’s mortgage lender, to confirm the property’s value before the bank commits to a loan. Because the lender-ordered appraisal determines whether the buyer can get a mortgage at the agreed price, the appraised value often becomes the practical ceiling on the transaction. If your CMA suggests $400,000 but the appraisal comes in at $380,000, the buyer’s lender will only finance based on the lower number. Setting a listing price that a future appraiser, working with the same comparable sales, is likely to support keeps the deal from unraveling at that stage.