Mulai sekarangMulai gratis

Impact of rising interest rates

In this example, the interest rates will rise by 0.25% every month, while the payment as calculated by the PMT() function remains the same. To calculate the correct closing balance, you will need to manually calculate the interest and principal balances every month.

Will there be negative amortization that will result in the loan never being paid off?

Latihan ini merupakan bagian dari kursus

Amortisasi Pinjaman di Google Sheets

Lihat Kursus

Instruksi latihan

  • Enter the correct interest payments in column I for every month on the loan, using the annual new interest rate in column H.
  • Enter the monthly principal repayments in column J.

Latihan interaktif langsung

Ubah teori menjadi aksi dengan salah satu latihan interaktif kami

Mulai latihan