LoslegenKostenlos loslegen

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.

Diese Übung ist Teil des Kurses

Loan Amortization in Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • 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!

Interaktive Übung

Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um

Übung starten