📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    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:

    ask-question