Excel - Compound Growth: Episode 1330
1,163 views · Published 26 January 2011 · 2:33 · Indexed 8 November 2026
Channel: MrExcel.com · 2011 · Education
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920