Required fields for the PMT() function.

Within the PMT() function, there are 3 required fields to perform the calculation. Select the correct 3 from the list below.

These fields may be:

A) The opening balance of the loan.
B) The interest rate of the loan.
C) The length of the loan.
D) The amortization period of the loan.
E) The monthly principal payments on the loan.

This exercise is part of the course

Loan Amortization in Google Sheets

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises