chapter 13 microsoft excel spreadsheet:dividend policy

please answer on microsoft excel parts a,b. please show formulas

One way to lower the market price of a firm's stock is via a stock split. Rock-O Corporation finds itself in a different situation: Its stock has been selling at relatively low prices. To increase the market price of the stock, the company chooses to use a reverse stock split of 2 -for-3. The company currently has 700,000 common shares outstanding and no preferred stock. The common stock carries a par value of $1. At this time, the paidin capital in excess of par is $7,000,000, and the firm's retained earnings is $3,500,000 TO DO Create a spreadsheet to determine the following: a. The stockholders' equity section of the balance sheet before the reverse stock split. b. The stockholders' equity section of the balance sheet after the reverse stock split