Excel - Compound Interest

  Dirty Dick 12:10 24 Feb 2008

How do I get to calculate compound interest, I have a monthly deposit, with a variable interest, over a variable monthly time. I can see how to do simple interest, but can't fathom out compound interest.



  VoG II 12:11 24 Feb 2008

Try this click here

  Dirty Dick 12:55 24 Feb 2008

I have tried your suggestion but it states that it applies to
• Microsoft Excel 2000 Standard Edition
• Microsoft Excel 2002 Standard Edition
• Microsoft Excel 97 Standard Edition
• Microsoft Excel 95 Standard Edition
• Microsoft Excel 95a
and I forgot to mention I am running Excel 2007


  Zak 13:51 24 Feb 2008

Does it work in Excel 2007? I think it should.

Also try FVSchedule function:

click here

  Dirty Dick 18:18 25 Feb 2008

I've tried your suggestion again. I have put in Cell A1 the title "Present Value , and in A2 inputted the figure £350. In Cell B1 the title "Interest Rate", and in B2 5.05 (manually inputted. In Cell C1 ihave the title "Time", and in C2 I have manually inputted the figure 1. In D4 I have put the formula =A2*(1+B2)^C2. The figure given in that cell is 2117.50

That is only calculating for 1 period, whether it is a month or a year.

The figure, done on my calculator is £367.67p

Where am I going wrong.


  VoG II 18:22 25 Feb 2008

In B2 you need 5.05% or 0.0505 - this will then give the correct result.

  Dirty Dick 18:28 25 Feb 2008

Thanx, so esay to miss that.


This particular formula only calculates for the amoount that is in NOW.

How can I adjust the calculations if I put in £350 every period for say a period of 31, with the same interest rate, but compounding the interest so that the amount of interest is added every time period

Thanx again

  VoG II 18:54 25 Feb 2008

I don't know - suggest you post on click here

  csqwared 19:11 25 Feb 2008

Does this help (pinched from click here

Compound Interest: The future value (FV) of an investment of present value (PV) dollars earning interest at an annual rate of r compounded m times per year for a period of t years is:

FV = PV(1 + r/m)mt

FV = PV(1 + i)n

where i = r/m is the interest per compounding period and n = mt is the number of compounding periods.

One may solve for the present value PV to obtain:

PV = FV/(1 + r/m)mt

Numerical Example: For 4-year investment of $20,000 earning 8.5% per year, with interest re-invested each month, the future value is

FV = PV(1 + r/m)mt = 20,000(1 + 0.085/12)(12)(4) = $28,065.30

Notice that the interest earned is $28,065.30 - $20,000 = $8,065.30 -- considerably more than the corresponding simple interest.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?