Loan Amortization Table Calculator

What is a loan amortization table?

An amortization table describes the repayment of a loan to the lender with interest. Based on the loan's amount, interest rate, and length, a monthly payment is determined that the must be paid to the lender. Each payment includes a portion that is interest while the rest is applied to the balance. The amount of interest paid each time is based on the remaining balance of the loan. Payments continue until the remaining balance of the loan is zero.

When do you use an amortization table?

An amortization table can be used anytime money is borrowed from a lender. The most common uses of an amortization table are for mortgages or car loans.

How is the monthly payment amount determined?

Determining the monthly (i.e., periodic) payment of a loan with interest requires a complicated formula:

Where A is the monthly or periodic payment, P is the loan's initial amount, i is the periodic interest rate, and n is the total number of payments.

Fortunately you can use the calculator above to determine the monthly payment and complete amortization table automatically.