Question

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%

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.

Answer 1

Solution:

		100%	2	5000
		stock	for 1 Stock	cash
Stock holder's equity	At Dec 31	dividend	split	dividend
Contributed capital:
Number of common shares outstanding	5000	10000	10000	5000
Par value per common share	1	1	0.5	1
Common stock, at par	5000	10000	5000	5000
Additional paid in capital	745000	745000	745000	745000
Total contributed capital	750000	755000	750000	750000
Retained earnings	980000	975000	980000	975000
Total stock holder's equity	1730000	1730000	1730000	1725000

Excel Poo-2 new - Microsoft Excel 2. General - - Home Insert Page Layout - 7 X File Formulas Dala Review View Calculate Now de Lookup & Math & More Reference Trig Functions Define Name Use in Formula Name Manager Create from Selection Defined Names Trace Precedents Show Formulas Trace Dependents Error Chexing Watch Remove Arrows ) Evaluate Formula Window Formula Auditing Calculation calculate Sheet Options Calculation Insert AutoSum Recently Financial Logical Text Date & Function Used Time Function Library C16 - A 1 Artists Unlimited 2 Ε F 5000 stock dividend for 1 Stock split cash dividend =B7 5 Stock holder's equity At Dec 31 6 Contributed capital: 7 Number of common shares outstanding 5000 8 Par value per common share 9 Common stock, at par 5000 10 Additional paid in capital 745000 11 Total contributed capital 750000 12 Retained earnings 980000 13 Total stock holder's equity 1730000 =B7+B7%C3 =B8 =C7C8 =B10 =C9+C10 =B12-B7*C3 =C11+C12 =B7%D3 =B8/D3 =D7D8 =B10 =D9+D10 =B12 =D11+D12 ERA =E7 E8 =B10 =E9+E10 =B12-E3 =F11 E12 14 15 22 23 24 Sheet418 Sheet419 Sheet420 Sheet421 Sheet422 Sheet423 Sheet424 Sheet425 Sheet426 Ready E M 100% + 0 12:41 O Type here to search A x 66 . ENG 18-02-20201