Lesson 24 · 3:57
Adjustments
Market support for a fourplex: a time adjustment from the price index, concessions over the norm, per-unit size and basement adjustments with Power Adjust, and weights.
Transcript
Adjustments
With the comps complete, 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.
Time and features
Time Adjustments shows how prices moved: up 1.31 percent over the last 12 months. Apply puts that price index on the grid's Contract Date row, and each comp is adjusted for the months between its contract date and the effective date. Feature Adjustments estimates rates from the same 22 sales. With so few sales, and buildings this varied, treat them as support only. The rates you apply are your call, based on all the evidence.
One rate 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. The time adjustment is already there, on Contract Date: a small upward adjustment for each comp.
Over the market's norm
Sales concessions next. In this market, sellers commonly pay up to 3 percent of the price toward the buyer's costs without changing what buyers pay. Only the excess needs an adjustment. Comp 1's seller paid $33,480, and 3 percent of its $558,000 price is $16,740. Adjust it down by the excess: $16,740. Comp 2's seller paid $20,002, against 3 percent of $580,000, or $17,400. Adjust it down $2,602. Comp 3 had no concessions.
Size and basement
Unit size: each of the subject's units is 636 square feet. Open unit 1's Finished Area Above Grade formula, and enter $50 per square foot. The panel's estimate from these few, varied sales is much higher, so we rely on our own analysis of this market. Do the same for units 2, 3 and 4. Comps 1 and 2 have larger units, so they're adjusted down; comp 3's are a little smaller, so it's adjusted up. The basement: the subject has an unfinished basement of 1,270 square feet, and the comps have none. Adjust each comp up $25,000, on unit 1's Unfinished Area Below Grade.
Net and gross
Net Adjustment Total and Adjusted Price update as you go, and so do the price per unit and per bedroom, the usual units of comparison for small income properties. 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.
Weigh the comps
Now weigh the comps, in the Comparable Weight row. Comps 1 and 2 get Most weight: they have the subject's layout and condition. Comp 3 gets Less weight. It's the smallest building, with a two-bedroom unit, and it sold for much more than the other two. Then enter the Indicated Value by the sales comparison approach: $560,000, within the range of the adjusted prices and close to the two comps with the most weight.
Explain the analysis
Last, explain the analysis. Open the Sales Comparison Approach section. In Reconciliation of Sales Comparison Approach, say which comps were used and why, and how concessions were treated. Then anything else a reader needs: the size differences, site sizes, and how the subject was measured.
Rental Information
That completes the sales comparison approach. Next, Rental Information, where each unit's rent goes into the rent schedule.