WorldatWork, the Total Rewards Association
Password:  Change  |  Forgot  |  Help   
Email   Print


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


Copyright  |  Privacy Policy  |  Site Map  |  Advertise with Us  |  Community Terms and Conditions