Please ONLY answer if you can show me in EXCEL. No handwritten answers, these questions...

50.1K

Verified Solution

Question

Finance

Please ONLY answer if you can show me in EXCEL.

No handwritten answers, these questions cost money.

I am having a hard time doing this in EXCEL

Thank you TONS

image

Mitch and Bill are both age 75 . When Mitch was 24 years old, he began depositing $1500 per year into a savings account. He made deposits for the first 10 years, at which point he was forced to stop making deposits. However, he left his money in the account, where it continued to earn interest for the next 41 years. Bill didn't start saving until he was 48 years old, but for the next 27 years he made annual deposits of $1500. Assume that both accounts earned an average annual return of 4% (compounded once a year). Complete parts (a) through (d) below. a. How much money does Mitch have in his account at age 75 ? At age 75 , Mitch has $ in his account. (Round to the nearest cent as needed.)

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