Pension Worksheet–Kramer Co.xls Home Insert Page Layout Formulas Data Review View P18 fx A B C D E F G H General Journal Entries Memo Record Annual Pension Pension Projected Benefit OC-Prior Service Cost 4 OC- Asset/ 5 Items Expense Cash Gain/Loss Liability Obligation Plan Assets 6 Balance, Jan. 1, 2017 Service cost 120,000 325,000 205,000 Dr. (1) 20,000 Interest cost (2) 26,000 9 Actual return (3) 18,000 Dr. 10 Unexpected loss 11 Amortization of PSC 2,500 (4) (5) 35,000 12 Contributions 41,000 41,000 Dr. 13 Benefits 15,000 15,000 Cr. 14 Increase in PBO (6) 43,500 15 Journal entry for 2017 16 Accumulated OCI, Dec. 31, 2016 (7) (8) (9) 80,000 45,000 (10) (11) 17 Balance, Dec. 31, 2017 46,000 150,500 Cr. 399,500 Cr. 249,000 Dr. 18
(Pension Worksheet—Missing Amounts) Kramer Co. has prepared the following pension worksheet. Unfortunately, several entries in the worksheet are not decipherable. The company has asked your assistance in completing the worksheet and completing the accounting tasks related to the pension plan for 2017.
Check the below image for pension worksheet.
Instructions
(a) Determine the missing amounts in the 2017 pension worksheet, indicating whether the amounts are debits or credits.
(b) Prepare the
(c) Determine the following for Kramer for 2017: (1) settlement rate used to measure the interest on the liability and (2) expected return on plan assets
![Pension Worksheet–Kramer Co.xls
Home
Insert
Page Layout Formulas Data
Review View
P18
fx
A
B
C
D
E
F
G
H
General Journal Entries
Memo Record
Annual
Pension
Pension
Projected
Benefit
OC-Prior
Service Cost
4
OC-
Asset/
5
Items
Expense
Cash
Gain/Loss
Liability Obligation Plan Assets
6 Balance, Jan. 1, 2017
Service cost
120,000
325,000
205,000 Dr.
(1)
20,000
Interest cost
(2)
26,000
9 Actual return
(3)
18,000 Dr.
10 Unexpected loss
11 Amortization of PSC
2,500
(4)
(5)
35,000
12 Contributions
41,000
41,000 Dr.
13 Benefits
15,000
15,000 Cr.
14 Increase in PBO
(6)
43,500
15 Journal entry for 2017
16 Accumulated OCI, Dec. 31, 2016
(7)
(8)
(9)
80,000
45,000
(10)
(11)
17 Balance, Dec. 31, 2017
46,000
150,500 Cr. 399,500 Cr. 249,000 Dr.
18](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F41311164-43c2-4eab-a592-70c21c1fddad%2Fb7c74221-5469-454e-b653-0651664efad6%2Fh8cazaj.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)