Tabellab
Accounting Advanced

Lease Accounting: IFRS 16 & ASC 842 in Excel

Lease payments, the lease liability as a present value, the right-of-use asset, the liability schedule, the IFRS 16 vs ASC 842 cost pattern, journal entries, modifications, exemptions and the maturity analysis: 8 labs on one retailer’s leases.

8 lessons 8 labs 2.1 h Certificate

The first lesson is free — no account needed.

About this course

A lease accounting course that applies the lessee rules of IFRS 16 and ASC 842 to one retailer's store and warehouse leases, for accountants, auditors and accounting students. You decide which cash flows belong in the lease payments, measure the lease liability as the present value of payments in arrears and in advance, build the right-of-use asset from the liability, initial direct costs, incentives and restoration costs, run the five-year liability schedule and split it into current and non-current, compare the front-loaded IFRS 16 cost with the straight-line cost of an ASC 842 operating lease, book the entries at commencement and at year-end, remeasure the liability after an extension at a revised rate and apply the short-term and low-value exemptions before building the maturity analysis. An educational summary, not the text of the standards and not accounting advice. The first lab is free.

Lessons

  1. Which Payments Go into the Lease Liability?Lab14 minFree
  2. Lease Liability = Present Value of the PaymentsLab15 min Pro
  3. The Right-of-Use Asset: What Goes In and What Stays OutLab16 min Pro
  4. The Lease Liability Schedule & the Current PortionLab16 min Pro
  5. P&L Pattern: IFRS 16 Front-Loading vs ASC 842 Straight-LineLab16 min Pro
  6. Journal Entries at Commencement and at Year-EndLab16 min Pro
  7. Lease Modification: Remeasure at a Revised RateLab16 min Pro
  8. Short-Term & Low-Value Exemptions and the Maturity AnalysisLab17 min Pro