The marking guidelines are as follows: Retirement Goals: Ho

The marking guidelines are as follows: Retirement Goals: How much… Image transcription text1. STARTING YOUR RETIREMENTPLAN AT 50 Alan is 50, Joanne is 51.They have a large house … Show more… Show moreImage transcription textPension, and that would be furtherreduced if they start receiving it beforeage 65. Alan has been ea… Show more… Show moreThe marking guidelines are as follows:Retirement Goals: How much money do they need? (3 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 Alan’s life expectancy of 91 and Joanne 96)How much have they got? (3 marks)Determine OAS full amount each at 67Determine CPP, assume they qualify for 80%Determine Joanne’s pensionOutline any assumptions (income splitting, investment portfolio, RRSP’s, TFSA’s)How much additional saving is required over the next 10 years? (4 marks)Assuming that they save $17,000 for 10 years in RRSP’s (Alan $15k, Joanna $2k)How does this affect their taxes?Calculate Alan’s marginal tax rateCalculate Joanne’s marginal tax rateDetermine tax credits (federal and provincial)Recommendations (3 marks)Feasibility, Reasonability, Pros and Cons & WhyOverall written report (2 marks)Introduction, data collection, Recommendations, Appearance (use of charts/tables) and ClarityTOTAL GRADE = 15 MarksCase Study RequirementYou are expected to undertake calculations to provide to this couple an amount (if any) of additional savings over the next 10 years prior to retirement needed to support (in inflation-adjusted dollars) their disposable income at a level equivalent to 80% 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 after-tax revenue and income during their retirementThe 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 10 years to balance these two calculationsIn 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 10 years to balance these two calculationsImportant ConsiderationsAssume in your analysis that the annual inflation rate over the entire pre and post retirement period is 2% and that investments they have or will make will yield a 4% return.CPP and OAS revenue, when received at age 65, will be in inflated dollars with the claw-back (if any) based on their retirement income at that time.Be sure in the EXCEL spreadsheet(s) that you submit that all links are included so I can follow how you carried out your calculations. PLEASE ANSWER numbers 2-4answer for 1 is already done and provided below1. Retirement Goals: How much money do they need? (3 marks) $670,620.80a. Calculate required income (Starting point not given, estimate it from present income and expenditures)$105,000 b. What level of retirement income is appropriate?$ 140,700c. How long do they need the income? (Based on Alan’s life expectancy of 91 and Joanne 96)It is assumed that retirement income would last for 15 years  Thank You Very muchBusiness Finance BADM 4070

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades