Chapter_09_HWK - Chapter 9 Question 13 Input area: Dividend...

Info iconThis preview shows pages 1–5. 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 T 5) After you load the Solver Add-in, the Solver command is available 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
ToolPak check boxes, and then click OK. n the Analysis group on the Data tab.
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
Background image of page 5
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 Dividend growth rate Required return Output area: Price #DIV/0! Chapter 9 Question 23 Input area: Net income Payout ratio Shares of stock outstanding Stock price ROE Output area: Growth rate 0.00% Current dividends per share #DIV/0! Dividend next year #DIV/0! Required return #DIV/0!...
View Full Document

Page1 / 5

Chapter_09_HWK - Chapter 9 Question 13 Input area: Dividend...

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

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