Question 4 Organising multiple Cash Flows(50 marks)

Meredith and Colin have just welcomed baby Eddie into the world and like all good Canadian parents, they immediately sat down at the kitchen table while he naps to plan out his and their financial future.They will do the saving inside TFSAs and RRSPs which allows them to ignore income taxes for this plan.They disagree on whether Eddie will be a lawyer (following his father) or a financial planner (following his mother), but they agree he will go to university or they will return him for a refund.In addition, they hope to have enough saved to help him buy his first house, and also for the three of them to take a trip around the world when he graduates.Leave all cash flows at year end unless otherwise stated.Their take home pay (two of them together) is $120,000 and they don't expect increases more than the rate of inflation in the future because of the effects of the pandemic.The inflation rate is 2%.Meredith is a skilled investor and expects to earn 6% on their investments.You will do this problem in real dollars and future amounts are expressed in real dollars.Here are the details of the savings and dates of the big expenditures they are saving for:

Allow five years of university education starting in 18 years (but first payment at end of the year to use ordinary annuities): $20,000 p.a.

Round the world trip in 23 years paid in advance at year 23: $50,000

Help him with a house in 32 years: $100,000

Saving: 5% of take home pay into TFSAs; 12% of take home pay into RRSPs.For 30 years, when they plan to retire.

The money in the TFSAs is used for Eddie's education, the world trip and the help buying a house.Anything left over they keep saving and accumulating for their retirement in addition to the RRSP money.

Required:

a)Will they have enough money in the TFSAs for his education, his trip and to give him $100,000 for a house, at the times planned?Show the calculations.

b)How much will they have at retirement in real dollars.Show calculations.

Please answer in details. Thank you!

(Course: York University - ADMS 3541 - Personal Financial Planning)