please use excel

Trial balance below as a starting point. Journalize and post entries related to equity transactions. Assume that all stock has been issued as $1 par value stock. You are not required to submit T-Accounts but they are always helpful. Produce a Statement of Stockholder's Equity A) Journalize the following equity transactions. 1) The company issues an additional 7000 shares of stock for $14280 in cash. 2) The company purchases 4034 of its own stock off the open market for $3.42 per share. 3) The company declares and pays a $0.50 per share dividend for all outstanding shares. 4) The company reissues 2219 of treasury stock at $4.1 per share. 5) The company declares and pays a $0.50 per share dividend for all outstanding shares. 6) The company reissues 1049 of treasury stock at $3.25 per share. 7) The company declares and distributes a 10% stock dividend. At the time of the declaration the stock was valued at $3.84 per share. B) Produce a Statement of Stockholder's Equity CHECK FIGURE: $14,075.50 Total value of cash paid dividends