Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate N Years Inflation (Excel 97-SR2)

    Is there a natty way of calculating a compound(?) inflation rate for 'n' years. I know the start date. I know where I am now. (I wish!). I have a single inflation rate I want to add for each year. I have a pay grade table that should be updated once a year. i.e. I know when it was last updated. I want to take account of people not updating the table and add 'n' years inflation. Currently I 'assume' the table was updated in recent history. I currently have:

    =IF(SomeConditionIsTrue,AZ5+(AZ5*(Inflation/100)),AZ5)
    N.B. I guess this came from cell BA5.

    In effect what it does is add the inflation rate to the value in the previous cell, or just copies the value in the previous cell if we are not due to increment inflation. The net result is that the TRUE calculation will only ever calculate every April, which is what I want.

    I would like to be able to add n' years inflation based upon the number of years between a start date and the current date. e.g.

    StartDate=2000
    NowDate=2003
    Inflation=3

    =1+(((YEAR(NowDate)-YEAR(StartDate))*Inflation)/100) = 1.09

    The answer I want, in this case is 1.092727. Picky I know.... Is there a way?

    Regards
    Peter

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calculate N Years Inflation (Excel 97-SR2)

    =(1+Inflation/100)^(NowDate-StartDate)

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calculate N Years Inflation (Excel 97-SR2)

    Steve, won't that compound daily? I usually use (where inflation rate is already expressed as a percentage):

    =(1+inflation_rate/12)^DATEDIF(now_date,end_date,"m")
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calculate N Years Inflation (Excel 97-SR2)

    Steve 's formula is correct, and compounds annually, as requested. I always work with dates, and compound monthly.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate N Years Inflation (Excel 97-SR2)

    Steve

    Many thanks. Exactly what I wanted. I knew I needed to use exponation, just had the numbers the wrong way round. (So many to choose from!)

    Regards
    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •