Financial Statement Analysis, US GAAP vs IFRS Inventory & LIFO Conformity
LIFO Reserve to FIFO Inventory, COGS & Tax Shield Formula
Convert US GAAP LIFO Financial Statements to IFRS-Comparable FIFO: FIFO Ending Inventory (LIFO + Reserve), FIFO COGS (LIFO COGS - ΔReserve), Cumulative Cash Tax Saved, and LIFO Liquidation Phantom Profit Detection.
Get the ΔLIFO-Reserve sign right—and catch artificial LIFO layer liquidations!
Because IFRS strictly prohibits Last-In, First-Out (LIFO) accounting while US GAAP permits LIFO under the IRS Section 472 LIFO Conformity Rule, equity analysts comparing US industrial/refining companies against European peers must convert LIFO financials to First-In, First-Out (FIFO) using the disclosed LIFO Reserve! On the balance sheet, FIFO_Ending_Inventory = LIFO_Inventory + Ending_LIFO_Reserve, and Cumulative Cash Taxes Deferred = Ending_LIFO_Reserve * Tax_Rate (leaving Retained Earnings higher by Ending_LIFO_Reserve * (1 - Tax_Rate)). On the income statement, watch the sign carefully: FIFO_COGS = LIFO_COGS - (Ending_LIFO_Reserve - Beginning_LIFO_Reserve)! Conversely, when destocking shrinks the LIFO Reserve (ΔReserve < 0), old cheap cost layers flow through COGS, inflating GAAP gross margin with non-recurring "LIFO Liquidation" phantom profit!
Verify on a Specialty Chemicals 10-K Footnote—Reported_LIFO_Inventory = $180.00M (B2), Ending_LIFO_Reserve = $45.00M (B3 -> Replacement-Cost FIFO Inventory = 180 + 45 = $225.00M in E2), Beginning_LIFO_Reserve = $33.00M (ΔReserve = +$12.00M, B4), Reported_LIFO_COGS = $620.00M (B5 -> Comparable FIFO COGS = 620 - 12 = $608.00M in E3), and Tax_Rate = 0.25 (25.0%, B6): Cumulative Cash Taxes Saved equal 45 * 0.25 = $11.25M (E4), and FIFO-Adjusted Retained Earnings Lift is 45 * 0.75 = $33.75M (E5)!
| LIFO-to-FIFO Conversion Metric ($180M Inv, $33M -> $45M Reserve, $620M COGS, 25% Tax) | Formula | Verified Output |
|---|---|---|
| FIFO Ending Inventory ($M) | LIFO_Inventory + Ending_LIFO_Reserve | $225.00M ($205.00M @ $25M Res) |
| FIFO Adjusted COGS ($M) | LIFO_COGS - (End_Reserve - Beg_Reserve) | $608.00M ($628.00M Liquidation!) |
| Cumulative Cash Tax Saved ($M) | Ending_LIFO_Reserve * Tax_Rate | $11.25M |
| FIFO Retained Earnings Lift ($M) | Ending_LIFO_Reserve * (1 - Tax_Rate) | $33.75M |
LIFO-to-FIFO Adjusted Cost of Goods Sold (COGS) Formula
Validate LIFO_Inventory >= 0, non-negative Beginning and Ending LIFO Reserves, LIFO_COGS > 0, and Tax_Rate in [0, 0.55)!
=LET(iv_l, B2, rs_1, B3, rs_0, B4, cg_l, B5, tx_r, B6, IF(OR(iv_l < 0, rs_1 < 0, rs_0 < 0, cg_l <= 0, tx_r < 0, tx_r >= 0.55), "Invalid LIFO Footnote Input", ROUND(cg_l - (rs_1 - rs_0), 2)))LIFO Layer Liquidation Phantom-Profit Check (Set Ending LIFO Reserve = $25.00M)
Drop Ending_LIFO_Reserve B3 from $45.00M down to $25.00M (below $33.00M Beginning Reserve -> ΔReserve = -$8.00M destocking): True Replacement-Cost FIFO COGS E3 jumps ABOVE reported LIFO COGS to 620 - (-8) = $628.00M, stripping out $8.00M of unsustainable LIFO-liquidation gross profit!
=IF(ISTEXT(E3), E3, ROUND(B3 * (1 - B6), 2))Try the example
Use the original values or change them to test your understanding.