Yr to Yr comparisons

[Guest]

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.

 

[Guest]

=(B1-A1)/A1

Regards,

Peo Sjoblom

 

[Guest]

I am actually looking for the percentage % increase or decrease not the
difference which is what I think I received.

 

[Guest]

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.

 

[copy commad in excel formula]

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

 

[joeu2004]

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.

 

[Mag]

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?

 

[Mag]

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]

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 -----

 

[JoeU2004]

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 -----