|
Yr to Yr comparisons
After years of being in a high level tech support position, I transferred to
a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003. |
=(B1-A1)/A1
Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003. |
I am actually looking for the percentage % increase or decrease not the
difference which is what I think I received. "Peo Sjoblom" wrote: =(B1-A1)/A1 Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003. |
A1 = $1,200,359
B1 = $2,529,259 C1 = (B1-A1)/A1 = ($2,529,259 - $1,200,359)/$1,200,359 = 110.71% Format as a percent. -- Sincerely, Michael Colvin "cisse_5" wrote: I am actually looking for the percentage % increase or decrease not the difference which is what I think I received. "Peo Sjoblom" wrote: =(B1-A1)/A1 Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003. |
Yr to Yr comparisons
The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 m actually looking for the percentage % increase or decrease not the difference which is what I think I received. "Peo Sjoblom" wrote: =(B1-A1)/A1 Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003. |
Yr to Yr comparisons
On Jan 26, 8:24 am, copy commad in excel formula
m wrote: The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 Technically, you cannot. With the information you provided, you can only estimate the intermediate years based on the __average__ growth rate. m actually looking for the percentage % increase or decrease not the The compound average growth rate (CAGR) is: =rate(5, 0, -1, 1+20%) assuming that the "base year" is the year before "year 1". Based on that, estimated sales for each year can be computed by: =fv(A1, A2, 0, -100) where A1 is the CAGR, A2 is the year number, and -100 is the base-year sales. On Jan 26, 8:24*am, copy commad in excel formula m wrote: The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 m actually looking for the percentage % increase or decrease not the difference which is what I think I received. "Peo Sjoblom" wrote: =(B1-A1)/A1 Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 * * * * * *2004 1,200,359 * * 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. *I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003.- Hide quoted text - - Show quoted text - |
Yr to Yr co,mparisons
Hi, I was searching for the formula for average CAGR and needed some help.
Assuming the data Y1 9604 Y2 10260 Y3 12532 Y4 15996 Y5 17633 Pls enlighten how do I make use of your formula below? "joeu2004" wrote: On Jan 26, 8:24 am, copy commad in excel formula m wrote: The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 Technically, you cannot. With the information you provided, you can only estimate the intermediate years based on the __average__ growth rate. m actually looking for the percentage % increase or decrease not the The compound average growth rate (CAGR) is: =rate(5, 0, -1, 1+20%) assuming that the "base year" is the year before "year 1". Based on that, estimated sales for each year can be computed by: =fv(A1, A2, 0, -100) where A1 is the CAGR, A2 is the year number, and -100 is the base-year sales. On Jan 26, 8:24 am, copy commad in excel formula m wrote: The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 m actually looking for the percentage % increase or decrease not the difference which is what I think I received. "Peo Sjoblom" wrote: =(B1-A1)/A1 Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003.- Hide quoted text - - Show quoted text - |
Yr to Yr co,mparisons
"Mag" wrote:
Hi, I was searching for the formula for average CAGR The year-to-year growth rate is y2/y1-1, y3/y2-1, etc. The CAGR can be computed many ways. Since you have the raw data, the simplest way is: (y5/y1)^(1/4)-1, or more generally: (yN/y1)^(1/(n-1))-1. If you have only the year-to-year growth rates, the following array formulas (commit with ctrl-shirt-Enter, not just Enter) often work: =product(1+y1:y5)^(1/4)-1 =geomean(1+y1:y5)-1 But those formulas behave poorly when the number of periods is large, simply due to computational limitations. So more generally, the following array formula works (commit with CSE): =10^average(log(1+B2:B5))-1 ----- original message ----- "Mag" wrote in message ... Hi, I was searching for the formula for average CAGR and needed some help. Assuming the data Y1 9604 Y2 10260 Y3 12532 Y4 15996 Y5 17633 Pls enlighten how do I make use of your formula below? "joeu2004" wrote: On Jan 26, 8:24 am, copy commad in excel formula m wrote: The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 Technically, you cannot. With the information you provided, you can only estimate the intermediate years based on the __average__ growth rate. m actually looking for the percentage % increase or decrease not the The compound average growth rate (CAGR) is: =rate(5, 0, -1, 1+20%) assuming that the "base year" is the year before "year 1". Based on that, estimated sales for each year can be computed by: =fv(A1, A2, 0, -100) where A1 is the CAGR, A2 is the year number, and -100 is the base-year sales. On Jan 26, 8:24 am, copy commad in excel formula m wrote: The base year sales is 100 and in the 5th year the increase is 20% of the base year's sales. How to calculate the sales in year 1, yr 2, yr 3 and year 4 m actually looking for the percentage % increase or decrease not the difference which is what I think I received. "Peo Sjoblom" wrote: =(B1-A1)/A1 Regards, Peo Sjoblom "cisse_5" wrote: After years of being in a high level tech support position, I transferred to a Business Analyst position. I forgot the formula used to provide the percentage increase or decrease this year compared to last year. 2003 2004 1,200,359 2,529,259 What is the percent increase in sales from 2003 to 2004? A3 = the first figure and cell G3 equals the second sales figure. I tried 1,200,359/2.529,259 but am not getting the correct percentage or percent formatting in Excel 2003.- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com