Automated Lease Accounting (IFRS 16 / ASC 842) Right-of-Use Asset & Liability Schedule

Professional Guide

This schedule computes right-of-use assets and lease liabilities for lease accounting standards by discounting future lease payments, allocating interest and principal via an amortization table, and recording lease expense recognition patterns (interest + amortization for finance leases or straight-line for operating leases under ASC 842 presentation differences). It supports lease modifications, remeasurement triggers, and variable payment handling. The workbook outputs journal entries, maturity analyses, and disclosure schedules, and links to capex forecasts for covenants. Use this to accelerate month-end lease accounting with clear audit trails and sensitivity tables for discount-rate choices.