Free tool · no account
IFRS 16 lease calculator
Enter the periodic lease payment, term and incremental borrowing rate (IBR) to calculate the opening lease liability, right-of-use (ROU) asset, initial journal entry and full amortisation schedule — downloadable as Excel for free.
Lease contract inputs
Initial measurement (IFRS 16.22–26)
- Lease liability (present value)
- €84,465.59
- Right-of-use (ROU) asset
- €84,465.59
- Total lease payments
- €90,000.00
- Total interest unwind
- €5,534.41
Opening journal entry at commencement
| Line item | Debit | Credit |
|---|---|---|
| Right-of-use (ROU) asset | €84,465.59 | — |
| Lease liability | — | €84,465.59 |
Amortisation & ROU depreciation schedule
| # | Period end | Opening liability | Interest | Payment | Principal | Closing liability | ROU depreciation | Closing ROU |
|---|---|---|---|---|---|---|---|---|
| 1 | 2027-01-31 | €84,465.59 | €301.21 | €2,500.00 | €2,198.79 | €82,266.80 | €2,346.27 | €82,119.32 |
| 2 | 2027-02-28 | €82,266.80 | €293.13 | €2,500.00 | €2,206.87 | €80,059.93 | €2,346.27 | €79,773.05 |
| 3 | 2027-03-31 | €80,059.93 | €285.02 | €2,500.00 | €2,214.98 | €77,844.95 | €2,346.27 | €77,426.78 |
| 4 | 2027-04-30 | €77,844.95 | €276.88 | €2,500.00 | €2,223.12 | €75,621.83 | €2,346.27 | €75,080.51 |
| 5 | 2027-05-31 | €75,621.83 | €268.71 | €2,500.00 | €2,231.29 | €73,390.54 | €2,346.27 | €72,734.24 |
| 6 | 2027-06-30 | €73,390.54 | €260.51 | €2,500.00 | €2,239.49 | €71,151.05 | €2,346.27 | €70,387.97 |
| 7 | 2027-07-31 | €71,151.05 | €252.28 | €2,500.00 | €2,247.72 | €68,903.33 | €2,346.27 | €68,041.70 |
| 8 | 2027-08-31 | €68,903.33 | €244.02 | €2,500.00 | €2,255.98 | €66,647.35 | €2,346.27 | €65,695.43 |
| 9 | 2027-09-30 | €66,647.35 | €235.73 | €2,500.00 | €2,264.27 | €64,383.08 | €2,346.27 | €63,349.16 |
| 10 | 2027-10-31 | €64,383.08 | €227.41 | €2,500.00 | €2,272.59 | €62,110.49 | €2,346.27 | €61,002.89 |
| 11 | 2027-11-30 | €62,110.49 | €219.06 | €2,500.00 | €2,280.94 | €59,829.55 | €2,346.27 | €58,656.62 |
| 12 | 2027-12-31 | €59,829.55 | €210.68 | €2,500.00 | €2,289.32 | €57,540.23 | €2,346.27 | €56,310.35 |
| 13 | 2028-01-31 | €57,540.23 | €202.26 | €2,500.00 | €2,297.74 | €55,242.49 | €2,346.27 | €53,964.08 |
| 14 | 2028-02-29 | €55,242.49 | €193.82 | €2,500.00 | €2,306.18 | €52,936.31 | €2,346.27 | €51,617.81 |
| 15 | 2028-03-31 | €52,936.31 | €185.34 | €2,500.00 | €2,314.66 | €50,621.65 | €2,346.27 | €49,271.54 |
| 16 | 2028-04-30 | €50,621.65 | €176.84 | €2,500.00 | €2,323.16 | €48,298.49 | €2,346.27 | €46,925.27 |
| 17 | 2028-05-31 | €48,298.49 | €168.30 | €2,500.00 | €2,331.70 | €45,966.79 | €2,346.27 | €44,579.00 |
| 18 | 2028-06-30 | €45,966.79 | €159.73 | €2,500.00 | €2,340.27 | €43,626.52 | €2,346.27 | €42,232.73 |
| 19 | 2028-07-31 | €43,626.52 | €151.13 | €2,500.00 | €2,348.87 | €41,277.65 | €2,346.27 | €39,886.46 |
| 20 | 2028-08-31 | €41,277.65 | €142.50 | €2,500.00 | €2,357.50 | €38,920.15 | €2,346.27 | €37,540.19 |
| 21 | 2028-09-30 | €38,920.15 | €133.84 | €2,500.00 | €2,366.16 | €36,553.99 | €2,346.27 | €35,193.92 |
| 22 | 2028-10-31 | €36,553.99 | €125.14 | €2,500.00 | €2,374.86 | €34,179.13 | €2,346.27 | €32,847.65 |
| 23 | 2028-11-30 | €34,179.13 | €116.41 | €2,500.00 | €2,383.59 | €31,795.54 | €2,346.27 | €30,501.38 |
| 24 | 2028-12-31 | €31,795.54 | €107.66 | €2,500.00 | €2,392.34 | €29,403.20 | €2,346.27 | €28,155.11 |
| 25 | 2029-01-31 | €29,403.20 | €98.86 | €2,500.00 | €2,401.14 | €27,002.06 | €2,346.27 | €25,808.84 |
| 26 | 2029-02-28 | €27,002.06 | €90.04 | €2,500.00 | €2,409.96 | €24,592.10 | €2,346.27 | €23,462.57 |
| 27 | 2029-03-31 | €24,592.10 | €81.18 | €2,500.00 | €2,418.82 | €22,173.28 | €2,346.27 | €21,116.30 |
| 28 | 2029-04-30 | €22,173.28 | €72.30 | €2,500.00 | €2,427.70 | €19,745.58 | €2,346.27 | €18,770.03 |
| 29 | 2029-05-31 | €19,745.58 | €63.37 | €2,500.00 | €2,436.63 | €17,308.95 | €2,346.27 | €16,423.76 |
| 30 | 2029-06-30 | €17,308.95 | €54.42 | €2,500.00 | €2,445.58 | €14,863.37 | €2,346.27 | €14,077.49 |
| 31 | 2029-07-31 | €14,863.37 | €45.43 | €2,500.00 | €2,454.57 | €12,408.80 | €2,346.27 | €11,731.22 |
| 32 | 2029-08-31 | €12,408.80 | €36.41 | €2,500.00 | €2,463.59 | €9,945.21 | €2,346.27 | €9,384.95 |
| 33 | 2029-09-30 | €9,945.21 | €27.36 | €2,500.00 | €2,472.64 | €7,472.57 | €2,346.27 | €7,038.68 |
| 34 | 2029-10-31 | €7,472.57 | €18.27 | €2,500.00 | €2,481.73 | €4,990.84 | €2,346.27 | €4,692.41 |
| 35 | 2029-11-30 | €4,990.84 | €9.15 | €2,500.00 | €2,490.85 | €2,499.99 | €2,346.27 | €2,346.14 |
| 36 | 2029-12-31 | €2,499.99 | €0.01 | €2,500.00 | €2,499.99 | €0.00 | €2,346.14 | €0.00 |
Managing multiple leases with CPI indexations and month-end close?
See how Fiatto automates lease modifications, CPI remeasurements, sale-and-leaseback and IFRS 16 disclosure notes.
How does this IFRS 16 calculator compute lease liability and ROU asset?
Under IFRS 16, lessees recognise almost every lease longer than twelve months on the balance sheet. The opening lease liability equals the present value of fixed lease payments discounted using the compound periodic rate derived from your annual incremental borrowing rate (IBR). When payments are due in advance, the first instalment is undiscounted (annuity due).
The right-of-use (ROU) asset starts at the opening lease liability plus initial direct costs minus lease incentives received. Each period, interest unwinds on the liability while the ROU asset depreciates straight-line to zero. This calculator runs on the exact same cent-exact engine used by Fiatto's general ledger.
Frequently asked questions
Should service charges and VAT be included in the lease payment?
No. Exclude recoverable VAT and non-lease components such as maintenance, cleaning or utilities unless you have elected the IFRS 16.15 practical expedient not to separate non-lease components.
Why is the monthly rate slightly different from the annual rate divided by twelve?
The engine uses the compound periodic rate (1 + r)^(1/12) − 1 so twelve monthly periods compound to the exact annual effective rate, with cent-exact closing reconciliation on the final instalment.
How does Fiatto handle annual CPI rent indexations?
In spreadsheets, every CPI adjustment or term extension forces manual remeasurement without overwriting closed periods. Fiatto calculates the remeasurement on the effective date and posts the adjustment automatically to the liability and ROU asset.
From standalone spreadsheets to a controlled IFRS 16 subledger
Fiatto tracks CPI indexations, renewal options and monthly depreciation per contract, reconciles with your ledger and prepares disclosure notes.