Copy of FCF 9th edition Chapter 17

Copy of FCF 9th edition Chapter 17 - Chapter 17 Problems...

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

View Full Document Right Arrow Icon
Chapter 17 Problems 1-16 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 DocumentRight Arrow Icon
Chapter 17 Question 1 Input Area: Dividend per share $4.60 Tax rate 15% Price $80.37 Output Area: After-tax Dividend $3.91 Ex-dividend price $76.46
Background image of page 2
Chapter 17 Question 2 Input Area: Common stock $30,000 Par value $1 Capital surplus $285,000 Retained earnings $649,180 Total owners' equity $964,180 a. Stock price $30 Stock dividend 10% b. Stock dividend 25% Output Area: a. New shares outstanding 33,000 New shares issued 3,000 Capital surplus on new shares $87,000 Common stock $33,000 Capital surplus $372,000 Retained earnings $559,180 $964,180 b. New shares outstanding 37,500 New shares issued 7,500 Capital surplus on new shares $217,500 Common stock $37,500 Capital surplus $502,500 Retained earnings $424,180 $964,180
Background image of page 3

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

View Full DocumentRight Arrow Icon
Chapter 17 Question 3 Input Area: Common stock $30,000 Par value $1 Capital surplus $285,000 Retained earnings $649,180 Total owners'Equity $964,180 Stock price $30 a. Stock split 4 for 1 b. Stock split 1 for 5 Output Area: a. New shares outstanding 120,000 The accounts are unchanged except that par value is now $0.25 b. New shares outstanding 6,000 The accounts are unchanged except that par value is now $5.00
Background image of page 4
Chapter 17 Question 4 Input Area: Shares outstanding 350,000 Stock price $90.00 a. Stock split 5 for 3 b. Stock divdend percent 15.00% c. Stock divdend percent 42.50% d. Stock split (shares) 4 for 7 Output Area: a. Stock split $54.00 b. Stock dividend $78.26 c. Stock dividend $63.16 d. Stock split $157.50 e. a. New shares outstanding 583,333 b. New shares outstanding 402,500 c. New shares outstanding 498,750 d. New shares outstanding 200,000
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 17

Copy of FCF 9th edition Chapter 17 - Chapter 17 Problems...

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

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