Compound Annual Growth Rate

G

Guest

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

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top