Question

In: Finance

You plan on starting a retirement fund at the end of the year. The fund earns...

You plan on starting a retirement fund at the end of the year. The fund earns 11% per year. You will invest X dollars into the fund. You plan to retire at the end of 40 years from now. Once you retire, you will take your entire retirement fund and transfer it into a safer investment that will only earn 5% interest per year compounded monthly. You will need $4000 per month for 30 years during your retirement to sustain your lifestyle. (After which point, RIP). Calculate exactly how much money you will deposit in your retirement account at the end of this year. Your cousin who is the same age as you and with the same life expectancy and desired retirement age decides she will wait 10 years to start saving for retirement (so she will save for only 30 years). How much does she need to invest per year to achieve the same retirement nest egg as you when she retires? Finally, your lazy best friend who is also your age decides he will wait 10 years to start saving for retirement just like your cousin. However, he will only save the same amount you save per year. He will retire at the same time as you and reinvest just like you do into a safer investment. He will try to live the same life style as you. How long after retirement (in months) before he is broke?

Solutions

Expert Solution

1). Amount needed in the retirement fund at the time of retirement, to sustain $4,000 per month for 30 years:

PMT = 4,000; N = 30*12 = 360; monthly rate (or I/YR) =5%/12 = 0.417%, CPT PV.

PV = 745,126.47

You will need a corpus of 745,126.47 at the time of retirement.

The annual deposits you need to make for 40 years: N = 39; annual rate = 11%; FV = 745,126.47; PV = 0, CPT PMT.

PMT = 1,280.67 (Annual amount to be put in the retirement fund)

2). Annual savings for the cousin:

FV = 745,126.47; N = 30; rate = 11% (assuming her retirement fund earns the same rate); PV = 0, CPT PMT.

PMT = 3,743.96 (Annual deposits to be made by her for 30 years.)

3). PMT = 1,280.67; N = 30; rate = 11%, PV = 0, CPT FV.

FV = 254,879.82 (He will have this much in this retirement fund, at the time of retirement.)

To calculate how many months, his retirement fund will last at $4,000 per month withdrawal at 5% compounded monthly:

PV = 254,879.82; rate = 5%/12 = 0.417%; PMT = -4,000, CPT NPER.

Nper = 74.21 months so he will be broke after 74.21 months.


Related Solutions

You plan on starting a retirement fund at the end of the year. The fund earns...
You plan on starting a retirement fund at the end of the year. The fund earns 11% per year. You will invest X dollars into the fund. You plan to retire at the end of 40 years from now. Once you retire, you will take your entire retirement fund and transfer it into a safer investment that will only earn 5% interest per year compounded monthly. You will need $4000 per month for 30 years during your retirement to sustain...
You plan on starting a retirement fund at the end of the year. The fund earns...
You plan on starting a retirement fund at the end of the year. The fund earns 11% per year. You will invest X dollars into the fund. You plan to retire at the end of 40 years from now. Once you retire, you will take your entire retirement fund and transfer it into a safer investment that will only earn 5% interest per year compounded monthly. You will need $4000 per month for 30 years during your retirement to sustain...
Rachael deposits $3,600 into a retirement fund each year. The fund earns 7.5% annual interest....
Rachael deposits $3,600 into a retirement fund each year. The fund earns 7.5% annual interest, compounded monthly. If she opened her account when she was 20 years old, how much will she have by the time she’s 55? How much of that amount was interest earned?  
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)?
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)? Answers: $21,349 $21,546 $20,930 $20,520
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)? a. 21.,349 b. 21, 546 c. 20,520 d. 20,930
Starting at the end of this year, you plan to make annual deposits of $6,000 for...
Starting at the end of this year, you plan to make annual deposits of $6,000 for 4 years followed by annual deposits of $10,000 for the following 5 years. The deposits earn interest of 3.5%. What will the account balance be at the end of 13 years? a) $89,136 b) $92,507 c) $96,003 d) $99,628 e) $103,386
Starting at the end of this year, you plan to make annual deposits of $5,000 for...
Starting at the end of this year, you plan to make annual deposits of $5,000 for the next 10 years followed by deposits of $13,000 for the following 10 years. The deposits earn interest of 4.6%. What will the account balance be by the end of 33 years? Round to the nearest cent You are interested in buying a house and renting it out. You expect to receive a monthly net income of $1450 from rent. You then expect to...
A person establishes a sinking fund for retirement by contributing $5,000 per year at the end...
A person establishes a sinking fund for retirement by contributing $5,000 per year at the end of each year for 5 years. For the next 10 years, equal yearly payments are withdrawn, at the end of which time the account will have a zero balance. If money is worth 4% compounded annually, what yearly payments will the person receive for the last 10 years?
You plan to invest $2,000 today in a mutual fund that earns 6% annually for 5...
You plan to invest $2,000 today in a mutual fund that earns 6% annually for 5 years. Which of the following statements is TRUE? Select one: a. All else being equal, if the interest rate doubles, the future value doubles. b. All else being equal, if the number of periods doubles, the future value doubles. c. All else being equal, if both the interest rate and the number of periods double, the future value doubles. d. All else being equal,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT