Anna just turned 55. She is planning to retire in 10 years, and she currently has...

Anna just turned 55. She is planning to retire in 10 years, and she currently has $500,00 in her 401k fund. She assumes that she will live 20 years past her retirement age. During each of these 20 years, she desires to withdraw $100,000 from her retirement fund. If the interest rate is 5% annually, how much will Anna have to save per year for the next 10 years (from 55 to 64)? Assume that the first deposit to her retirement fund will be today, followed by nine more annual deposits, and that the annual withdrawals from age 65 will occur at the beginning of each year. (excel with calculations)

Solutions

Expert Solution

jeff jeffy answered 11 months ago

Next > < Previous

Related Solutions

Anna just turned 55. She is planning to retire in 10 years, and she currently has...

Ms. B is 55 years old and is planning to retire at age 62. She wants...

Ms. B is 55 years old and is planning to retire at age 62. She wants to have a retirement income from that point until age 85. She projects that she will need $5,000 per year during her retirement to supplement her other retirement income. She has accumulated a nest egg $25,000 at this point. Assume that she can invest at a 8% annual rate in the pre-retirement period, that her funds can be invested at a 9% annual rate...

Julia, your aunt, currently is 55 years old; she will retire at the age of 60....

Julia, your aunt, currently is 55 years old; she will retire at the age of 60. Last month, Julia just formed a portfolio with stock A, B, and C. Julia invest her retirement money equally in all 3 assets. Beta of each assets are as follows; bA = 2.21; bB = 1.85; and bC = 1.75 Aunt Julia is a very conservative investor, she can accept minimal risk and she can bear the maximum loss only 5% of her investment,...

GIVEN: Francis Frugal has just turned 65 and is about to retire. She has $1,500,000 in...

GIVEN: Francis Frugal has just turned 65 and is about to retire. She has $1,500,000 in her bank account and plans to live on $76,500 per year. Please show the equations. Not on Excel. A. If she lives to age 95, what is the minimum rate of return she needs to earn during retirement? B. Oh no! Her three bachelor sons all suddenly lost their jobs and have to move back in with her. Poor Francis will have to spend...

(Solve manually) Lucy, has just turned 27 years old today and wants to retire at age...

(Solve manually) Lucy, has just turned 27 years old today and wants to retire at age 63. When she retires she wants to have enough money to purchase a 27-year annuity that will pay $4.000 per month. Monthly payments should start on her birthday when she reaches age 63 years old. The annuity earns 3.25% rate of return (compounded annually). To achieve her financial goals, Lucy needs to invest $X every month. She has identified 2 types of investments she...

Sasha just turned 55 years old today and plans on retiring in 20 years on her...

Sasha just turned 55 years old today and plans on retiring in 20 years on her 75th birthday. She would like to withdraw money from her retirement account on her birthday each year until she dies. She would like to withdraw $80,000 on her 75th birthday, and increase her withdrawals 6% each year through her 89th birthday. She expects to die on her 90th birthday, at which time she would like to leave $300,000 to her granddaughter. Sasha currently has...

Clara plans to retire in fifteen years. She has just deposited $100,000 in a bank that...

Clara plans to retire in fifteen years. She has just deposited $100,000 in a bank that pays 8% interest and compounds MONTHLY. Upon retirement, she plans to withdraw $3,000 per MONTH. How long (in years) will Clara be able to maintain that lifestyle? Select one: a. 16.65 b. 9.19 c. 17.25 d. 15.86

Hypothetically, you are currently 55 years old and intend to retire at age 60. To make...

Hypothetically, you are currently 55 years old and intend to retire at age 60. To make your retirement easier, you intend to start a retirement account. At the beginning of each years 1, 2, 3, 4 (that is, starting today and at the beginning of each of the next four years), you intend to make a deposit into the retirement account. You assume that the account will earn 8% per year. After retirement at age 60, you anticipate living 8...

You are planning to retire in 40 years. You currently have $ 300,000 in a bond...

You are planning to retire in 40 years. You currently have $ 300,000 in a bond mutual fund and $100,000 in a stock mutual fund. You plan to invest $10,000 per year in the stock mutual fund for the next 40 years (i.e., from t=1 to t=40). The bond fund is expected to earn 4% per year, compounded annually, and the stock account is expected to earn 9% per year, compounded annually, indefinitely. When you retire in 40 years, you...

Your dad is now 55 years old and plans to retire at age 70. He currently...

Your dad is now 55 years old and plans to retire at age 70. He currently has a stock portfolio worth $450,000. The portfolio is expected to earn a return of 8 percent per year. b. Assume he plans to invest an additional $12,000 every year in his portfolio for the next 15 years (starting one year from now). How much will his investments be worth when he retires at 70? c. Assume that your dad expects to live 20...

Subjects