Question

In: Finance

2. Mrs. D who 27 years old plans to retire at the age of 55. Mrs....

2. Mrs. D who 27 years old plans to retire at the age of 55. Mrs. D would like to be able to withdraw $132,000 per year from her retirement account for 45 years after retirement beginning the year after her retirement. She is also expecting an inheritance of $54,000 to be transferred to her on her 35th birthday. a How much does she need to have in her retirement account by retirement date if the interest rate is 6% per year during the post-retirement years? b Suppose she already has $12,000 in her retirement investment account that earns 9% per year. What will be the value of this amount by her retirement date? c Given her goal, her expected inheritance, and the investment she already has in 1b, how much does she need to invest per year from now till retirement (at 9% annual rate of return) in order to reach her retirement goal?

Solutions

Expert Solution

Answer (a):

Retirement duration = 45 years

Annual withdrawal at the beginning of year = $132,000

Interest rate = 6%

Amount required in retirement account by retirement date = PV (rate, nper, pmt, fv, type) = PV (6%, 45, -132000, 0, 1)

= $2,162,580.027

Amount required in retirement account by retirement date = $2,162,580.03

Answer (b):

She already has $12,000 in her retirement investment account that earns 9% per year.

Current age = 27

Retirement age = 55

Years in investment = 55 - 27 = 28

Value of this amount by her retirement date = 12000 * (1 + 9%) ^28 = $134,005.674

Value of this amount by her retirement date = $134,005.67

Answer (c):

She is expecting an inheritance of $54,000 to be transferred to her on her 35th birthday.

Years in investment = 55 - 35 = 20

Value of this amount by her retirement date = 54000 * (1 + 9%)^20 = $302,638.181

Remaining balance required (at retirement date) = 2162580.027 - 134005.674 - 302,638.181 = $1,725,936.17

Amount she need to invest per year from now till retirement = PMT (9%, 28, 0, -1725936.17, 0) = $15278.07

Amount she need to invest per year from now till retirement = $15,278.07


Related Solutions

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...
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,...
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...
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...
1. George is currently 30 years old, plans to retire at the age of 65 and...
1. George is currently 30 years old, plans to retire at the age of 65 and to live to the age of 85. His labor income is $25,000 per year, and he intends to maintain a constant level of real consumption spending over the next 55 years. Assume no taxes, no growth in real salary, and a real interest rate of 3% per year. a. What is the value of George’s human capital? b. What is his permanent income? c....
Rick is currently 35 years old. He plans to retire at age 65 and hopes to...
Rick is currently 35 years old. He plans to retire at age 65 and hopes to live to age 85. His labour income is $50,000 per year, and he intends to maintain a constant level of real consumption spending over the next 50 years. Assuming a real interest rate of 3% per year, no taxes, and no growth in real labour income, what is the value of Rick’s human capital? ****I would like this broken down step by step, and...
You have a couple who are 31 years old, and want to retire at the age...
You have a couple who are 31 years old, and want to retire at the age of 67. Knowing that, the couple has a combined annual income of $95,000 today. 1. They are curious to find out if college costs $90,000 per year when their child gets into college in 19 years, how much is the total cost of a college education (that lasts for 4 years) in today’s dollars if the cost of money is 8%? Assume you pay...
(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...
A client, 35 years old, who would like to retire at age 65 (30 years from...
A client, 35 years old, who would like to retire at age 65 (30 years from today). Her goal is to have enough in her retirement account to provide an income of $75,000 a year, starting a year after retirement or year 31, for 25 years thereafter. She had a late start on saving for retirement, with a current balance of $10,000. To catch up, she is now committed to saving $5,000 a year, with the first contribution a year...
You are 30 years old and want to retire at the age of age 65 and...
You are 30 years old and want to retire at the age of age 65 and expect to live another 25 years. On the day you retire, you want to have $900,000 in your retirement savings account. a) If you invest monthly starting one month from today and your investment earns 6.0 percent per year, How much money do you need to invest every month until you retire? b) You're retired with $900,000 and you have 25 more years. You...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT