Reader Question: How Do You Calculate Compound Growth (or Interest)?

November 19, 2007

Frank left the following comment in my Turning $1,000 Into $1,000,000 Post:

Great information! Can you publish your formula for these tables? I would love to know what’s going to happen if I put $2000– or $5000 per year into my retirement fund.

Certainly, Frank!

I simply used the RATE function in Excel, which is found in the functions menu under the Insert tab. The formula will require you to input some information but it’s fairly easy to use.

You can see an illustration of formula by downloading the Turning $1,000 Into $1,000,000 spreadsheet (Download) that I put together when writing the post. Once you have downloaded the spreadsheet, save it and then open it in Excel. Once you have it open in Excel, simply click on one of the cells in the Required ROR column and then click on “Insert Function” under the Insert menu on main menu in Excel. As soon as you do that, a function box should open that looks like this:

NOTE: Should you get an error message in the cell after you use the formula, it might be necessary to add a “guess” for Excel to use in making the calculation. For some reason the formula dialogue box does not contain an area for a guess. However, you can add in the formula bar like this:

The number “20” in the formula represents my guess of 20%. NOTE: Although my example doesn’t show it, be sure and close out the formula with paranthesis.

I hope this was straight-forward and easy to understand. If you have any questions, either leave a comment or shoot me an email.

12 responses to Reader Question: How Do You Calculate Compound Growth (or Interest)?

  1. From the look of the dialog box I suspect you need to use the scroll bar (that’s poorly placed) to get to ‘guess’.

  2. Fox Cutter,

    I didn’t even see that! Thanks for mentioning that.

  3. If anybody wants a method that will work on a simple calculator, try this:

    Calculate how much money it would take for the growth alone to equal your annual contribution. For instance, if you want to add $2000 per year, and assume 12% growth, 2000/0.12 = 16666.66.

    Now use the simple compounding interest formula to calculate the growth for however long you want. For instance, after 20 years you will have 16666.66 * 1.12^20 = 160771.48.

    Finally, subtract out the original seed money to get the actual amount you will have. To conclude the example, 160771.48 – 16666.66 = 144104.82.

  4. I have a question that I’m having trouble getting the answer correct…I’m trying to see the formula as to how they came up with the answer to the following question.

    If you save $10 per week in a savings account that pays 6% interest compounded yearly how much money would be in your account in 3 years. The answer supposedly is $1703..

  5. I have a math problem that I am having a problem with” Grow $100 monthly deposits for 30 yrs @12% compounded continuously. I need to run this on a excel spreadsheet. Which I can do using a Marco but what is the formula to run this ?

Trackbacks and Pingbacks:

  1. Free Money Finance - November 23, 2007

    Star Money Articles for the Week of November 19

    Here are some recent interesting posts from the MoneyBlogNetwork and beyond: AllFinancialMatters tells how to calculate compound growth. MightyBargainHunter covers flexible spending accounts. Five Cent Nickel hates Dish Network. Blueprint for Financial…

  2. » Weekly Roundup - Thanksgiving Turkey Chili Edition @ fivecentnickel.com - November 25, 2007

    […] JLP talked about how to calculate compound growth. […]

  3. Back In The Saddle - Plus A Stroll Through My Blogroll - November 25, 2007

    […] JLP talked about calculating compound growth. […]

  4. Roundup for week of 18 November 2007: Furnace fire edition at Mighty Bargain Hunter - November 26, 2007

    […] All Financial Matters explains to a reader how to calculate compound interest. […]

  5. » Weekly Blog Roundup II, Market Crash Edition on Consumerism Commentary: A Personal Finance Blog - November 26, 2007

    […] How Do You Calculate Compound Growth (or Interest)? AllFinancialMatters loves tackling these mathematical questions. Here he answers with an Excel function and the underlying formulas. […]

  6. money news blog » Weekly Blog Roundup II, Market Crash Edition - December 6, 2007

    […] How Do You Calculate Compound Growth (or Interest)? AllFinancialMatters loves tackling these mathematical questions. Here he answers with an Excel function and the underlying formulas. […]

  7. calculate compound interest in excel - August 31, 2008

    […] tackling these mathematical questions. Here he answers with an excel function and the underlying …http://allfinancialmatters.com/2007/11/19/reader-question-how-do-you-calculate-compound-growth-or-in…Read “free download MP3” at Salt the Wound Forum…interest mortgage prime rate calculator compound […]