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
____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____
_____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________ _____________
__________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________
____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________ ____________
__________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________