Comparative Market Analysis Tool: What Investors Need Beyond a CMA
A comparative market analysis tool pulls recently sold, active and pending listings near a property and estimates what it is worth. Agents use it to price a listing as-is. Investors need more: an after-repair value built from renovated comps, adjustments they can defend, and a max offer, so a plain CMA is a starting point, not the number.
What a CMA tool does, and who it is built for
A CMA is, in Redfin's words, an estimate of a home's current market value based on how it compares with similar properties in the area. It draws on recently sold homes, active listings and pending sales, and it is typically prepared by a real estate agent for a seller. Redfin's summary of the difference from an appraisal is useful: a CMA helps price a home, while an appraisal helps a lender verify that the price is justified. Neither one is built to answer an investor's question.
The investor's questions are different. What will this house sell for after I fix it? What is it worth as it sits, if I have to hold it or the rehab goes sideways? What can I pay and still clear my margin, or my assignment fee, once repairs are out? A CMA tool built for listing presentations is organized around the first impression a seller sees: a suggested list price and a range. It rarely separates renovated sales from as-is sales, and it rarely turns the answer into an offer.
Where a CMA and an investor's comps part ways
- Condition. A listing agent comps a house in its current state. A flipper or wholesaler needs the value after renovation, so the comps that matter are the renovated sales and the buyers' end price, not the neighboring houses that sold dated.
- Purpose of the number. A listing price can be aspirational. An ARV you give a buyer or a lender has to survive scrutiny, because the buyer will pull the same sales and check your math.
- Downstream math. The value is an input. The deliverable is a max offer by exit (wholesale, flip, rental, novation) with repairs and costs taken out.
- Pendings and actives. For an agent they show competition. For an investor they set a ceiling on what a buyer will pay and show which price points are sitting unsold. Closed sales set the number; contracts and listings support it. See pending vs sold comps.
Borrow the lender's standard for your comps
You are not an appraiser, but the secondary-market standard is a good discipline for choosing comps, and buyers' lenders will hold your comps to something like it. Fannie Mae's Selling Guide (B4-1.3-08, version dated June 4, 2025) says comparable sales that closed within the last 12 months should be used, that a minimum of three closed comparables must be reported, and that comparable sales should have similar physical and legal characteristics to the subject property and come from the subject's market area when possible. Current listings and contracts may support the appraisal but do not count toward the three closed sales.
On adjustments (B4-1.3-09, same date), the guide says an appraiser's adjustments must reflect the market's reaction to property differences, not rules of thumb, and that the number or dollar amount of adjustments must not be the sole determinant of whether a comp is acceptable. Fannie Mae sets no specific net or gross adjustment limits. Where no truly comparable sales exist, the appraiser selects the best indicators of value and makes market-supported adjustments. The investor's version: prefer closed renovated sales, keep the set tight in distance and time, and when a comp needs large adjustments, trust it less, not more. Our comp adjustments guide shows how to derive a per-square-foot or per-feature adjustment from the sales themselves, and how far is too far covers radius.
Worked example: from comps to max offer
This is an illustrative deal with assumed numbers. Subject: 3 bed, 2 bath, 1,400 sq ft, one-car garage, in need of cosmetic renovation. All four comps are renovated, closed within the last six months, close to the subject. Assume the neighborhood supports $100 per square foot for size differences and $8,000 for a garage; derive your own from paired sales.
| Comp | Sold price | Difference from subject | Adjustment | Adjusted price |
|---|---|---|---|---|
| A | $262,000 | 50 sq ft larger | −$5,000 | $257,000 |
| B | $248,000 | 20 sq ft smaller | +$2,000 | $250,000 |
| C | $255,000 | No garage | +$8,000 | $263,000 |
| D | $259,000 | 100 sq ft larger | −$10,000 | $249,000 |
The adjusted prices run $249,000 to $263,000, with a median of $253,500 and an average of $254,750. Take an ARV of $254,000. With $38,000 in repairs and a $10,000 assignment fee, the 70% rule (one rule of thumb, not a law; see the 70% rule explained) gives: 0.70 × $254,000 = $177,800, less $38,000 repairs = $139,800 is the most your end buyer should pay you, and $139,800 less your $10,000 fee = $129,800 is the most you offer the seller.
Now see why the comp work is the deal. If a sloppy CMA sets the ARV $12,700 too high (at $266,700), the same formula says $148,690 for your buyer, $8,890 more. You would price your contract above what the buyer's own comps support, and the buyer renegotiates or walks. An ARV that is a little low costs you a deal you could have won; an ARV that is too high costs you a deal you will lose, usually after you have already tied up the property. More on the common traps in ARV mistakes that kill deals.
What to look for in a comp tool as an investor
- Sold, pending and active in one view, with the status of each clear, plus the date, distance, beds, baths, square footage and price per square foot.
- Filters you control for distance, sale date and size, so you can tighten the set rather than accept a black box.
- A way to select and de-select comps and see the ARV change, with the reasoning shown.
- MLS-grade data. If you do not have MLS access, see how to get comps without MLS.
- The next step built in: repairs, then a max offer by exit, not a PDF you retype into a spreadsheet.
For a side-by-side of the options, see best comp analysis tools.
How Deal Run handles it
Put in a property address and Deal Run pulls sold comps and actives and pendings, picks the comps used for the ARV and shows its reasoning, estimates rent, estimates repairs from photos (or gives a labeled rough guide without them) and works out a max offer for wholesale, flip, rental and novation with the formula written out. You can change the selected comps and the ARV follows. The comp analysis feature is an interactive map with flip and rental comps and distance and date filters. An analysis is $2, and it works in the web app and inside ChatGPT, Claude and Grok. If the deal is one you are selling, the same record goes on to find the buyers who purchased nearby.
Related
- Real Estate Comps: How to Pull and Analyze
- How to Calculate ARV Step by Step
- AI Repair Cost Estimator
- How Appraisers Pick Comps
Sources
- Fannie Mae, Selling Guide B4-1.3-08, Comparable Sales (06/04/2025), selling-guide.fanniemae.com/sel/b4-1.3-08/comparable-sales, checked Nov 12, 2026
- Fannie Mae, Selling Guide B4-1.3-09, Adjustments to Comparable Sales (06/04/2025), selling-guide.fanniemae.com/sel/b4-1.3-09/adjustments-comparable-sales, checked Nov 12, 2026
- Redfin, What is a Comparative Market Analysis (CMA)?, redfin.com/blog/what-is-a-comparative-market-analysis, checked Nov 12, 2026
- Deal Run, product and pricing summary, dealrun.ai/pricing, checked Nov 12, 2026