+ Reply to Thread
Results 1 to 3 of 3

How to calculate the quarterly increase given a yearly percentage increase

  1. #1
    Registered User
    Join Date
    07-11-2011
    Location
    Cleveland
    MS-Off Ver
    Excel 2010
    Posts
    3

    How to calculate the quarterly increase given a yearly percentage increase

    If I know headcount will increase by x% a year, how can I calculate the value at each quarter?

    I have found that a 15% annual increase equates to a 3.55% quarterly increase.

    I can say =D2*1.03555 and get the increase, but I found the 3.55 number by trial and error, and I'm hoping to find a formulaic way to do it.

    Thank you for reading!
    Attached Files Attached Files
    Last edited by outjet; 07-12-2011 at 11:08 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,698

    Re: How to calculate the quarterly increase given a yearly percentage increase

    If cell A1 contains an annual percentage rate, then the rate applied each quarter that will be equivalent to that annual rate is

    =(1+A1)^(1/4)-1
    Last edited by 6StringJazzer; 07-11-2011 at 04:44 PM. Reason: corrected error in formula, the cell is A1
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-11-2011
    Location
    Cleveland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up [SOLVED] How to calculate the quarterly increase given a yearly percentage increase

    Quote Originally Posted by 6StringJazzer View Post
    If cell A1 contains an annual percentage rate, then the rate applied each quarter that will be equivalent to that annual rate is

    =(1+A1)^(1/4)-1
    Perfect, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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