Excel- Template-Chapter_12

# Excel- Template-Chapter_12 - 0.00% Variance = - Standard...

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

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

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

View Full Document
quire that  xcel.
Chapter 12 Question 7 Input area: Year X Y 1 2 3 4 5 Output area: X Deviation 1 - - - 2 - - - 3 - - - 4 - - - 5 - - - Total - Average return 0.00% Variance - Standard Deviation 0.00% X Deviation 1 - - - 2 - - - 3 - - - 4 - - - 5 - - - Total - Average return 0.00% Actual Return Average Return Actual Return Average Return

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

View Full Document
Variance - Standard Deviation 0.00%
- - - - - - - - - - - - Squared Deviation Squared Deviation

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

View Full Document
Chapter 12 Question 8 Input area: Year T-bills 1970 1971 1972 1973 1974 1975 Output area: Large company stocks Year Deviation 1970 - - - - 1971 - - - - 1972 - - - - 1973 - - - - 1974 - - - - 1975 - - - - Total - - Average return

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: 0.00% Variance = - Standard deviation = 0.00% T-bill returns Year Deviation 1970- - - - 1971- - - - 1972- - - - 1973- - - - 1974- - - - 1975- - - - Total- - Average return 0.00% Variance = - Standard deviation = 0.00% Large Stocks Actual Return Average Return Squared Deviation Actual Return Average Return Squared Deviation Average observed risk premium Year Actual Average Deviation 1970- - - - 1971- - - - 1972- - - - 1973- - - - 1974- - - - 1975- - - - Total- - Average return 0.00% Variance = - Standard deviation = 0.00% d. Before the fact, for most assets the risk premium will be positive; investors demand compensation over and above the risk-free return to invest their money in the risky asset. After the fact, the observed risk premium can be negative if the asset's nominal return is unexpectedly low, the risk-free rate is unexpectedly high, or if some combination of these two events occurs. Squared Deviation...
View Full Document

## This note was uploaded on 07/09/2011 for the course MK MK 640 taught by Professor Dr.lee during the Spring '11 term at Jefferson College.

### Page1 / 9

Excel- Template-Chapter_12 - 0.00% Variance = - Standard...

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

View Full Document
Ask a homework question - tutors are online