How To Calculate CAGR In Excel (Compound Annual Growth Rate)

[@rajalakshmih757]

Clearly explained.

[@FinallyLearn]

I just found your channel by searching for CAGR videos. Good job. You have good video tutorials for Excel. We have similar channels, so I am excited about your channel's growth. Best wishes from the USA.

[@theexcelhub]

Thanks for watching and all the best with your channel too!

[@francizkou]

Simple and crear, thank you very much!

[@siddharthadwivedi4903]

Thanks buddy.. you have explained beautifully..

[@theexcelhub]

Thanks for watching!

[@alanrussell3739]

Very helpful! Thank you.

[@theexcelhub]

Thanks for watching!

[@frosherman]

what a dope video, thumbs up!

[@theexcelhub]

Thanks for watching!

[@itumaesh]

Awesome and very much informative. Do you also make videos for adding business related formula in excel. If so then great if you can share links to those videos. 👍🙏

[@theexcelhub]

Thanks for watching! When you say business, do you mean accounting and finance related videos? In which case, I have a playlist dedicated to this: kzbin.info/aero/PLK5FjPWoDFmIz-WQjXgTK3BYEM_SIi5DO

[@georgeemil3618]

That calculation is compounding on an annual basis. If you want continuous compounding it's ln(EA/BA)/n, where n can be any fraction of a year.

[@chew-dur1372]

I have questions. I am still confused to this day. Hope you can help. 1. I wanted to calculate CAGR from 2021 to 2030. That is 10 years. So, what year should be the "beginning value" of the calculation? is it 2021 or 2020? the formula is =((2030/2020)^(1/10)-1) 2. Or, would it be meaningful to write it as CAGR 2020-2030? the formula is the same, that is =((2030/2020)^(1/10)-1) thank you.

[@theexcelhub]

If you want to calculate it from 2021 to 2030 it would be (2030 amount/2021 amount)^(1/9)-1 whereas to calculate it from 2020-2030 it would be (2030 amount/2020 amount)^(1/10)-1. I explain the rationale behind this in 1:40.

[@chew-dur1372]

@@theexcelhub that's what I thought the correct way to write/calculate them. However, I often see like the first one. They would say CAGR 2021-2030, but calculate as (2030/2020)^(1/10)-1 It is very confusing. But I prefer your way.

[@seepanaharikeshava6418]

How do we calculate CAGR if we have days instead of Years?