Question: please do it with formulas and excel function 2. You have just turned 30 years old and finally received your MBA degree. After passing principle

please do it with formulas and excel function please do it with formulas and excel function 2. You have just

2. You have just turned 30 years old and finally received your MBA degree. After passing principle of finance course, you got accepted to your first job. Your employer told you that you must deposit annual payments of 9366.29 to your retirement plan at the end of each year. Assuming the retirement age is 65. You can't withdrawals until you retire on your sixty-fifth birthday. Assume the interest rate is 7% during that time (from age 30 to 100). a. How much money will you have in your retirement plan at your 65-birthday? b. Assume you plan to live until 100 years old and would like to have an equal income each year 1. How much money will you be able to withdraw every year from your retirement plan until "knocking on heaven's door" (death), starting at the end of first year of retirement and ending on your 100th birthday? 2. How much money will you be able to withdraw every year from your retirement plan until death, starting at the beginning of your retirement year and ending at the beginning of year 100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!