Anne-Marie and Yancy calculate their current living expenditures to be $80,000 a

Question

Anne-Marie and Yancy calculate their current living expenditures to be

$80,000

a year. During retirement they plan to take one cruise a year that will cost

$5,000

intoday's dollars. Anne-Marie estimated that their average tax rate in retirement would be

16

percent. Yancy estimated their Social Security income to be about

$26,011

and their retirement benefits are approximately

$39,910.

Use this information to answer the following questions:a. How much income, in today's dollars, will Anne-Marie and Yancy need in retirement assuming 70 percent replacement and an additional

$5,000

for the cruise?

b. Calculate their projected annual income shortfall in today's dollars.

c. Determine, in dollars, the future value of the shortfall

33 years from now, assuming an inflation rate of

3

percent.

d. Assuming a nominal rate of return of

9

percent and

28

years in retirement, calculate their necessary annual investment to reach their retirement goals.

I need help with D

Homework: 6-3 MyFinanceLab: Assignment: Module Six Homework Save Score: 0 of 1 pt 2 of 7 (1 complete) HW Score: 5.71%, 0.4 of 7 pts Problem 15-4 (similar to) Question Help * Anne-Marie and Yancy calculate their current living expenditures to be $80,000 a year. During retirement they plan to take one cruise a year that will cost $5,000 in today's dollars. Anne-Marie estimated that their average tax rate in retirement would be 16 percent. Yancy estimated their Social Security income to be about $26,011 and their retirement benefits are approximately $39,910. Use this information to answer the following questions: a. How much income, in today's dollars, will Anne-Marie and Yancy need in retirement assuming 70 percent replacement and an additional S5,000 for the cruise? b. Caculate their projected annual income shortfall in today's dollars c. Deterrnine, in dollars, the future value of the shortfall 33 years from now, assuming an inflation rate of 3 percent. d. ssuming a nominal ate o return o 9 percent and 28 ears n etirement, a late their nec ssary an al investment to each their et rement go ci c on the able con to view e table on the le cont vie·them A ble . click on the table icon to view the FVIFA table a. The pre-tax amount, in today's dollars, that Anne-Marie and Yancy wl need in retirement assuming 7D percent replacement and an additional $5,000 for the cruise is $ 72619.05 (Round to the nearest cent.) b. Their projected annual income shorttal in today's dollars is S 6698.05. (Round to the nearest cent.) c. The future value of the shortfall 33 years from now, assuming an inflation rate of 3 percent is $ 17765.47. (Round to the nearest cent.) d. Assuming a nominal rate of return of 9 percent and 28 years in retirement, their necessary annual investment to reach their retirement goals is S(Round to the nearest cent.)

Explanation / Answer

Part d)

The solution to Part d) is based on the values determined in earlier parts.

____

Step 1: Calculate the Value of Total Shortfall at Retirement:

The total shortfall at retirement can be calculated with the use of PV (Present Value) function/formula of EXCEL/Financial Calculator. The function/formula for PV is PV(Rate,Nper,-PMT,FV) where Rate = Interest Rate, Nper = Period, PMT = Payment and FV = Future Value.

Here, Rate (Inflation Adjusted) = 9% - 3% = 6%, Nper = 28, PMT = $17,765.47 and FV = 0

Using these values in the above function/formula for PV, we get,

Value of Total Shortfall at Retirement = PV(6%,28,-17765.47,0) = $238,166.81

____

Step 2: Calculate the Value of Annual Investment:

The value of annual investment can be calculated with the use of PMT (Payment) function/formula of EXCEL/Financial Calculator. The function/formula for PMT is PMT(Rate,Nper,PV,FV) where Rate = Interest Rate, Nper = Period, PV = Present Value and FV = Future Value.

Here, Rate = 9%, Nper = 33, PV = 0 and FV = $238,166.81

Using these values in the above function/formula for PMT, we get,

Annual Investment = PMT(9%,33,0,238166.81) = $1,324.62 (answer)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.