PLEASE INCLUDE FORMULAS CORRELATING TO THE PICTURE

INCLUDE FORMULAS

A1 x fx Accessibility tab summary: A statement for requirement is presented in rows 4 to 13. The table for student prepa A B C D E F. 3 4 Required: 5 The company is considering three alternative distributions to stockholders. Consider each alternative independently of the others. 6 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 9 100% 1) Issue a 100% stock dividend. OR 10 11 2 12 2) Execute a 2-for-1 stock split. OR 3) Distribute a $5,000 cash dividend. 13 $5,000 14 Stock Dividend 2 for 1 Stock Split Cash Dividend At Dec 31 15 16 Stockholders' Equity 17 Contributed Capital: 18 Number of common shares outstanding 19 Par value per common share 20 Common Stock, at par 21 Additional Paid-in Capital 22 Total Contributed Capital 23 Retained Earnings 24 Total Stockholders' Equity 25 5,000 $1.00 $5,000 745,000 750,000 980,000 $1,730,000