1. Analyze the effects of alternative distributions on stockholders' equity. Cash dividends, stock dividends, and stock splits - Excel FILE Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 A A % Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Paste BIU Clipboard Font Styles A1 fe At December 31, Artists Unlimited Company had the following B D E At December 31, Artists Unlimited Company had the following 2 stockholder's equity components that would be part of the balance sheet: 100% 2 $5,000 Stock for 1 Stock Cash 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 At Dec 31 Dividend Split Dividend 5,000 24 1.00 5,000 745,000 Total Contributed Capital 12 Retained Earnings 13 750,000 980,000 Total Stockholders' Equity 14 15 16 Required: 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 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. 20 123 4
1. Analyze the effects of alternative distributions on stockholders' equity. Cash dividends, stock dividends, and stock splits - Excel FILE Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 A A % Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Paste BIU Clipboard Font Styles A1 fe At December 31, Artists Unlimited Company had the following B D E At December 31, Artists Unlimited Company had the following 2 stockholder's equity components that would be part of the balance sheet: 100% 2 $5,000 Stock for 1 Stock Cash 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 At Dec 31 Dividend Split Dividend 5,000 24 1.00 5,000 745,000 Total Contributed Capital 12 Retained Earnings 13 750,000 980,000 Total Stockholders' Equity 14 15 16 Required: 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 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. 20 123 4
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Transcribed Image Text:1. Analyze the effects of alternative distributions on stockholders' equity.
Cash dividends, stock dividends, and stock splits - Excel
Sign In
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
A A
11
%
Alignment Number Conditional Format as Cell
Formatting Table Styles
Paste
в I U
Cells
Editing
Clipboard a
Font
Styles
A1
fe
At December 31, Artists Unlimited Company had the following
A
B
D
E
1 At December 31, Artists Unlimited Company had the following
2 stockholder's equity components that would be part of the balance sheet:
3
100%
2
$5,000
4
Stock
for 1 Stock
Cash
5 Stockholders' Equity
6 Contributed Capital:
7 Number of common shares outstanding
8 Par value per common share
9 Common Stock, at par
At Dec 31
Dividend
Split
Dividend
5,000
1.00
5,000
10
Additional Paid in Capital
745,000
11
Total Contributed Capital
750,000
12 Retained Earnings
980,000
Total Stockholders' Equity
13
1,730,000
14
15
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.
20
04.
Sheet1
>
%24
Transcribed Image Text:7 Number of common shares outstanding
8 Par value per common share
9 Common Stock, at par
10 Additional Paid in Capital
5,000
1.00
5,000
745,000
11
Total Contributed Capital
12 Retained Earnings
Total Stockholders' Equity
750,000
980,000
13
2$
1,730,000
14
15
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.
20
21 1) Issue a 100% stock dividend.
22 OR
23 2) Execute a 2-for-1 stock split.
24 OR
25 3) Distribute a $5,000 cash dividend.
26
Sheet1
....
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education