Please show work in excel.

E15-8 (Preferred Stock Entries and Dividends) Otis Thorpe Corporation has 10,000 shares of $100 par value, 8%, preferred stock and 50,000 shares of $10 par value common stock outstanding at December 31, 2014. Instructions Answer the questions in each of the following independent situations. (a) If the preferred stock is cumulative and dividends were last paid on the preferred stock on Decem- ber 31, 2011, what are the dividends in arrears that should be reported on the December 31, 2014, balance sheet? How should these dividends be reported? (b) If the preferred stock is convertible into seven shares of $10 par value common stock and 4,000 shares are converted, what entry is required for the conversion assuming the preferred stock was issued at par value? (c) If the preferred stock was issued at $107 per share, how should the preferred stock be reported in the stockholders' equity