Question: I will do this one for you and show you how I want you to describe your formula/inputs in excel if that is how you

 I will do this one for you and show you how

I will do this one for you and show you how I want you to describe your formula/inputs in excel if that is how you choose to go about solving problems 2 through 5 - which I strongly recommend. If you choose to perform the calculations by hand show the formula used with values. Excel: Formula used: PMT Rate input: .03/12 NPer input: 4*12 Pv input: 18500 Answer: $409.49 per month 2. You want to buy a $22,500 car. The company is offering a 4% interest rate for 5 years. a. What will your monthly payments be? Round to the nearest cent. b. Assuming you pay that monthly amount for the entire 5 years, what is the total amount of money you will pay during those 5 years for the car? c. How much interest will you pay during those 5 years

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 Mathematics Questions!