Question

!!! Apps SRC AK47 Airsoft... JG AK47 JG AK Ta... BMW M3 E92 Drif... lowa's Tyler Sash... C value: 20.00 points 1. Analyze the effects of alternative distributions on stockholders' equity. Safs HOME INSERT ? * Cash dividends, stock dividends, and stock splits - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign in FILE Calibri 11 A Paste B I U . ED. A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D20 100% Stock Dividend 2 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 9 Common Stock, at par 10 Additional Paid in Capital 11 Total Contributed Capital 12 Retained Earnings 13 Total Stockholders' Equity 5,000 1.00 5,000 745,000 750,000 980,000 1,730,000 $ 16 Required: 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 resulting balances on the stockholders' equity section as a result 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 1) Issue a 100% stock dividend. 22 OR . ... Sheet1 ... + @ J -- + 100% READY Attempt(s)

ENTER YOUR ANSWERS AS FORMULAS!

Answer 1

Solution:

Stockholder's Equity	At Dec 31	100%	2	$5,000.00
		Stock	For 1	Cash
		Dividend	stock split	Dividend
Contributed Capital:
Number of common shares outstanding	5000	10000	10000	5000
Par value per common share	$1.00	$1.00	$0.50	$1.00
Common stock, at par	$5,000.00	$10,000.00	$5,000.00	$5,000.00
Additional paid in capital	$745,000.00	$745,000.00	$745,000.00	$745,000.00
Total contributed capital	$750,000.00	$755,000.00	$750,000.00	$750,000.00
Retained Earnings	$980,000.00	$975,000.00	$980,000.00	$975,000.00
Total stockholder's equity	$1,730,000.00	$1,730,000.00	$1,730,000.00	$1,725,000.00

Excel 8 - Microsoft Excel X 90 = File Home Insert Page Layout Formulas Data Review View - 2 x Calculate Now Insert Function Math & Trig More Functions A a Define Name Use in Formula Name Manager Create from Selection Defined Names AutoSum Recently Financial Logical Text Date & Lookup & Used Time Reference Function Library fax =B7+(B7*C3) Trace Precedents 5 Show Formulas Trace Dependents Error Checking Remove Arrows" Evaluate Formula Formula Auditing Watch Window Calculation Calculate Sheet Options Calculation A 5000 Stock For 1 Cash Stockholder's Equity At Dec 31 Dividend stock split Dividend 5 6 Contributed Capital: 5000 =B7*D3 =B8/D3 =D7*D8 =B10 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 stockholder's equity 14 =B7+(B7*C3) =B8 =C7*C8 745000 =C9+C10 =B12-(B7*C3*B8) =C11+C12 =B7 =B8 =E7*E8 =B10 =B7*B8 745000 =B9+B10 980000 =B11+B12 =D9+D10 =E9+E10 =B12 =D11 D12 =B12-E3 =E11+E12 20 Sheet52 Sheet156 (30) Sheet157 (21) Sheet64 Sheet204 Sheet207 Sheet364 Sheet950 KI M Ready Sheet786 (3) Circular References BO 100% o e o | Sowels acounting ques. Ky wicestco - W answes - Micres. De mase - Wind.. 0 + 9:15 AM 11/21/2019