Task recipe · Intermediate · 20 min

IFRS 16 lease liability schedule

আইএফআরএস ১৬ লিজ দায়ের সূচি

Calculate the initial lease liability and right-of-use asset, build the amortisation table and journal entries, then prove the numbers with Excel’s PV function.

Works well with ClaudeChatGPTMicrosoft Copilot in Excel

The problem

A company has signed a 5-year lease. You need the opening lease liability, a year-by-year schedule of interest and payments, depreciation of the right-of-use asset, and the journal entries.

What you need

  • Payment amount and timing (in arrears or in advance)
  • Lease term, including any options that are reasonably certain to be exercised
  • Discount rate: the rate implicit in the lease, or the lessee’s incremental borrowing rate
  • Any initial direct costs, lease incentives or payments made before commencement

Steps

  1. Collect the lease terms. The document summary prompt in Lesson 8 helps.
  2. Paste the prompt below with your own figures.
  3. Check the opening liability in Excel with =PV(rate, years, -payment).
  4. Check that the liability falls to zero at the end of the lease.
  5. Check that total interest equals total payments minus the opening liability.

The prompt

Copy it, then replace the example figures and [brackets] with your own.

Prompt
You are an IFRS specialist helping a lessee apply IFRS 16 Leases.

Facts:
- Annual lease payment: Tk 100,000, paid at the END of each year
- Lease term: 5 years, no extension or termination options
- Incremental borrowing rate: 10% a year (rate implicit in the lease not known)
- No initial direct costs, incentives or prepayments; no residual value guarantee
- Right-of-use asset depreciated straight-line over the lease term

Tasks:
1. Calculate the initial lease liability (present value of payments) and show the formula.
2. Build a table: Year | Opening liability | Interest at 10% | Payment | Closing liability. Round to whole taka and adjust the final year's interest for rounding so the closing balance is zero.
3. Calculate annual depreciation of the right-of-use asset.
4. Give the journal entries at commencement and for Year 1.
5. Split the Year 1 closing liability into current and non-current portions.

Show all working. Do not assume any fact not listed above.

What the AI should give you

Sample AI reply
1. Initial lease liability
   PV = 100,000 × [1 − 1.10^−5] ÷ 0.10 = 100,000 × 3.79079 = Tk 379,079

2. Lease liability schedule (Tk)
   Year | Opening | Interest 10% | Payment | Closing
   1    | 379,079 |  37,908      | 100,000 | 316,987
   2    | 316,987 |  31,699      | 100,000 | 248,686
   3    | 248,686 |  24,869      | 100,000 | 173,555
   4    | 173,555 |  17,356      | 100,000 |  90,911
   5    |  90,911 |   9,089 *    | 100,000 |       0
   Total interest 120,921   (* reduced by 2 for rounding)

3. Depreciation of right-of-use asset
   379,079 ÷ 5 years = Tk 75,816 a year

4. Journal entries
   Commencement   Dr Right-of-use asset        379,079
                      Cr Lease liability                 379,079
   End of Year 1  Dr Interest expense           37,908
                  Dr Lease liability            62,092
                      Cr Bank                            100,000
                  Dr Depreciation expense       75,816
                      Cr Acc. depreciation (ROU)          75,816

5. Year 1 closing liability                    316,987
   Current (Year 2 reduction: 100,000 − 31,699)  68,301
   Non-current                                  248,686

How to check it

Common mistakes

Learn more

More recipes

All recipes

Sample figures are for learning only. Check every AI answer before you rely on it.