# The Pension Accounting Handbook: companion files

Julian R. Sterling, julianrsterling.com/asc715

## What is here

- **Pension_Accounting_Model.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Kessenridge Fabrication, Inc., a listed maker of castings, its funded pension plan and its unfunded retiree medical plan, at 31 December 2025 and 2026. Every case figure is a teaching assumption, never a market figure.

## The eleven tabs, in the order to read them

1. **Inputs**: every typed number of the case, with a column for each year, and two selectors (market-related value method; gain and loss policy).
2. **Obligation**: the roll-forward of the projected benefit obligation, the actuarial result closing it to the actuary's figure.
3. **Assets**: the roll-forward of plan assets, the expected return and the asset gain or loss.
4. **Cost**: net periodic pension cost component by component, service cost apart from the other components.
5. **Corridor**: the 10 percent corridor, the excess and its amortization.
6. **Settlement**: the threshold test of the lump-sum window, the share settled and the settlement loss.
7. **OPEB**: the retiree medical plan, its amendment, its corridor and its attribution.
8. **BalanceSheet**: the funded status, accumulated other comprehensive income and the entries.
9. **IAS19**: the same pension plan under IAS 19, for comparison.
10. **Note**: the tables of the pension note.
11. **Checks**: each key figure reached by two routes; the status at the top must read ALL PASS.

## How to use it

Change one input at a time on Inputs, follow it to the cost and the balance sheet, and read Checks before any figure. The workbook takes the actuary's closing obligations as inputs: it rolls everything else but does not rebuild the valuation.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not accounting, actuarial or audit advice: your plan's facts govern, and its accountants, actuaries and auditors decide.
