To build a loan or mortgage amortization schedule in Excel, we will need to use the following functions: How to create a loan amortization schedule in Excel Loan amortization schedule with additional payments.Amortization schedule for a variable number of periods.How to create a loan amortization schedule in Excel.To detail each payment on a loan, you can build a loan amortization schedule.Īn amortization schedule is a table that lists periodic payments on a loan or mortgage over time, breaks down each payment into principal and interest, and shows the remaining balance after each payment. Each payment applies some amount towards principal and some towards interest. For example, a fully amortizing loan for 24 months will have 24 equal monthly payments.
The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage.Īn amortizing loan is just a fancy way to define a loan that is paid back in installments throughout the entire term of the loan.īasically, all loans are amortizing in one way or another.
