+ Reply to Thread
Results 1 to 4 of 4

Interpolate monthly growth from known Annual Growth

  1. #1
    Registered User
    Join Date
    06-14-2014
    Posts
    1

    Interpolate monthly growth from known Annual Growth

    Cross post here: http://www.mrexcel.com/forum/excel-q...al-growth.html

    Hi All,

    I have a series of values

    Jan-11 101
    Feb-11 111
    Mar-11 118
    Apr-11 135
    May-11 140
    Jun-11 149
    Jul-11 151
    Aug-11 161
    Sep-11 166
    Oct-11 175
    Nov-11 187
    Dec-11 191

    So total 2011 = 1785
    I also know that 2012 grew by 71% so there fore 2012 = 3052.35

    Now, I'd like to extrapolate 2012 monthly data to get a steady growth for 2012 which will add up to 3052.35

    So for Jan'12 it would be Dec'11*(1+X%) and then Feb'12 would be Jan'12*(1+X%)

    My question is what is this X%? I've interpolated the 71% growth to monthly as 4.57% but if I use that as my X I get 2012 = 3101.563 which is actually 2011*(1+74%) instead of 71% as I know the total to be for 2012.

    Any ideas how to find the correct X to show upward growth?

    Thanks very much for your help

    EDIT: Adding crosspost - apologies for not doing before
    Last edited by nopointing; 06-14-2014 at 07:54 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,474

    Re: Interpolate monthly growth from known Annual Growth

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    http://www.mrexcel.com/forum/excel-q...al-growth.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,676

    Re: Interpolate monthly growth from known Annual Growth

    ....^....1
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Interpolate monthly growth from known Annual Growth

    See responses in the crossposting at http://www.mrexcel.com/forum/excel-questions/784571-interpolate-monthly-growth-known-annual-growth.html

+ 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. Replies: 8
    Last Post: 02-02-2020, 01:39 AM
  2. Replies: 6
    Last Post: 05-05-2013, 07:17 PM
  3. annual growth rate from monthly data
    By kotlon in forum Excel General
    Replies: 5
    Last Post: 06-16-2006, 04:00 PM
  4. How to: average annual growth
    By macdakoo@hotmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-02-2006, 02:20 PM
  5. Compound Annual Growth Rate
    By Stash in forum Excel General
    Replies: 2
    Last Post: 03-30-2005, 03:06 PM

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