Question

Using the information below, answer the following questions: Annual Retirement Income Need 150,000 Years until Retirement...

Using the information below, answer the following questions:

Annual Retirement Income Need

150,000

Years until Retirement

30

Years in Retirement

35

Expected Inflation Rate

2.50%

Rate of Return before Retirement

8.00%

Rate of Return during Retirement

5.00%

  1. Using equation 8-10 from the book, how much money will you need to have accumulated at the time of retirement to be able to meet your income needs during retirement?
  2. If you were to make a single lump sum investment today, how much would you need to invest to meet your goal at the time of retirement?
  3. If you were to invest an equal dollar amount each year, how much would you need to invest annually to meet your goal at the time of retirement?

Please show steps in the EXCEL!!!!

Homework Answers

Answer #1

Real rate of return=(1+nominal)/(1+inflation)-1

Before retirement:1.08/1.025-1=.0537 or 5.37%

After retirement:1.05/1.025=.0244 or 2.44%

Present value=23.3567*150000

PV=3503505

b) Investment to be made today=3503505/(1.0537^30)

=729446.32

c)3503505 is the future value of annuity to be invested each year

Formula:

FV of annuity= FV factor for 30 years at 5.37% * Annuity

Annuity=FV of annuity/FV factor

Annuity=3503505/70.8187

Annuity=49471.47

Hence every year he should invest 49471.47

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You want to have $150,000 in your retirement account when you retire in 30 years. Your...
You want to have $150,000 in your retirement account when you retire in 30 years. Your retirement account earns 7% interest. How much do you need to deposit each month to meet your retirement goal? Round your answer to the nearest cent if necessary and do not include the dollar sign.
Your goal is to become a millionaire by retirement. How much do you need to save...
Your goal is to become a millionaire by retirement. How much do you need to save each month to have $1,000,000 assuming you have 35 years to invest in an account that earns 7.5% real rate of return? If you earn $5,000/month, what percentage of your monthly income do you need to invest for retirement?
Bob needs to replace an income stream of $55,000 for 20 years during retirement. He assumes...
Bob needs to replace an income stream of $55,000 for 20 years during retirement. He assumes inflation will be 3% and he can earn 5% on his investments during retirement. If he begins saving money at age 22 and retires when he is 65, he can earn 10% annually, how much will he need to contribute monthly to meet his goal?
You are planning your retirement and you come to the conclusion that you need to have...
You are planning your retirement and you come to the conclusion that you need to have saved $1,250,000 in 30 years. You can invest into a retirement account that with earn you a 5% average annual return. Required: i.            If your investment can earn 5% annually, how much would you need to put into your account at the end of each year to reach your retirement goal? ii.            If your investment can earn 10% annually, how much would you need to put...
3-part question. Five years from now you would like to have $25,000 for a down payment...
3-part question. Five years from now you would like to have $25,000 for a down payment on a home. Assuming you could earn 9% interest, how much money would you need to invest today as a lump sum to meet your goal? How much money would you have to invest at the end of each year to meet your goal? How much would you need if you invested the payments at the beginning of each year with the first payment...
Jones is planning for his retirement, which he understands will be in 6 years. She would...
Jones is planning for his retirement, which he understands will be in 6 years. She would like to retire with at least $ 500,000 at that time. It already has accumulated $ 150,000, which it has just deposited at an interest rate of 6% per year, compounded annually. How much will you have to invest at the end of each period to achieve your retirement and if you assume that the annual interest rate of 12% on the remaining will...
you are planning your retirement and you come to conclusions that you need to save 1,250,000...
you are planning your retirement and you come to conclusions that you need to save 1,250,000 in 30 years. You can invest into a retirement accounts that guarantees you 5% annual return. how much do you put into account at the end of each year to reach your retirement goal?
If you wanted to retire in 50 years with $4,000,000 in your retirement account, how much...
If you wanted to retire in 50 years with $4,000,000 in your retirement account, how much would you need to invest each month if your annual rate of return was 10%? (nearest $1) Given the same information as the question above, how much would you need to invest each month if your annual rate of return was 5%?(nearest$1)
a. Suppose your client is 35 years old and has already saved $150,000 for retirement. How...
a. Suppose your client is 35 years old and has already saved $150,000 for retirement. How much does your client need to contribute to a fund each month for the next 25 years (first payment at the end of this month), to reach a retirement goal of 4,000,000, if the fund is expected to earn an effective annual rate of 12%? b. Suppose your client is also very generous, and wishes to leave the entire $4,000,000 in savings to charity...
Thelma and Timothy have a retirement savings goal of $1,500,000. They are planning for a retirement...
Thelma and Timothy have a retirement savings goal of $1,500,000. They are planning for a retirement lasting 30 years. They would like to retire in 27 years. The combined total of their retirement accounts is $90,000 today. They assume their portfolio can earn 6 percent over time and that inflation will average 2.5% annually. How much will they need to save at the end of each year to meet their retirement goal? A. $18,435. B. $15,785. C. $12,430. D. $17,730....