Please create a table like the one below in excel to complete this assignment and answer all the questions a & b. I will dislike if you don't answer all the questions or wrong the format.

Question a:

Question b:

Identifying and Analyzing Financial Statement Effects of Stock Transactions The stockholders' equity of Gaulin Company at the start of the current year follows: During the current year, the following transactions occurred: Jan. 5 Issued 10,000 shares of common stock for $13 cash per share. Jan. 18 Repurchased 4,000 shares of common stock at $16 cash per share. Mar. 12 Sold one-fourth of the treasury shares acquired January 18 for $19 cash per share. July 17 Sold 500 shares of treasury stock for $14 cash per share. Oct. 1 Issued 5,000 shares of 8%,$25 par value preferred stock for $36 cash per share. This is the first issuance of preferred shares from the 50,000 authorized preferred shares. (a) Use the financial statement effects template to indicate the effects of each transaction. Use negative signs with answers, when appropriate. (b) Prepare the current year stockholders' equity section of the balance sheet assuming that the company reports net income of $76,900 for the year. Use a negative sign with your answer for treasury stock