Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do with Excel formula Excel McGraw Hill Excel Question - Saved - Search (Option +Q) 03 File Home Insert Draw Formulas Data Review View
please do with Excel formula
Excel McGraw Hill Excel Question - Saved - Search (Option +Q) 03 File Home Insert Draw Formulas Data Review View Help Editing Comments * Calibri 11 BE A 20 General 40 00 00 - Tov ... T30 fx A B D E F G McGraw Hill 1 Check Answers 50,000 $10 3 for 1 Check My Work Legend Graded cell: Leave blank if no answer is needed. Scratchpad: Use as a non-graded workspace 2 3 On June 30, Sharper Corporation's stockholders' equity section of its balance sheet appears as follows before any stock dividend or split. 4 Before stock split: Common stock-$10 par value, 50,000 shares issued and outstanding $500,000 Number of common shares outstanding Paid-in capital in excess of par value, common stock 200,000 Par value 7 Retained earnings 660,000 Stock Split 8 Total stockholders' equity $1,360,000 9 10 Assume Sharper issues a 3-for-1 stock split. -. 11 12 Required: 13 (1) Compute the number of shares outstanding after the split. 14 15 (Use cells A2 to E10 for cell referencing and/or formulas needed to complete this question.) 16 17 After the stock split: 18 Number of common shares outstanding after the stock split 19 Par value of shares after the stock split 20 21 (2) Prepare the updated stockholders' equity section after the split. 22 23 SHARPER CORPORATION 24 Stockholders' Equity Section of the Balance Sheet 25 June 30 26 Common stock - ? par value, shares issued and outstanding 27 Paid-in capital in excess of par value, common stock 28 Retained earnings 29 Total stockholders' equity ' >= Graded Worksheet + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 90% +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started