Formula: Add, Subtract; Cell Referencing AP1-10A Using Excel to Determine Missing Statement of Changes in Equity Amounts of Retained Earnings PROBLEM the rest of the year as the rest of The change so retained wings from the beginning of the year t net earnings mis dividends for the year. These changes are part of the information prested on the statement of changes in equity the Problem w Student Work Arva Calculate the missing in the ion of ed earnings in each of the following independent situations B C D Retained earnings, Dec 31, 2019 $ 100,000 $420,000 $ (11.5 930,000 Dividends declared and paid Net earnings Retained earnings, Dec. 31, 2020 40,000 10,000 (2) 50,000 (4) 530,000 550,000 225,000 1.800.000 290,000 (3) 1,080,000 -Cover Page Q1 Q2 Q3 tomatic Workbook Statistics 04 (1) (2) (3) (4)