Function: SUM; Cell Referencing
Some cells are merged.
Using Excel to Prepare the Shareholders' Equity Section of the Statement of Financial Position Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use cell references to amounts and account names in the Problem and work area as indicated. Use the SUM function to add amounts.
PROBLEM
Southern Corporation's adjusted trial balance contained the following accounts at December 31, 2023.


Retained earnings $120,000 Prepare the shareholders' equity section of the statement of financial position.
Common shares 700,000
Bonds payable 100,000
Contributed surplus 200,000 Shareholders’ equity
Preferred shares 50,000
Goodwill 55,000
Accumulated other comprehensive loss (150,000)

Prepare the shareholders' equity section of the statement of financial position.