FM11_Ch_05_Tool_Kit - Michael C Ehrhardt Model Ch 05 Tool...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
983e 486f2b383ac35d 7b729b a9bf726517f7e.xls Model Michael C. Ehrhardt Page 1 01/20/2014 Ch 05 To l Kit 5/2/20 3 Chapter 5. To l Kit for Risk and Return: Portfolio Theory and As et Pricing Models PROBABILITY DISTRIBUTIONS The probability distribution is a listing of al pos ible outcomes and the cor esponding probability. Rate of Return Distribution E F G H 0.10 10% 6% 14% 4% 0.20 10% 8% 12% 6% 0.40 10% 10% 10% 8% 0.20 10% 12% 8% 15% 0.10 10% 14% 6% 2 % 1.0 EXPECTED RATE OF RETURN AND STANDARD DEVIATION Calculation of expected return and standard deviation for E Expected rate of return for E Standard deviation for E Rate of Return Product Sq Dev * Prob. 10% 10% 1.0 % 0% 0.0 % 0.0 % 20% 10% 2.0 % 0% 0.0 % 0.0 % 40% 10% 4.0 % 0% 0.0 % 0.0 % 20% 10% 2.0 % 0% 0.0 % 0.0 % 10% 10% 1.0 % 0% 0.0 % 0.0 % 10 % Sum: 0.0 % 10% 0.0 % Indirect method r hat = 10% 0.0 % Calculation of expected return and standard deviation for F Expected rate of return for F Standard deviation for F Rate of Return Product Sq Dev * Prob. 10% 6% 0.60% -4% 0.16% 0.02% 20% 8% 1.60% -2% 0.04% 0.01% 40% 10% 4.0 % 0% 0.0 % 0.0 % 20% 12% 2.40% 2% 0.04% 0.01% 10% 14% 1.40% 4% 0.16% 0.02% 10 % Sum: 0.05% 10% 2.19% Indirect method r hat = 10% 2.19% Calculation of expected return and standard deviation for G Expected rate of return for G Standard deviation for G Rate of Return Product Sq Dev * Prob. 10% 14% 1.40% 4% 0.16% 0.02% 20% 12% 2.40% 2% 0.04% 0.01% 40% 10% 4.0 % 0% 0.0 % 0.0 % 20% 8% 1.60% -2% 0.04% 0.01% 10% 6% 0.60% -4% 0.16% 0.02% 10 % Sum: 0.05% 10% 2.19% Indirect method r hat = 10.0 % 2.19% Calculation of expected return and standard deviation for H Expected rate of return for H Standard deviation for H Rate of Return Product Sq Dev * Prob. 10% 4% 0.40% -6% 0.36% 0.04% 20% 6% 1.20% -4% 0.16% 0.03% 40% 8% 3.20% -2% 0.04% 0.02% 20% 15% 3.0 % 5% 0.25% 0.05% 10% 2 % 2.20% 12% 1.4 % 0.14% 10 % Sum: 0.28% 10.0 % 5.27% Indirect method r hat = 10.0 % 5.27% COVARIANCE Calculation of covariance betwe n F and G 10% -4% 4% -0.160 % -0.02% 20% -2% 2% -0.040 % -0.01% 40% 0% 0% 0.0 0 % 0.0 % 20% 2% -2% -0.040 % -0.01% 10% 4% -4% -0.160 % -0.02% 10 % -0.048% Calculation of covariance betwe n F and H 10% -4% -6% 0.240 % 0.02% 20% -2% -4% 0.080 % 0.02% 40% 0% -2% 0.0 0 % 0.0 % 20% 2% 5% 0.10 0% 0.02% 10% 4% 12% 0.480 % 0.05% 10 % 0.108% Calculation of covariance betwe n F and E 10% -4% 0% 0.0 0 % 0.0 % 20% -2% 0% 0.0 0 % 0.0 % 40% 0% 0% 0.0 0 % 0.0 % 20% 2% 0% 0.0 0 % 0.0 % 10% 4% 0% 0.0 0 % 0.0 % 10 % 0.0 0% COR ELATION COEF ICIENT Calculation of the cor elation betwe n F and G Covariance FG ÷ = -0.048% ÷ 2.19% 2.19% = -0.048% ÷ 0.048% -1.0 Calculation of the cor elation betwe n F and H Covariance FH ÷ = 0.108% ÷ 2.19% 5.27% = 0.108% ÷ 0.1 6% 0.935 PORTFOLIO RISK AND RETURN: THE TWO-AS ET CASE AT AINABLE PORTFOLIOS: THE TWO AS ET-CASE As et A As et B Expected return, r ha 5% 8% 4% 10% Cor elation = 1 1.0 0.0 5.0 % 4.0% 0.90 0.10 5.30% 4.6% 0.80 0.20 5.60% 5.2% 0.70 0.30 5.90% 5.8% 0.60 0.40 6.20% 6.4% 0.50 0.50 6.50% 7.0% 0.40 0.60 6.80% 7.6% 0.30 0.70 7.10% 8.2% 0.20 0.80 7.40% 8.8% 0.10 0.90 7.70% 9.4% 0.0 1.0 8.0 % 10.0% Cor elation = 0 1.0 0.0 5.0 % 4.0% 0.90 0.10 5.30% 3.7% 0.80 0.20 5.60% 3.8% 0.70 0.30 5.90% 4.1% 0.60 0.40 6.20% 4.7% 0.50 0.50 6.50% 5.4% 0.40 0.60 6.80% 6.2% 0.30 0.70 7.10% 7.1% 0.20 0.80 7.40% 8.0% 0.10 0.90 7.70% 9.0% 0.0 1.0 8.0 % 10.0% Cor elation = -1 1.0 0.0 5.0 % 4.0% 0.90 0.10 5.30% 2.6% 0.80 0.20 5.60% 1.2% 0.70 0.30 5.90% 0.2% 0.60 0.40 6.20% 1.6% 0.50 0.50 6.50% 3.0% 0.40 0.60 6.80% 4.4% 0.30 0.70 7.10% 5.8% 0.20 0.80 7.40% 7.2% 0.10 0.90 7.70% 8.6% 0.0 1.0 8.0 % 10.0% AT AINABLE AND EF ICIENT PORTFOLIOS: MANY AS ETS OPTIMAL PORTFOLIOS EF ICIENT SET WITH A RISK-FRE AS ET OPTIMAL PORTFOLIO WITH A RISK-FRE AS ET CALCULATING BETAS Date March 20 3 0.8% 6.0% 1.1% 0.09% 0.7% 5.9% February 20 3 -1.7% 4.7% -1.2% 0.10% -1.8% 4.6% January 20 3 -2.7% -5.0% -2.8% 0.10% -2.8% -5.1% December 20 2 -6.0% -9.5% -7.2% 0.10% -6.1% -9.6% November 20 2 5.7% 7.4% 5.2% 0.10% 5.6% 7.3% October 20 2 8.6% 2.4% 9.4% 0.13% 8.5% 2.3% September 20 2 -1 .0% -17.7% -10.8% 0.14% -1 .1% -17.8% August 20 2 0.5% -6.4% 1.0% 0.14% 0.4% -6.5% July 20 2 -7.9% 10.8% -7.2% 0.14% -8.0% 10.7% June 20 2 -7.2% -6.1% -7.7% 0.14% -7.4% -6.3% May 20 2 -0.9% -1.3% -0.3% 0.14% -1.1% -1.4% April 20 2 -6.1% -15.6% -6.4% 0.14% -6.3% -15.8% March 20 2 3.7% -2.9% 3.4% 0.15% 3.5% -3.0% February 20 2 -2.1% 4.1% -1.7% 0.14% -2.2% 4.0% January 20 2 -1.6% -7.3% -3.1% 0.14% -1.7% -7.4% December 20 1 0.8% 4.6% 0.7% 0.14% 0.6% 4.4% November 20 1 7.5% 5.7% 7.5% 0.16% 7.4% 5.6% October 20 1 1.8% -2.1% 2.4% 0.18% 1.6% -2.3% September 20 1 -8.2% -8.6% -8.1% 0.2 % -8.4% -8.8% August 20 1 -6.4% -6.0%
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online