Chapter_11

Chapter_11 - Chapter 11 Problems 1-10 Input boxes in tan...

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

View Full Document Right Arrow Icon
Chapter 11 Problems 1-10 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, click on "Tools|Add-Ins" and select "Analysis ToolPak and "Solver Add-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
k"
Background image of page 2
Chapter 11 Question 1 Input area: GNP 1.200000 3.00% Interest rates (0.80) 4.50% E(R) of stock 11.00% Output area: Revised expected return 12.36% Factor Beta of Factor Expected Value
Background image of page 3

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

View Full DocumentRight Arrow Icon
4.20% 4.60% Actual Value
Background image of page 4
Chapter 11 Question 2 Input area: GNP 0.000586 $5,396 Inflation (1.40) 3.10% Interest rates (0.67) 9.50% Stock return from news -2.60% E(R) of stock 9.50% Output area: a. Systematic risk 0.83% b. Total return 7.73% Factor Beta of Factor Expected Value
Background image of page 5

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

View Full DocumentRight Arrow Icon
$5,436 3.80% 10.30% Actual Value
Background image of page 6
Chapter 11 Question 3 Input area: Growth in GNP 2.04 3.50% Interest rates (1.90) 7.10% Stock return 10.50% Previous market share 23.00% New market share 27.00%
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/14/2010 for the course FINC 311 taught by Professor Stanley,t during the Fall '08 term at Winthrop.

Page1 / 18

Chapter_11 - Chapter 11 Problems 1-10 Input boxes in tan...

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

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