Multiple Choice
The Excel formula to compute the annual payment for a car loan of $30,000 at 5% interest rate over five years is:
A) =PMT(5,0.05,30000)
B) =PMT(30000, 0.05,5)
C) =PMT(0.05,60,30000)
D) =PMT(0.05,5,30000)
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q28: What is the net present value for
Q29: In any Excel functions that uses NPER
Q30: Prescriptive analytics will optimize the decisions based
Q31: An accounting rate of return is the
Q32: _ is the cost of available funds
Q34: Which of the following does not incorporate
Q35: A series (such as monthly or annually)
Q36: The Excel formula to compute the net
Q37: The _ is the interest rate that
Q38: The point at which it no longer