Compunding Interest

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
 
J

joeu2004

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
 
Top