1. Retirement Assets Required? (Provide 3 scenarios (50% lowest amount, 75% middle amount, and 100% best case scenario amount). Calculate all three scenarios on an excel spreadsheet.

2. Based on your responses to question 1, How much savings will the Magees require if Inflations is considered? Calculate all three scenarios on an excel spreadsheet.

3. How much savings will the Magees require if they retire at age 60, 65, 70? (Based on your responses in questions #2) i) Calculate all three scenarios on an excel spreadsheet. ii) Which of the three scenarios is most realistic for the Magees to achieve and why? Give full details

4. What are some points that should be made to the Magees when presenting the above figures? 1. 2. 3. 4. 5. 6. 7. 8.

5. Calculate the following for both Joseph and Grace: (use excel spread sheet) i. Company Pension benefits for both Joseph and Grace, for the current year? ii. Calculate the Pension Adjustment for both Joseph and Grace, for the current year. iii. Calculate the Future Value of their Company Pension Plans at retirement. iv. Calculate their RRSP contribution room, for the current year. v. Calculate the future value of their RRSP at retirement. vi. Calculate the future RRSP of their non-registered savings at retirement.

6. Based on the value of their Pensions, RRSP savings and non-registered savings, at what age will the Magees be able to retire? Give full detail, outlining the numbers, only using your calculator. Provide answers on excel spreadsheet.

7. What additional savings if any will the Magees require, to retire comfortably? Show calculations using excel spreadsheet.

8. What other sources of income may be available to the Magees at retirement? Explain each, including the tax implications

9. What steps can you take to help ensure that the Magees reach their retirement goals? 1

0. What actions could you take to standout to the Magees?