I have attached the problem. I do not believe my work is correct. If it can be redone in an excel balance sheet.

PROBLEM # 9: Financial statement effects of Stockholders' Equity Transactions (25 points) Billabong's statement of stockholders' equity on December 31, 2011 is as follows: 6% cumulative preferred stock, $50 par, 10,000 shares authorized; 5,000 shares issued and outstanding $250,000 Common stock, $2 par, 500,000 share authorized; 245,000 shares issued and outstanding 490,000 Paid-in capital in excess of par - Preferred stock 10,000 Paid-in capital in excess of par - Common stock 1,960,000 Retained earnings 600,000 Total stockholders' equity $3,310,000 The following transactions occurred during 2012: Jan 15 ssued 1,500 shares of preferred stock for $50 per share. Apr 14 Issued 75,000 shares of common stock for $10 per share. Net proceeds were $710,000 Jul 3 Nov 1 Repurchased 20,000 shares of common stock at $6 per share. Sold 10,000 shares of treasury stock bought on July 3 for $18 per share. Nov 26 Split stock of common stock 2-for-1 reducing the par value of the stock Dec 5 Issue a stock dividend of 100% of the outstanding shares of common share. Use the financial statement effects template, below, to record these transactions. Balance Sheet Income Statement Transaction Cash Noncash Liabik Contrib Earned Rev- Net Asset Asset ities Capital Capital Serves Sos = Income 75,000 Jan 15 75,000 addtl paid > 75,000 75,000 in capital