Assume you invest 200 per month in your 401 K account in lar
Assume you invest $200 per month in your 401 K account in large stocks, given your age (32 years & 1 month), how much you will accumulate at age 67?
Solution
Using present value function in MS excel
FV(rate,nper,pmt,pv,type) = rate =12.1% /12 = 1.008% nper = (35*12)-1 =419 PMT = 200 PV = 0 type =0
FV(1.008%,419,-200,0,0)
$1,306,446.99
Amount in 401 K account at 67 age
$1,306,446.99
rate is missing which I have taken 12.1% which is given in similar question on net
| Using present value function in MS excel | FV(rate,nper,pmt,pv,type) = rate =12.1% /12 = 1.008% nper = (35*12)-1 =419 PMT = 200 PV = 0 type =0 | FV(1.008%,419,-200,0,0) | $1,306,446.99 |
| Amount in 401 K account at 67 age | $1,306,446.99 | ||
| rate is missing which I have taken 12.1% which is given in similar question on net |
