In this video, you will learn the meaning of CAGR and how it is calculated, the difference between CAGR and growth rate and how to calculate CAGR with the RRI function and create a custom CAGR function using the LAMBDA function.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
00:03 Intro
00:25 What is CAGR?
01:08 How is CAGR calculated?
02:02 CAGR vs Growth rate
02:34 Formula approach
03:39 RRI function
04:02 LAMBDA function
Thank you!
Connect with me on:
👉Instagram https://www.instagram.com/youexceltutorials/
👉Facebook https://www.facebook.com/youexceltutorials
👉Twitter https://twitter.com/youexceltutor
👉 TikTok https://www.tiktok.com/@youexceltutor
👉LinkedIn https://www.linkedin.com/in/bunmi-sanusi/
🎬Check these videos:
YoY analysis
https://youtu.be/2PtlrBzedB4
What is EBITDA?
https://youtu.be/lAUcqDp3A7M
YTD analysis
https://youtu.be/s7SWbVgi5y4
Common size analysis
https://youtu.be/HxZoOe1VcaU
🔽Link to file https://docs.google.com/spreadsheets/d/1BoaBnhINLtJuB4AVJL3st_tmqKkSei_l/edit?usp=sharing&ouid=112939358226643879339&rtpof=true&sd=true
📢” Don’t just pretend to love others. Really love them. Hate what is wrong. Hold tightly to what is good” Psalm
12:9 (NLT)
#cagr, #lambda, #youexceltutorials