please make the spreadsheets, it helps me understand where everything goes.

Saved mework Che The following information pertains to JAE Corp. at January 1, 2018: Common stock, $9 par, 12,000 shares authorized, 2,400 shares issued and outstanding Paid-in capital in excess of par, common stock Retained earnings $21,600 15,300 74,500 JAE Corp. completed the following transactions during 2018: 1. Issued 850 shares of $9 par common stock for $31 per share. 2. Repurchased 240 shares of its own common stock for $28 per share. 3. Resold 50 shares of treasury stock for $29 per share. Required: a. How many shares of common stock were outstanding at the end of the period? b. How many shares of common stock had been issued at the end of the period? c. Organize the transactions data in accounts under the accounting equation. d. Prepare the stockholders' equity section of the balance sheet reflecting these transactions. Include the number of sl authorized, issued, and outstanding in the description of the common stock.