Cash dividends, stock dividends, and stock splits-Excel HOME INSERT PAGE LAYOUT

Question

Cash dividends, stock dividends, and stock splits-Excel HOME INSERT PAGE LAYOUT FORMULASDATA REVIEW VIEW an In 1 u·EB. e.-. a-& A Alignment Number Conditional Format as Cell Cells Editing Number Formatting Table Styles A1 | At December 31, Artists Unlimited Company had the following 1 At December 31, Artists Unlimited Company had the following 2 stockholder's equity components that would be part of the balance sheet: Stock Dividend for 1 Stock Split Cash Dividend At Dec 31 5 Stockholders Equity 6 Contributed Capital 7 Number of common shares outstanding 8 Par value per common share 9 Common Stock, at par 10 Additional Paid in Capital 11 Total Contributed Capital 12 Retained Earnings 13 Total Stockholders' Equity 14 15 16 Required: 5,000 1.00 745,000 980,000 1,730,000 17 The company is considering 3 alternative distributions to stockholders. Consider each alternative independently of the others. 18 Complete the table above and show the effect on stockholders' equity as a result of each of these distributions. 19 Use only cell references in formulas. Use cells C3, D3, and E3 as appropriate. Do not reference cells from one alternative in another alternative. 21 11) Issue a 100% stock dividend. 4 . Sheet1 100% 000F

Explanation / Answer

Ans.

Usual case 100% stock issue 2 -1 stcok split $5000 in cash dividends Shares O/S (Number) 5000 985000 10000 5000 Par value 1 1 1 1 Common stock at par ($) 5000 985000 10000 5000 Additional paid in cap($) 745000 745000 745000 745000 Total Capital ($) 750000 1730000 755000 750000 Retained earnings ($) 980000 0 980000 975000 Total Stockholders Equity ($) 1730000 1730000 1735000 1725000

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.