Corporate Accounting & Pension Actuarial GAAP
ASC 715 Pension 10% Corridor & NPPC Formula
Calculate US GAAP ASC 715 Pension 10% Corridor Threshold 0.10 * MAX(PBO, Plan_Assets), Excess Actuarial Loss Amortization, Net Periodic Pension Cost (NPPC), and Balance-Sheet Funded Status.
Apply the 10% MAX(PBO, Plan_Assets) corridor before amortizing pension AOCI losses!
Under US GAAP ASC 715 (formerly FAS 87), unexpected discount-rate swings and asset return shortfalls accumulate in Accumulated Other Comprehensive Income (AOCI) rather than hitting the income statement immediately! To smooth offsetting market noise, ASC 715 establishes a 10% Smoothing Corridor equal to 0.10 * MAX(Beginning_PBO, Market_Related_Plan_Assets): ONLY the excess of Unrecognized Net Actuarial Loss (or Gain) ABOVE that 10% corridor is amortized over active employees’ Average Remaining Service Period: Corridor_Amort = MAX(0, ABS(AOCI_Loss) - 0.10 * MAX(PBO, Assets)) / Avg_Service_Years, feeding into Net Periodic Pension Cost NPPC = (Service_Cost + Interest_Cost) - Expected_Return_EROA + Corridor_Amort!
Verify on Beginning_PBO = $500.0M (B2), Beginning_Plan_Assets = $450.0M (B3 -> 10% Corridor = 0.10 * MAX(500, 450) = $50.00M in E2, Funded Status = -$50.00M liability in E5), Unrecognized_AOCI_Loss = $110.0M (B4 -> $60.0M excess above corridor), Avg_Remaining_Service = 12 years (B5 -> Annual Corridor Amortization = 60 / 12 = $5.00M in E3), Service_Plus_Interest_Cost = $48.0M (B6), and Expected_Return_EROA = $36.0M (B7): Net Periodic Pension Cost NPPC equals 48 - 36 + 5 = $17.00M (E4)!
| ASC 715 Pension Metric (PBO=$500M, Assets=$450M, Loss=$110M, 12 Yrs, Cost=$48M, EROA=$36M) | Formula | Verified Output |
|---|---|---|
| 10% Corridor Threshold ($M) | 0.10 * MAX(Beg_PBO, Beg_Plan_Assets) | $50.00M ($60.00M @ $600M Assets) |
| Minimum Corridor Amortization | MAX(0, Loss - Corridor) / Service_Yrs | $5.00M ($0.00M @ $40M Loss) |
| Net Periodic Pension Cost NPPC | Service_Interest - EROA + Amort | $17.00M ($12.00M @ $40M Loss) |
| Balance-Sheet Funded Status ($M) | Plan_Assets - PBO | -$50.00M (+$100M @ $600M Assets) |
ASC 715 Net Periodic Pension Cost (NPPC) with 10% Corridor Formula
Validate PBO > 0, Plan_Assets >= 0, Unrecognized_Loss >= 0, Service_Years > 0, and Service_Interest >= 0!
=LET(pb_o, B2, as_t, B3, ls_u, B4, sv_y, B5, si_c, B6, er_a, B7, IF(OR(pb_o <= 0, as_t < 0, ls_u < 0, sv_y <= 0, si_c < 0, er_a < 0), "Invalid ASC 715 Actuarial Input", LET(cr_d, 0.1 * MAX(pb_o, as_t), am_t, MAX(0, ls_u - cr_d) / sv_y, ROUND(si_c - er_a + am_t, 2))))Inside-Corridor Zero-Amortization & Overfunded Asset-Base Checks
Drop Unrecognized_Loss to $40.0M (<= $50.0M corridor): Amortization E3 hits $0.00M and NPPC drops to $12.00M! Raise Plan_Assets to $600.0M (> PBO): MAX(500, 600) lifts the corridor to $60.0M and Amortization becomes 50 / 12 = $4.17M!
=IF(ISTEXT(E4), E4, ROUND(B3 - B2, 2))Try the example
Use the original values or change them to test your understanding.