In: Finance
please use financial calculator!!!!
Step-1:Future value of investments on his 60th birthday | |||||
Future value | =fv(rate,nper,pmt,pv) | Where, | |||
$ 2,88,325.70 | rate | 6% | |||
nper | 30 | ||||
pmt | $ -3,400.00 | ||||
pv | $ -3,400.00 | ||||
Step-2:Future value of investment 65 years from now | |||||
Future value | =fv(rate,nper,pmt,pv) | Where, | |||
$ 3,85,844.83 | rate | 6% | |||
nper | 5 | ||||
pmt | $ - | ||||
pv | $ -2,88,325.70 | ||||
Step-3:Annual withdrawal from 65 to 80 years from now | |||||
Annual withdrawal | =pmt(rate,nper,pv,fv) | Where, | |||
$ 39,727.65 | rate | 6% | |||
nper | 15 | ||||
pv | $ -3,85,844.83 | ||||
fv | 0 |