Question

In: Finance

Case 1 The Johnsons Consider Retirement Planning Harry Johnson’s father, William, was recently forced into early...

Case 1

The Johnsons Consider Retirement Planning

Harry Johnson’s father, William, was recently forced into early retirement at age 63 because of poor health. In addition to the psychological drawbacks of the unan- ticipated retirement, William’s financial situation is poor because he had not planned adequately for retirement. His situation has inspired Harry and Belinda to take a look at their own retirement planning. Together they now make about $100,000 per year and would like to have a similar level of living when they retire. Harry and Belinda are both 27 years old and recently received their annual Social Security Benefits Statements indicating that they could expect about $28,000 per year in today’s dollars as retirement benefits at age 67. Although their retirement is a long way off, they know that the sooner they put a plan in place, the larger their retirement nest egg will be.

(a) Belinda believes that the couple could maintain their current level of living if their retirement income represented 75 percent of their current annual income after adjusting for inflation. Assuming a 4 percent inflation rate, what would Harry and Belinda’s annual income need to be over and above their Social Security benefits when they retire at age 67?

(b) Both Harry and Belinda are covered by defined- contribution retirement plans at work. Harry’s employer will contribute $1170 per year, and Belinda’s employer will contribute $1140 per year in addition to the $4620 total that Harry and Belinda can contribute. Assuming a 7 percent rate of return, what would their retirement nest egg total 40 years from now?

(c) For how many years would the retirement nest egg provide the amount of income indicated in Question (a)? Assume a 4 percent return after taxes and inflation.

Solutions

Expert Solution

a) Annual requirement after retirement = $100,000*0.75
= $75,000
Amount Available from social security = $28,000
(in present $ terms)
Additional amount before inflation = $75000-$28000
= $47,000
Amount after inflation over security benefits = $47000*(1.04)^40
= $47000*4.8010
= 225647.9695
b) Total amount = $1170+$1140+$4620
= $6,930
future value at retirement = $6930*FVAF(7%,40 years)
= $6930*199.64
= $1,383,471.33
c) To find out these we create the following table
amount withdrwan
year opening bal interest@4% Closing bal
1 $1,383,471.33 $55,338.85 225647 $1,213,163.18
2 $1,213,163.18 $48,526.53 225647 $1,036,042.71
3 $1,036,042.71 $41,441.71 225647 $851,837.41
4 $851,837.41 $34,073.50 225647 $660,263.91
5 $660,263.91 $26,410.56 225647 $461,027.47
6 $461,027.47 $18,441.10 225647 $253,821.57
7 $253,821.57 $10,152.86 225647 $38,327.43
8 $38,327.43 $1,533.10 225647 ($185,786.47)
since amount becomes -ve in year 8,they can withdraw only upto 7 years
The saving has been exhausted in just 7 years because they aimed to withdraw $225647 but invested very little amount ($6930) comparetively

Related Solutions

Mini case #1 - Retirement Planning This assignment is to be completed in Excel. When completed,...
Mini case #1 - Retirement Planning This assignment is to be completed in Excel. When completed, submit the exercise by the due date in Blackboard (BB) and Attach a copy of the excel spreadsheet. Case Narrative: Ann E. Belle is age 45 and plans to retire in 20 years (at age 65). She has retirement savings in a mutual fund account, which has a current balance of $150,000 (Ann does not plan to add any additional money to this account)....
Mini case #1 - Retirement Planning This assignment is to be completed in Excel. When completed,...
Mini case #1 - Retirement Planning This assignment is to be completed in Excel. When completed, submit the exercise by the due date in Blackboard (BB) and Attach a copy of the excel spreadsheet. Case Narrative: Ann E. Belle is age 45 and plans to retire in 20 years (at age 65). She has retirement savings in a mutual fund account, which has a current balance of $150,000 (Ann does not plan to add any additional money to this account)....
You are planning for a very early retirement. You would like to retire at age 40...
You are planning for a very early retirement. You would like to retire at age 40 and have enough money saved to be able to draw $ 210 comma 000$210,000 per year for the next 4040 years​ (based on family​ history, you think​ you'll live to age 8080​). You plan to save for retirement by making 2020 equal annual installments​ (from age 2020 to age​ 40) into a fairly risky investment fund that you expect will earn 1010​% per year....
6. Retirement Planning for Jennifer and Lennon. Jenifer is an early bird for everything. She starts...
6. Retirement Planning for Jennifer and Lennon. Jenifer is an early bird for everything. She starts to contribute $1,000 to her own 401(K) plan right after she joined company A.E. Corp (at the age of 30). Jenifer's colleague, Lennon, is a late bird for everything. He decides to enjoy his life before he turns 45 and then contributes to his 401(K). Over a coffee break, he learns that Jenifer contributes $1,000 per month now. He figured that if he can...
You are planning for a very early retirement. You would like to retire at age 40...
You are planning for a very early retirement. You would like to retire at age 40 and have enough money saved to be able to draw $ 220,000 per year for the next 40 years​ (based on family​history, you think​ you'll live to age 80​). You plan to save for retirement by making 15 equal annual installments​ (from age 25 to age​ 40) into a fairly risky investment fund that you expect will earn 12% per year. You will leave...
MINI CASE TTHE OZZIE CAKE COMPANY IN EARLY 2012, Harry and Anne Ozzie formed the ozzie...
MINI CASE TTHE OZZIE CAKE COMPANY IN EARLY 2012, Harry and Anne Ozzie formed the ozzie cake company. the company produced a range of cakes, and its specialities included pavlova, lamingtons and sponge cake. the couple formed the company as an outside interest, and both continued work at their current jobs. Harry did all the cake baking and Anne did all the distribution. with good product quality and a sound marketing plan the company grew rapidly. In early 2015 the...
Felix, who was educated in London, now lives in Zurich, Switzerland, and recently took early retirement...
Felix, who was educated in London, now lives in Zurich, Switzerland, and recently took early retirement (from a chocolate firm he joined 25 years ago), leaving the company with a lump sum (after tax) payment of CHF 900,000. Surprisingly, rather than being depressed by his new state of independence, he is excitedly contemplating a new career as a retailer of natural pearls. He is confident that he can set up a business to import pearls from Tahiti and sell them...
Discharge Plan Assignment Case: Cindy, 13, with poor nutritional intake, Bulimia Nervosa. Recently lost his father...
Discharge Plan Assignment Case: Cindy, 13, with poor nutritional intake, Bulimia Nervosa. Recently lost his father to alcoholism. lives with her mother in a private home. Has insurance coverage through mother. Resides in New York, Brooklyn, Zip code 11205. A client scheduled for discharge back to their community New York, Brooklyn, Zip code 11205 from the acute care setting. As the Community Health Nurse assigned to be the Case Manager for this client, you will be required to prepare a...
Discharge Plan Assignment Case: Cindy, 13, with poor nutritional intake, Bulimia Nervosa. Recently lost his father...
Discharge Plan Assignment Case: Cindy, 13, with poor nutritional intake, Bulimia Nervosa. Recently lost his father to alcoholism. lives with her mother in a private home. Has insurance coverage through mother. Resides in New York, Brooklyn, Zip code 11205 A client scheduled for discharge back to their community New York, Brooklyn, Zip code 11205 from the acute care setting. As the Community Health Nurse assigned to be the Case Manager for this client, you will be required to prepare a...
1. Your uncle is planning for retirement, and he wants to buy an annuity that will...
1. Your uncle is planning for retirement, and he wants to buy an annuity that will provide him with $96,000 of income a year for 20 years, with the first payment coming immediately. The market rate on this annuity is 5.25%. How much would the cost be today? Answer just the dollar amount without the + or - sign. Round to the nearest dollar. 2. What's the value today of $1,950 to be received in 5 years if the appropriate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT