Excel Solutions - Chapter 08

Fundamentals of Corporate Finance Standard Edition

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

View Full Document Right Arrow Icon
Chapter 8 Problems 1-22 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 8 Question 1 Input area: Dividend paid $1.40 Dividend growth rate 6% Required return 12% # of years 0 Output area: Price $24.73
Background image of page 2
Chapter 8 Question 2 Input area: Dividend paid $3.10 Dividend growth rate 5% Stock price $48.00 Output area: Required return = 11.46%
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 8 Question 3 Input area: Dividend paid $3.10 Dividend growth rate 5% Required return $48.00 Output area: Dividend yield = 6.46% Capital gains yield = 5.00%
Background image of page 4
Chapter 8 Question 4 Input area: Dividend paid $3.60 Dividend growth rate 4.50% Required return 13% Output area: Price = $42.35
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 8 Question 5 Input area: Dividend growth rate 6.0% Required return 3.9% Output area: Required return = 9.90%
Background image of page 6
Chapter 8 Question 6 Input area: Stock price $70.00 Required return 12.0% Output area: Current dividend = $3.96
Background image of page 7

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

View Full DocumentRight Arrow Icon
Chapter 8 Question 7 Input area: Current dividend $12.00 Required return 10.0% Years until dividend ceases 8 Output area: Share price = $64.02
Background image of page 8
Chapter 8 Question 8 Input area: Current dividend $8.25 Share price 113.00 Output area: Required return = 7.30%
Background image of page 9

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

View Full DocumentRight Arrow Icon
Chapter 8 Question 9 Input area: Dividend paid $3.00 Dividend growth rate 5.0% Initial required return 16% Second required return
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 24

Excel Solutions - Chapter 08 - Chapter 8 Problems 1-22...

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

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