Question

In: Finance

The table below shows daily returns on XYZ and Market. Return of XYZ Return of Market...

The table below shows daily returns on XYZ and Market.

Return of XYZ

Return of Market

Monday

5%

-4%

Tuesday

-3%

3%

Wednesday

6%

10%

Thursday

-10%

-5%

Friday

8%

7%

  1. Find Expected returns of XYZ and Market.

  1. What is the covariance of XYZ and the Market?
  1. Find the Beta of XYZ.

Solutions

Expert Solution

Expected return of XYZ = [5%-3%+6%-10%+8%]/5 = 6%/5 = 1.2%

Expected return of market = [-4%+3%+10%-5%+7%]/5 = 11%/5 = 2.2%

Days (i) Return of XYZ (ii) Return of Market (iii) Return of XYZ - Expected return of XYZ (iv) Return of market - Expected return of market (v) (vi) = (iv)*(v) (vii) = (v)^2
Monday 5% -4% 3.80% -6.20% -0.2356% 0.3844%
Tuesday -3% 3% -4.20% 0.80% -0.0336% 0.0064%
Wednesday 6% 10% 4.80% 7.80% 0.3744% 0.6084%
Thursday -10% -5% -11.20% -7.20% 0.8064% 0.5184%
Friday 8% 7% 6.80% 4.80% 0.3264% 0.2304%
1.2380% 1.7480%

Covariance of XYZ & market = Σ{[Return of XYZ - Expected return of XYZ]*[Return of market - Expected return of market]/N = 1.238%/5 = 0.2476%

Variance of market = Σ{[(Return of market - Expected return of market)^2]}/N = 1.748%/5 = 0.3496%

Beta of XYZ = Covariance of XYZ & market/Variance of market = 0.2476%/0.3496% = 0.7082


Related Solutions

EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in...
EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in percentages) for 2 major market indices. For each index, calculate the arithmetic mean return and the geometric mean return of full-year returns from 2005-2015. What is the relationship between the arithmetic and geometric mean returns? 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 Nasdaq Composite Index 1.37 8.59 50.0 -31.5 -21.1 -39.3 85.6 39.6 21.6 22.7 39.9 Dow Jones Industrial Average...
3The table below shows the number of diapers demanded daily and the cumulative probabilities associated with...
3The table below shows the number of diapers demanded daily and the cumulative probabilities associated with each level of demand. Daily Demand 1 2 3 Cumulative Probability 0.12 0.25 1 If a random number 67 is generated. What would be the simulated demand ?
Intro The following table shows rates of return for a mutual fund and the market portfolio...
Intro The following table shows rates of return for a mutual fund and the market portfolio (S&P 500). A B C 1 Year Fund Market 2 1 14% 13% 3 2 -24% -14% 4 3 -6% -7% 5 4 5% 28% 6 5 14% 8% 7 6 16% 8% Attempt 1/3 for 10 pts. Part 1 Regress the returns on the stock on the returns on the S&P 500. What is the beta of the fund, using the industry model...
Table below shows the historical returns for Companies A, B and C Year Company A Company...
Table below shows the historical returns for Companies A, B and C Year Company A Company B Company C 1 30% 26% 47% 2 7% 15% -54% 3 18% -14% 15% 4 -22% -15% 7% 5 -14% 2% -28% 6 10% -18% 40% 7 26% 42% 17% 8 -10% 30% -23% 9 -3% -32% -4% 10 38% 28% 75% 11 27.0% 23.4% 42.3% 12 6.3% 13.5% -48.6% 13 16.2% -12.6% 13.5% 14 -19.8% -13.5% 6.3% 15 -12.6% 1.8% -25.2% 16...
The table below shows the returns and probabilities of 3 different financial assets (A, B, C)....
The table below shows the returns and probabilities of 3 different financial assets (A, B, C). Which financial asset should be preferred according to the Risk-Return analysis? (Coefficient of Change will be calculated over Standard Deviation / Expected Return.). You can use 4 digits after the comma in your calculations. Possibility Return A Return B Return C 0,10 (-)0,09 0,01 (-)0,20 0,35 0,08 0,05 (-)0,10 0,40 0,13 0,10 0,25 0,15 0,20 0,15 0,75
The table below shows the returns and probabilities of 3 different financial assets (A, B, C)....
The table below shows the returns and probabilities of 3 different financial assets (A, B, C). Which financial asset should be preferred according to the Risk-Return analysis? (Coefficient of Change will be calculated over Standard Deviation / Expected Return.). You can use 4 digits after the comma in your calculations. Possibility Return A Return B Return C 0.10 (-)0,09 0,01 (-)0,20 0.35 0,08 0,05 (-)0,10 0,40 0,13 0,10 0,25 0,15 0,20 0,15 0,75 I would appreciate if you show transactions
The table below shows annual returns for stocks of companies X and Y. Calculate the arithmetic...
The table below shows annual returns for stocks of companies X and Y. Calculate the arithmetic average returns. In addition, calculate their variances, as well as their standard deviations.    Returns Year X Y 1 11 %     19 %     2 29         40         3 18         -9         4 -19         -23         5 20         48             Requirement 1: (a) The arithmetic average return of company X's stock is: (Click to select)  11.80%  9.56%  13.33%  14.75%  14.40%     (b) The...
Misha makes wooden dolls. The table below shows the daily demand for his dolls and his...
Misha makes wooden dolls. The table below shows the daily demand for his dolls and his marginal costs. Misha's total fixed cost is $20 per day. Price 24 22 20 18 16 14 12 10 QD 0 1 2 3 4 5 6 7 MC 0 5 6 7 8 9 10 11. In the scenario above, what is Misha's marginal revenue from the fourth doll? In the scenario above, how many dolls should Misha produce to maximize his profit?...
The table below shows the probability of three economic scenarios and the corresponding percent return for...
The table below shows the probability of three economic scenarios and the corresponding percent return for stock X and stock Y (note that f(x) = f(y) =f(x+y)=f(x,y)                                         Economy Probability f(x,y) Return On X Return On Y recession .20 -15 7 stable .55 8 3 Strong .25 20 1 You are given the expected value E(x) = 6.4, the variance Var(x) = 139.24, and E(y) = 3.3,   Var(y) = 4.11 a) Find the expected value E(x+y) b) Find the variance Var(x+y)...
Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3:...
Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3: Annual Returns Year Returns 2000 -9.0% 2001 -11.9% 2002 -22.0% 2003 28.4% 2004 10.7% 2005 4.8% 2006 15.6% 2007 5.5% 2008 -36.6% 2009 25.9% 2010 14.8% 2011 2.1% 2012 15.9% 2013 32.2% 2014 13.5% 2015 1.4% 2016 11.7% Calculate: The cumulative return over the 17 years; The average annual return; The standard deviation; The Sharpe Ratio (assuming a risk free rate of 2.3% on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT