Homework Help is Here – Start Your Trial Now!
Business
Finance
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
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
See similar textbooks
icon
Related questions
Question
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: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
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 ....
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Stock Market Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
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…
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
SEE MORE TEXTBOOKS