stuck on doing cell refs never really done anything with excel but shes wanting us to do excel refs and not just typing the awnsers in

Stockholders' Equity / Corporations Using Excel for stockholders' equity transactions and preparing financial statements Naxion Corporation began operations on January 2, 2018, and had the following transactions during the year: olm tin Jan. 2 Issued 250,000 shares of $1 par value common stock at $45 per share. Total shares authorized: 1,000,000. Feb. 5 Issued 10,000 shares of $50 par, 5% cumulative preferred stock at $65 per share. Total shares authorized: 25,000. Mar. 15 Issued 150,000 shares of $1 par value common stock at $35 per share. Apr. 2 Declared a $2.50 per share cash dividend on its preferred stock to be paid on April 25. Date of record is April 10. Apr. 3 Declared a $0.10 per share cash dividend on its common stock to be paid on April 26. Date of record is April 10. Apr. 25 Payment of cash dividend on preferred stock. Apr. 26 Payment of cash dividend on common stock. Jun. 1 Declared a 2% stock dividend on all common stock outstanding. Current market price of the stock was $48 per share. Date of record is June 15. Jun. 30 Distributed common stock dividend to shareholders. Oct. 10 Purchased 2,500 shares of treasury stock-common at $52 per share. Nov. 15 Sold 2,000 shares of treasury stock-common at $54 per share. 7 Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. 3 ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points. Possible Points 1 Requirements: 1 Journalize Naxion's transactions for 2018. Prepare the stockholders' equity section of the balance sheet as of December 31, 2018, including the heading. Assume Naxion had net income of $15,000,000 2 during 2018 Determine Naxion's earnings per share for 2018, rounded to two decimal places. For the average number of common shares outstanding, average the 3 number of shares outstanding on January 2 and December 31. Assuming Naxion's market value per common share as of December 31, 2018 was $55, calculate Naxion's price/earnings ratio for 2018, rounded to two 4 decimal places. 5 US 3 Excel Skills: 1 Data validation for journal entry accounts. 2 Indent journal entry credit accounts using the Increase Indent button. 3 ROUND function. 1 Requirement 1 2 Journalize Naxion's transactions for 2018. 3 (Always use cell references and formulas where appropriate to receive full credit.) Date Account and Explanation Debit Credit Jan. 2 Issued common stock at a premium. Feb. 5 Issued preferred stock at a premium. Mar. 15 Issued common stock at a premium. pr. 2 Declared a cash dividend on preferred stock. pr. 3 Declared a cash dividend on common stock. Apr. 25 Payment of cash dividend on preferred stock. Apr. 26 Payment of cash dividend on common stock. Payment of cash dividend on preferred stock. Apr. 26 Payment of cash dividend on common stock. Jun. 1 Declared a 2% stock dividend on common stock Jun. 30 issued 2% common stock dividend. Oct. 10 Purchased treasury stock - common. Nov. 15 Sold 2,000 shares of treasury stock-common at $54 per share. HINTS 58 1. Use an equal sign (=) and numeric values from the table of transactions in Instructions worksheet for calculations. G C D E F Requirement 2 Prepare the stockholder's equity section of the balance sheet as of December 31, 2018. Assume Nanion had net income of $15,000,000 during 2018 (Always use cell references and formulas where appropriate to receive full credit. ) 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, rounded to two decimal places. For the average number of common shares outstanding, average the number of shares outstanding on January 2 and (Always use cell references and formulas where appropriate to receive full credit.) Formula Ansyer Requirement 4 Assuming Naxion's market value per common share as of December 31, 2018 was $55, calculate Naxion's pricelearnings ratio for 2018, rounded to two decimal places. (Always use cell references and formulas where appropriate to receive full credit.) Formula Ansyer HINTS 42 Cell Hint: 43 11:12 Use an equal sign (=) and appropriate cell references to ENTERANSWERS1worksheet. 44 C14:016 Use an equal sign (=), appropriate cell references and numerio values from ENTERANSWERS1 and ENTERANSWERS2 worksheets. 45 017 Use the funotion=SUMO) to calculate the total paid-in capital. 46 C18 Use the numeric value of net income in caloulation of retained earnings. Note that Nanion had net income of $15,000,000 during 2018 47 C20 Treasury Stock should be entered as a negative value. Use a minus sign in front of the formula for Treasury Stock value. 48 C29 Use the function=ROUNDI), appropriate cell references and numeric values from ENTERANSWERS1 and ENTERANSWERSZ 49 C37 Use the function =ROUNDI), appropriate cell references and numerio values from ENTERANSWERS2 worksheet