Chapter_11

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

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

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."

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

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

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

View Full Document
4.20% 4.60% Actual Value
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

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

View Full Document
\$5,436 3.80% 10.30% Actual Value
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%

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.

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