Question

Input Current age                      25 Retirement age               &

Input
Current age                      25
Retirement age                      60
Number of years until retirement                      35
Annual withdrawal ($)            120,000
Number of years to withdraw                      20
Interest rate (%) 6.00%
Employer contribution ($)                 5,000
Trust fund distribution ($)            150,000
Age at trust fund distribution                      45
Years until distribution                      20
Calculation & Output
Present value of withdrawals
Question 4
Annual deposit until retirement
Question 5
Present value in lump sum
Question 6
Value of employer's contribution at retirement:
Value of trust fund at retirement:
Amount required at retirement
Annual deposit until retirement

Homework Answers

Answer #1

PV of withdrawals= 13,76,391/ (1+0.06)^35 = $179,075

Question 4

Annual deposit until retirement= Employers contribution+ Employees contribution

= 5000+ 5000

= $10,000

Question 5

So, present value= $144,982

Question 6

Value of employers contribution at retirement is calculated in excel with the formula =FV(rate, periods, pmt, pv)

Where, rate= 0.06, periods= 35, pmt= -5000, pv=0

FV= $557,174

Value of employers contribution at retirement= $557,174

Amount required at retirement= Value of withdrawals at retirement= 1,376,391

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
This is a classic retirement problem. A friend is celebrating her birthday and wants to start...
This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals: - Years until retirement: 30 - Amount to withdraw each year: $90,000 - Years to withdraw in retirement: 30 - Interest rate: 8% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual...
Your friend is celebrating her 35th birthday today wants to start saving for her anticipated retirement...
Your friend is celebrating her 35th birthday today wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $105,000 from her savings account on each birthday for 20 years following her retirement; the first withdrawal will be on her 66th birthday. Your friend intends to invest her money in the local credit union, which offer 7 percent interest per year. She wants to make equal annual payments on each birthday into the...
A couple is saving for retirement with three different accounts. The table below shows the current...
A couple is saving for retirement with three different accounts. The table below shows the current balances in their accounts, along with their yearly contribution, and the yearly return on each account. The couple will retire in 24.00 years and pool the money into a savings account that pays 4.00% APR. They plan on living for 29.00 more years and making their yearly withdrawals at the beginning of the year. What will be their yearly withdrawal? Account Balance Yearly Contribution...
A couple is saving for retirement with three different accounts. The table below shows the current...
A couple is saving for retirement with three different accounts. The table below shows the current balances in their accounts, along with their yearly contribution, and the yearly return on each account. The couple will retire in 24.00 years and pool the money into a savings account that pays 3.00% APR. They plan on living for 28.00 more years and making their yearly withdrawals at the beginning of the year. What will be their yearly withdrawal? Account Balance Yearly Contribution...
This is a classic retirement problem. Your friend, Mary Jones, is celebrating her 30th birthday and...
This is a classic retirement problem. Your friend, Mary Jones, is celebrating her 30th birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals, which are as follows: Years until retirement:                                                           30 Amount to withdraw each year upon retirement:        $90,000        Years to withdraw in retirement:                                           20 Interest rate:                                                                           5% Mary is planning to make equal annual deposits into her retirement account, while her first withdrawal will take place one...
You are planning for a very early retirement. You would like to retire at age 40...
You are planning for a very early retirement. You would like to retire at age 40 and have enough money saved to be able to draw $210,000 per year for the next 40 years​ (based on family​ history, you think​ you'll live to age 80​). You plan to save for retirement by making 20 equal annual installments​ (from age 20 to age​ 40) into a fairly risky investment fund that you expect will earn 10​% per year. You will leave...
Doreen is celebrating her 35th birthday and decides she needs to start saving for retirement beginning...
Doreen is celebrating her 35th birthday and decides she needs to start saving for retirement beginning at age 65. She wants to be able to withdraw 90,000 annually for 15 years starting on her 66th birthday. She intends to invest at 8% over the life of the account. Her employer will contribute 1500 per year until she retires. Additionally, she expects a 25,000 distribution from a family trust on her 55th birthday which will be deposited into the retirement account....
Happy​ birthday! You are 30 years old today. You want to retire at age 60. You...
Happy​ birthday! You are 30 years old today. You want to retire at age 60. You want to have ​$1,800,000 at retirement. ​ Realistically, you know that the most that you can save from your 31st birthday until your 50th is ​$5,500 per year​ (you only save on your​ birthdays!). How much do you have to save each year from your 51st to your 60th birthday in order to achieve your retirement goal if you can earn 6​% on your​...
Ann E. Belle is age 45 and plans to retire in 20 years (at age 65)....
Ann E. Belle is age 45 and plans to retire in 20 years (at age 65). She has retirement savings in a mutual fund account, which has a current balance of $150,000 (Ann does not plan to add any additional money to this account). Also, Ann opened a 401K retirement account with her new employer and will contribute $15,000 per year into her 401K until retirement. If Ann’s mutual fund account grows at an annual rate of 8.0% how much...
Assume that you are 30 years old today, and that you are planning on retirement at...
Assume that you are 30 years old today, and that you are planning on retirement at age 65. Your current salary is $40,000 and you expect your salary to increase at a rate of 4% per year as long as you work. To save for your retirement, you plan on making annual contributions to a retirement account. Your first contribution will be made on your 31st birthday and will be 9% of this year's salary. Likewise, you expect to deposit...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT