Last version published: 21/04/2021 05:56
Publication number: ELQ-31976-3
View all versions & Certificate
Loan amortisation schedules
Loan amortisation schedule in Microsoft Excel + PDF with explanations.
Gary Knott offers you this Best Practice for free!
download for free
Add to bookmarks
Do you need to check your loan repayments, depict a loan in a financial model or calculate your IFRS16 balances? Learn how to develop flexible amortisation schedules for loans and financial leases with simple inputs and automated calculations in Excel. You can also download a file with four versions for free!
When users have intermediate Excel and some financial knowledge
Users with little or no Excel or financial knowledge