All of the following are arguments of the built-in PMT function EXCEPT:
A) Rate
B) Present value
C) Future value
D) Loan payment

Question

Quizplus · Accepted Answer

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. It requires the interest rate, the number of periods, and the present value (the total amount of the loan) as arguments. Future value can also be an argument, representing the desired balance after the last payment is made. Loan payment is not an argument of the PMT function; it is the result calculated by the function.

All of the Following Are Arguments of the Built-In PMT