
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.
Further information
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