Corporate Income Tax Footnote Analysis & US GAAP ASC 740
ASC 740 Valuation Allowance, UTP & Effective Tax Rate Formula
Reconcile US GAAP ASC 740 Statutory Income Tax Expense to Total GAAP Tax Provision Across Permanent Differences, Deferred-Tax Valuation Allowance Changes, Uncertain Tax Position (FIN 48) Reserves, and Effective Tax Rate (ETR).
Read the ASC 740 Effective Tax Rate reconciliation like a forensic equity analyst!
Why does a corporation facing a 21.0% US federal statutory tax rate suddenly report a 33.0%—or 18.0%—GAAP Effective Tax Rate (ETR = Total_GAAP_Tax_Provision / Pretax_Book_Income)? Under US GAAP ASC 740, Total Tax Provision starts at Expected Statutory Tax = Pretax_Income * Statutory_Rate, then adds Permanent Non-Deductible Tax Items (executive 162(m) comp, meals/fines), Net Change in Deferred-Tax Valuation Allowance Delta_VA (recorded whenever it becomes >50% "more likely than not" that foreign or state NOL Deferred Tax Assets will expire unused—and NEGATIVE when a turnaround releases a prior Valuation Allowance!), plus ASC 740-10 (FIN 48) Uncertain Tax Position (UTP) reserve accruals!
Verify on an Industrial Footnote Rate Reconciliation—Pretax_Book_Income = $50.00M (B2), Federal_Statutory_Rate = 0.21 (21.0%, B3 -> Statutory Tax = $10.50M in E2), Permanent_Items_Tax_Effect = $1.00M (B4), Valuation_Allowance_Change = +$3.50M (new foreign DTA reserve, B5), and FIN48_UTP_Reserve_Increase = $1.50M (B6): Total GAAP Tax Provision is 10.50 + 1.00 + 3.50 + 1.50 = $16.50M (E3); GAAP Effective Tax Rate jumps to 16.50 / 50.00 = 0.3300 (33.00% in E4); and Valuation Allowance alone accounts for +3.50 / 50.00 = +0.0700 (+7.00 percentage points of ETR in E5)!
| ASC 740 Rate Reconciliation ($50M Pretax, 21% Stat, +$1M Perm, +$3.5M VA, +$1.5M UTP) | Formula | Verified Output |
|---|---|---|
| Expected Statutory Tax ($M) | Pretax_Book_Income * Statutory_Rate | $10.50M |
| Total GAAP Tax Provision ($M) | Stat_Tax + Perm_Tax + VA_Change + UTP | $16.50M ($9.00M @ -$4M VA Release) |
| GAAP Effective Tax Rate ETR | Total_GAAP_Tax_Provision / Pretax_Income | 0.3300 (0.1800 @ -$4M VA Release) |
| Valuation Allowance ETR Impact | VA_Change / Pretax_Book_Income | +0.0700 (+7.00% ETR Drag) |
ASC 740 Effective Tax Rate (ETR) Reconciliation Formula
Validate Pretax_Book_Income > 0 (meaningful positive ETR denominator) and Statutory_Rate in (0, 0.55)!
=LET(pt_i, B2, st_r, B3, pm_t, B4, va_d, B5, ut_p, B6, IF(OR(pt_i <= 0, st_r <= 0, st_r >= 0.55), "Invalid ASC 740 Rate Input", LET(pr_v, pt_i * st_r + pm_t + va_d + ut_p, ROUND(pr_v / pt_i, 4))))Turnaround Valuation-Allowance Release Check (Set VA Change = -$4.00M)
Simulate sustained profitability allowing management to release -$4.00M of prior Valuation Allowance (B5 = -4.0): Total Tax Provision E3 drops to $9.00M and GAAP ETR E4 falls to 0.1800 (18.00%—a non-recurring earnings tailwind analysts strip out of normalized EPS)!
=IF(ISTEXT(E4), E4, ROUND(B5 / B2, 4))Try the example
Use the original values or change them to test your understanding.