Need help on forming table using given data:

Application Problem 11-2A a-b (Part Level Submission)

Pharma Shop Ltd. is a mid-sized public company that had been in operation for many years. On December 31, 2019, it had an unlimited number of common shares authorized and 6,300,000 shares issued at an average value of $25 per share. As well, there were 6,100,000 preferred shares authorized, with 305,000 of them issued at $18 per share. The balance in retained earnings was $26,710,000. The balance in accumulated other comprehensive income was $540,000. The preferred shares pay an annual dividend of $2 per share. During 2020, the following transactions affected shareholders equity:

1.		In total, 160,000 new common shares were issued at $30 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 2020, a dividend of $1.50 per share was declared on the common shares. The date of record was December 15, 2020. The dividend will be paid the following year.
5.		The company earned a net income of $14,950,000 and had an other comprehensive loss of $145,000.
6.		On December 31, 2020, the company declared a two-for-one stock split on common shares.

Application Problem 11-2A a-b (Part Level Submission) Pharma Shop Ltd. is a mid-sized public company that had been in operation for many years. On December 31, 2019, it had an unlimited number of common shares authorized and 6,300,000 shares issued at an average value of $25 per share. As well, there were 6,100,000 preferred shares authorized, with 305,000 of them issued at $18 per share. The balance in retained earnings was $26,710,000. The balance in accumulated other comprehensive income was $540,000. The preferred shares pay an annual dividend of $2 per share. During 2020, the following transactions affected shareholders' equity: 1. 2. 3. 4. 5. 6. In total, 160,000 new common shares were issued at $30 per share. The preferred dividend for the year was declared and paid. A 10% common stock dividend was declared when the market price was $33 per share. The shares were distributed one month after the declaration. In early December 2020, a dividend of $1.50 per share was declared on the common shares. The date of record was December 15, 2020. The dividend will be paid the following year. The company earned a net income of $14,950,000 and had an other comprehensive loss of $145,000. On December 31, 2020, the company declared a two-for-one stock split on common shares. (a) Use a spreadsheet or table format like the one in the first practice problem to track all of the changes in the shareholders' equity accounts in 2020. (If an amount reduces the account balance then enter with negative sign, e.g. -15,000 or in parenthesis, e.g. (15,000).) Number of common shares Number of preferred Shares Preferred Retained Earnings Accumulated other comprehensive income Date Common Shares Total Preferred shares $ 5490000 Dec. 31, 2019 6300000 157500000 305000 $ 26710000 540000 189700000 1. issued common shares 160000 4800000 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, 2020