Question

In: Finance

You just graduated from college and are starting your new job. You realized the importance to...

You just graduated from college and are starting your new job. You realized the importance to save for the future and have figured out that you will save $1,000 per month for the next 14 years; and then increase to $5,000 per month for the following 5 years. The amount accumulated at the end of these investments will be your retirement egg nest. You plan to start retirement and start withdrawing monthly amounts the following month (you will be in retirement for 24 years). If your required rate of return is 12% compounded monthly, how much are your monthly withdrawals?

Solutions

Expert Solution

FV of Annuity :
Annuity is series of cash flows that are deposited at regular intervals for specific period of time.

FV of Annuity = CF [ (1+r)^n - 1 ] / r
r - Int rate per period
n - No. of periods

FV of Annuity of $ 1000 at the end of 14 years:

Particulars Amount
Cash Flow $      1,000.00
Int Rate 1.000%
Periods 168

FV of Annuity = Cash Flow * [ [ ( 1 + r ) ^ n ] - 1 ] /r
= $ 1000 * [ [ ( 1 + 0.01 ) ^ 168 ] - 1 ] / 0.01
= $ 1000 * [ [ ( 1.01 ) ^ 168 ] - 1 ] / 0.01
= $ 1000 * [ [5.321] - 1 ] / 0.01
= $ 1000 * [4.321] /0.01
= $ 432096.98

FV of this amount after 5 Years ( 14 + 5= 19):

Future Value:
FV = PV (1+r)^n
Where r is Int rate per period
n - No. of periods

Particulars Amount
Present Value $4,32,096.98
Int Rate 1.0000%
Periods 60

Future Value = Present Value * ( 1 + r )^n
= $ 432096.98 ( 1 + 0.01) ^ 60
= $ 432096.98 ( 1.01 ^ 60)
= $ 432096.98 * 1.8167
= $ 784989.16

FV of Annuity of $ 5000 at the end of 19 years:

Particulars Amount
Cash Flow $      5,000.00
Int Rate 1.000%
Periods 60

FV of Annuity = Cash Flow * [ [ ( 1 + r ) ^ n ] - 1 ] /r
= $ 5000 * [ [ ( 1 + 0.01 ) ^ 60 ] - 1 ] / 0.01
= $ 5000 * [ [ ( 1.01 ) ^ 60 ] - 1 ] / 0.01
= $ 5000 * [ [1.8167] - 1 ] / 0.01
= $ 5000 * [0.8167] /0.01
= $ 408348.35

Total Value in account after 19 Years = $ 784989.16 + $ 408348.35
= $ 1193337.51

Monthly withdrawl:

PV of Annuity:

Annuity is series of cash flows that are deposited at regular intervals for specific period of time.

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
r - Int rate per period
n - No. of periods

Particulars Amount
PV Annuity $    11,93,337.51
Int Rate 1.000%
Periods 288

Cash Flow = PV of Annuity / [ 1 - [(1+r)^-n]] /r
= $ 1193337.51 / [ 1 - [(1+0.01)^-4]] /0.01
= $ 1193337.51 / [ 1 - [(1.01)^-4]] /0.01
= $ 1193337.51 / [ 1 - 0.0569 ] /0.01
= $ 1193337.51 / [0.9431 / 0.01 ]
= $ 1193337.51 / 94.3056
= $ 12653.93

Each month, we can withdraw $ 12653.93


Related Solutions

You just graduated from college and are starting your new job. You realized the importance to...
You just graduated from college and are starting your new job. You realized the importance to save for the future and have figured out that you will save $2,000 per month for the next 14 years; and then increase to $6,000 per month for the following 6 years. The amount accumulated at the end of these investments will be your retirement egg nest. You plan to start retirement and start withdrawing monthly amounts the following month (you will be in...
Clarissa just graduated from High school and she is starting her new job today. Her new...
Clarissa just graduated from High school and she is starting her new job today. Her new employer gave her a $15,000 signing bonus that she will invest today. She plans to retire 50 years from today (i.e., at the end of year 50). Once she retires, she would like to be able to withdraw from her retirement account $180,000 at the end of each year, starting the year after she retires (i.e., year 51). She expects that her retirement will...
You just graduated college with your Bachelors Degree and accepted a job offer at your dream...
You just graduated college with your Bachelors Degree and accepted a job offer at your dream company. You decided to celebrate by purchasing the vehicle of your dreams. Pictured is a Dodge Challenger HellCat see picture above for $58,995). You have a 720 credit score, therefore you were able to get a 5% interest rate on a 7 year loan. You will be making monthly payments. Using Excel, prepare a professional amortization schedule for the entire 7 years. It must...
Sofia just graduated from college and she is starting her newjob today. Her new employer...
Sofia just graduated from college and she is starting her new job today. Her new employer gave her a $15,000 signing bonus that she will invest today. She plans to retire 50 years from today (i.e., at the end of year 50). Once she retires, she would like to be able to withdraw from her retirement account $180,000 at the end of each year, starting the year after she retires (i.e., year 51). She expects that her retirement will last...
Congratulations! You have just graduated from your University. Your first day on your new job involves...
Congratulations! You have just graduated from your University. Your first day on your new job involves a lot of paperwork including your decision to participate in the company 401K plan. First, should you participate? Second, describe the benefits of diversification if any including adding international stocks to your investment portfolio? You must include a full explanation to support your answer.
Your 21 year old client just graduated from college and started a job with monthly salary...
Your 21 year old client just graduated from college and started a job with monthly salary of $5,000 per month. He wants to retire when he is 60 years old and wants to start saving for retirement right away. We cannot be sure of how long we live after retirement, but the client wants to be extra careful and save for 30 years of after retirement life. Market expectation for average annual inflation for the future is 1.7% (Let’s assume...
MINICASE A JOB AT S&S AIR You recently graduated from college, and your job search led...
MINICASE A JOB AT S&S AIR You recently graduated from college, and your job search led you to S&S Air. Because you felt the company’s business was taking off, you accepted a job offer. The first day on the job, while you are finishing your employment paperwork, Chris Guthrie, who works in Finance, stops by to inform you about the company’s 401(k) plan. A 401(k) plan is a retirement plan offered by many companies. Such plans are tax-deferred savings vehicles,...
You have recently graduated from college, and your job search led you to East Coat Yachts....
You have recently graduated from college, and your job search led you to East Coat Yachts. Since you left the company’s business was seaworthy, you accepted a job offer. The first day on the job, while you are finishing your employment paperwork, Dan Ervin, who works in Finance, stops by to inform you about the company’s 401(k) plan. A 401(k) plan is a retirement plan offered by many companies. Such plans are tax-deferred savings vehicles, meaning that any deposits you...
You have just graduated from The a College and is making a budget presentation to a...
You have just graduated from The a College and is making a budget presentation to a group of students. In your presentation you are required to prepare the cash budget for Neann Ltd for the first quarter of 2011. The following information is to be used in the preparation of the budget. a) The directors have agreed at a special meeting to inject additional capital into the business of $60million dollars in February 2011. b) The business expects to receive...
Grady​ Zebrowski, age​ 25, just graduated from​ college, accepted his first job with a ​$45 comma...
Grady​ Zebrowski, age​ 25, just graduated from​ college, accepted his first job with a ​$45 comma 000 ​salary, and is already looking forward to retirement in 40 years. He assumes a 3.5 percent inflation rate and plans to live in retirement for 20 years. He does not want to plan on any Social Security benefits. Assume Grady can earn a 6 percent rate of return on his investments prior to retirement and a 6 percent rate of return on his...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT