excel formula help please
On June 30, Sharper Corporation's stockholders' equity section of its balance sheet appears as follows before any stock dividend or split. Assume Sharper issues a 3-for-1 stock split. Required: (1) Compute the number of shares outstanding after the split. (Use cells A2 to E10 for cell referencing and/or formulas needed to complete this questlon.) After the stock split: 18 Number of common shares outstanding after the stock split Par value of shares after the stock split (2) Prepare the updated stockholders' equity section after the spit. SHARPER CORPORATION Stockholder's Equity Section of the Balance Sheet Jund 30 Common stock - ? par value, ? shares issued and outstanding \begin{tabular}{|l|l|l|} \hline 17 & After the stock split: & B \\ 18 & Number of common shares outstanding after the stock split \\ 19 & Par value of shares after the stock split \\ \hline \end{tabular} (2) Prepare the updated stockholders' equity section after the split. SHARPEA CORPORATION Stockholders' Equity Section of the Balance Sheet June 30 Common stock - ? par value, ? shares issued and outstanding Paid-in capital in excess of par value, common stock Retained earnings Total stockholders' equity On June 30, Sharper Corporation's stockholders' equity section of its balance sheet appears as follows before any stock dividend or split. Assume Sharper issues a 3-for-1 stock split. Required: (1) Compute the number of shares outstanding after the split. (Use cells A2 to E10 for cell referencing and/or formulas needed to complete this questlon.) After the stock split: 18 Number of common shares outstanding after the stock split Par value of shares after the stock split (2) Prepare the updated stockholders' equity section after the spit. SHARPER CORPORATION Stockholder's Equity Section of the Balance Sheet Jund 30 Common stock - ? par value, ? shares issued and outstanding \begin{tabular}{|l|l|l|} \hline 17 & After the stock split: & B \\ 18 & Number of common shares outstanding after the stock split \\ 19 & Par value of shares after the stock split \\ \hline \end{tabular} (2) Prepare the updated stockholders' equity section after the split. SHARPEA CORPORATION Stockholders' Equity Section of the Balance Sheet June 30 Common stock - ? par value, ? shares issued and outstanding Paid-in capital in excess of par value, common stock Retained earnings Total stockholders' equity