Early in 2011, Herndon Industries was formed with authorization to issue 250,000 shares of $10 par value common stock and 30,000 shares of $100 par value cumulative preferred stock. During 2011, all the preferred stock was issued at par, and 120,000 shares of common stock were sold for $16 per share. The preferred stock is entitled to a dividend equal to 10 percent of its par value before any dividends are paid on the common stock. During its first five years of business (2011 through 2015), the company earned income totaling $3,700,000 and paid dividends of 50 cents per share each year on the common stock outstanding. On January 2, 2009, the company purchased 20,000 shares of its own common stock in the open market for $400,000. On January 2, 2013, it reissued 10,000 shares of this treasury stock for $250,000. The remaining 10,000 were still held in treasury at December 31, 2015. Instructions a. Prepare the stockholders equity section of the balance sheet (use excel) for Herndon Industries at December 31, 2015. Include supporting schedules showing (1) Your computation of any paid-in capital on treasury stock and (2) Retained earnings at the balance sheet date. b. As of December 31, compute Herndons book value per share of common stock. c. At December 31, 2015, shares of the companys common stock were trading at $30. Explain what would have happened to the market price per share had the company split its stock 3-for-1 at this date. Also explain what would have happened to the par value of the common stock and to the number of common shares outstanding.

Please make sure to use EXCEL so proper formatting can be seen