Free template with formulas. Use this free loan amortization template to create a monthly loan amortization table for any loan period up to 30 years.Enter your loan details in the green boxes. 5. Loan Amount, Interest Rate, Term in Years. An amortisation schedule is a table that displays the remaining balance following each payment, breaks down each instalment in interest and Principal, Use the following formulas to show the total payment, interest portion of the payment, and principal portion of the payment.