H 1 KL M M N Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area and work area as indicated. Determine the missing amounts for items [1] to [8]. [1] A B D E F 1 Formula: Add, Subtract: Cell Referencing G 2 3 BE11.10 Using Excel to Prepare a Statement of Changes in Equity 4 PROBLEM 5 Luxat Corporation reported the following statement of changes in equity for the year 6 ended December 31, 2021. 7 8 Luxat Corporation 9 Statement of Changes in Equity 0 Year Ended December 31, 2021 1 1 Accumulated 2 Other 3 Common Contribute Retained Comprehensive 4 4 Shares d Surplus Earnings Income Total 5 Bal. January 1 $1,500,000 $500,000 $3,000,000 $100,000 $5,100,000 6 Issued common shares [1] [2] 7 Declared and issued 110,000 [3] [4] 8 stock dividend 9 Declared cash dividends -135,000 -135,000 0 Comprehensive income 1 Net income 750 000 [5] 2 Other comprehensive 25,000 3 [6] income Bal December 31 $2,050,000 4 [7] $3.505.000 $125,000 [8] [2] [3] [4] [5] [6] [7] [8] 5 Enter Answer eady O Type here to search E