Margot, 44, and Craig, 43, plan to retire when Margot reaches age 61 and Craig reaches...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Margot, 44, and Craig, 43, plan to retire when Margot reaches age 61 and Craig reaches age 60. They estimate that they will need $67,500/year after-tax in retirement. They would like to leave some room for contingencies and therefore would like to plan for about $72,500/year or $36,250 each after-tax. They currently have $98,700 saved in their RRSPs. Margot expects to receive a CPP benefit of $10,680/year. Craig expects to receive a CPP pension benefit of $9,600/year. Each of them will receive the maximum OAS benefit, starting at age 65. CPP and OAS are both indexed for inflation. Craig will also receive an indexed pension benefit of $39,780/year and a non-indexed pension benefit of $8,100/year. Their expected nominal rate of return before and during retirement is 10.00% and 7.00 %, respectively. The annual inflation rate is expected to be 3.00% during the entire planning period. Margot and Craig would like to plan for a retirement that will last for 35 years. Their average tax rate in retirement is 25%. When completing the calculations below, convert all annual amounts to monthly. Interest is compounded annually. Income is received at the beginning of the period. 1. Use a table and/or timeline to describe Craig and Margot's retirement cash flows. Be as descriptive as possible. 1. Use a table and/or timeline to describe Craig and Margot's retirement cash flows. Be as descriptive as possible. 2. Use a table to describe their nominal and real rates of return before and during retirement? REAL RATE BEFORE RETIREMENT DURING RETIREMENT NOMINAL RATE Retirement Income Planning 6. What is the present value at retirement of Craig's CPP before-tax? P/Y= N=tx P/Y- I/Y= PV = PMT- FV= 7. What is the present value at retirement of Margot's OAS before-tax? HINT: First calculate the present value at age 65 and then discount this amount back to age 61. P/Y= N=tx P/Y- I/Y= PV- PMT= C/Y= FV= C/Y= P/Y= N=tx P/Y= I/Y= PV- PMT= FV= 3 C/Y= 3. What is their before-tax income need? 4. What is the present value at retirement of their required retirement income before-tax? P/Y= N=tx P/Y- I/Y= PV = PMT- FV= N=tx P/Y- 5. What is the present value at retirement of Margot's CPP before-tax? P/Y= I/Y= PV- Retirement Income Planning PMT- C/Y= FV= C/Y= 2 Retirement Income Planning 8. What is the present value at retirement of Craig's OAS before-tax? HINT: First calculate the present value at age 65 and then discount this amount back to age 60. C/Y= P/Y= N=tx P/Y- I/Y= PV- PMT= FV= P/Y= N=tx P/Y- I/Y= PV = PMT= FV= 9. What is the present value at retirement of Craig's Indexed pension benefit before-tax? N=tx P/Y- I/Y= PV = PMT- C/Y= FV= P/Y= N=tx P/Y- C/Y= I/Y= 10. What is the present value at retirement of Craig's non-indexed pension benefit before-tax? P/Y= PV- PMT= FV= C/Y= 4 11. Taking into consideration their CPP, OAS, and pension plans, how much do Craig and Margot need to have saved, at retirement, from their RRSP savings? 12. Place the following RRSP savings plan on a timeline. NOTE: Savings are made at the end of the period. Lump sum amount of $98,700 today. Depositing $7,000 at the end of year 1. Retirement Income Planning 13. What is the future value at retirement of their RRSP savings? P/Y= C/Y= Depositing $24,000 from years 2 through 9. Depositing $23,000 at the end of year 10. Depositing $16,000 from years 11 through 17 N=tx P/Y- V/Y= PV = PMT- FV= Margot, 44, and Craig, 43, plan to retire when Margot reaches age 61 and Craig reaches age 60. They estimate that they will need $67,500/year after-tax in retirement. They would like to leave some room for contingencies and therefore would like to plan for about $72,500/year or $36,250 each after-tax. They currently have $98,700 saved in their RRSPs. Margot expects to receive a CPP benefit of $10,680/year. Craig expects to receive a CPP pension benefit of $9,600/year. Each of them will receive the maximum OAS benefit, starting at age 65. CPP and OAS are both indexed for inflation. Craig will also receive an indexed pension benefit of $39,780/year and a non-indexed pension benefit of $8,100/year. Their expected nominal rate of return before and during retirement is 10.00% and 7.00 %, respectively. The annual inflation rate is expected to be 3.00% during the entire planning period. Margot and Craig would like to plan for a retirement that will last for 35 years. Their average tax rate in retirement is 25%. When completing the calculations below, convert all annual amounts to monthly. Interest is compounded annually. Income is received at the beginning of the period. 1. Use a table and/or timeline to describe Craig and Margot's retirement cash flows. Be as descriptive as possible. 1. Use a table and/or timeline to describe Craig and Margot's retirement cash flows. Be as descriptive as possible. 2. Use a table to describe their nominal and real rates of return before and during retirement? REAL RATE BEFORE RETIREMENT DURING RETIREMENT NOMINAL RATE Retirement Income Planning 6. What is the present value at retirement of Craig's CPP before-tax? P/Y= N=tx P/Y- I/Y= PV = PMT- FV= 7. What is the present value at retirement of Margot's OAS before-tax? HINT: First calculate the present value at age 65 and then discount this amount back to age 61. P/Y= N=tx P/Y- I/Y= PV- PMT= C/Y= FV= C/Y= P/Y= N=tx P/Y= I/Y= PV- PMT= FV= 3 C/Y= 3. What is their before-tax income need? 4. What is the present value at retirement of their required retirement income before-tax? P/Y= N=tx P/Y- I/Y= PV = PMT- FV= N=tx P/Y- 5. What is the present value at retirement of Margot's CPP before-tax? P/Y= I/Y= PV- Retirement Income Planning PMT- C/Y= FV= C/Y= 2 Retirement Income Planning 8. What is the present value at retirement of Craig's OAS before-tax? HINT: First calculate the present value at age 65 and then discount this amount back to age 60. C/Y= P/Y= N=tx P/Y- I/Y= PV- PMT= FV= P/Y= N=tx P/Y- I/Y= PV = PMT= FV= 9. What is the present value at retirement of Craig's Indexed pension benefit before-tax? N=tx P/Y- I/Y= PV = PMT- C/Y= FV= P/Y= N=tx P/Y- C/Y= I/Y= 10. What is the present value at retirement of Craig's non-indexed pension benefit before-tax? P/Y= PV- PMT= FV= C/Y= 4 11. Taking into consideration their CPP, OAS, and pension plans, how much do Craig and Margot need to have saved, at retirement, from their RRSP savings? 12. Place the following RRSP savings plan on a timeline. NOTE: Savings are made at the end of the period. Lump sum amount of $98,700 today. Depositing $7,000 at the end of year 1. Retirement Income Planning 13. What is the future value at retirement of their RRSP savings? P/Y= C/Y= Depositing $24,000 from years 2 through 9. Depositing $23,000 at the end of year 10. Depositing $16,000 from years 11 through 17 N=tx P/Y- V/Y= PV = PMT- FV=
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Sam and Susan Scully have come to financial planner Lissa Cardenas to ask about the adequacy of their life insurance coverage. They have two children ages 4 and 2. They are each 35 years old. Sam...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The value of integral integration from - infinity to infinity dx/1+x^4
-
Arnold Industries has pretax accounting income of $33 million for the year ended December 31, 2018. The tax rate is 40%. The only difference between accounting income and taxable income relates to an...
-
Manuel Patron Inc. announced a bid to take over Vic Orbison Limited. Manuel Patron Inc. has 3 million shares outstanding, selling at $15 per share. Vic Orbison Limited has 2 million shares...
-
What are the various types of pulley used for flat belt?
-
What is the minimum cost of crashing the following project that James Walters manages at Ball State University by 4days? Normal Crash Time Time Normal Crash Immediate Activity (days) (days) Cost Cost...
-
Applying analytical synthesis of mechanisms, design a four-bar mechanism to move the object shown in the figure, through the three positions indicated in their numbered order without taking into...
-
Condensed balance sheet and income statement data for Bramble Corporation are presented here. BRAMBLE CORPORATION Balance Sheets December 31 2019 2018 2017 Cash $ 31,000 $ 21,000 $ 19,000 Accounts...
-
Why must buyers and sellers be price takers for a market to be perfectly competitive?
-
Classify the following nudges as either a potentially advantageous default nudge, an information or encouragement nudge, or not a nudge. a. A firm redesigns its health enrollment form so that...
-
What will be the effect of a technological development that reduces marginal costs in a competitive market on short-run price, quantity, and profit?
-
If a firm is owned by its workers but otherwise meets all the qualifications for a perfectly competitive firm, will its price and output decisions differ from the price and output decisions of a...
-
Under what cost condition is the shutdown point the same as the point at which a firm exits the market?
-
A ball with a mass of 1.50 kg is initially rolling due north across the floor with a speed of 7.00 m/s when it bumps into a table leg. The ball bounces off the table leg, moving at a speed of 4.00...
-
Using a graphing utility, graph y = cot -1 x.
-
Bob is working on two separate probability-related projects. The first involves a variable N, which is the number of consecutively manufactured parts that weigh in above the weight specification...
-
Ten attributes were rank-ordered in terms of increasing importance and were identified as A, B, C, . . . , and J. Determine the weight of (a) Attribute C (b) Attribute J.
-
An asset that was purchased 3 years ago for $100,000 is becoming obsolete faster than expected. The company thought the asset would last 5 years and that its book value would decrease by $20,000 each...
-
Someone who exposes the ethical misdeeds of others in an organization is usually called a/an _________. (a) whistleblower (b) ethics advocate (c) ombudsman (d) stakeholder
-
If a manager fails to enforce a late-to-work policy for all workersthat is, by allowing some favored employees to arrive late without penaltiesthis would be considered a violation of _________. (a)...
-
According to research on ethics in the workplace, _________ is/are often a major and frequent source of pressures that create ethical dilemmas for people in their jobs. (a) declining morals in...
Study smarter with the SolutionInn App