Compounding interst formulas

1. Aug 22, 2007

Eph

I think I found a simple formula if I was putting in the same amount of money each year, but what if I wanted to start with 1000$, add 10k$ for 10 years, and then watch it compound at X interest; how would i set that up?

And if you know, can you put this formula into Excell.

2. Aug 23, 2007

CRGreathouse

It's very easy to do with Excel -- just have the first cell with the starting amount, then for each cell below it have the interest formula beneath, referring to the cell above as principle, and add in the amount you deposit each year.

3. Aug 23, 2007

Eph

What about if you want to just put in a deposit of say 10k per annum for 10 years but have it still compound at the same yearly rate?

4. Aug 23, 2007

CRGreathouse

Yep, just like I said. Follow the instructions above.