Question: please solve using excel and show me which funtions You plan to retire in 30 years and live for another 20 years after that. For
please solve using excel and show me which funtions You plan to retire in 30 years and live for another 20 years after that. For your retirement, you want to withdraw $10,000 at the end of every year starting at the end of year 31. However, you will be leaving on a two year vacation at the end of year 32, and so you want to withdraw an extra $20,000 then, and not withdraw any money at the end of year 33. To pay for these plans, you want to deposit $550 at the end of each year from years 1 through 29 into an IRA account paying 10% per annum. How much money will you need to deposit into the account at the end of year 30 in order to meet your retirement and holiday plans?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
