IFRS 16 Calculator Documentation

Entity Name

The name of the reporting entity. Used in disclosure note headings and Excel export headers. Does not affect calculations.

Reporting Date

The financial year-end date for which disclosure extracts are generated. The tool uses this to split the lease liability into current and non-current portions and to produce SOFP and SOCI extracts for the correct period.

Lease Term (Years)

The non-cancellable lease term. Per IFRS 16, include extension periods the lessee is reasonably certain to exercise and exclude termination option periods the lessee is reasonably certain to exercise. Enter as a decimal if needed (e.g., 2.5 for a two-and-a-half year lease).

Lease Payment Per Period

The fixed lease payment amount per payment period. Do not divide by the number of periods per year — if you pay Rs. 50,000 monthly, enter 50,000. The tool handles frequency conversion internally.

Payment Frequency

Monthly, Quarterly, or Annually. Determines the number of periods per year (12, 4, or 1) and the periodic interest rate used in the amortization loop.

Payment Timing

In Advance (annuity due) or In Arrears (ordinary annuity). In Advance means the first payment falls on the commencement date. In Arrears means the first payment falls at the end of the first period. The interest calculation formula differs between the two — the engine applies the correct formula automatically.

Incremental Borrowing Rate (IBR)

The annual rate the lessee would pay to borrow, over a similar term and with similar security, the funds needed to obtain an asset of similar value. Enter as a percentage — for 10% enter 10, not 0.10.

Lease Commencement Date

The date on which the lessor makes the underlying asset available for use. This is the date the first journal entry is booked and the first row of the amortization schedule is dated.

Advanced Day-1 Parameters (Optional):

• Guaranteed Residual Value (GRV): Amount the lessee guarantees to the lessor at the end of the lease term. Included in lease payments and in the PV calculation. Final period payment = regular PMT + GRV.
• Purchase Option Exercise Price: The price at which the lessee can purchase the asset at end of term. Include only if reasonably certain to be exercised per IFRS 16.
• Initial Direct Costs (IDC): Incremental costs to obtain the lease (commissions, legal fees). Added to ROU asset cost. Generates a separate Day-1 journal entry.
• Lease Incentives Received: Cash received from the lessor as an incentive. Reduces ROU asset cost. Generates a Dr Cash / Cr ROU Asset journal entry.
• PV of Dismantling Costs: Present value of the estimated cost to restore the underlying asset at end of lease, if the lessee has an obligation under IAS 37. Added to ROU asset cost with a corresponding provision entry.
• Useful Life of Asset: Required when a Purchase Option exists or ownership transfers. Overrides the lease term as the depreciation period per IFRS 16.

Lease Liability Amortization Table

Columns: Date, Period, Opening Balance, Interest Expense, Lease Payment, Closing Balance. The Interest Expense column represents the effective interest for the period (Opening Balance × periodic rate for arrears; post-payment balance × periodic rate for advance). The Closing Balance should reach zero on the final row.

ROU Asset Schedule

Columns: Date, Period, Opening ROU Asset, Depreciation, Closing ROU Asset. Depreciation is straight-line: initial ROU cost divided by the number of periods. For purchase option scenarios, cost is divided by useful life periods instead.

KPI Summary Cards

Four summary figures appear above the tables: Initial Lease Liability (the PV at commencement), Initial ROU Asset Cost (may differ from liability if Day-1 adjustments exist), Total Lease Payments (undiscounted sum of all payments), and Total Interest Expense (total finance cost over the lease term).

Journal Entries Tab

Dated entries for every transaction from Day 1 through the final period. Pre-modification entries appear first, followed by modification entries if applicable, followed by post-modification entries.