Sandhill Shop Ltd. is a mid-sized public company that had been in operation for many years. On December 31, 2023, it had an unlimited number of common shares authorized and 5.6 million shares issued at an average value of $27 per share. As well, there were 5.4 million preferred shares authorized, with 270,000 of them issued at $18 per share. The balance in retained earnings was $26,650,000. The balance in accumulated other comprehensive income was $521,000. The preferred shares pay an annual dividend of $2 per share. During 2024 , the following transactions affected shareholders' equity: 1. In total, 170,000 new common shares were issued at $32 per share. 2. The preferred dividend for the year was declared and paid. 3. A 10% common stock dividend was declared when the market price was $33 per share. The shares were distributed one. month after the declaration. 4. In early December 2024 , a dividend of $1.60 per share was declared on the common shares. The date of record was December 15, 2024. The dividend was to be paid the following yeat. 5. The company earned net income of $15.060.000 and had an other comprehensive loss of $130,000. 6. On December 31, 2024, the company declared a two-for-one stock split on common shares. 6. On December 31, 2024, the company declared a two-for-one stock split on common shares. a) Use a spreadsheet or table format to track all of the changes in the shareholders' equity accounts in2024. If an amount reduces the account balance then enter with negative sign, e.g. 15,000 or in parenthesis, e.g. (15,000). 1. Issued common shares 2. Preferred share dividends 3. 10% stock dividend on common shares 4. Common share dividend 5a. Net income for year 5b. Other comprehensive (loss) for year 6. Two-for-one stock split on common shares Dec. 31, 2024 Number of preferred Shares Preferred Accumulated other comprehensive income Retained earnings Accumulated other comprehensive income