Artists Unlimited Company has provided the stockholders' equity section of the balance sheet as of December 31. The Controller has asked you to calculate different distribution options to stockholders for management to consider. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

File Home Insert Draw Page Layout Formulas Data Review View Help Search Comments Calibri General - 11 - AA === 20 - A E a Wrap Text 3 Merge & Center - Share AutoSum Fill Sort & Find & Clear Filter - Select Paste BIU - $ -% 0,0% , 40.00 88 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Editing Ideas C15 x fc 1 At December 31, Artists Unlimited company had the following 2 Stockholder's equity components that would be part of the balance sheet: A WN 100% Stock Dividend for 1 stock split $5,000 Cash Dividend At Dec 31 5 Stockholders' Equity 6 Contributed Capital: 7 Number of common shares outstanding 8 Par value per common share Common Stock, at par 10 Additional Paid in Capital 11 Total Contributed Capital 12 Retained Earnings 13 Total stockholders' Equity 9 5,000 1.00 5,000 745,000 750,000 980,000 1,730,000 $ 14 15 Sheet1 @ J - + 160% File Home Insert Draw Page Layout Formulas Data Review View Help Search Comments = == Oyun General - 2 p E Calibri BIU - 11 - AA - - A. a Wrap Text Merge & Center - Share AutoSum 48 O Fill ZY Sort & Find & Clear Filter Select Editing Paste $ -% 6828 Insert Delete Format Ideas Conditional Format as Formatting Table Styles Cell Styles Clipboard Font Alignment Number Cells Ideas C15 : fic B C D E F G C 15 16 Required The company is considering 3 alternative distributions to stockholders. Consider each alternative independently of the 17 others Complete the Table above and show the resulting balances on the stockholders' equity section as a result of these 18 distributions Use only cell refrences in formulas. Use cells C3, D3, and E3 as appropriate. Do not refrence cells from one alternative in 19 another alternative 20 21 1) Issue a 100% stock dividend. 22 OR 23 2) Execute a 2-for-1 stock split 24 OR 25 3) Distribute $5,000 cash dividend Sheet1 @ - + + 140%