Johnson & Wales University Week 4 Bobby and Robin Cases Analysis

This week you are presented with two sets of case facts to determine various retirement fundingoptions for these clients. A successful submission will include not only the final answer, but also all ofthe work along the way. Demonstrate your mastery of the topic step-by-step and you will do well.Submit just the final amount, right or wrong, and you will not. You see I will provide credit for taking theright steps, even if the final answer may be incorrect.Please submit your answers as a Word document. I will accept Excel spreadsheets if you choose to usethat method, be sure to clearly note your steps and assumptions.Case #1Bobby, age 52, has come to you for help in planning his retirement. He works for a bank, where he earns$60,000. Bobby would like to retire at age 62. He has consistently earned 8% on his investments andinflation has averaged 3%.1) Assuming he is expected to live until age 95 and he has a wage replacement ratio of 80%, how muchwill Bobby need to have accumulated as of the day he retires to adequately provide for his retirementlifestyle?2) Assuming the same facts as Question 16, approximately how much must Bobby save at the end ofeach year, from now until retirement, to provide him with the necessary capital balance assuming hehas a zero balance today?3) How much more will Bobby need at retirement to have the same amount at his death as he will have(calculated in #2) at his retirement?4) How much more will Bobby need at retirement to have the same amount at his death with an equalpurchasing power as he will have (calculated in #3) at his retirement?(next page)Case #2Robin is planning for her retirement. She is currently 37 years old and plans to retire at age 62 and liveuntil age 97. Robin currently earns $100,000 per year and anticipates needing 80% of her income duringretirement. She anticipates Social Security will provide her with $15,000 per year at age 62, leaving herwith required savings to provide $65,000 ($100,000 x 0.80 – $15,000) annually during retirement. Shebelieves she can earn 11% on her investments and inflation will be 2% per year.1) How much must Robin save at the end of each year if she wants to make her last savings payment atage 62 to meet her retirement goal?2) How much must Robin save at the end of each year if she wants to make her last savings payment atage 62, and maintain the original account balance needed at retirement for the entire retirement lifeexpectancy? College of Online Education FISV5440 Johnson & Wales University3) How much must Robin save at the end of each year if she wants to make her last savings payment atage 62 to meet her retirement goal, assuming she wants to maintain the original purchasing power ofher capital balance?