Compound Annual Growth Rate

How do I cacluate the Compound Annual Growth Rate from 1 number to another
number over 5 years?

I'm not sure what you're actually asking.
Do you mean =RATE(5,0,-beginning number,ending number)



"Stash" wrote:

> How do I cacluate the Compound Annual Growth Rate from 1 number to another
> number over 5 years?

Thanks for checking with me. I found my answer by checking related postings
- after I had asked my question. I was looking for the formula: (end
value/start value)^(1/years).

"ww" wrote:

> I'm not sure what you're actually asking.
> Do you mean =RATE(5,0,-beginning number,ending number)
>
>
>
> "Stash" wrote:
>
> > How do I cacluate the Compound Annual Growth Rate from 1 number to another
> > number over 5 years?