Explaining the calculation of compound interest

CCOVICH

Registered User
Messages
8,826
Originally asked in this thread

Aileen2 said:
To get back to the mathematical calculation of compound interest. South/Gonk - What does to the power of actually mean, I don't have this button on my calculator - alternatively where do I find this symbol in excel. I can do compound interest the long hand way in excel. Also how do you change the 5% interest to 1.05 is it if it's 6% 1.06 and if it's 10% 1.10 meaning 10% plus the 1 = 1.10. Also didn't understand the 1/3 calculation, I'm assuming you dividing the total amount over 3 years to 1 year to get annual but for sure don't know how you do this.
 
3 to the power of 2 = 3 * 3 = 9

3 to the power of 3 = 3 * 3 * 3 =27

And so on...to calculate compound interest remember that 6% = 6/100 so 6% growth compounds as (after two years) 1.06 * 1.06 and so on...

In Excel you can use the ^ to calculate for example 1.06 ^ 4 (four years compounding).

Hope that helps!
 
Back
Top