Answered step by step
Verified Expert Solution
Question
1 Approved Answer
STARTING YOUR RETIREMENT PLAN AT 5 0 Alan is 5 0 , Joanne is 5 1 . They have a large house worth $ 8
STARTING YOUR RETIREMENT PLAN AT Alan is Joanne is They have a large house worth $ in Toronto and a cottage worth $ in Muskoka. Mortgage payments on these properties are $ pa and they will be paid off in years. They have no other debts, although they just finished paying off a car loan. They each own a recent model car, and they replace their cars every three or four years because they do not want to be seen driving older models. Alan's net income or takehome income was $ last year, after taxes, CPP EI premiums, medical insurance, etc. Joanne takes home $ pa after the same set of deductions and contributions to her employer pension plan. They have two children whom they are currently helping through school, at a cost of $ pa This cost will continue for another five years, after which the children are on their own. They are both carrying substantial life insurance and disability insurance, all of the cost of which is deducted from their gross pay in arriving at the net income reported above. They have $ in a chequing account and a substantial line of credit at the bank if they need it Alan has $ in an oil and gas mutual fund. He has no pension plan. Joanne has $ invested in GICs in an RRSP She expects an indexed pension plan of $in today's dollars if she retires at age They would each qualify for only of maximum Canada Pension, and that would be further reduced if they start receiving it before age Alan has been earning gross income over $ pa for five years, and he expects the $ net income of last year to be sustainable until he reFtires. He started saving money only in the last two years. Last year he deposited $ in the mutual fund this amount is included in the $ balance Joanne has been contributing $$ pa to her RRSP for years. They would like to retire in years. Advise them in their retirement planning.
The marking guidelines are as follows:
Retirement Goals: How much money do they need? marks
Calculate required income Starting point not given, estimate it from present income and expenditures
What level of retirement income is appropriate?
How long do they need the income? Based on Alans life expectancy of and Joanne
How much have they got? marks
Determine OAS full amount each at
Determine CPP assume they qualify for
Determine Joannes pension
Outline any assumptions income splitting, investment portfolio, RRSPs TFSA's
How much additional saving is required over the next years? marks
Assuming that they save $ for
You are expected to undertake calculations to provide to this couple an amount if any of additional savings over the next years prior to retirement needed to support in inflationadjusted dollars their disposable income at a level equivalent to what they are currently experiencing.
These calculations will be undertaken on an EXCEL spreadsheet. The exercise will be based on:
Calculating the net present value at the beginning of their retirement period of net aftertax revenue and income during their retirement
The second calculation will be to compare this to the future value of all their accumulated savings available at the beginning of their retirement period.
In the event that the future value of the savings is not sufficient to support the present value of their net retirement expenditures, you will calculate what additional annual savings needed over the next years to balance these two calculations
In the event that the future value of the savings exceeds the present value of their net expenditures, you will calculate the reduction in annual savings that they would be able to afford over the next years to balance these two calculations
Assume in your analysis that the annual inflation rate over the entire pre and post retirement period is and that investments they have or will make will yield a return.
CPP and OAS revenue, when received at age will be in inflated dollars with the clawback if any based on their retirement income at that time.
Be sure in the EXCEL spreadsheets that you submit that all links are included so I can follow how you carried out your calculations.
Please provide an excel sheet with your answer to better assist me thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started