Calculate hanford''s capital needed at retirement

Assignment Help Finance Basics

Reference no: EM13886435

Hanford MacDwaddy is 47 years old today and makes $78,000 per year. His wage replacement ratio has been determined to be 72%.He expects inflation will average 3.5%/year over his lifetime. He expects to earn 8% on his investments andhe plans to retire at age 67.You havehelped him determine his estimated social security retirement benefit at his fullretirement age of 67 to be $18,000 per year (in today's dollars). Due to longevity in his family he wants youto help him determine his capital needs for retirement assuming he lives to age97.

Answer the following questions on the next Excel worksheet labeled "Capital Needs".Rely on the use of the TVM functions we have learned so far and keep your answers within the shaded cells.

Questions:

1. Calculate Hanford's capital needed at retirement at age 67 using the Pure Annuity, Capital Preservation and PPP models.You will have 3 separate solutions here.Remember we do this calculation in BEGIN mode since we need the money each year at the start of each year.

2. Calculate the monthly savings Hanford must make at the end of each month to accumulate the capital needed as ifdentified in Question 1.You will have 3 separate solutions here as well.

Attachment:- problemworkout2.xlsx

Reference no: EM13886435

Questions Cloud

Sketch the ?ow ?eld around an airfoil : Sketch the ?ow ?eld around an airfoil that has stalled. Show the boundary layers, the separated region, and the wake.

Find the debt data includes the coupon rate : Find the debt data includes the coupon rate, par value, yield rate and year to maturity on Morningstar.com. For these three companies: JD.com, Tencent (TCEHY),Baidu(BIDU).

What judgments did management at the company make : What judgments did management at the company make that may affect the ability of the external auditor to assess the reasonableness of the impairment charges?

Federal taxes : Candy owns 40% of the stock of Park, Inc. an S corporation. Her stock basis is $25,000, and she loaned $10,000 to the corporation during the year. How much of Park's $100,000 operating loss can Candy deduct for this year? Show your computation of the..

Calculate hanford''s capital needed at retirement : Hanford MacDwaddy is 47 years old today and makes $78,000 per year. His wage replacement ratio has been determined to be 72%.He expects inflation will average 3.5%/year over his lifetime. He expects to earn 8% on his investments andhe plans to reti..

Calculate pressure difference between air and water pipe : Calculate the pressure difference between the air pipe and the water pipe

Audit of a manufacturing company and a government unit : 1.What is meant by using benchmarks for setting a preliminary judgment about materiality? How will those benchmarks differ for the audit of a manufacturing company and a government unit such as a school district?

Define ethical communication within organizations : Define Ethical Communication Within Organizations

Initial acceleration under water : A 20-cm-diameter 4-m-long horizontal cylinder is released from rest under water. If it weighs 1500 N in air, what is its initial acceleration under water if the added mass is neglected? If the added mass is included?

User Account

All Pages