A. B c H function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Calculate Equity Balances PROBLEM Pasta Creations issued additional shares of common shares, reported net income, and declared dividends during the year. nformation concerning its equity is provided here. Beginning of year common shares Beginning of year retained earnings Additional common shares issued Net income reported Dividends declared \$ 98,000 476,000 52,000 78,000 16,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. a. Calculate the ending balances of (1) common shares, (2) retained earnings, and (3) total shareholders' equity. Common shares Retained earnings Total shareholders' equity b. Calculate the same amounts if the company had reported a net loss rather than net income and had not declared any dividends