PELLYKW6A4 - Chapter 19 Problems 2 4 6 10 Input boxes in...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 19 Problems 2, 4, 6, 10 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak" and "Solver Add-In."
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Chapter 19 Question 2 Input Area: Common stock $20,000 Par value $1 Capital surplus $210,000 Retained earnings $735,000 Total owners' equity $965,000 a. Stock price $48 Stock dividend 10% b. Stock dividend 25% Output Area: a. New shares outstanding 22,000 New shares issued 2,000 Capital surplus on new shares $94,000 Common stock $22,000 Capital surplus 304,000 Retained earnings 639,000 $965,000 b. New shares outstanding 25,000 New shares issued 5,000 Capital surplus on new shares $235,000 Common stock $25,000 Capital surplus 445,000 Retained earnings 495,000 $965,000
Background image of page 2
Chapter 19 Question 4 Input Area: Shares outstanding 260,000 Stock price
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 5

PELLYKW6A4 - Chapter 19 Problems 2 4 6 10 Input boxes in...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online