LOAN AMORTIZATION WORKSHEET Subtract Amortization Payment from Beginning Balance to get Balance. For the next year subtract Amortization Payment from last year's Balance to get new Balance. Balance column is ending balance for one year and beginning balance for next year. Beginning Balance Year Total Payment -Interest = Amortization Balance Year Total Payment -Interest = Amortization Balance ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________ ____ _____________ __________ ____________ __________