Calculate the Compound Monthly Growth Rate (CMGR) in Excel

Compound Monthly Growth Rate (CMGR) is your growth rate over a given period, assuming the growth is at a constant rate every month. CMGR is similar to the Compound Annual Growth Rate (CAGR), but monthly instead of annually. I'm using CMGR since you may not have years of data to work with, but you have months of data you can use. CMGR and CAGR are excellent tools for investments, YouTube creators, or businesses analyzing subscribers, watch time, or revenue. You can use CMGR to calculate where you will be in 6, 12, or any number of months in the future.

Imagine that your active users were growing as follows:

Month Revenue % change
Mar 2020 100
Apr 2020 115 15.00%
May 2020 138 20.00%
Jun 2020 126 (8.70%)
Jul 2020 146 15.87%
Aug 2020 154 5.48%
Sep 2020 200 29.87%

Now you want to know two things: 1) What are my CMGR and 2) Where will I be in September 2021?
The CMGR is 12.25% rounded to two decimal places. It is (12.2462% with more decimal places)

If you start at 100 for March 2020, your base month, and multiple 100 times six periods (Apr through September), you would have 100 x 1.125 x 1.125 x 1.125 x 1.25 x 1.125 x 1.125

CAGR - Compound Annual Growth Rate
CMGR - Compound Monthly Growth Rate

Chapters:
0:00 Intro
1:18 Example with months
1:42 Month over month %
2:42 CMGR in steps
4:20 CMGR one formula
4:55 RRI function Excel
6:20 Test of CMGR
7:18 Forecast out
9:35 Check figure

I use CMGR to calculate my future YouTube revenue and subscribers. I'll make a specific video on how to calculate when you will reach 1,000 subscribers. You will need a few months of data.

Drawbacks: I'll discuss a few drawbacks with CMGR and CAGR in my next video.

Chris Menard's website: https://chrismenardtraining.com
Cristian's YouTube Channel:    / @graphicious  

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!