PELLYKWS3A4Chapter 9 Individual Problems

PELLYKWS3A4Chapter 9 Individual Problems - Chapter 9...

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

View Full Document Right Arrow Icon
Chapter 9 Problems 13, 16, 23 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: 1) Click the Microsoft Office Button, and then click Excel Options 2) Click Add-Ins, and then in the Manage box, select Add-ins. 3) Click Go. 4) In the Add-Ins available box, select the Solver Add-in and Analysis ToolPak check boxes, and then click OK. 5) After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Chapter 9 Question 13 Input area: Dividend one $9.00 Dividend two 7.00 Dividend three 5.00 Dividend four 2.50 Dividend growth rate 5% Required return 13% Output area: Year 4 price $32.81 Share price $38.57 Chapter 9 Question 16 Input area: Dividend paid $12.00 Dividend growth rate-6% Required return 11% Output area: Price $66.35 Chapter 9 Question 23 Input area: Net income $10,000,000 Payout ratio 20% Shares of stock outstanding 2,000,000 Stock price $85.00 ROE 16% Output area: Growth rate 12.80% Current dividends per share $1.00 Dividend next year $1.13 Required return 14.13%...
View Full Document

Page1 / 4

PELLYKWS3A4Chapter 9 Individual Problems - Chapter 9...

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