Excell Spreadsheed to calc GLA adjustment

[Ken Youngkrantz]

Excel Spreadsheet to calc GLA adjustment

About two years ago Metamorphic posted a spread sheet to help calculate and GLA difference adjustment. Wondering if anyone is using that.

Thanks
Ken

 

[incognito]

I was the OP on this thread. I use the program on nearly every appraisal I do. I print out the page 1, with the results.

Yes, I know that in order for it to be reasonably credible, ALL other adjustments need to be solidly derived and supported.

However, you can bet your sweet Bippy (whatever a Bippy is) that an underwriter (or more importantly a Judge in a case where you have provided an appraisal such as Dissolution or Marriage) are going to be MUCh more comfortable with an appraisal that has some sort of support for living area adjustments in it!

 

[Ken Youngkrantz]

Thanks for the quick response. The way you have the spread sheet set up do you do all of your other adjustments before you do the GLA or only the adjustments above the GLA line. I agree 100% about your statement of some support for adjustments. I do a regression on some of my reports, many do not have enough sales for the regression to be reliable.
Appreciate your time.
Ken

 

[Riick]

About two years ago Metamorphic posted a spread sheet to help calculate and GLA difference adjustment. Wondering if anyone is using that.

Thanks
Ken

I keep a version on my desktop that has separate worksheets for 3 /4 /5 /6 comparables.

BTW -- Frequently I find the number it calculates is close to 1/3 of the average sale price per foot of the comps.
...and yes on occasion, it has come up with a negative adjustment.

When it does you can see there's an oddball property that's in decent condition, a good bit larger than the subject, but it sold cheap.

Some Buyers just don't know how to make a good deal for themselves,
while others know how to steal property from the Seller.

 

[Terrel L. Shields]

Correctly done, you need to subtract out the land value and any other differences that are significant like a shop building, pool, etc.

I have a very rudimentary sens. adjustment grid set up to do age adjustments based on $/SF/yr then use that to adjust the sales price of the comps then used to estimate the SF adjustment. I have a series of these for various commercial and farm items from 3 to 5 comps, so I am attaching an abbreviated version with only 3 comps and 2 worksheets - age and SF. After extracting the land value and the outbuildings, etc. I can then adjust for age first then SF.

I've attached them in a zip file. AF doesn't handle .xls files. The grid is saved as an older version of Excel so it should run on all but the oldest versions.

If it doesn't work, pm me with an email and I will send that

 

[Ken Youngkrantz]

Thank You fellas; this is going to give me something to work on.
I appreciate the help.
Thank You !
Ken

 

[Sid Holderly]

I use an extraction grid to find the house value and then use a percentage of the house value per square foot (marginal value of a difference) and not the full value per square foot.
The spreadsheet subtracts the lot, basements, and other amenities then figures the remaining average of several sales to give a $/sf from which the percentage is chosen.