Loan Amortization Schedule in Microsoft Excel

Description
An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated by an amortization calculator. Amortization refers to the process of paying off a debt over time through regular payments.

What Is an Amortization Schedule?
An amortization schedule is a complete table of periodic loan payments, showing the amount of principal and the amount of interest that comprise each payment until the loan is paid off at the end of its term. Each periodic payment is the same amount in total for each period. However, early in the schedule, the majority of each payment is what is owed in interest; later in the schedule, the majority of each payment covers the loan's principal. The last line of the schedule shows the borrower’s total interest and principal payments for the entire loan term.

This loan calculator - also known as an amortization schedule calculator - lets you estimate your monthly loan repayments. It also determines out how much of your repayments will go towards the principal and how much will go towards interest.

An amortization schedule is a table that shows each periodic loan payment that is owed, typically monthly, and how much of the payment is designated for the interest versus the principal.