Chapter_08 - Chapter 8 Input boxes in tan Output boxes in...

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

View Full Document Right Arrow Icon
Chapter 8 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 req the "Analysis ToolPak" or "Solver Add-In" be installed in Ex To install these, click on the Office button  then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and  "Solver Add-In," then click "OK."
Background image of page 1

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

View Full Document Right Arrow Icon
quire that  xcel.
Background image of page 2
Chapter 8 Question 4 Input area: Dividend paid Dividend growth rate Required return Output area: Price #DIV/0!
Background image of page 3

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

View Full Document Right Arrow Icon
Chapter 8 Question 6 Input area: Stock price Required return Output area: Next year's dividend $- Current dividend $-
Background image of page 4
Question 10 Input area: Dividend paid Dividend growth rate Required return for first 3 years Required return for second 3 years Final required return Output area: Stock price at beginning of final period #DIV/0! Stock price at beginning of second period #DIV/0! Current stock price
Background image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 9

Chapter_08 - Chapter 8 Input boxes in tan Output boxes in...

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

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