Question

In: Finance

Consider the following table:     Stock Fund Bond Fund Scenario Probability Rate of Return Rate of...

Consider the following table:

   

Stock Fund Bond Fund
Scenario Probability Rate of Return Rate of Return
  Severe recession 0.05        −44%        −13%         
  Mild recession 0.25        −16%        11%         
  Normal growth 0.40        10%        4%         
  Boom 0.30        30%        3%         

   

b.

Calculate the values of expected return and variance for the stock fund. (Do not round intermediate calculations. Enter "Expected return" value as a percentage rounded to 1 decimal place and "Variance" as decimal number rounded to 4 decimal places.)

       

Expected return %
  Variance   


c.

Calculate the value of the covariance between the stock and bond funds. (Negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer as a decimal number rounded to 4 decimal places.)


  Covariance   

Solutions

Expert Solution

Stock Fund:
Scenario Probability of scenario [p] Rate of return [%] E[r] = p*r d = r-E[r] d^2 p*d^2
Severe recession 0.05 -0.44 -0.0220 -0.5080 0.2581 0.0129
Mild recession 0.25 -0.16 -0.0400 -0.2280 0.0520 0.0130
Normal growth 0.40 0.10 0.0400 0.0320 0.0010 0.0004
Boom 0.30 0.30 0.0900 0.2320 0.0538 0.0161
0.0680 0.0425
Expected return 6.8%
Variance 0.0425
SD 20.60%
Coefficient of variation 3.03
Bond Fund:
Scenario Probability of Scenario [p] Rate of return [%] E[r] = p*r d = r-E[r] d^2 p*d^2
Severe recession 0.05 -0.13 -0.0065 -0.1760 0.0310 0.0015488
Mild recession 0.25 0.11 0.0275 0.0640 0.0041 0.0010240
Normal growth 0.40 0.04 0.0160 -0.0060 0.0000 0.0000144
Boom 0.30 0.03 0.0090 -0.0160 0.0003 0.0000768
0.0460 0.0026640
Expected return 4.60%
Variance 0.0027
SD 5.16%
Coefficient of variation 1.12
Correlation [A,B]:
Scenario Probability of Scenario [p] ds*db ds*db*p
Severe recession 0.05 0.089408 0.0045
Mild recession 0.25 -0.014592 -0.0036
Normal growth 0.40 -0.000192 -0.0001
Boom 0.30 -0.003712 -0.0011
Covariance [Stock,Bond] -0.0004
a] STOCK FUND:
Expected return 6.80%
Variance 0.0425
b] BOND FUND:
Expected return 4.60%
Variance 0.0027
c] Covariance [Stock,Bond] -0.0004

Related Solutions

Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.10 –43 % –10 % Mild recession 0.20 –23 % 16 % Normal growth 0.40 28 % 9 % Boom 0.30 33 % –6 % a.Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 2 decimal places.) b.Calculate the value of the covariance...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.05 −41% −18% Mild recession 0.20 −11.0% 14% Normal growth 0.30 8% 5% Boom 0.45 34% 6% a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) b. Calculate the value of the covariance between the stock and bond funds....
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.10 ?30% ?11% Mild recession 0.15 ?12% 8% Normal growth 0.35 6% 2% Boom 0.40 39% 5% a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) Mean return _______ % Variance ________ b. Calculate the value of the covariance...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.05 –25 % –10 % Mild recession 0.25 –5 % 16 % Normal growth 0.40 10 % 9 % Boom 0.30 15 % –6 % a.Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 2 decimal places.) b.Calculate the value of the covariance...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.10 −32% −17% Mild recession 0.15 −22.0% 15% Normal growth 0.35 14% 6% Boom 0.40 35% 4% a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) PLEASE USE EXCEL AND PROVIDE FORMULA VIEW Consider the following table: Stock Fund...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.05 −46% −16% Mild recession 0.20 −22.0% 11% Normal growth 0.30 5% 2% Boom 0.45 42% 5% a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) b. Calculate the value of the covariance between the stock and bond funds....
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession .10 –37% –9% Mild recession .20 –11% 15% Normal growth .35 14% 8% Boom .35 30% –5% a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) Mean return % Variance b. Calculate the value of the covariance between the...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.05 –40 % –9 % Mild recession 0.25 –14 % 15 % Normal growth 0.40 17 % 8 % Boom 0.30 33 % –5 % a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 2 decimal places.) b. Calculate the value of...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.20 −18% −18% Mild recession 0.25 −11.0% 20% Normal growth 0.25 8% 5% Boom 0.30 34% −6% a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) Mean return ??? % Variance ??? %-Squared b. Calculate the value of the...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return...
Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.05 –25 % –10 % Mild recession 0.25 –5 % 16 % Normal growth 0.40 10 % 9 % Boom 0.30 15 % –6 % a.Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 2 decimal places.) b.Calculate the value of the covariance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT