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

Time adjustment formula

Status
Not open for further replies.
C

cwgiant

Freshman Member
Joined
Oct 4, 2006
Professional Status
Licensed Appraiser
State
California
I am having some computer issues and have lost my excel spreadsheet that I had some formulas on.
I am looking for a formula for time adjustments.
I am not looking for ANY theory or OPINIONS about time adjustments.
The scenario is simply: sale 1 sold for $350,000 on 01/01/08 and sale 2 sold for $300,000 on 06/01/08. What is the correct mathematical formula for determining a price difference based on a monthly factor? Again, make no assumptions about anything; please just help me properly reconstruct my formula.
Thank you very much for your help, I am grateful and appreciative.
 
month avg sp - prev month avg sp = $X
$X / month avg sp = % +/-
total % +/- = adj amt
 
That would depend are you using straight line or compound adjustments for market conditions? Which adjustment type does your market data support?
 
Pair the sales, listings and/or pendings.
 
Common, that's a 1/7th reduction in price over 6 months. You dont need an excel spread sheet and a computer to figure this out.
 
Joshua Fookes said:
ROFL

Does the short bus make special trips for property inspections???
Click to expand...

I think Mr. Rex drives the short bus, but he drives it out behind the wood shed and gives the passengers wedgies!:rof::rof:
 
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