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
#1

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

Can anyone share the formula you use to age data?


Private11192

   
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"

 


Private23117

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

http://www.worldatwork.org/waw/Content/library/html/library-formulas.jsp


 
Top Contributors
Compensation