A home mortgage amortization spreadsheet is used by many financial institutions, banks and credit unions to determine how much of a loan the mortgagor will have to pay. Amortization is the process of paying off a mortgage loan over a period of time, generally 10 years or more. By subtracting the principal from the amount owed, a monthly payment is calculated.