Fixed | Ifrs 16 Lease Excel Template

An Excel template automates the reconciliation of these three moving parts.

This template is designed to help companies comply with IFRS 16 by automating the recognition of right-of-use (ROU) assets and lease liabilities. It includes: ifrs 16 lease excel template

Your final report should summarize three key areas for financial statement disclosure: leaseaccounts.com Report Section Key Figures to Include Balance Sheet (Net of depreciation) and Lease Liability (Split into Current vs. Non-current). Profit & Loss Depreciation Expense (Straight-line over term) and Interest Expense An Excel template automates the reconciliation of these

If you copy-paste a row, does the =PV formula shift? Use absolute references ( $B$4 ) for the IBR and $B$5 for payment. Lock your ranges using F4. Non-current)

You cannot use the rate in the lease contract. You must use the Incremental Borrowing Rate (IBR) —the rate the company would pay to borrow funds to buy the asset.

This results in a higher total expense in the early years of the lease (front-loaded expense) compared to the later years, which differs from the straight-line expense profile of the old operating lease standard.