Suppose you are a financial planner at Tangerine Bank, A client of yours has recently become a parent. The family wants to open up an RESP account for their child to save for her university expenses, They plan to send their daughter to study Bachelor of Commerce at UOIT, at the age of 18. (solve using excel formulas)

1. How much should they save before her school starts

2. For that, how much should the parents save in the account each month to fund their childs university expenses, They are very risk averse and would like to save in a GIC-type account (use the long term interest rates as their average investment rate)

3.How much of the saving is the parents contribution, the Governments contribution, and the Investment Income.

4. If the rates changes, say +/- 1%, how much their monthly payments should change? Hint: FV of payments up until year 17 so that from years 18-21 they can pay $8000/year for tuition

RESP INFO:

A Registered Education Savings Plan (RESP) is a government-registered plan that helps you save for a childs post-secondary education.

The money that you invest in an RESP grows tax-deferred, and the federal government helps contribute to your savings along the way in the form of education grants.

Tax is applied to the investment income and government grants received when withdrawn from the RESP, not on the contributions you made using your own funds. These amounts are taxed in the hands of the student, and this usually means little or no tax will be paid, because students typically fall into the lowest tax bracket.

The Canada Education Savings Grant (CESG) matches 20% of annual contributions, up to $500 per year

The matching contributions can continue until the lifetime limit of $7,200 per child has been reached