In: Finance
1. You are saving for retirement. You have decided that one year from today you will begin investing 10 percent of your annual salary in a mutual fund which is expected to earn a return of 12 percent per year (compounded semi-annually). Your present salary is $30,000, and you expect that it will grow by 4 percent per year throughout your career (consequently, your investment at time 1 will be $3,000, your investment at time 2 will be $3,120, etc.). You will retire 40 years from today.
a) How much money will you have in your investment account at retirement (assume you make your last investment deposit 40 years from now on the day you retire)?
b) At retirement, you shift your investment portfolio balance into a money market account earning 6% per year, compounded monthly. You would like to make an equal monthly withdrawal from this money market account over the next 20 years (first withdrawal beginning one month into retirement at time 40 + one month). What equal, monthly amount can you withdraw from the account so that at time 60 (20 years into retirement) your money market account balance is reduced to $0?
a) Total balance in investment account on day of retirement = $3,624,221.51 (Solution provided as excel images below - Closing balance in year 40)
b) Equal monthly instalment for 20 years = $25,965.05 (Solution below)