How to model and graph compound interest in Excel

Uses a recurrence relation; Shows how to add a line graph to compare interest rates. Target audience is Year 12 General Maths QLD, but would be helpful for those wishing to model compound interest in Microsoft Excel in any country!

[TheRoastedPeppers]

Great help for my engineering final, thank you.

[kwoffshore]

How do I work out compound interest over a number of years if the principal being injected into the (bank) account is changing every year? (as opposed to simply starting with a principal and then not adding any more after that?). Thanks

[francesrandolph]

Compound interest=P(1*i)^n why didn’t you raise to the power n??