Cathy and john from last week need more assistancenbsp as a

Assignment Help Corporate Finance

Reference no: EM13381034

Cathy and John from last week need more assistance. As a reminder, here are their assets:

- John 401K - $60,000

- Cathy Trading account - $100,000

- John Roth IRA - $15,000

- John IRA - $195,000

- CD - $25,000

- Cathy 401k at old job - $17,000

- Checking and Savings total $6,000

Cathy and John have about $700 every month left over after paying for expenses. Their joint annual income is $112,000. They are both 48 years old. Monthly living expenses during retirement are $7,000. Assume inflation is 4% and the nominal rate of return is 8%. His social security kicks in at age 66 and he will draw $2,600 per month. She will begin at age 66 too and will draw based on his benefit.

You will need to input the information in the attached spreadsheet. You will also have to add all formulas including using the "goal seek" function. Do NOT turn in a report that looks like Worksheet 14.1 shown on page 477. If you do this to answer the questions, you will receive no credit. There is not an example in the book so follow the instructions carefully. Make sure you send me both a spreadsheet and a word document with your answers.

- Column Headers:

o Age

o Annual Spending Needs which begin at retirement

o Annual Contributions to investments from now until retirement

o Income derived from other sources

o Net spending from investments (adjusted for inflows and outflows)

o Net Rate Of Return

o Ending Adjusted Balance on Investments

- Reminders:

o Begin the plan at their current age and run through age 90

o Reduce the rate of return directly by inflation

o Make sure you present everything in TODAY's DOLLARS, not future dollars

1. Cathy and John would like to retire when they are 65. Using their retirement assets ONLY, what is the annual savings required to fully fund retirement if the last dollar is spent at their age 90?

2. John is sort of dreaming of leaving the work force early. What amount of annual savings is required to fully fund retirement at age 62 for both if the last dollar is spent at age 90?

3. Based on the information you have been given:

a. Can they retire at age 62?

b. Why or why not?

Reference no: EM13381034

Questions Cloud

You are the assistant to the ceo of a major company your : you are the assistant to the ceo of a major company. your ceo keeps an eye on the competition and asks you to do the

1the corporate treasurer of ajax company expects the : 1the corporate treasurer of ajax company expects the company to grow at 4 in the future and debt securities at 6

On march 19 2012 apple aapl announced plans to begin paying : on march 19 2012 apple aapl announced plans to begin paying dividends for the first time since 1995. according to the

It is sometimes argued that a forward exchange rate is an : it is sometimes argued that a forward exchange rate is an unbiased predictor of future exchange rates. under what

Cathy and john from last week need more assistancenbsp as a : cathy and john from last week need more assistance.nbsp as a reminder here are their assets- john 401k - 60000- cathy

As the prevalence of social media continues to rise : as the prevalence of social media continues to rise consumers are recognizing ways in which social media can direct

Task 1the private equity world is in its golden era right : task 1the private equity world is in its golden era right now ...the stars are aligned.-henry kravis banking conference

If common stockholders are the owners of the company why do : if common stockholders are the owners of the company why do they have the last claim on assets and a residual claim on

1 during the year the dalton firm had sales of 3210000 cost : 1. during the year the dalton firm had sales of 3210000. cost of goods sold administrative and selling expenses and

User Account

All Pages