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   485 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