Compounding Interest Formulas for Varying Annual Deposits and Interest Rates

[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.

 

[CRGreathouse]

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?

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.

 

[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?

 

[CRGreathouse]

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?

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