Suppose you have just graduated Harvard and accepted a job with a $100,000 salary. Your 401(K)...

Suppose you have just graduated Harvard and accepted a job with a $100,000 salary. Your 401(K) will be maxed at 5% employee contribution and 1-1 employer match. You will work for exactly the next 45 years (for simplicity assume your salary is unchanged). At your 5 year review you will receive a one-time $20,000 bonus which you will deposit in your retirement plan. You will live exactly 25 years after you retire. You plan to leave $200,000 to Harvard to name a building after yourself. If you expect to earn 6% return annually, what are your annual withdrawals? USE EXCEL IF NEEDED

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

jeff jeffy answered 2 months ago

Next > < Previous

Related Solutions

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...

Grady Zebrowski, age 25, just graduated from college, accepted his first job with a $47,000 salary,...

Grady Zebrowski, age 25, just graduated from college, accepted his first job with a $47,000 salary, and is already looking forward to retirement in 40 years. He assumes a 2.1 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 9 percent rate of return on his investments prior to retirement and a 5 percent rate of return on his investments post-retirement...

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...

You have just turned 22 received your degree and accepted your first job. You must decide...

You have just turned 22 received your degree and accepted your first job. You must decide how much to put in your retirement plan. The plan works as follows. Every dollar in the plan earns 6.5 percent per year. You may not make withdrawals until you retire at 65. After that you can withdrawal money as needed. You believe you will live to 100 and work until 65, and believe you need 95000 per year to be comfortable starting at...

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.

You have just been offered a job. Your base salary will be $90,000 per year and...

You have just been offered a job. Your base salary will be $90,000 per year and the first year’s annual salary will be received one year from the day you start working. You receive a bonus immediately of $12,500. Your salary will grow 4 percent per year and you will receive a bonus of 10 percent of your salary. You expect to work 30 for years. Your discount rate is 11 percent. What is the present value of your offer?...

You have just been offered a job. Your base salary will be $95,000 per year and...

You have just been offered a job. Your base salary will be $95,000 per year and the first year's annual salary will be received one year from the day you start working. You receive a bonus immediately of $12,500. Your salary will grow 4 percent per year and you will receive a bonus of 10 percent of your salary. You expect to work for 30 years. Your discount rate is 10 percent. What is the present value of your offer?

You have just turned 22 years old, received your bachelor's degree, and accepted your first job....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn 65....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 6.9 % per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn...

You have just turned 22 years old, received your bachelor's degree, and accepted your first job....

You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 6.7 % per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn...

Subjects