Question: please help me D E F G Function: SUM; Cell Referencing BE5.10 - Using Excel to Prepare the stockholders' Equity Section of the Balance Sheet
D E F G Function: SUM; Cell Referencing BE5.10 - Using Excel to Prepare the stockholders' Equity Section of the Balance Sheet PROBLEM Hawthorn Corporation's adjusted trial balance contained the following accounts at December 31, 2020: 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 area. Use the SUM function with cell referencing in cells which require addition of amounts Prepare the stockholders equity section of the balance sheet. Refer to illustration 5.16 Classified Report Form Balance Sheet for format Retained earnings Common stock Bonds payable Paid.in capital in excess of par-common stock Goodwill Accumulated other comprehensive loss Noncontrolling interest $120,000 750,000 100,000 200,000 55,000 150,000 35,000 Stockholders' equity 3 Equity attributable to Hawthorn Corporation 0 1 Total stockholders' equity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
