Calculate the Compound Monthly Growth Rate (CMGR) in Excel

[@AdeusG]

Saved my butt with my new job. Thank you!!

[@andrewvillamor5478]

I have watched sevral videos and still confused on how to calculate CGMR. Sir, you made it very simple. Kudos! A new subscriber here!!

[@shawnphickman]

This was such a clear explanation of a calculation I was struggling with. Thank you for breaking it down step-by-step. It really helped me out!

[@ChrisMenardTraining]

You're very welcome!

[@aanchalvishavkarma9698]

This is really helpfull..I am from India (Noida) as a Sr. MIS Executive

[@ChrisMenardTraining]

Thank you! I appreciate the support.

[@joshlh3057]

Perfect! You totally solved a problem I've been trying to fix for a month now. Just subscribed! Thank you.

[@ChrisMenardTraining]

Glad I could help!

[@InspiredByBudh]

Awesome calculation style, thanks so much Sir

[@NBA_NowandThen]

Thank you! Learned a new skill that's critical for our goals.

[@Graphicious]

If you're obsessing over how fast your KZbin channel is growing, you can use this formula to forecast when you're going to have 1000 subscribers. Thanks for the video!

[@marcojuarezreichert]

Very good explanation. Congrats!

[@ChrisMenardTraining]

Thanks!

[@carloslara5686]

You called it. Friday was awesome

[@PatrickKaligis]

clear explanation. thank you

[@ChrisMenardTraining]

Glad you liked it. Thanks, Patrick!

[@nattacev9954]

This was great - thanks a lot!

[@ChrisMenardTraining]

Glad you enjoyed it!

[@husamwadi2635]

Great video

[@ChrisMenardTraining]

Glad you enjoyed it

[@andru6223]

Hey Chris, i'm not sure if this is correct. What about that: Month 1: 100 Revenue - Month 2-5: 500 Revenue - Month 6: 100 Revenue. That would mean that your CMGR is 0 but there was a strong revenue increase in the months in between...

[@eduardorodriguezdelpaso6646]

Excellent!

[@ChrisMenardTraining]

Glad you liked it!

[@nadyeskagonzales1025]

Thank you very much you saved me !

[@ChrisMenardTraining]

You're welcome! Thank you.

[@tizme2311]

Excellent, video, my project is slightly different and would appreciate some feedback (project summary) this is to calculate future value of a current value the variable is the number of days, therefor the days value has to be a variable cell. Formulae: (current fixed value* Number of days) * 10)) * fixed % = current value. Future value is function of the number of days from the day starting value (ie todays vnumber value = 294 tomorrow will be 294+1) One years time expressed as days will be 294+365. So the days variable cell would have 365 inserted. The formulae above will calculate the future value extrapolated from todays value. So, the objective is to take todays and extrapolate for any number of future days. Nb: (current number of days increases * 1 per day). so calculation is current value * days to ^n power. NB: the future number is a projection based upon the starting point snapshot. Is there a flaw in my formulae and how can this be easily expressed in excel 365 ? can you help?

[@vidya014]

There are 2 different type of compoundings. Homework: 2 years compoundings: Dividend Compounding = (1+g)² Intrinsic Compounding = ?

[@learning_with_irving4266]

Is that not the same as the CAGR formula?

[@ChrisMenardTraining]

CAGR and CMRG are difference. If the CAGR is 12%, most people say the CMGR is 1%. 12/12=1, but that is incorrect. The CMGR would be 0.94888%. Calculated as =1.12^(1/12)=100.949% then subtract 1 = 0.94888%.

[@valyanurfadila]

Hi, would like to ask (and confirm) for a case of : 1) the number of revenue is all negative 2) say the beginning value is -5000 and the end value is -4000 , for a period of 12 months For the CMGR, following the formula above I would get a result of -1,48%. Considering that there is a positive growth in revenue (starts with -5000 and ends with -4000) , should I add *(-1) so that the CAGR is positive of 1,48% ? Thank you!

[@interestingLife5002]

Is there anyway to do this for months that don't have data in the cell - Some way to skip the empty, zero, non-numerical value in cells?

[@nattacev9954]

🛑 ❓I really hope someone can help me answer this: I thought that the CMGR was used to average out the growth rate for the months listed. I thought this was supposed to be ONLY one value since we want the value to encompass the dates listed as a whole. If you/he are applying it to each month, wouldn’t we call this average monthly growth rate? Sorry… a little confused - please help! 🙏🏻 :)

[@billmoody7194]

Thank you for the great tutorial. Can this also be applied to a daily format? Also, I didn't see a link to the file.

[@broyston]

Thanks for the video. I'm trying to figure out the formula that will return the number of months to get to y dollars starting with x dollars and given a monthly growth rate. Any help (or video) on this?

[@broyston]

Got it...used the NPER excel formula. Thx.

[@stanarthur]

I've never used Microsoft Excel but I have a 12 month growth rate of 2% per month. What is the annual growth rate?

[@ChrisMenardTraining]

That would be *26.824%* Add 1 to .02 to get 1.02 then raise to the power of 12 =1.02^12 = 1.26824

[@carloslara5686]

Lol I thought this was about the stock never mind ha

[@aanchalvishavkarma9698]

Hi sir

[@Tavvy4351]

This does not work. Change your 200 to a different number and you'll see it does not work!!!