Compound interest in Excel

  Stubacka 14:46 14 Feb 2006

I'm sure this must be easy to do but I can't find how.

I need a formula to add compound interest to a sum and return a the new total e.g.

cell A3 contains 100

The result in (say) cell A6 needs to add compound interest at 6% for 5 years and give the total figure including the interest.

  seedie 15:13 14 Feb 2006


Personally I find financial functions a pain in the ass but the help section in Excel may of of some use: lookup "financial".

Good luck


  avesnes 15:25 14 Feb 2006

I think this may work:-
Put the starting amount in cell A1
Put the interest rate in cell A2 (in decimal form such as 5% is entered as 0.05)
Put the number of years in cell A3

Then type in cell A4:-


(Note the two brackets at the end)

  pc_sausage 15:27 14 Feb 2006

This has exactly what you want with screenshots:

click here

  Stubacka 15:55 14 Feb 2006

Thanks everyone.

All suggestions could have been adapted to meet my needs but the site pc_sausage gave me had the exact calculation that I needed even down to the percentages and period used in the example.

Thanks again

  Cesar 08:58 15 Feb 2006


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

Elsewhere on IDG sites

Sea of Thieves Review

Dell Canvas review: the cheap Wacom Cintiq alternative

How to use iMovie for Mac, tips and more

Comment filmer l’écran d’un iPhone ?