In our readings, we studied Craig's decision to buy a car. Craig knows the following two Excel commands that he used during the Quantitative Reasoning Process: PMT(rate, nper, PV, FV) FV(rate, nper, pmt, PV)   In step3 of the Quantitative Reasoning Process, quantitative tools, Craig used the following command in Excel: =PMT(0.04/12, 7*12, -5000, 0) The Excel output for this command was $68.34. Which of the following best describes what this output represents?   1   If Craig saves $405.85 per year in an account paying 0.04% interest he will be able to buy a $5000 car in 84 years. 2   If Craig saves $68.34 per month in an account paying 4% interest he will be able to buy a $5000 car in 7 years. 3   The monthly payment on a car loan of $5000, with an interest rate of 0.04% for 84 months, will be $68.34. 4   The monthly payment on a car loan of $5000 with an interest rate of 4% for 7 years will be $68.34. 5   The monthly payment on a car loan of $5000, with an interest rate of 0.33% for 7 years, will be $68.34 times 12 (or $820.08 per month).

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter4: Linear Functions
Section: Chapter Questions
Problem 33PT: For the following exercises, consider this scenario: The population of a city increased steadily...
icon
Related questions
icon
Concept explainers
Topic Video
Question

In our readings, we studied Craig's decision to buy a car. Craig knows the following two Excel commands that he used during the Quantitative Reasoning Process:

PMT(rate, nper, PV, FV)

FV(rate, nper, pmt, PV)

 

In step3 of the Quantitative Reasoning Process, quantitative tools, Craig used the following command in Excel:

=PMT(0.04/12, 7*12, -5000, 0)

The Excel output for this command was $68.34. Which of the following best describes what this output represents?

 

1  

If Craig saves $405.85 per year in an account paying 0.04% interest he will be able to buy a $5000 car in 84 years.

2  

If Craig saves $68.34 per month in an account paying 4% interest he will be able to buy a $5000 car in 7 years.

3  

The monthly payment on a car loan of $5000, with an interest rate of 0.04% for 84 months, will be $68.34.

4  

The monthly payment on a car loan of $5000 with an interest rate of 4% for 7 years will be $68.34.

5  

The monthly payment on a car loan of $5000, with an interest rate of 0.33% for 7 years, will be $68.34 times 12 (or $820.08 per month).

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Application of Algebra
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell