Wondering how to price a house for sale? This practical comparative market analysis worksheet helps you turn nearby sales, property differences, current competition, and market conditions into a defensible listing-price range rather than relying on guesswork or an online estimate alone.
Overview
A comparative market analysis, or CMA, estimates what buyers may reasonably pay by comparing your home with similar properties that recently sold, are currently listed, or were listed but did not sell. It is not the same as a formal appraisal, and it does not guarantee the final sale price. Its value is that it gives you a consistent process for answering, “What should I list my home for?”
The strongest analysis uses three types of evidence:
- Recently sold properties: These show what buyers actually paid, although the sale may reflect earlier market conditions.
- Active listings: These show the homes your property will compete with when it appears in property listings. Their asking prices are signals, not proof of value.
- Expired or withdrawn listings: Where available, these can reveal prices or presentation choices that did not attract an acceptable offer. Treat the reasons for non-sale cautiously because they are not always visible.
Begin with a range, not a single number. A realistic low-to-high range makes uncertainty visible and gives you room to consider timing, condition, buyer demand, and your selling priorities. If you need a formal valuation for lending, legal, tax, or estate purposes, use a qualified professional appropriate to your location.
How to estimate
1. Define the subject property
Record the facts buyers are likely to compare: location, property type, internal or living area, lot size, bedrooms, bathrooms, parking, outdoor space, age, construction type, energy features, renovations, views, and notable defects. Use the same measurement convention throughout your worksheet. Mixing advertised area, gross area, and internal area can distort the comparison.
2. Select comparable properties
Start with properties that are genuinely similar, then widen the search only when necessary. Prioritize the same neighborhood or a nearby area with comparable access, housing stock, and buyer appeal. Look for similar property types, sizes, bedroom counts, condition, and land characteristics. Recency matters, but a very recent sale that is a poor physical match may be less useful than an older sale with similar features.
For each candidate, record the address or listing reference, status, date, asking or sold price, size, key features, condition, and the reason it is comparable. Aim to review several candidates and keep the most relevant group rather than selecting only the highest or lowest examples.
3. Calculate a basic price-per-area indicator
For each sold comparable, calculate:
Price per area unit = sale price ÷ measured area
Use the same area unit for every property. This figure is a useful cross-check, not a complete valuation method. It can be misleading when homes differ substantially in land, layout, quality, views, parking, or renovation level.
4. Adjust for meaningful differences
Choose a reasonable starting point from the best comparable, then adjust upward or downward for differences. Do not automatically add the cost of an improvement to the value of the home; buyers may value an improvement differently from its construction cost.
Your worksheet can use this format:
- Comparable sale price: ______
- Adjustment for superior or inferior location: ______
- Adjustment for size or layout: ______
- Adjustment for condition and renovations: ______
- Adjustment for bedrooms, bathrooms, parking, or outdoor space: ______
- Adjusted indication: ______
The adjustments do not need to look mathematically precise when the underlying evidence is limited. Explain the reasoning beside each one, such as “subject has updated kitchen; comparable needs work” or “comparable has an additional parking space.” Transparent judgment is more useful than false accuracy.
5. Reconcile the evidence
Compare the adjusted indications, then identify the range where the strongest evidence overlaps. Check that the result is consistent with active competition. If your proposed price is materially above similar homes currently available, document the feature that justifies the difference. If no feature does, the price may reduce visibility or extend the time needed to find a buyer.
Finally, separate market value from selling strategy. A seller who values a quick, straightforward sale may choose a sharper entry price. A seller with flexible timing may test a different position, while accepting the risk of fewer early enquiries. The right asking price is not simply the highest number imaginable; it is a deliberate starting point supported by evidence.
Inputs and assumptions
Use the following worksheet before publishing a property listing:
| Input | What to record |
|---|---|
| Subject property | Location, type, area, lot, rooms, parking, condition, improvements |
| Sold comparables | Sale date, sale price, size, features, condition, and similarity |
| Active competition | Asking price, days listed if known, presentation, and notable advantages |
| Market context | Recent direction of local demand, inventory, and buyer feedback where available |
| Seller constraints | Preferred timing, minimum acceptable outcome, and willingness to negotiate |
| Costs | Expected commission, legal or administrative costs, repairs, staging, and moving costs |
Keep the assumptions visible. For example, note whether an area measurement came from a plan, a listing, or another record; whether a sale price included unusual concessions; and whether a comparable was substantially renovated. Avoid treating automated online estimates as a final answer. They can be a starting reference, but they may not capture condition, layout, micro-location, or recent improvements.
It is also helpful to create three figures: a target range supported by the CMA, a minimum acceptable net outcome after selling costs, and a review point for evaluating buyer response. A home listing price calculator can help with arithmetic, but it cannot choose appropriate comparables or judge condition.
Worked examples
The following numbers are illustrative only. Replace them with local evidence and use one consistent area unit.
Suppose a subject home measures 150 square units. Three relevant sold comparables produce these adjusted indications:
- Comparable A: 146,000 after adjustments
- Comparable B: 151,000 after adjustments
- Comparable C: 154,000 after adjustments
The evidence clusters between 146,000 and 154,000, with a midpoint near 150,000. If the subject property is presented in better condition than most active competition, a seller might test the upper part of that range. If it needs visible repairs or faces several similar homes, the lower or middle part may be more defensible.
For a simple price-per-area check, assume the selected evidence suggests an adjusted indication of 1,000 per area unit. Multiplied by 150 units, that produces an initial indication of 150,000. This does not replace the comparison adjustments: a small home with exceptional outdoor space may not behave like a larger home with poor layout, even if the calculated rate is identical.
Now assume the seller expects 6,000 in selling and preparation costs and wants at least 140,000 after those costs. The required asking price is not automatically 146,000 because negotiation, timing, and additional costs may apply. The worksheet should show the desired net outcome separately from the market-supported price. If the two goals are far apart, the seller may need to reconsider repairs, timing, expectations, or whether selling now is appropriate.
For broader preparation, pair this analysis with a property viewing questions guide to anticipate what buyers may notice, and review the home inspection checklist to identify condition issues that could affect negotiations.
When to recalculate
Revisit your CMA when its inputs change, not just when you feel uncertain. Recalculate before listing if the original research is more than a short period old or if new comparable sales have appeared. Update it after a major renovation, a change in condition, a material shift in local competition, or a significant change in your preferred selling timeline.
Once listed, monitor buyer response rather than changing the price impulsively. Track the number and quality of enquiries, viewing attendance, recurring objections, saved or shared listing activity where available, and feedback about condition or price. A lack of attention can indicate a pricing or presentation problem; repeated viewings without offers may point to condition, terms, or buyer uncertainty. These signals are not conclusive on their own, so compare them with new market evidence.
Use this action sequence:
- Refresh sold and active comparable data.
- Confirm that measurements, features, and condition notes are still accurate.
- Recalculate adjusted indications and the price-per-area cross-check.
- Review your expected net outcome after selling costs.
- Choose whether to hold, improve presentation, adjust the asking price, or seek a professional valuation.
Save each version of the worksheet with its date and assumptions. That record makes future pricing decisions easier and shows exactly why a listing price changed. Revisit the analysis again after material market movement, new comparable sales, or a meaningful change in the home itself.
