Please record the following transaction in Excel.

Problem 11 Use the Excel working papers provided in this module for both parts of this problem PART A-Record the following 2016 transctions for the Hasbro Corporation im the journal (Par value information is listed in part B) Jan.1 Issued 30.000 shares of preferred stock for cash at $104 per share. Feb. 2Issued 490,000 shares of common stock for cash at $12 per share Mar. 3Declared a cash dividend on the preferred stock $385,000 Apr 4Discovered a $15,000 understatement of 2014 depreciation May 5 Paid the cash dividend declared of March 3. June 6Issued 4,000 shares of common stock for land that was advertised for sale at $50,000. The stock market price of the stock is S12 per share. Sept 9Hasbro purchased 10,000 shares of its own common stock at S14 per share Oct10 Sold 3.000 shares of treasury stock for S18 per share Nov. 11 Declared a SO 50 cash dividend per share on common stock for a total of $743,500. Dec.31 Net income was reported to be $950,000 PART B. Based on the Hasbro Corp.partial trial balance below, prepare (a) a retained earnings statement for the year and (b) a stockholder's equity section at December 31. 2016 Additional information you will need: when Hasbro began operations several years ago, they were authorized to issue 100,000 shares of 796, $100 par value preferred stock and 5,000,000 shares of$4 par value common stock. Hasbro Corporation