Excel- Template-Chapter_12

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

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

View Full Document Right Arrow Icon
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."
Background image of page 1

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

View Full DocumentRight Arrow Icon
quire that  xcel.
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Variance - Standard Deviation 0.00%
Background image of page 4
- - - - - - - - - - - - Squared Deviation Squared Deviation
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
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
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9
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 Right Arrow Icon
Ask a homework question - tutors are online