Lease Amortisation Schedule: How to Build One Under IFRS 16 (With a Worked Example)

The lease amortisation schedule is the core calculation that sits underneath IFRS 16 and Ind AS 116 compliance. Every lease on your balance sheet needs one. Every month, it generates the journal entries that keep your financials accurate. When auditors arrive, they will ask to see it for every lease.

For a single lease, building the schedule is a manageable spreadsheet exercise. For an enterprise with 50, 100, or 300+ leases — with different start dates, payment frequencies, currencies, escalation clauses, and modification histories — it becomes a significant operational challenge.

This guide walks through exactly how a lease amortisation schedule works, provides a full worked example, and explains what breaks when you try to manage them at scale.

What a Lease Amortisation Schedule Does

A lease amortisation schedule tracks two things simultaneously over the life of a lease:

The lease liability — starting at the present value of future lease payments, increasing each period by interest accrued, and decreasing each period by the cash payment made. By the end of the lease term, the liability reaches zero.

The right-of-use (ROU) asset — starting at its initial measurement (usually close to the lease liability, plus initial direct costs and prepayments), amortised on a straight-line basis over the lease term. By the end of the lease term, the carrying value reaches zero.

The schedule runs from commencement date to end of lease term, typically with one row per period (monthly for most enterprise leases).

The Inputs You Need Before You Build

Before building the schedule, you need four pieces of information for every lease:

1. Commencement date — the date the lessee obtains the right to use the underlying asset.

2. Lease term — the non-cancellable period, plus any option periods the lessee is reasonably certain to exercise.

3. Lease payments — the fixed payment amounts, including any escalation schedule (indexed or fixed-step increases).

4. Discount rate — the interest rate implicit in the lease, or if that is not readily determinable, the lessee's incremental borrowing rate (IBR) at commencement. The IBR is the rate the lessee would pay to borrow funds to purchase an asset of similar value in a similar economic environment over a similar term.

Getting the IBR right is a judgement call that matters. A rate 1% higher or lower on a 10-year lease with ₹10L monthly payments changes the initial lease liability by approximately ₹1 crore.

Worked Example: Full Lease Amortisation Schedule

Lease parameters:

• Asset: Retail store premises, Mumbai
• Commencement date: 1 April 2024
• Non-cancellable term: 3 years (36 months)
• Monthly fixed payment: ₹3,00,000 (payable at end of each month)
• Incremental borrowing rate: 9% per annum (0.75% per month)
• Initial direct costs: ₹50,000
• Security deposit: ₹6,00,000 (refundable, not included in lease payments)

Step 1: Calculate the Lease Liability at Commencement

Lease liability = Present value of 36 monthly payments of ₹3,00,000 at 0.75% per month.

Using the present value of annuity formula:

PV = PMT × [1 − (1 + r)^−n] / r

PV = 3,00,000 × [1 − (1.0075)^−36] / 0.0075 PV = 3,00,000 × [1 − 0.7641] / 0.0075 PV = 3,00,000 × 31.45 PV (Lease Liability) = ₹94,35,000 (approximately)

Step 2: Calculate the ROU Asset at Commencement

ROU Asset = Lease liability + Initial direct costs ROU Asset = ₹94,35,000 + ₹50,000 = ₹94,85,000

*(Note: The refundable security deposit of ₹6,00,000 is recognised as a financial asset under IND AS 109/IFRS 9, not included in the ROU asset.)*

Step 3: Monthly ROU Asset Amortisation

Amortisation per month = ₹94,85,000 ÷ 36 = ₹2,63,472 per month (straight-line)

Step 4: The Monthly Schedule

Below is the lease amortisation schedule for the first six months and final two months:

*Final payment includes small rounding adjustment to close the liability to zero.

Step 5: The Journal Entries Each Month

On commencement (1 April 2024):

Each month (example: April 2024):

The total P&L charge for April: ₹2,63,472 (amortisation) + ₹70,763 (interest) = ₹3,34,235.

Compare this to the old straight-line operating lease model: ₹3,00,000 per month, flat. IFRS 16 produces a higher charge in early periods and lower in later periods — a front-loading effect that is material over a portfolio.

Handling Escalation Clauses

Most commercial leases include rent escalation. The treatment depends on the type:

Fixed-step escalation (e.g., rent increases by ₹20,000 on year 3): Include the escalated payments in the initial lease liability calculation. The schedule uses different payment amounts in different periods.

Index-linked escalation (e.g., rent increases by CPI each year): Initially calculate the liability using the current index rate. When the escalation is applied, remeasure the lease liability and adjust the ROU asset. Do not take the remeasurement through P&L.

Revenue-linked variable payments (e.g., percentage of store sales above a minimum): These are variable lease payments not dependent on an index. Exclude from the lease liability. Recognise in P&L when incurred.

For retail enterprises, index-linked and revenue-linked clauses are common. The remeasurement trigger for index-linked payments — and the accounting for it — is one of the areas where spreadsheet-based systems most commonly introduce errors.

Why Spreadsheets Break at Scale

A lease amortisation schedule for a single lease is a manageable spreadsheet. A portfolio of 200 leases is a different problem:

Different start dates. Every lease started on a different date. Monthly period rows don't align across leases.

Different currencies. A multinational enterprise has leases in INR, AED, USD, SGD. Each needs its own IBR. Translation to presentation currency adds another layer.

Modifications. A lease is renegotiated. The schedule needs to be rebuilt from the modification date using the new terms and a revised IBR. In a portfolio, modifications happen every month.

Version control. Who changed the IBR on lease 147? When? Why? Spreadsheets don't audit themselves.

Month-end timing. The schedules for all 200 leases need to generate journal entries before the books close. If any lease schedule is wrong, the balance sheet is wrong.

Auditor requests. "Please provide the amortisation schedule for all leases as at 31 March." Producing this from 200 separate spreadsheet tabs is a multi-day exercise.

What a System Does Differently

Hubler's Lease Management solution generates the amortisation schedule automatically for every lease in the portfolio — at commencement and after every modification. Each month, the system calculates the journal entries and posts them to the ERP. Auditors can export the complete schedule for the entire portfolio in minutes.

Modifications trigger an automatic remeasurement workflow: new terms are entered, the system recalculates the liability using the revised IBR, adjusts the ROU asset, and generates a modification journal. The audit trail is complete.

For enterprises managing leases across India, the UAE, Singapore, or anywhere else, multi-currency and multi-entity support means every subsidiary is running the same governed process, denominated in the right currency, with IFRS 16 and country-specific standards (Ind AS 116, IFRS 16 as adopted locally) both handled.

Related Reading

• IFRS 16: Complete Guide for Finance and Operations Leaders
• Right-of-Use Asset: Definition, Calculation and IFRS 16

*Managing lease amortisation schedules across a large portfolio?* Get a Demo →