I need help with this excel sheet. I also want to the calculation, so I can do in my excel sheet. thank you

SUM x C fc =15 D 2 On January 5, 2017, Phelps Corporation received a charter granting the right to in common and preferred stock 3 provided below: Cumulative and nonparticipating preferred stock: Number of shares authorized Par value Dividend rate Common stock Number of shares authorized Par value 5,000 shares 100 per share 8% 50,000 shares 10 per share 13 Phelps then completed the following transactions an. 11 Issued common stock Number of shares Issue price per share 20,000 16.00 Feb. 1 50,000 160,000 270,000 4,000 Jul. 29 1,800 17.00 Issued preferred stock to Sanchez Corp. for assets with the following values: Fair value of equipment Fair value of a factory building Appraised value of land Number of shares issued Purchased shares of common stock (use the cost method) Number of shares purchased Purchase price per share Sold treasury shares Number of shares sold Selling price per share Declared cash dividend on the common stock Dividend per share Declared the preferred dividend Closed the Income Summary account. Net income during 2017 Aug. 10 1,500 14.00 Dec 31 0.25 Dec 31 175,700 36 Instructions: Do not show "cents in your amounts. + al Read the imal entries for the transacting listed showe P15-1 Point B C D F G H 38 ) Record the journal entries for the transactions listed above Debit Credit Jan. 11 Cash Feb. 1 Choose your account nam Buildings Cash Common Stock Dividend Payable Dividend Receivable Equipment Income Summary Land Paid-in Capital from Treasu Paid-in Capital in Excess of Paid-in Capital in Excess of Preferred Stock Property, Plant and Equipm Retained Earnings Stock Dividend Distributable Stockholders' Equity Treasury Stock Jul 29 Aug. 10 Common stock cash dividend Preferred stock cash dividend Total cash dividend 74 (b) Prepare the stockholders' equity section of Phelps Corporation's balance sheet as of December 31, 2017 Show P15-1 + Point 74 kb) Prepare the stockholders' equity section of Phelps Corporation's balance sheet as of December 31, 2017. Show any negative numbers in parentheses. PHELPS CORPORATION Stockholders' Equity December 31, 2017 Capital Stock Additional Paid-in Capital Total Stockholders' Equity Choose your account names from the following Buildings Cash Common Stock Dividend Payable Dividend Receivable Equipment Income Summary Land Paid-in Capital from Treasury Stock Paid-in Capital in Excess of Par-Common Stock Paid-in Capital in Excess of Par-Preferred Stock Preferred Stock Property, Plant and Equipment Retained Earnings Stock Dividend Distributable Stockholders' Equity Treasury Stock