Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I solve part B using Excel? 6. You want to have $85,000 saved in your bank account 11 years from now. You want

image text in transcribed

How do I solve part B using Excel?

6. You want to have $85,000 saved in your bank account 11 years from now. You want to deposit the same amount every year, starting next year, and you can earn 5.5% per year on your savings. a. What would be your annual deposit? FV:$85,000t:11yearsr:0.055 =PMT(0.055,11,0,85000)=$5828.51 b. Say that you make the first deposit today and the last one in 10 years, what would be your annual deposit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Complacency And Collusion A Critical Introduction To Business And Financial Journalism

Authors: Keith J. Butterick

1st Edition

074533203X,1849648379

More Books

Students also viewed these Finance questions

Question

What is the worst/most expectable/least damaging scenario?

Answered: 1 week ago