Lease Liability Schedule (IFRS 16) – Excel Template

Calculate the lease liability and right-of-use asset for an office, shop or vehicle lease, with monthly interest, payments and depreciation.

• Automatic summary: Initial lease liability, Right-of-use asset, Monthly depreciation, Total interest over the lease, Check: final liability (should be 0)
• Calculated for you: Month, Month starting, Opening liability, Payment, Interest, Closing liability, Depreciation, Right-of-use asset (closing)
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.