Excel Solutions - Chapter 18

Excel Solutions - Chapter 18 - Chapter 18 Problems 1-18...

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

View Full Document Right Arrow Icon
Chapter 18 Problems 1-18 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green
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 18 Question 1 Input Area: Dividend per share $6.00 Tax rate 15% Price $80 Output Area: After-tax Dividend $5.10 Ex-dividend price $74.90
Background image of page 2
Chapter 18 Question 2 Input Area: Common stock $10,000 Par value $1 Capital surplus $180,000 Retained earnings $586,500 Total owners'Equity $776,500 a. Stock price $25 Stock dividend 10% b. Stock dividend 25% Output Area: a. New shares outstanding 11,000 New shares issued 1,000 Capital surplus on new shares $24,000 Common stock $11,000 Capital surplus $204,000 Retained earnings $561,500 $776,500 b. New shares outstanding 12,500 New shares issued 2,500 Capital surplus on new shares $60,000 Common stock $12,500 Capital surplus $240,000 Retained earnings $524,000 $776,500
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 18 Question 3 Input Area: Common stock $10,000 Par value $1 Capital surplus $180,000 Retained earnings $586,500 Total owners'Equity $776,500 Stock price $25 a. Stock split 4 for 1 b. Stock split 1 for 5 Output Area: a. New shares outstanding 40,000 The accounts are unchanged except that par value is now $0.25 b. New shares outstanding 2,000 The accounts are unchanged except that par value is now $5.00
Background image of page 4
Chapter 18 Question 4 Input Area: Shares outstanding 150,000 Stock price $65.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 $39.00 b. Stock dividend $56.52 c. Stock dividend $45.61 d. Stock split $113.75 e. a. New shares outstanding 250,000 b. New shares outstanding 172,500 c. New shares outstanding 213,750 d. New shares outstanding 85,714
Background image of page 5

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

View Full DocumentRight Arrow Icon
Chapter 18 Question 5 Input Area: Shares outstanding
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 19

Excel Solutions - Chapter 18 - Chapter 18 Problems 1-18...

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

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