please provide answers in same excel sheet
13-2A Koehler Corporation reports the following components of stockholders' equity at December 31 of the prior year. Common stock- $10 par value, $100,000 shares authorized, 40,000 shares issued and outstanding $400,000 Paid-in capital in excess of par value, common stock 60,000 Retained earnings 270,000 Total stockholders equity $730,000 During the current year, the following transactions affected its stockholders' equity accounts. Jan. 2 Purchased 4,000 shares of its own stock at $20 cash per share. Jan. 5 Directors declared a $2 per share cash dividend payable on February 28 to the February 5 stockholders of record. Feb. 28 Paid the dividend declared on January 5 July 6 Sold 2,000 of its treasury shares at $24 cash per share. Aug. 22 Sold 2,000 of its treasury shares at $16 cash per share. Sep. 5 Directors declared a $2 per share cash dividend payable on October 28 to the September 25 stockholders of record. Oct. 28 Paid the dividend declared on September 5. Dec. 31 Closed the $388,000 credit balance (from net income)in the Income Summary account to Retained Earnings. Required 1. Prepare journal entries to record each of these transactions. 2. Prepare a statement of retained earnings for the current year ended December 31 3. Prepare the stockholders equity section of the balance sheet as of December 31 of the current year. 13-2B Balthus Corp reports the following components of stockholders' equity at December 31 of the prior year. Common stock- $1 par value 3,200 shares authorized, 200,000 shares issued and outstanding $200,000 Paid in capital in excess of par value, common stock. 1,400,000 Retained earnings 2,160,000 Total Stockholders equity $3,760,000 It completed the following transactions related to stockholders' equity during the current year. Jan 10. Purchased 40,000 shares of its own stock at $12 cash per share. Mar 2. Directors declared at $1.50 per share cash dividend payable on March 31 to the March 15 stock-holders of record. Mar 31. Paid the dividend declare on March 2 Nov 11 Sold 24,000 of its treasury shares at $13 cash per share. Nov 25 Sold 16,000 of its treasury shares at $10.50 cash per share. Dec 1 Directors declared a $2.50 per share cash dividend payable on January 2 to the December 10 stockholders of record. Dec. 31 Closed the $1,072,000 credit balance (from net income) in the Income Summary account to Retained Earnings Required 1. Prepare journal entries to record each of these transactions. 2. Prepare a statement of retained earnings for the current year ended December 31. 13-3B At December 31, the end of Chilton Communication's third quarter, the following stockholders' equity accounts are reported. Common stock, $10 par value $ 960,000 Paid-in Capital in excess of par value, common stock 384,000 Retained earnings 1,600,000 In the fourth quarter, the following entries related to its equity are recorded. Jan. 17 Retained Earnings 96,000 Common Dividend Payable 96,000 Feb.5 Common Dividend Payable 96,000 Cash 96,000 Feb 28 Retained Earnings 252,000 Common Stock Dividend Distributable 120,000 Paid-In Capital in Excess of Par Value, Common Stock 132,000 Mar 14 Common Stock Dividend 120,000 Common Stock, $10 Par Value 120,000 Mar 25 Memo-Change the title of the Common Stock account to reflect the new par value of $5. account to reflect the new par value of $5 Mar 31 Income Summary 720,000 Retained Earnings 720,000 Required 1. Explain the transactions underlying each journal entry 2. Complete the following table showing the equity account balances at each indicated table (take into account the beginning balances from December 31).