In: Finance
Let us assume that that the amount of $150000 is required at the beginning of each year
So, requirement is $150000 at age 65 (day of retirement) every year for 25 years and then $1000000 at the end of 25 years
Balance required in the account at retirement
=150000+150000/1.06+....+150000/1.06^24+1000000/1.06^25
=150000/0.06*(1-1/1.06^25)*1.06+1000000/1.06^25
=$ 2,265,552.26
If first amount of saving (A) is deposited in account today (at age 25) and last installment one year before the retirement, there will be a total of 40 installments
A/0.06*(1.06^40-1)*1.06 = 2265552.26
=> 164.04768*A = 2265552.26
=> A = 13810.33
So, $13810.33 is required every year starting today for 40 years
If first amount of saving (A) is deposited in account at age 40 and last installment one year before the retirement, there will be a total of 25 installments
A/0.06*(1.06^25-1)*1.06 = 2265552.26
=> 58.15638*A = 2265552.26
=> A = 38956.21
So, $38956.21 is required every year starting for 25 years starting age 40
Let X be the amount required each year (including employer's contribution)
30000*1.06^35+X/0.06*(1-1/1.06^40)*1.06 = 2265552.26
=> 164.04768*X = 2034969.66
=> X = 12404.74
So, amount required to be put into account each year = 12404.74/2 = $6202.37
So, $6202.37 is required every year starting today for 40 years