B D E F H J KL M N 7 B 9 0 P Formula: Add, Subtract; Cell Referencing 3 BE11.10 Using Excel to Prepare a Statement of Changes in Equity PROBLEM 5 Luxat Corporation reported the following statement of changes in equity for the year 5 ended December 31, 2021. Luxat Corporation Statement of Changes in Equity Year Ended December 31, 2021 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 2 Accumulated Other [1] 3 4 5 Bal. January 1 Common Shares $1,500,000 Contribute Retained Comprehensive d Surplus Earnings Income $500,000 $3,000,000 [2] Total $100,000 $5,100,000 [3] 6 Issued common shares [1] [2] 7 Declared and issued 110,000 [3] [4] [4] 8 stock dividend 9 Declared cash dividends -135,000 -135,000 [5] 0 Comprehensive income 1 Net income 750,000 [5] [6] 2 Other comprehensive 3 income [6] 25,000 [7] 4 Bal. December 31 $2,050,000 [7] $3,505,000 $125,000 [8} 5 [8] 6 7 8 9 0