CAGR is short for Compound Annual Growth Rate. With the verb “to compound” meaning “to multiply”. Growth on top of growth.
What if a company currently has $100 million dollar in sales, and wants to be at $249 million five years from now. What growth rate would get you from A to B?
The answer is 20%, and the formula to calculate this CAGR consists of three steps:
ending point (in our case $249 in cell B7) divided by starting point (in our case $100 in cell B2),
to the power 1 divided by n (in our case 12345, as we have a 5year growth plan),
and all of that minus 1 in order to convert to a percentage.

Philip de Vroe (The Finance Storyteller) aims to make accounting, finance and investing enjoyable and easier to understand. Learn the business and accounting vocabulary to join the conversation with your CEO at your company. Understand how financial statements work in order to make better investing decisions. Philip delivers #financetraining in various formats: YouTube videos, livestreams, classroom sessions, and webinars. Connect with me through Linked In!

Want to get access to bonus content, and/or express your gratitude by buying me a cup of tea? Join my channel as a member through    / @thefinancestoryteller