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

[@mrcarroll3204]

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.

[@fatemeazizi1863]

Can the CAGR method be combined with other financial metrics?

[@naimady]

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

[@ChrisMenardTraining]

Very welcome!

[@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!

[@md.gulammustafa7563]

it is really helpful thank you from DHAKA ,Bangladesh

[@ChrisMenardTraining]

You are most welcome from Atlanta, Georgia. :-)

[@lindapertiwi1600]

very nice tutorial and very helping

[@ChrisMenardTraining]

Thanks, Linda.

[@trainingguru2645]

An excellent explanation

[@ChrisMenardTraining]

Glad you liked it

[@NikoJayCorre]

Big help officer!

[@ChrisMenardTraining]

Thank you.

[@josephalaguna]

great video sir. Thanks

[@ChrisMenardTraining]

you are welcome.

[@lucasbrandao-financas]

You really, really helped me! Cheers from Brazil!

[@ria8591]

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

[@ChrisMenardTraining]

Thanks Ria!

[@dmehta3476]

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.

[@ChrisMenardTraining]

I will add to my video list. I'll make it either this week or next week.

[@sonerguney3225]

Very good

[@ChrisMenardTraining]

Thanks

[@pshep5827]

Great video! Thanksa lot.

[@ChrisMenardTraining]

Glad you liked it!

[@bizolution]

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

[@chanakapradeep4109]

Thanks sir

[@ChrisMenardTraining]

Welcome

[@HighFlyer098]

thank you.

[@ChrisMenardTraining]

You're welcome

[@dltyler4023]

This is a keeper. Thank you.

[@ChrisMenardTraining]

Thank you. I've been wanting to make this video for a few weeks.

[@MoritzvPoser]

fantastic - thank you very much

[@ChrisMenardTraining]

Thank you.

[@rajesht7771]

Thanks a lot..

[@ChrisMenardTraining]

You are welcome!

[@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?

[@ChrisMenardTraining]

When you have a negative initial value, calculate CAGR based on the first positive initial value you have. You can always make a footnote of the negative year. Example: if you had a project that lost $1,000 in the year 2013, then gained $10,000 in the year 2014, and ended in the year 2017 with $50,000, you might write the following: Revenues grew from $10,000 to $50,000 during the period from 2014-2017. Note that this excluded the initial 2013 year when the project lost $1,000.

[@MoritzvPoser]

@@ChrisMenardTraining many thanks! I´ll can work with that! apparently there is no mathematical work around, but practically I can handle it that way :)

[@eliasmiahsohel1845]

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

[@evanrandika4888]

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

[@ChrisMenardTraining]

You need to start with a positive number.

[@MrBillava]

Thank You....

[@hamzatouaibia8330]

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

[@ChrisMenardTraining]

That is the formula to find the CAGR.

[@divyareddy5832]

Can we calculate the CAGR Value Quarterly with the same Formula

[@kanchan3312]

I think yes, but you just have change the period becos in 1 yr there are 4 quaters

[@juanpablochedraui6729]

How can I calculate CAGR and CMGR with quarterly results?

[@FinallyLearn]

You can calculate the four quarters as if they were four years. You can use the same formula.

[@何奇-m5v]

what happens when the first year is negative?

[@ChrisMenardTraining]

Use a year that is not negative. The 1st year can't be negative.

[@greginfla_1]

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

[@ChrisMenardTraining]

Thank you! It has slowed down a little.

[@greginfla_1]

25,000 subscribers is not too shabby either; I was impressed