• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.

Newbie question: How do you come up with adjustments?

Status
Not open for further replies.

Sbps30

Sophomore Member
Joined
May 22, 2013
Professional Status
Licensed Appraiser
State
California
One of the most difficult parts of appraising for me so far is how to calculate adjustments. In the appraising classes, they taught about a few vague ways to find adjustments, but they all seem very difficult, time consuming, and not very accurate.

I am working with a very experienced appraiser who uses his own adjustments he's used for 20+ years. Most of how he came up with adjustments he learned from his supervisor. And others he learned from an appraising company he used to work for.

How do you learn adjustments? Does it just come with experience? Or just repeating what others do? Or is there another method? What's the real world way to do it (not the textbook way)?
 
...

I am working with a very experienced appraiser who uses his own adjustments he's used for 20+ years. Most of how he came up with adjustments he learned from his supervisor. And others he learned from an appraising company he used to work for.

...


That's a bit scarey.
 
Ok, at first learn all you can by doing it the way they do it.

I remember your predicament when I first started.

Its hard to make those adjustments for the first time. I made mine about 22 years ago and can remember asking so many questions as I struggled with the process of emotionally involving myself in the valuation process.

Best bet is to listen close. Hopefully you started with a decent appraiser.

Don't take it too seriously right now because your new.

If you have some adjustment questions, answer most quickly by pulling similar appraisals in your office of similar type properties.

You don't have a lot of time to come in here and have us hold your hand.

So, pull similar files and ask questions in your office.

Hopefully they are giving you some cake appraisals at first.

Once you start extracting your land values from your comps you can then get a handle on living area size adjustments.

Ex. you pull the land value out of your comp and are left with (ie ex. $100 psf) of living area.

You may adjust that at $50 a sf ....

Just try to keep your age, room count, location as similar as possible ....
 
You're working for a supervisor who relies on "the list", which is basically a collection of adjustment factors that are considered acceptable across a variety of properties and which require zero thinking or analysis to apply. It's like autopilot, and it's a valuable tool for those appraisers who are fixated on getting reports out the door in the least amount of time.

As well, "the list" can be pretty functional when most of your assignments involve properties for which there are always a ton or really similar comps. So it's not necessarily an evil thing to rely on the list.

But it would be a good thing to learn how to develop and support your own adjustments at some point in your career.

Opinions on adjustments vary. Some people see an adjustment grid with 20 lines and figure that having numbers in every single one of them is helpful for adjusting their dataset to support the one true value conclusion that can be considered "accurate". Others see adjustments as a (mostly) minor refinement that should be used sparingly, as in, the fewer the better.

You can probably see by the way I just characterized the two that I am among the group that favors the latter viewpoint. In my opinion if you have great comparables you don't need adjustments. You can just rank your subject within an unadjusted dataset and get a reasonable value conclusion from that. Conversely, when you have great comps the factors you use for adjustment will mostly be irrelevant to the conclusion anyway because those adjustments will usually be so small as to not be of effect.


The way I generally develop adjustments is to compare the sales in my dataset against each other to see which adjustments produce the tightest spread, starting with those factors that I think will be of most effect. That comparable dataset usually includes a lot more properties than I end up using as direct comparables in my report.

I usually qualify more sales than I use in my reports - that means that besides the details of the transaction itself I am also getting an idea of quality, condition, site and location attributes as they relate to my subject. Although the statistic geeks like large quantities of data for statistical analysis I don't favor using unqualified data when I'm trying to identify adjustment factors.

Anyways, the way I do it is to array my sales data in reverse chronological order (newest sale or pending first >> most dated sale last). Since I use spreadsheets a lot I've found it's easier to do it on a spreadsheet. If the properties are all in similar locations and have similar site influences then that simplifies the decision of which factor to adjust first, in which case I usually go straight for GLA.

I try out different GLA factors to see which one results in the tightest spread. Sometimes I guess correctly and the first one I start with works better than the rest, but usually I have to try several different iterations. This is where using a spreadsheet can be faster - you can write an equation that references a single cell (which contains your adjustment factor) and copy it into the column or line you're using for your adjustments. You can check on your spread using another set of equations, which on an Excel spreadsheet looks like this:

=max(A28:A38) that cell range refers to the line or column with your adjusted value indicators
=min(a28:A38)
=x-y (x equals the "max" cell above and y = the "min" cell

You're basically telling the spreadsheet to identify which adjusted value out of the range is the highest and which is the lowest and you're looking for the adjustment factors that reduce the spread between the two to the lowest possible margin.

Sometimes GLA is not the primary adjustment factor. Sometimes it's a view amenity or the date of sale or location or physical condition. This is where having an open mind and paying attention during your research pays off. It doesn't pay to start with too many assumptions. If you structure your analysis well you can try a couple different attributes out on a trial/error basis to see which has the most effect. It's often GLA but not always.

Anyways, after you get the first adjustment factor squared away you can test others. If GLA worked best the condition may be the next biggest factor. Or vice-versa; it just depends on the situation.

Sooner or later you're going to reach the point of diminishing returns. Where going further with your adjustment factor doesn't have additional effect or it has an opposing effect on increasing your spread. That's the trick of adjusting, to get to that point and stop.

In many residential assignments you can reach that point of diminishing returns after adjusting for just a few attributes: GLA, condition, date of sale, financing (and seldom in that exact order). Realistically we're supposed to start with financing first, then date of sale; but in my experience it can often work more effectively in a different order.

Anyways, once your spread gets reduced that's the time to stop. You may not be identifying adjustments for 4bd vs 3bd, but then again you wouldn't need to make such an adjustment had you just stuck to 3bd comps in the first place. In this region garage spaces are usually worth adjusting for, but not always. Pools usually aren't worth an adjustment in the older homes but sometimes the data says otherwise.

The main trick is to let the data speak for itself; and having done so, to say that in your report so you don't get some pencil neck "reviewer" hassling you for not adjusting for 1,000 sf of lot area or that 4th bedroom.

In my view, a reasonably adjusted dataset that gets there after only a few adjustments conveys significant support for a value conclusion. If I have to apply a lot of different adjustments that indicates that I started out with a really weak dataset in terms of comparability.
 
Appraisal is an art

I came from the "old school" where every adjustment has paired sales data within the office to support your work.

The "art" of appraisal is a highly jealously regarded process that puts a lot of work on the person who wants to "reflect" market behavior.

But, since your very new, you have to go slowly.

Your biggest hurdle will come when you understand the interplay between the three approaches and how this can be applied in the market approach when appraising owner occupied single family homes.

Hopefully you have a good mentor who is guiding you.

If we did 4 or 5 appraisals a week we were at full speed.

If your in a shop where your appraisers are cranking out 10 to 20 appraisals a week per person then your in a automated situation which George Hatch described and you need to get out of there as soon as you get some more experience and have another job lined up.
 
What George just gifted the readers of this thread with, is an excellent description of how to use sensitivity analysis to help explain variance.
 
In my view, a reasonably adjusted dataset that gets there after only a few adjustments conveys significant support for a value conclusion. If I have to apply a lot of different adjustments that indicates that I started out with a really weak dataset in terms of comparability.

The longer I stayed in the appraisal field and worked in large rural areas the more the data sets began to show better and better "modal tendency".

If I have one good comp in close proximity and have other similar homes in terms of condition, function and design then I would tend towards those sales - the grid looks very clean and free of adjustments.

The longer I appraised the fewer adjustments I made.
 
Thank you.

But it would be a good thing to learn how to develop and support your own adjustments at some point in your career.

Wow! That is a lot of valuable information that I don't fully understand at this point. I'm sure I will though. I will try your method out. Thanks very much.
 
Status
Not open for further replies.
Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Back
Top