I accept

WorldatWork uses cookies to enhance your experience on the website.
By continuing to use the website, you are agreeing to the use of cookies.

View Privacy Policy Learn more about cookies


Compensation  >>   Aging Market Data Formula Search Discussion Posts
Discussions Help
Sort By: Oldest posts first Most recent posts first

Aging Market Data Formula  
Posted: 10/14/2010 01:30pm   751 Views
   (0 ratings)

Can anyone share the formula you use to age data?


Aging Market Data Formula  
Posted: 10/14/2010 02:40pm   Revised: 10/14/2010 02:41pm  

Values needed:

Survey data: x

Aged survey data: y

Annual aging percent: i

Survey date: SD

Current date: CD


y = x*(1plus ((CD-SD)/365)*i)


For some reason the plus sign isn't showing, so use that in lieu of where I put "plus"



Aging Market Data Formula  
Posted: 10/15/2010 12:22pm  
   (0 ratings)

There are sample calculations in the WAW website (click on link and scroll down to aging survey data for example).


Top Contributors