Charged w AL Te Home Page Layout Formulas Cats Review Vs Help PROTECTED View This the has beefed by Muh Delende At Ted A held w f Formula Add Subtract, Call Referencing 3BE 11.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 &ended December 31, 2021. Luxat Corporation Statement of Changes in Equity Year Ended December 31, 2021 Student Work Ars Required: Provide input into cells shaded in low intra template. Use mathematical formulas with cell references the Problem area and work area as indicated Determine the mosing amounts for items (1) to Accumulated Other 0 13 14 15 Bal January 1 Common Contributed Retained Comprehensive Shares Surplus Income Earnings $1,00,000 $15,00,000 $5,00,000 $30,00,000 121 16 Issued common shares [1] Total $51.00.000 12 P 17 Declared and issued 1,10,000 131 141 (4) 18 stock dividend i 19 Declared cash dividends, -1,35,000 -1.35,000 20 21 Comprehensive income Net income 7,50.000 150 22 Other comprehensive [6] 25.000 EEEE 171 23 income 24 Bal December 31 $20,50,000 1 $35,05,000 $1.25.000 Enter Answer Ready a