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.
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
- Collect the lease terms. The document summary prompt in Lesson 8 helps.
- Paste the prompt below with your own figures.
- Check the opening liability in Excel with =PV(rate, years, -payment).
- Check that the liability falls to zero at the end of the lease.
- 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.
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
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
- In Excel, =PV(10%,5,-100000) returns 379,078.68, which agrees to the opening liability.
- The closing liability in Year 5 must be zero, allowing for rounding.
- Total interest (120,921) must equal total payments (500,000) minus the opening liability (379,079).
- If payments are in advance, every number changes: the first payment reduces the liability at once. Make sure the AI used the timing you gave.
- Check the discount rate and any options against the lease agreement, not the AI’s assumptions.
Common mistakes
- Treating payments in arrears as payments in advance, or the reverse.
- Depreciating over the asset’s full useful life when ownership does not transfer. In that case, use the shorter of the lease term and the useful life.
- Forgetting the current and non-current split in the statement of financial position.
Learn more
More recipes
Bank reconciliation with AI
এআই দিয়ে ব্যাংক রিকনসিলিয়েশন
Match a cash book against a bank statement, list unmatched items with likely reasons, and draft a bank reconciliation statement you can check line by line.
ChatGPTClaude
Salary income tax computation (Bangladesh)
বেতনভোগীর আয়কর হিসাব
Lay out a salaried person’s Bangladesh income tax computation step by step, using the rates and limits you paste from the current Finance Act, never the AI’s memory.
ChatGPTClaudeGoogle Gemini
Budget vs actual variance commentary
বাজেট বনাম প্রকৃত: ভ্যারিয়েন্স মন্তব্য
Turn a budget-versus-actual table into clear management commentary that flags material variances and uses only the reasons you supply, never invented ones.
ChatGPTClaudeCopilot in Excel
Sample figures are for learning only. Check every AI answer before you rely on it.