I need an Excel Formula please

I need an Excel Formula please

I need an Excel Formula please

I need an Excel Formula please

I need an Excel Formula please

I need an Excel Formula please

I have the answers but it doesn't work with me. I need the formulas

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 A1 ft 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. A 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: 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 Legend 9 1) Issue a 100% stock dividend. 100% Graded cell: Leave blank if no answer is 10 OR needed. 11 2) Execute a 2-for-1 stock split 2a 21 . 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 * Graded Worksheet + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +