Record of Loan Payments and Rate Changes calculator

You can use this calculator to produce a historical payment schedule. This calculator allows for changes in payment dates, payment amounts, and interest rates, as well as computes deferred interest and allows for additions to principal during the loan, such as late fees.

To open this calculator, click Calculators in the toolbar, and then click Other Loan > Record of Loan Payments and Rate Changes in the left panel.

You can export the data as a PDF file or clear all data that you entered. For more information, see Financial calculators.

First, establish the loan by entering data in the following fields.

  • Date of Loan Origination
  • Loan Amount
  • Deferred Interest
  • Compounded (Payment Date or Daily)

Then, as payments are made, enter the date of the payment, the amount, and interest rate to be used since the last payment. The interest rate will automatically fill in when the user enters a rate in the preceding Interest Rate field. You can enter a different rate for each payment.

Payments are applied in the following order.

  • Interest
  • Deferred interest
  • Principal

Internal notes


Contact us

Was this article helpful?