In: Finance
financial calculator
Henry calculated that if he saved $500 per month for retirement for 20 years and could earn on average a 7.5% return he would have approximately $276,865 at retirement. What would he have if he could earn 8% ?
a. $276,865
b. More than $276,865
c. Less than $276,865
d. It cannot be determined
please explain
| Rate | Rate of interest (Nominal Rate /12) | 0.62% | 
| Period | Nos of deposits to be made (20*12) | 240 | 
| PMT | Amount deposit every month | 500 | 
| PV | Present Value | |
| Type | Deposits made at beginning of the month | 1 | 
| Future Value | ($277,002.61) | |
| Rate of interest | 7.50% | |
| Assuming interest is Quarterly compounding | ||
| Effective rate is = EFFECT(7.50%,4) | 7.714% | |
| Converting Effective rate into monthly compounding | ||
| Nominal rate is = NOMINAL(7.71%,12) | 7.454% | 
| Rate | Rate of interest (Nominal Rate /12) | 0.66% | 
| Period | Nos of deposits to be made (20*12) | 240 | 
| PMT | Amount deposit every month | 500 | 
| PV | Present Value | |
| Type | Deposits made at beginning of the month | 1 | 
| Future Value | ($294,524.85) | |
| Rate of interest | 8.00% | |
| Assuming interest is Quarterly compounding | ||
| Effective rate is = EFFECT(7.50%,4) | 8.243% | |
| Converting Effective rate into monthly compounding | ||
| Nominal rate is = NOMINAL(7.71%,12) | 7.947% | 
So Answer is b, i.e. more than $276865.