Simulate a Loan Table with Annual and Monthly Payments

A loan or credit is a long-term or short-term debt. The amount of the debt must be repaid in the form of monthly or annual payments.

This simulator generates a table that calculates the annual and monthly payments.

Two calculation methods for the payments

There are two calculation methods for the annual or monthly payments:

• Constant payments: The payment amount stays the same throughout the term of the loan.
• Constant amortization: The amortization (principal) amount stays the same throughout the term of the loan.

Payment frequency

You can choose the repayment frequency of your loan: monthly or annual.

The frequency determines how often you make your payments and has a direct impact on the total interest: a monthly frequency generates less interest than an annual one, because the principal is paid down more frequently, reducing the base on which interest is calculated.

Loan table

This free simulator generates a loan table with the following information: the year, the remaining balance, the interest to pay, the amortization, the annual payment, the monthly payment and the net value of the loan. You also get the total interest to pay over the entire term.

Definitions

• Year: The year of the loan.
• Interest: The amount of interest to pay.
• Amortization: The principal amount repaid.
• Annual payment: The total amount to repay each year.
• Monthly payment: The total amount to repay each month.
• Remaining balance: The principal amount still to be repaid at a given time.

Results history and export

By pressing the Save button, the loan simulator keeps a history of the results. You can export the loan table in CSV or PDF format.

Delete the data

To delete the data, press the Clear button. This erases all the data entered in the loan simulator.

Shortcuts

m ⇝ Clear

f ⇝ Save