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

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!