Corporate Lease Accounting & US GAAP ASC 842
ASC 842 Operating Lease ROU Asset & Plug Amortization
Calculate US GAAP ASC 842 Day-1 Right-of-Use (ROU) Asset (Liability_PV + Direct_Costs - TI_Incentives), Single Straight-Line Annual Lease Expense, Year-1 Liability Discount Accretion, and Year-1 Plug ROU Amortization.
Master ASC 842’s dual-model operating lease "plug" ROU amortization vs IFRS 16!
While both IFRS 16 and US GAAP ASC 842 put multi-year office and warehouse leases onto the balance sheet, ASC 842 preserves a crucial Operating Lease distinction on the income statement! At lease commencement, Day-1 Right-of-Use (ROU) Asset = Lease_Liability_PV + Initial_Direct_Costs - Landlord_Lease_Incentives (cash tenant-improvement reimbursements received from the landlord REDUCE the ROU asset!). Unlike IFRS 16—which charges front-loaded interest PLUS straight-line ROU depreciation—ASC 842 Operating Leases recognize ONE flat Annual Straight-Line Lease Cost = (Total_Undiscounted_Lease_Payments + Initial_Direct_Costs - Landlord_Incentives) / Term_Years, making Year-1 ROU Asset Amortization an accelerating "plug": Year1_ROU_Amort = Straight_Line_Lease_Cost - (Lease_Liability_PV * Discount_Rate_IBR)!
Verify on a 5-Year Headquarters Lease—Day1_Lease_Liability_PV = $850,000 (B2), Initial_Direct_Commissions = $30,000 (B3), Landlord_TI_Incentive_Received = $120,000 (B4 -> Day-1 ROU Asset = 850,000 + 30,000 - 120,000 = $760,000 in E2), Total_Undiscounted_Cash_Rent = $1,000,000 (B5), Lease_Term = 5 years (B6), and Incremental_Borrowing_Rate IBR = 0.06 (6.0%, B7): Single Straight-Line Lease Expense is (1,000,000 + 30,000 - 120,000) / 5 = $182,000/yr (E3); Year-1 Liability Imputed Interest is 850,000 * 0.06 = $51,000 (E4); and Year-1 ROU Asset Amortization (plug) is 182,000 - 51,000 = $131,000 (E5)!
| ASC 842 Operating Lease ($850k PV, $30k IDC, $120k TI, $1M Cash, 5 Yr, 6% IBR) | Formula | Verified Output |
|---|---|---|
| Day-1 Right-of-Use (ROU) Asset | Liability_PV + Direct_Costs - TI_Incentive | $760,000 ($880,000 @ $0 TI) |
| Straight-Line Annual Lease Cost | (Total_Cash_Rent + IDC - TI) / Term_Yrs | $182,000/yr ($206,000 @ $0 TI) |
| Year-1 Liability Accretion ($) | Liability_PV * Discount_Rate_IBR | $51,000 |
| Year-1 Plug ROU Amortization ($) | Straight_Line_Cost - Liability_Interest | $131,000 ($155,000 @ $0 TI) |
ASC 842 Operating Lease Year-1 Plug ROU Amortization Formula
Validate Liability_PV > 0, non-negative IDC and TI incentives (with ROU_Asset > 0), Total_Undiscounted_Rent >= Liability_PV, Term_Yrs >= 1, and IBR > 0!
=LET(pv_l, B2, id_c, B3, ti_r, B4, cs_r, B5, tr_y, B6, ib_r, B7, IF(OR(pv_l <= 0, id_c < 0, ti_r < 0, pv_l + id_c - ti_r <= 0, cs_r < pv_l, tr_y < 1, ib_r <= 0), "Invalid ASC 842 Lease Schedule", LET(sl_c, (cs_r + id_c - ti_r) / tr_y, in_1, pv_l * ib_r, ROUND(sl_c - in_1, 2))))Zero-Incentive Baseline Check (Set Landlord TI Incentive = $0)
Set Landlord_TI_Incentive B4 = $0: Day-1 ROU Asset E2 rises to $880,000, Straight-Line Cost E3 becomes $206,000/yr, and Year-1 Plug ROU Amortization E5 increases to $155,000!
=IF(ISTEXT(E5), E5, ROUND(B2 + B3 - B4, 2))Try the example
Use the original values or change them to test your understanding.