Lin Developments Ltd. provides post-employment benefits to its retirees for supplementary health care, including prescription medication. Lin had an accumulated OCI loss amount related to OPEBs of $45,000 at the beginning of the year, an experience loss related primarily to unexpected cost increases in prescription medication.
Lin does not fund health care benefits to any great extent. As a result, there was only $21,500 in the fund asset account at the beginning of the year, while the estimated obligation for supplementary health care benefits was $566,300. Actual earnings of the fund this year were $600. At the end of the year, contributions of $46,400 were made to the fund and benefits paid out were $43,900. In the current year, actuarial estimates indicate that current service cost is $67,800, and there is a new actuarial loss of $35,000 related to further increases in health care costs.

Required:
Prepare a spreadsheet for the current year that determines the expense for post-employment benefits, accumulated OCI, and also the closing accrued asset or liability with respect to the benefits. Begin by calculating the opening SFP OPEB liability balance. The long-term bond yield rate is 5%.