5. An investor saves for retirement $500 per month for next 35 years. The money is invested in a stock/ bond portfolio and is expected to earn an average 10% per year. When he retires, he believes he will live 30 years and he will invest his retirement fund in a conservative bond fund that will earn 4.0% per year. a. Calculate the investor's planned equal monthly withdrawals in his retirement years. b. The investor's spouse suggests a more aggressive investment portfolio of stocks only. Such an investment has an expected annual return of 10.6%. Recalculate the potential monthly withdrawals in his retirement years. 6. Evaluate the monthly payments on a 20 years mortgage of $1,000,000 and 4.80% annual rate. How much does the borrower owe after 10 years (try without Excel)