Hellow guys, Welcome to my website, and you are watching Calculate the Compound Monthly Growth Rate (CMGR) in Excel. and this vIdeo is uploaded by Chris Menard at 2020-09-25T07:54:53-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Calculate the Compound Monthly Growth Rate (CMGR) in Excel |
| Video Uploader | Video From Chris Menard |
| Upload Date | This Video Uploaded At 25-09-2020 14:54:53 |
| Video Discription | 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: https://www.youtube.com/channel/UCvn7oUZPytubATC8Sx_DXOw 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! |
| Category | Entertainment |
| Tags | CMGR | cagr | compound monthly growth rate excel | compound monthly growth rate | compound monthly growth rate formula | excel rri function | rri excel formula | excel compound monthly growth rate | compound annual growth rate | youtube revenue | youtube subscribers | cagr calculation | cagr meaning | cagr excel | compounded annual growth rate | microsoft excel | personal finance 101 | personal finance | microsoft creators | microsoft creators youtube |
