Please do in Excel:

Top Tech, Inc. Stockholders' Equity Section at the end of last year was as follows: Paid In capital: Preferred Stock, 300,000 Shs. Authorized, 100,000 Outstanding, $1 Par, 8% dividend rate 100,000 Common Stock, 60,000 Shs. Issued and Outstanding, No Par 2,200,000 Total Paid in Capital 2,300,000 Retained Earnings 554,300 Total Stockholders' Equity 2,854,300 Req. #1, give general journal entries for the following transactions that took place this year: 1Bought back 700 shs of the common stock that were outstanding. Paid $60/Sh. 2Sold 200 of the shares bought back in prior transaction. Received $57/Sh. 3Sold 4,000 shares of Pfd. Stock for $5/Sh. 4Give 3rd closing enrty with the corp. earning 82,000 for the year. Req. #2 prepare Top Tech, Inc. Stockholders' Equity Section at the end of this year. Req. #3 calculate common stock book value per share at the end of last year and at the end of this year.