The following incomplete (columns have missing amounts) pension spreadsheet is for Old Tucson Corporation (OTC).
- What is OTC's pension expense for the year?

Question

The following incomplete (columns have missing amounts) pension spreadsheet is for Old Tucson Corporation (OTC). 
- What is OTC's pension expense for the year?

Quizplus · Accepted Answer

Service cost (from pension expense column) = $62
Interest cost = ($574) + 500 + 62 (from pension expense column) + $25 - 43 = ($30) = $30 in pension expense column
Expected return on assets (given) = ($23)
Amortization of prior service cost = from prior service column = $6
Amortization of net loss = $78 - 58 + 2 - 25 = ($3) = $3 in pension expense column
Pension expense = $62 + 30 - 23 + 6 +3 = $78

The Following Incomplete (Columns Have Missing Amounts) Pension Spreadsheet Is