Compunding Interest

  • Thread starter Thread starter Ed O'Brien
  • Start date Start date
E

Ed O'Brien

I have had to give up trying to do this myself.

I have a total of £2000 in cell 2A.
The monthly net interest is 0.02% in cell 2B
The number of periods is 12 in cell 2C
I want the total compound interest over the 12 periods to appear in cell 2D

Can anyone show me what formula achieves this?

TIA

Ed
 
Ed said:
I have a total of £2000 in cell 2A.
The monthly net interest is 0.02% in cell 2B
The number of periods is 12 in cell 2C
I want the total compound interest over the 12 periods to appear in cell 2D
Click to expand...

=FV(B2, C2,, -A2) - A2
 
Back
Top