We know the following two commands in Excel: PMT(rate, nper, PV, FV) FV(rate, nper, pmt, PV) Which of the following Excel commands gives the monthly payment on a house that cost $255,000 with a down payment of $22,725. The loan was a conventional 30-year loan with an annual interest rate of 3.1%.   1   =PMT(0.031/12,30,-255000,-22725) 2   =FV(0.031/12,30,-255000,-22725) 3   =PMT(0.031/12,360,-232275,0) 4   =FV(3.1/12,360,-22725,-255000) 5   =PMT(3.1/12,360,0,-232275)

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

We know the following two commands in Excel:

PMT(rate, nper, PV, FV)

FV(rate, nper, pmt, PV)

Which of the following Excel commands gives the monthly payment on a house that cost $255,000 with a down payment of $22,725. The loan was a conventional 30-year loan with an annual interest rate of 3.1%.

 

1  

=PMT(0.031/12,30,-255000,-22725)

2  

=FV(0.031/12,30,-255000,-22725)

3  

=PMT(0.031/12,360,-232275,0)

4  

=FV(3.1/12,360,-22725,-255000)

5  

=PMT(3.1/12,360,0,-232275)

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