![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Financial > Financial Terminology | < Previous | Next > |
Simple Interest |
If £50 is invested for 3 years at an annual interest rate of 5% what is the total amount after 3 years. | ||
The total amount after 3 years will be £57.50. |
![]() |
The total amount accumulated using simple interest can be calculated with the following equation: |
![]() |
This is an example of an arithmetic progression where a series of numbers differs by a fixed amount. |
Compound Interest |
If £50 is invested for 3 years at an annual compounded interest rate of 5% what is the total amount after 3 years. | ||
The total amount after 3 years will be £57.88. |
![]() |
The total amount accumulated using compounded interest can be calculated with the following equation: |
![]() |
This is an example of a geometric progression where a series of numbers is multipled by a fixed amount (or common ratio). | ||
This is an example of discrete compounded interest. |
Present Value |
In the above example the original investment is often referred to as the Present Value. | ||
If a bank offers a componded interest rate of 5% how much money do I need to invest in order to have $50 after 3 years. | ||
The amount you need to invest at the beginning of the 3 years is £43.19. |
![]() |
The present value can be calculated with the following equation: |
![]() |
Things to Remember |
There are actually two types of componded interest there is discretely compounded and continuously compounded. | |||
Continously compounded interest is used in quantitative finance. |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | < Previous | Top | Next > |