Question

    What does the PMT function do in

    Excel?
    A Calculates the principal payment for a loan Correct Answer Incorrect Answer
    B Calculates the payment for a loan based on constant payments and a constant interest rate Correct Answer Incorrect Answer
    C Calculates the total payment for a loan Correct Answer Incorrect Answer
    D Calculates the present value of an investment Correct Answer Incorrect Answer

    Solution

    The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.

    Practice Next

    Relevant for Exams: