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.

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 ?

1. - 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. - November 25, 2007

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

3. - November 25, 2007

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

4. - November 26, 2007

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

5. - 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. - 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. - 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 […]