Question: Data for Penne Inc.'s defined benefit plan for Year 5 follows: At January 1: Projected benefit obligation (PBO), $120,000 Plan assets at fair value (Assets),
Data for Penne Inc.'s defined benefit plan for Year 5 follows:
At January 1:
- Projected benefit obligation (PBO), $120,000
- Plan assets at fair value (Assets), $90,000
- Prior service cost (PSC) balance in accumulated other comprehensive income (AOCI), $25,000
For Year 5:
- Service cost, $40,000
- Discount rate, 5%
- Expected rate of return on assets, 6%
- Amortization of PSC, $2,500
- Actual return on assets, $6,000
- PBO loss at year-end, $15,000
- Funding contribution at year-end, $40,000
- Benefits paid, $45,000
Complete the Year 5 pension spreadsheet below using the above information. Use parenthesis for negative amounts within categories, and for losses. Enter and extend your amounts to all appropriate cells. Enter 0 in any cell that does not require another entry.
| PBO | Assets | PSC in AOCI | Gain/loss in AOCI | Pension Expense | Pension Liability | |
| January 1 amounts | 123 | 123 | 123 | 123 | 123 | 123 |
| Service cost | 123 | 123 | 123 | 123 | 123 | 123 |
| Interest cost | 123 | 123 | 123 | 123 | 123 | 123 |
| Expected return | 123 | 123 | 123 | 123 | 123 | 123 |
| Asset gain/loss | 123 | 123 | 123 | 123 | 123 | 123 |
| PSC amortization | 123 | 123 | 123 | 123 | 123 | 123 |
| PBO loss | 123 | 123 | 123 | 123 | 123 | 123 |
| Funding | 123 | 123 | 123 | 123 | 123 | 123 |
| Benefits paid | 123 | 123 | 123 | 123 | 123 | 123 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
