ComeçarComece de graça

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.

Este exercício faz parte do curso

Loan Amortization in Google Sheets

Ver curso

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício