Excel provides formulas to assist in creating basic amortization schedules. For more advanced amortization schedules that involve uneven or complex cashflow events, specialized amortization software is easier and generally the accepted method used to create loan amortization schedules.

The following excel formulas can be used to assist in the creation of simple amortization schedules:

Summary

Excel provides functions for calculating some of basic amortization schedules used in accounting.