please do it with Excel formula

Excel McGraw Hill Excel Question - Saved Search (Option +Q) File Home Insert Draw Formulas Data Review View Help Editing Comments Calibri 11 BA ab General $ oo 08HPB 27 --- A1 fx Accessibility tab summary: A statement for requirement is presented in rows 4 to 13. The table for student preparation is presented in cells A15 to E24. B B D E F G H 1 3 McGraw Hill 1 2 At December 31, Artists Unlimited Company had the following stockholders' equity components that would be part of the balance sheet: 3 Check Answers 4 Required: 5 The company is considering three alternative distributions to stockholders. Consider each alternative independently of the others. Check My Work Complete the table above and show the effect on stockholders' equity as a result of each of these distributions. 7 Use information in column B to complete columns C, D, and E. 8 8 Legend 91) Issue a 100% stock dividend. a 100% Graded cell: Leave blank if no answer is 10 OR needed. 11 2) Execute a 2-for-1 stock split. 2a 2 12 OR Scratchpad: Use as a non-graded 13 3) Distribute a $5,000 cash dividend. 3$ $5,000 workspace 14 15 Stock 2 for 1 Stock Cash 16 Stockholders' Equity At Dec 31 Dividend Split Dividend 17 Contributed Capital: 18 Number of common shares outstanding 5,000 10,000 19 Par value per common share $1.00 20 Common Stock, at par , $5,000 21 Additional Paid-in Capital 745,000 22 Total Contributed Capital 750,000 23 Retained Earnings 980,000 24 Total Stockholders' Equity $1,730,000 25 26 Save and Return to Assignment * Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft 100% +