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
Write a review
People using this Best Practice also downloaded
Your new Excel buddy… toolKCit for Excel!toolKCit is a new toolbar for Excel to help you work more efficiently in Excel and provides 19 useful tools in six areas323add_shopping_cart$9.50by Gary Knott
Let it snow! Excel@ChristmasLet it snow in Excel!209add_shopping_cart
The Best Excel ShortcutsA one page PDF with the best & most useful Microsoft Excel Shortcuts.106add_shopping_cart
Simulate the number of Corona virus infectionsSimulate Corona virus infection rates350add_shopping_cart
Coronavirus Heat Map Excel ModelCreate a heat map to show Corona virus cases561add_shopping_cart
Simulate Christmas tree lights in ExcelSimulate Christmas tree lights in Excel32add_shopping_cart
Any questions on Loan Amortisation Schedules?
The user community and author are here to help. Go ahead!