Lesson 23 · 4:59
Adjustments
Adjusting a manufactured home on acreage: no time adjustment in a flat market, site and area rates, garage, quality, condition and outbuildings, weights and commentary.
Transcript
Adjustments
With the comps in place, we adjust each one for how it differs from the subject, using the market's evidence, then decide how much weight each one gets. Open the Adjustments panel in the right rail. It analyzes the closed sales in the market we imported.
What the sales show
Time Adjustments shows how prices moved, month by month. This index is flat: under one percent over six months, and no change since July. The market is stable, so there's no time adjustment to apply. Feature Adjustments estimates a rate for each feature from the same sales. Site Size comes out at 38 cents a square foot: about $16,500 an acre. Finished area comes out at $25 a square foot. Open it: it rests on 20 of the 28 sales, and its 90 percent range runs from below zero to $111. That's weak support. Treat these rates as evidence; the rate you apply is your call.
One formula per row
Close the panel, and select Power Adjust in the grid toolbar. It adds a column of formulas beside the subject: one rate per row, applied to every comp at once.
Site and area
Site Size first. Open its formula, switch the unit to acres, and enter $16,000 an acre, just under the panel's estimate. On acreage, each site still holds one home, so value doesn't rise in step with size; we stay conservative. Finished Area Above Grade: $85 a square foot, inside the panel's range, from comparing the pool's larger and smaller homes with the same bedroom count. The adjustments land in every column. Comps 1 and 5, with the smallest sites and less area, are adjusted up the most.
Concessions, garages, quality
Other adjustments go comp by comp. Seller concessions are adjusted dollar for dollar: minus $35,000 for comp 1, and minus $10,000 for comp 3. Comp 5's amount isn't known, so it stays blank. Vehicle storage: the subject has no garage, and no nearby sale bracketed that, so every garage space is adjusted at $14,240. Minus $28,480 for the two-car garages of comps 1 and 2, minus $42,720 for the three-car garages of comps 3 and 4, and minus $14,240 for comp 5. Quality and condition, at $50,000 a rating step, from paired sales: plus $50,000 for the Q4 quality of comps 2 and 5, and plus $50,000 for the C4 condition of comps 2, 3 and 5. Enter each one on the Overall Quality and Overall Condition rows. Comp 4 also sold with a stable, a three-bay shop and a studio cottage, which the subject doesn't have. Add a Miscellaneous row under Property Amenities, describe comp 4's buildings, and adjust it down $100,000 for what they contribute to its price. Bedrooms and baths stay unadjusted: the sales don't support a rate, and the panel's estimates, over $100,000 a room, aren't credible.
Net and gross
Net Adjustment Total and Adjusted Price update as you go. The adjusted prices now run from about $714,000 to $791,000. Back in the Adjustments panel, Analysis shows each comp's net and gross adjustments as a share of its price, so a heavily adjusted sale stands out.
Comparable Weight
Now weigh the comps, in the Comparable Weight row. Comp 2 is the closest sale, half a mile away, with the subject's exact size; comp 1 needed the smallest net adjustment. Both get Most weight. Comps 3, 4 and 5 get Less weight: comp 3 is much newer, comp 4 needed the largest downward adjustment, for its outbuildings, and comp 5 the largest upward one. Then enter the Indicated Value by the sales comparison approach: $730,000, between the two most weighted comps.
Explain the analysis
Last, explain the analysis. Open the Sales Comparison Approach section. In Reconciliation of Sales Comparison Approach, describe the comps and the search, and where each adjustment rate came from. Then the ratings and the outbuildings, what was left unadjusted, and which sales carry the most weight. Type it yourself, or paste it in from your notes.
Land Comparables
That completes the sales comparison approach. Next, the land sales that support the site value, for the cost approach.