Compound interest in Excel

  Stubacka 14:46 14 Feb 06

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 06


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 06

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 06

This has exactly what you want with screenshots:

click here

  Stubacka 15:55 14 Feb 06

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 06


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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…