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).

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON