In: Finance
If Paige has accumulated $6200 by saving $80 every month for six years, what nominal annual rate of interest compounded semi-annually has been earned?
The nominal annual rate of interest is _____%compounded semi-annually
0.4104%
| Step-1:Calculation of effective annual interest on monthly saving | ||||||||||
| Effective annual interest | = | ((1+(i/n))^n)-1 | Where, | |||||||
| = | ((1+(0.004100/12))^12)-1 | i | = | 0.4100% | ||||||
| = | 0.4108% | n | = | 12 | ||||||
| Working: | ||||||||||
| Nominal annual rate of interest | =rate(nper,pmt,pv,fv)*2 | |||||||||
| = 0.4100% | ||||||||||
| Where, | ||||||||||
| nper | = | Number of period | = | 6*12 | = | 72 | ||||
| pmt | = | Periodic cash flow | = | $ -80.00 | ||||||
| pv | = | Initial cash flow | = | 0 | ||||||
| fv | = | Future cash flow | = | $ 6,200.00 | ||||||
| Step-2:Calculation of nominal interest rate with semi annual compounding | ||||||||||
| Effective annual rate | = | ((1+(I/n))^n)-1 | Where, | |||||||
| 0.004108 | = | ((1+(i/2))^2)-1 | i | = | Nominal annual rate | |||||
| 1.004108 | = | (1+(i/2))^2 | n | = | Number of times compounding | |||||
| 1.004108 | ^(1/2) | = | 1+(i/2) | |||||||
| 1.002052 | = | 1+(i/2) | ||||||||
| 0.002052 | = | i/2 | ||||||||
| 0.004104 | = | i | ||||||||
| So, | ||||||||||
| Nominal annual rate with semi annual compounding | = | 0.4104% | ||||||||
| Note: | ||||||||||
| Effective annual interest rate must be same for both monthly and semi annually compounding. | ||||||||||