開始使用免費開始

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.

本練習屬於課程

在 Google Sheets 進行貸款攤還

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習