ARV without wishful thinking: a better comparable-sales process

ARV is conditional, not guaranteed

After-repair value describes an estimate of what a property might sell for after a specified scope of work, in a specified market, at a particular time. The estimate has little meaning unless those conditions are written down. A renovated kitchen does not eliminate a location disadvantage, functional layout problem, or unpermitted addition. Define the proposed finished product before searching for comparables.

The process below is an educational underwriting method rather than a professional appraisal. A lender may require its own appraisal with different standards and assumptions. Treat your analysis as a decision tool that should become more conservative when evidence is weak.

Define the buyer’s alternatives

Search for properties that a plausible buyer would actually compare with the subject. School boundaries, access, building type, age, condition, lot utility, and layout can matter as much as straight-line distance. A nearby luxury remodel may be a poor comparable for an entry-level home even if the square footage is similar.

Create a search log. Record your initial criteria and explain every expansion of distance, date, or property type. If you expand the search until you find a desired price, you have reversed the purpose of evidence. A thin comparable set is itself a risk that should affect your offer or decision to proceed.

Verify closed sales and meaningful details

An active listing is a competing offer, not evidence that a buyer paid its asking price. A pending sale shows activity but may not reveal its eventual terms. Closed sales are useful only after checking basic facts: actual sale date, price, property characteristics, apparent condition, and whether unusual circumstances may limit comparison.

Use authorized listing information, public records, a qualified local professional, and physical observations where appropriate. Never copy photographs or proprietary database content without permission. Keep source URLs or record references and the date accessed. If concessions are unknown, do not invent a net sale price.

Use adjustments carefully

Price per square foot is a quick diagnostic, not a universal value formula. Small houses can command a different price per foot than large houses. Extra area may be less valuable if it is poorly configured. A simple average can hide the very differences that explain price.

Where you make an adjustment, record the reason and evidence. Do not use a standard dollar amount for a bedroom, garage, or bathroom merely because an online rule suggested it. When the adjustment is material and poorly supported, investigate further or widen the value range. An unsupported adjustment is another assumption, not a verified fact.

Construct a range and test it against the project

Imagine three verified sales at $282,000, $296,000, and $309,000. Their arithmetic average is about $295,667, but that is not automatically the subject’s value. Perhaps the highest sale has a superior lot and the lowest has dated finishes. Explain which sale most closely matches your proposed finish and why.

You might underwrite $295,000 as a base scenario and $280,000 as a downside scenario, provided the comparison supports them. Then test the entire project against both values. If a $15,000 change removes your margin, improving valuation evidence may matter more than negotiating a small contractor discount.

Distinguish market trends from property value

FHFA publishes repeat-sales price indexes for multiple geographic levels. Such an index can help describe broader price movement, but it does not know your home’s condition, title, floor plan, renovation quality, or immediate competition. Avoid multiplying a prior sale by an index and calling the result an appraisal.

Use historical series as context and preserve the data vintage. A new release can revise earlier observations. Current asking prices can also change while you renovate. Underwrite the likely sale window rather than assuming today’s market will remain unchanged through construction.

Build the comparison around a specific finished product

Write a short finished-property brief before looking for additional sales. Describe the layout you intend to deliver, usable rooms, parking, outdoor space, major systems, and finish quality. Include constraints that rehabilitation will not change, such as adjacency to a busy road or an awkward bedroom arrangement. This gives you a stable comparison target. If the target changes while reviewing attractive sales, stop and ask whether you have found better evidence or simply redesigned the project to justify a higher number.

For a hypothetical house, suppose your scope replaces worn finishes but preserves one bathroom and an enclosed kitchen. A renovated sale with two bathrooms and an open living area may help establish an upper comparison boundary, but it does not describe the same product. Do not assume paint and new counters create the same utility. Ask what additional work would actually be required to match that competitor, obtain a scope and cost estimate, and decide whether the expanded project remains sensible before using its sale price.

Use a comparable evidence matrix

Create a row for each candidate sale and columns for transaction evidence, physical similarity, location, finished condition, and unresolved differences. Add a final column explaining why the property belongs in the analysis. A nearby sale can be useful because it reveals a buyer tradeoff, even when it is too different to anchor the estimate. Conversely, a visually similar house across a meaningful market boundary may belong only in a secondary group. Describe your reasoning rather than letting a distance filter make every inclusion decision.

Consider four hypothetical candidates: a close physical match with verified condition, a larger renovated house, a similar house with an unknown interior, and an active listing. The verified close match deserves more interpretive weight than the unknown interior merely because their recorded prices are similar. Keep the larger house as context and the active listing as current competition. You now have different evidence roles instead of four interchangeable numbers. This prevents a spreadsheet average from concealing the limits of the underlying observations.

Investigate the middle instead of selecting the highest sale

Suppose one verified comparable sold for $300,000, another for $305,000, and a third for $340,000. The third sale may represent a genuinely better outcome, a superior property, different transaction terms, or information you have not obtained. Start by investigating the difference. Compare photographs you are authorized to use, layout, lot utility, completion quality, sale timing, and available transaction details. Record the missing explanations. An unexplained premium is a research task; it is not automatically evidence that every renovated house can command that price.

The two lower sales may still differ from the subject in important ways. A disciplined conclusion could be that current evidence supports further analysis near the lower cluster while the premium sale remains contextual. That conclusion is conditional, not a declaration of appraised value. If the investment only works near $340,000, identify which verified subject characteristics justify competing at that level. Without them, revise the acquisition model or investigate another property. Repeating the highest number in several worksheets does not create independent support for it.

Separate renovation quality from renovation spending

Money spent is a project input; market response is a separate question. Two houses can each receive $50,000 of work and emerge with very different functionality. One budget may repair hidden damage without changing visible appeal. Another may refresh an already sound property. Buyers compare the finished choices available to them, so your valuation brief should describe the result of the work rather than advertise the budget as proof of a price premium.

Prepare a scope-to-evidence check. For each major value assumption, name the finished feature and identify comparable evidence showing that feature in a similar competing property. Where no support exists, flag the assumption and avoid assigning a precise premium. For example, replacing an unsafe electrical panel may be necessary to deliver an acceptable house, but the repair bill does not itself prove an equal increase in resale price. Keeping necessary cost separate from market value avoids counting a required repair twice: once as work that makes the base comparison possible and again as an unsupported bonus.

Connect valuation uncertainty to acquisition capacity

Translate the range into a purchase decision using the same cost structure. Imagine two resale scenarios of $290,000 and $310,000. Assume, only for this exercise, selling costs equal 8% of price, other nonpurchase costs total $65,000, and the required project spread is $30,000. The purchase ceiling is 92% of resale price minus $95,000. That produces $171,800 at the lower value and $190,200 at the higher value. The $20,000 price difference changes the ceiling by $18,400 because the modeled selling costs also move.

This calculation shows why valuation uncertainty cannot be hidden inside a narrow purchase estimate. It does not establish which resale scenario is right. Before proceeding, ask whether you can obtain evidence that meaningfully narrows the range and what that research costs. If additional evidence remains unavailable, decide which scenario your capital and risk limits can tolerate. Do not adopt the higher ceiling merely because it matches the seller's request. The ceiling should follow the supported assumptions and required outcome, with every cost convention clearly labeled.

Create an evidence refresh trigger

A valuation file should state when it must be revisited. Useful triggers include a material scope change, a delayed completion, a new close competitor, a significant comparable transaction, or discovery that a relied-upon sale was physically different. Name the person who watches for those changes and the decision that requires a fresh review. Otherwise an estimate built for one product and sale window can quietly survive long after both have changed.

At the refresh, preserve the prior conclusion, add the new evidence, and explain what moved. Suppose the planned garage conversion is removed from the scope. Check whether the original comparison assumed the resulting living area and whether its use was adequately verified. Do not simply leave the earlier price in place because construction costs decreased. The updated memo should connect the revised finished property to the revised comparison set. A useful final sentence states the supported range, the unresolved differences, and the next event that could alter the estimate.

Document what would invalidate your estimate

List material risks such as inferior utility, unknown permits, difficult access, unusual foundation issues, or a tiny pool of buyers. Some problems are not solved by a cosmetic renovation. Confirm that the proposed work creates a product buyers will value enough to cover its cost.

Your final valuation note should be concise: property and proposed finish, search method, best evidence, adjustment rationale, value range, and uncertainties. Revisit it when the scope or timeline changes. The best ARV process makes it easier to pass on a property when the evidence does not support the required price.

• Define the completed condition.
• Log search criteria and changes.
• Verify completed comparable sales.
• Label assumptions and unsupported adjustments.
• Use a range with a downside scenario.
• Refresh evidence before the final commitment.