ComeçarComece de graça

Guess the right payment

In this exercise, you have been provided a 1-year, $20,000 loan at a rate of approximately 2.92%.

However; when you tried entering in a $2,200 monthly payment, it provided a closing balance of -$2,826! For all loans, you know that the ending balance needs to be zero and that the payment needs to be the same every month.

Try picking a number which will bring the closing balance to as close to zero as possible.

  • If your closing balance is negative, your guess is too high.
  • If your closing balance is positive, your guess is too low.

Este exercício faz parte do curso

Loan Amortization in Google Sheets

Ver curso

Instruções do exercício

  • Enter the correct monthly payment in cell B4.
  • The correct monthly payment guess will be divisible by 100, and will not have any cents.
  • Make sure that the closing balance in F15 is zero!

Exercício interativo prático

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

Começar o exercício