The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Use mortgage calculator templates to figure out when you can pay off your loans or use budget calculator templates to help you save money.This amortization calculator shows the schedule of paying extra principal on your mortgage over time. Fill in the "Period" column. Fill in the column titled "Period" with your payment dates. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. This is an estimate of payments for various loan types including farm loans, land loans, ranch loans, livestock loans and ag loans.