Posted to microsoft.public.excel.misc
|
|
Average Growth Rate
According to this site, you can use AVERAGE as an array function:
https://www.exceltip.com/st/Calculat...owth/1096.html
Dave
--
Brevity is the soul of wit.
"Scott" wrote:
Dave F,
Thanks for your response. That does what I am looking for, although I was
looking for a formula that I could fit in one cell to accomplish it. Sorry
for not being more specific.
Thanks!
"Dave F" wrote:
Here's something more specific
1 $10,000,000.00
2 $14,740,634.86 47.41%
3 $16,736,647.04 13.54%
4 $16,922,847.13 1.11%
5 $18,653,648.44 10.23%
6 $26,127,105.88 40.06%
7 $33,074,355.97 26.59%
8 $42,284,677.94 27.85%
9 $42,545,480.92 0.62%
10 $49,387,299.55 16.08%
20.39%
Range is A1:c12.
C2 = B2/B1-1 etc, filled down to C10
C12 = AVERAGE(C2:C10) = 20.39% average growth rate.
Is that what you're looking for?
Dave
--
Brevity is the soul of wit.
"Dave F" wrote:
Calculate the revenue growth rate for each pair of consecutive years and then
average those rates.
--
Brevity is the soul of wit.
"Scott" wrote:
If I have a revenue number for 10 concescutive years, what is the best way to
get the average growth rate for these numbers? Thanks!
|