The PMT function in Excel calculates:
-
A
The future value of an investment
-
B
The periodic payment for a loan or annuity given interest rate, term, and principal
-
C
The present value of a series of cash flows
-
D
The number of periods required to repay a loan