PELLYKWS3A4Chapter 9 Individual Problems

# PELLYKWS3A4Chapter 9 Individual Problems - Chapter 9...

This preview shows pages 1–4. 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 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.

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

View Full Document

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 \$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

## This note was uploaded on 02/12/2012 for the course MBA 551 taught by Professor Smith during the Spring '11 term at Indiana Wesleyan.

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