Using Excel to Calculate Compound Interest
Using Excel to Calculate Compound Interest
1. Assume you put £100 into a bank. How much will your investment be worth after one year at an annual interest rate of 8%? The answer is £108.
[pic]
2. Now this interest (£8) will also earn interest (compound interest) next year. How much will your investment be worth after two years at an annual interest rate of 8%? The answer is £116.64.
[pic]
3. How much will your investment be worth after 5 years? Simply drag the formula down to cell A6.
[pic]
The answer is £146.93.
4. All we did was multiplying 100 by 1.08, 5 times. So we can also directly calculate the value of the investment after 5 years.
[pic]
which is the same as:
[pic]
Note: there is no special function for compound interest in Excel. However, you can easily create a compound interest calculator to compare different rates and different durations.
5. Assume you put £10,000 into a bank. How much will your investment be worth after 10 years at an annual interest rate of 5% compounded monthly? The answer is £16,470.
[pic]
6. Assume you put £10,000 into a bank. How much will your investment be worth after 15 years at an annual interest rate of 4% compounded quarterly? The answer is £18,167.
[pic]
-----------------------
Although Microsoft Excel does not include a function for determining compound interest, you can use the following formula for this calculation
=PV*(1+R)^N
where PV is present value, R is the interest rate, and N is the number of investment periods.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- how to calculate compound growth rate excel
- how to calculate compound interest in excel
- how to do compound interest excel
- how to calculate compound interest
- calculate compound interest calculator
- how to calculate compound interest formula
- how to use compound interest formula
- calculate compound interest in excel
- how to calculate compound annual growth rate
- calculate compound interest on calculator
- calculate compound interest with deposits
- how to figure compound interest annually