• 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.

Formula - to Adjust GLA ?

Status
Not open for further replies.

Riick

Elite Member
Joined
Aug 14, 2007
Professional Status
Certified Residential Appraiser
State
Delaware
OK.. for centuries I've been using a rule of thumb I worked out for adjusting comparables GLA - based on the average sale price/ft of the comparables.
Now I'd like to set up an Excel spreadsheet to calculate the best adjustment.
Played with it this afternoon, and realized after a little while that I had no idea what measure to use to get "best fit", my last course in "sadistics" was over 30 years ago.

Anyone with a formula for me?
.
 
OK.. for centuries I've been using a rule of thumb I worked out for adjusting comparables GLA - based on the average sale price/ft of the comparables.
Now I'd like to set up an Excel spreadsheet to calculate the best adjustment.
Played with it this afternoon, and realized after a little while that I had no idea what measure to use to get "best fit", my last course in "sadistics" was over 30 years ago.

Anyone with a formula for me?
.


Riick,

Send me a PM with more specifics and maybe I can help you out. I've been doing a lot of work with array formulas; array formulas can accomplish just about anything.
 
Riick,

Send me a PM with more specifics and maybe I can help you out. I've been doing a lot of work with array formulas; array formulas can accomplish just about anything.


The "formula" would be different for each set of comparables.

Basically you're looking for the value of X that results in the lowest range of adjusted values, where x is the adjustment factor for GLA.

You can do this pretty easily by trial and error in Wintotals Comp Adjuster function.

Or you could do a multiple regression of the data.

Or you could just play with it in the comp grid, going up or down by $5/sf increments till you minimize the difference between the comps.
 
........Or you could just play with it in the comp grid, going up or down by $5/sf increments till you minimize the difference between the comps.

Which is what the Ratterman book basically teaches assuming you follow the theory. Any appraiser guessing how they come up with a $/SF GLA adjustment needs to own the book.
 
Which is what the Ratterman book basically teaches assuming you follow the theory. Any appraiser guessing how they come up with a $/SF GLA adjustment needs to own the book.


"Using Residential Appraisal Report Forms", pages 97-99.
 
OK.. for centuries I've been using a rule of thumb I worked out for adjusting comparables GLA - based on the average sale price/ft of the comparables.
WOW. That is SO SO SO SO wrong!!! This adjustment should be market based. You have fallen into the trap that every Realtor who does a CMA has. I am dumbfounded.

If you have a comparable house that sells for $100,000, and is 2000 sq.ft., the $/SqFt FIGURE (not cost or value or adjustment) is $40/sq.ft. That figure includes EVERYTHING. Land, site improvements, garages, pools, etc.

Assuming that your comparables are IDENTICAL IN EVERY WAY to your subject except living area, (which is rarely the case), I presume you are stating that you would adjust the comparable at $40/sq.ft. The problem with this methodology is that incremental differences in house sizes DO NOT cost $40/sq.ft. to build. When you balloon a 2000 sq.ft. house to an otherwise comparable + 10% (a 2200 sq.ft. house), both still have the same basic features in the kitchens and bathrooms (which are 5-10 times more expensive to build than simply ballooning every room by 10%. All you are adding is slab, roof and floor covering, perhaps in this example $20/sq.ft. max.

If you are looking for a universal formula, well perhaps you need to think again. Riick, I would LOVE to see your method described in print. Where in the world did you learn this 30 years ago?

No you know why underwriters want comparables bracketed by size. It is because appraisers with convoluted ideas on how to make square footage adjustments (using methods like yours) can horribly skew an appraisal. With bracketing, the net effect of the adjustments will nullify each other.

No other adjustment factor is more suited for matched pair analysis than $/sq.ft. I am certain that if you do one, you will see that your $/sq.ft. method GROSSLY overestimates the actual MARKET reaction to incremental differences in living area.
 
Here's a little spread sheet that does basically what Ratterman is talking about.

I've put some sample formulas in there for people that aren't really excel savvy.

00000142.png
 
Perhaps you could educate us with the correct procedure??? Please be specific.

The simple suggestion is LUDICROUS that:

If a buyer of a comparable pays $100,000 for a 2000 sq.ft. pool home on 1 acre with a 2 car garage, it would support a $50/Sq.ft. adjustment factor for that comparable.

First off, presume the comparable is new. A quick cost analysis may indicate that the land is worth $15,000, the garage $5000, and the pool $15,000, leaving the cost/value of the improvements (assuming no obsolescence or deterioration) of $65,000. Heck, if you MUST use this method, AT LEAST break it down that far. Now we would be adjusting just for the improvements size, at $32.50/sq.ft.

So I can only guess that you, too Jerry, use Riicks method... I hope you re-think that.

Matched pair analysis WILL NOT match your non-market based, non-logical $/sq.ft. method.

And we wonder how so many properties were over appraised in the mid 2000's. Apparently appraisers have been using sale price $/sq.ft. as an adjustment factor, and using 50% smaller units as comparables. Skippity do da day...
However, even that will most likely prove to be high, because that is an AVERAGE $/sq.ft for the house, skewed higher by the MUCH higher costs of small areas like kitchens and baths, water heaters, HVAC, and all those things that are very expensive, that both houses will have regardless of total size. A more realistic conclusion, if you MUST use this method, would be to discount that $32.50/sq.ft. by some factor to recognize that ballooning a house is MUCH cheaper, per sq.ft., than constructing the whole house.

In a Residential 101 book I read, Taken from an example of a residential appraisal, :

In our home appraisal example, Comparable #2 had been remodeled while the subject was in pretty much pristine 1966 condition. Therefore the appraiser subtracted $5,000 from the comparable, effectively removing the remodeling from the equation. There was substantial variation in the square footage of the house so comparables were adjusted up or down at the rate of $20 per foot. Comparable #2 slightly smaller than the subject so $440 was added (thus tacking on another 22 square feet) while Comp #3 was debited $11,000 to negate the value of its substantially larger footprint.
Remember, the cost approach had yielded a psf replacement value of $70.50 and the comparables had sold at a psf price ranging from $63 to $86. Our appraiser said that the $20 has NOTHING (my emphasis) to do with either of the other calculations. It is more a measure of impact. Buyers do not attach that much value to actual measurements, assuming the size meets their needs.
 
Last edited:
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