Calculate the Compound Annual Growth Rate (CAGR) in Excel by Chris Menard

The Compount Annual Growth Rate shows the growth rate that gets you from the initial value to the ending value. CAGR assumes that the initial value has been compounding over the time period.

You can also use CAGR to forecast where you will be in the future. I use Compound Monthly Growth Rate to analysze my YouTube subscribers.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[FinallyLearn]

Chris, good video! It is about 10 months later and by my calculations your monthly subscriber growth has been 23%. I used PV= 2, 592 and FV 21, 000 over 10 months. Great job!

[mrcarroll]

Chris, you did a great job, Love your illustration of the formula. Because of your steps in the visual organizer I was able to conceptually see and contrast the first step of raw proportional growth 2.48 with CAGR 's reductive impact of raw proportional growth 1.1992 and then simply subtract 1 for the implied compound rate of .1992. Bravo! You are a great teacher.

[naimady]

This was great, thanks Chris. Great articulation and illustration, clear and to the point

[md.gulammustafa]

it is really helpful thank you from DHAKA, Bangladesh

[ria]

i usually don't comment but thank you so much, this was very helpful!

[fatemeazizi]

Can the CAGR method be combined with other financial metrics?

[lucasbrandao-financas]

You really, really helped me! Cheers from Brazil!

[bizolution]

Hi Chris, how can you explain if the revenue yearly number is up and down and isn't gradually always up

[dmehta]

Request. There are no you tube videos that show CAGR as well as TOTAL RETURN and ANNUAL RETURN for stock purchase and sale if one can enter their own personal transaction of each purchase and sale. If you can make a video that would help so many of us. Please please make one that calculates all 3 of the rates. Thank you in advance. If you can show also what percentage of your total investment is in each equity that would be a PLUS.

[eliasmiahsohel]

Sir is it possible to calculate dynamically cagr calculation in excel ..

[MoritzvPoser]

How do you calculate the compound annual growth rate with negative numbers? For example the average yearly growth from a beginning value of -1283 to an ending value of 6701 in time period of five years?

[evanrandika]

what if initial number has negative number? is it still use the same formula of CAGR?

[ucthunb]

what happens when the first year is negative?

[divyareddy]

Can we calculate the CAGR Value Quarterly with the same Formula

[hamzatouaibia]

What is the logic behind the CAGR test you have made (end value*(cagr^periode)

[juanpablochedraui]

How can I calculate CAGR and CMGR with quarterly results?

[greginfla_]

Looks like your compound monthly growth rate is just under 9% .... congrats