Excel - Compound Growth: Episode 1330

1,163 views · Published 26 January 2011 · 2:33 · Indexed 8 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Calculating Compound Growth in Excel | Excel Tips and Tricks.

Welcome to another episode of the MrExcel podcast. In today's episode, we will be discussing compound growth and how to calculate it in Excel. This topic was suggested by Jack, who is working on a project that requires him to calculate compounded growth over a number of years. 

To start off, we will use a series of formulas to calculate the growth over a certain number of years. However, this can become tedious and time-consuming if we have to do it for a large number of years. That's where a simple formula comes in handy. By using the original amount and multiplying it by 1.05 raised to the power of the number of years, we can get the same result without having to add multiple cells. 

But what if we want to work backwards and determine the initial amount needed to reach a certain goal in the future? For example, if we want to retire with $250,000 in 30 years, we can use the same formula but this time, divide the desired amount by 1.04 raised to the power of the number of years. This will give us the initial amount needed to reach our goal. 

I hope this episode has helped you understand compound growth and how to calculate it efficiently in Excel. Thank you to Jack for suggesting this topic and thank you for tuning in. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time for another episode of the MrExcel podcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Compound Growth 
(00:21) Explanation of Compound Growth 
(00:31) Using a Simple Formula 
(01:02) Multiplying Original Amount by (01:19) 05  Explanation of Exponents 
(01:34) Working Backwards with Compound Growth 
(02:09) Example Calculation 
(02:23) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Compound growth
Compounded growth formula
Episode 1330
Excel formula
Excel tips
Exponential growth
Financial calculations
Investment returns
Retirement planning


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153010/


Jack asks how to calculate compound growth for a year that is 10 years in the future. Rather than using a table to calculate the growth for each year, Bill uses the Exponent Calculation to provide the result in one step!

More from this channel