You can delve deep into the formulas used in my Loan Amortization Schedule template listed above, but you may get lost, because that template has a lot of features and the formulas can be complicated.
My article ' Amortization Calculation' explains the basics of how loan amortization works and how an amortization table or 'schedule' is created. Learn how to create a simple amortization chart with this example template.