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 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)...
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?...
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...
The table below shows this market basket and the price of each good in 2015 and...
The table below shows this market basket and the price of each good in 2015 and 2016. For the questions below, assume that 2015 is the base year. 2015 2016 Good Quantity Unit price Unit price Textbooks 7 $180.00 $210.00 Pizza 9 12.00 10.00 Beer 12 10.00 12.00 Compute the CPI in 2016 and the inflation rate between 2015 and 2016. Suppose in 2016, you buy 10 textbooks instead of 7, will your answers in (a) and (b) change? Explain...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT