Chapter_09_HWK

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

This preview shows pages 1–5. Sign up to view the full content.

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

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

View Full Document
ToolPak check boxes, and then click OK. n the Analysis group on the Data tab.

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

View Full Document
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online