PLEASE SHOW HOW YOU WOULD SOLVE USING EXCEL SOFTWARE

You realize the wisdom of starting early at age 22 in saving for your retirement and plan on making 43 equal end of the year annual deposits in an IRA account in hopes of having at least 1,000,000 once you retire at age 65 (immediately after your last deposit into the IRA account) but you think it would be best to have $1,750,000 at age 65 to retire. Answer the following questions based on this information. 1. What rate compounded annually would you need to earn in order to have 2. What annual deposit would you need in order to accumulate $1,750,000 upon 3 Now you decide you might need more than $1,750,000 in your IRA once you turn 65 $1,750,000 upon retirement if your annual deposit is $4000? retirement if your IRA earns 7.9% compounded annually? given the uncertainty of Social Security. How much money would you have in your IRA at age 65 after 43 end of the year deposits of $6,000 invested at an expected annual return of 7.9%? Let's now assume you carry out the plan described in the last question (#3) and expect to continue to earn an 7.9% annual return on your IRA account after retirement. Once you reach retirement at age 65, you decide you will live exactly 25 more years. At age 65, you want two things from your retirement fund: $250,000 to leave to your grandkids upon your death in 25 years and a 25-year annuity-due (25 equal annual withdrawals beginning immediately upon retirement). How large can 4. your annual retirement annuity be while still leaving $250,000 to your grandkids upon your death at age 90 if your IRA account continues to earn 7.9% annually? In looking back at your answer #4, you wonder if this retirement annuity will be enough to live on and you worry about potential loss of purchasing power after retirement. Let's forget about leaving money to the grandkids, they never visit anyway, and make some different retirement income assumptions. Assume you want your first retirement withdrawal, taken immediately upon retirement, to be $150,000 at age 65. Also, let's assume you want each of the remaining (24) withdrawals to increase by 3% annually. Assume your retirement account will still earn an 7.9% expected annual return. 5. a How much will you need in your retirement account at age 65 to fund this desired retirement income stream? b) How much will you have to deposit annually at the end of each year into your account over the next 43 years to fund this desired retirement stream? Your results from question 5 (the last question) have you somewhat concerned. Re do question 5 assuming you'll wait until age 67 to retire and you will live 23 years after retirement. Assume you want your first retirement withdrawal, taken immediately upon retirement, to be $160,000 at age 67. Also, let's assume you want each of the remaining (22) withdrawals to increase by 3% annually. Assume your retirement account will still earn an 7.9% expected annual return. 6. a How much will you need in your retirement account at age 67 to fund this desired retirement income stream? How much will you have to deposit annually at the end of each year into your account over the next 45 years to fund this desired retirement stream? b)