please solve using excel and show me which funtions You plan to retire in 30...

80.2K

Verified Solution

Question

Finance

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?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students