D Stackdesquity / Corporation Using Excel for stockholders' equity transactions and preparing financial statements Nixion Corporation began operations on lanuary 2, 2018, and had the following transactions during the year! 5 an Issued 250,000 shares of $ par valuie common stock at SA per share. Total shares authorized 1,000,000 2 Feb, issued 10,000 shares of $50 par Scumulative preferred stock per share. Totalares authorized: 25,000 DI Mar. 15 Issund 150,000 shares of 51 par value common stock at Siper share Apt 2Declared a $2.50 per share cash dividend on its preferred stock to be paid on April 3, Date of records April 10 10 April Dedared a $4.10 per share cash dividend on its common stock to be paid on April 2Date of record April 10 11 Apr. 25 Payment of cash dividendo preferred stock 12 Apr 26 Payment of cash dividend on common stock, 11 Jun, 1 Declared a stock dividend on all common stock outstanding Current market price of the stock was 548 pershare. Date of records 14 Jun 30 Distributed.common stock dividend to shareholders. 15 Oct. 10 Durchased 2.500 shares of treasury stock common per share 10 Nov. 15 Sold 2,000 shares of treasury stock.commonata per share 11 Use the blue shaded on the ENTER ANSWERS tab for inputs. 18. Always use el references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab, you will be marked wrong 19 20 1 Number A Requirement1 Styles A Requirement1 Journalize Naxion's transactions for 2018. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab, you will be marked wrong) 5 Date Account and Explanation Debit Jan. 2 Credit 3 B 9 Issued common stock at a premium. 30 11 Feb. 5 12 13 14 Issued preferred stock at a premium. 15 16 Mar. 15 17 18 19 Issued common stock at a premium 20 21 22 32 Dallerhandel Instructions ENTERANSWERS ENTERANSWERS Apr. 2 Ready a o Type here to search Agnment Number Styles Cells X D Requirement 2 Prepare the stockholder's equity section of the balance sheet as of December 31, 2018. Assume Naxion had net income of $15,000,000 during 2018 (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong.) Stockholders' Equity Paid In Capital: Preferred Stock Common Stock Total Paid-In Capital Retained Earnings Treasury Stock-Common Total Stockholders' Equity > Requirement 3 Determine Naxion's earnings per share for 2018, founded to two decimal places. For the average number of common shares outstanding, average the number of shares outstanding on January 2 and December 31. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked pron) Formula Answer Requirement 4 Assuming Naxion's market value per common share as of December 31, 2018 was SSS, calculate Naxion's price/earnings ratio for 2018, rounded to two decimal places. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong.) Formula Answer HINTS Hint: like an equalsian leland annonciate celleforennect ENTERANSWERS 1. Wochent instructions ENTERANSWERS ENTERANSWERS 74 Type here to search