You deposited $160,000 into an education savings plan, hoping to have $420,000 available 12 years later

You deposited $160,000 into an education savings plan, hoping to have $420,000 available 12 years later
You deposited $160,000 into an education savings plan, hoping to have $420,000 available 12 years later when your first child starts university. However, you did not invest very well, and two years later, the account’s balance has dropped to $140,000. Let us look at what you need to do to get the savings plan back on track.
a. What was the original annual rate of return needed to reach your goal when you started the fund two years ago?
b. With only $140,000 in the fund and 10 years remaining until your first child starts university, what annual rate of return would the fund have to make for you to reach your $420,000 goal if you add nothing to the account?
c. Shocked by your experience of the past two years, you feel the education savings fund has invested too much in shares, and you want a low-risk fund in order to ensure you have the necessary $420,000 in 10 years. You are willing to make end-of-the-month deposits to the fund as well. You find you can get a fund that promises to pay a guaranteed annual return of 6% that is compounded monthly. You decide to transfer the $140,000 to this new fund and make the necessary monthly deposits. How large a monthly deposit must you make into this new fund each month to obtain the $420,000 required at the end of 10 years? (6 marks)
d. After seeing how large the monthly deposit would be (in part (c) of this question), you decide to invest the $140,000 today and $500 at the end of each month for the next 10 years into a fund comprising 50% shares and 50% bonds and hope for the best. What Annual Percentage Rate (APR) would the fund have to earn in order to reach your $420,000 goal?