To create an amortization schedule using Excel, you can use our Shop Amortization Calculator Excel which is able to handle the type of rounding required of an official payment schedule. The schedule also shows the remaining balance still owed after each payment is made, so you know how much you have left to pay. An amortization schedule is a list of payments for a mortgage or loan, which shows how each payment is applied or allocated to both the principal amount and the interest.
