+ Reply to Thread
Results 1 to 5 of 5

How can I calculate the base cost after nth year percentage increases?

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post How can I calculate the base cost after nth year percentage increases?

    I have already created a cumulative increase calculator that gives me a cost after a number of years where a fixed interest rate is applied each year.
    This is based on;
    Inflated rate = base cost X (1 + interest rate) ^ Years
    e.g. £500 * (1 + 0.04) ^ 5 = £608.33 {assuming 4% interest over 5 years}
    or £500 * (1 + 0.04) ^ 25 = £1332.92 {assuming 4% interest over 25 years} etc

    I would like to be able to calculate in the opposite direction. If I know that the current cost is £608.33 and that 4% interest was applied each year for 5 years, what was the base cost? How do I calculate backwards to the £500?
    I know that I can calculate the nth root by using (current cost)^(1 / Years) but that doesn't take into account any cumulative increase that has been applied. Can anyone help as I'm getting tied in knots!


    Many thanks

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: How can I calculate the base cost after nth year percentage increases?

    So your equation is:
    InfR = BC(1+IntR)^Y
    and you want to know BC? Then divide both sides of the equation by (1+IntR)^Y:
    BC=InfR/((1+IntR)^Y)

    or:
    608.33/((1+0.04)^5)=500

    I think.

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How can I calculate the base cost after nth year percentage increases?

    Hi,

    Not sure I understand.

    If:

    Inflated Rate = Base Cost x (1 + Interest Rate) ^ Years

    then:

    Base Cost = Inflated Rate / ((1 + interest rate) ^ Years)

    no?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    10-30-2013
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Red face Re: How can I calculate the base cost after nth year percentage increases?

    Many, many thanks for your help. About 5 minutes after I posted this I realised my mistake. I had simply forgot to place brackets around the last part... DOH!
    All working so thanks again for the quick response.

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How can I calculate the base cost after nth year percentage increases?

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate Regular savings where the amount saved increases every year
    By flossy129 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-01-2012, 01:41 PM
  2. Calculate rate increases based on financial year and start dates
    By cowproduct in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2012, 08:25 AM
  3. Replies: 2
    Last Post: 08-03-2012, 08:23 AM
  4. Replies: 8
    Last Post: 06-05-2012, 01:16 PM
  5. formula - calculate the yearly cost each year of the 10 year contract
    By Ineedxhelp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2008, 11:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1