Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Human Resource Management

Authors: Robert L. Mathis, John H. Jackson

13th Edition

053845315X, 978-0538453158

More Books

Students also viewed these Accounting questions