$1$

$4$

$5$

$5$

$7$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use

mathematical formulas with cell references to the Problem and work areas as

indicated.

$3$

$0$

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

A

Function: SUM; Formula: Add, Subtract, Multiply, Divide; Cell Referencing

Using Excel to Account for Pensions

PROBLEM

Uvo Corporation is a private company with a defined benefit pension plan. The

following information is available for Uvo Corporation for $2023.$

Opening balance, DBO

Opening balance, plan assets

Service cost

Employer contributions paid evenly through $2023$

Applicable interest or discount rate

Actual return on plan assets

Actuarial loss due to change in actuarial assumptions

F

F

G

I

K

$ $210,000$

$200,000$

$58,000$

$77,000$

$10\%$

$25,000$

$14,000$

$126,000$

$58,000$

$58,000$

$9$

$1$

$2$

$3$

$5,000$

$14,000$

$19,000$

$5$

$6$

$7$

Assuming that Uvo follows IFRS, determine the $2023$ effect of the pension plan

on pension expense and the company's shareholders' equity. Display amounts

to be subtracted as negative amounts.

Average plan assets

Defined benefit expense:

Current service cost

Net interest$/$finance cost

Defined benefit expense

Remeasurement gain or loss $($OCI$)$:

Actural return on plan assets

Actuarial loss on DBO

Net remeasurement loss $($OCI$)$

Effect on shareholders' equity

Net decrease Using Excel to Account for Pensions

PROBLEM

Uvo Corporation is a private company with a defined benefit pension plan. The

following information is available for Uvo Corporation for $2023.$

Opening balance, DBO

Opening balance, plan assets

Service cost

Employer contributions paid evenly through $2023$

Applicable interest or discount rate

Actual return on plan assets

Actuarial loss due to change in actuarial assumptions

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use

mathematical formulas with cell references to the Problem and work areas as

indicated.

Assuming that Uvo follows IFRS, determine the $2023$ effect of the pension plan

on pension expense and the company's shareholders' equity. Display amounts

to be subtracted as negative amounts. Correct the red blanks.