Question

In: Finance

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 between the stock and bond funds. (Negative value should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to 2 decimal places.)

Solutions

Expert Solution

Answer:

STEPS:

1.Determine Mean= Probability x rate of return( say a)

2. Determine Da = A-a.

3. Determine Da².

4. Determine Variance of return= Probability x Da².

5. For finding Co variance multiply Da and Db.

Note: Covariance is a measure of how changes in one variable are associated with changes in second variable.

DETAILED CALCULATION IS SHOWN BELOW:-

1. Calculation of MEAN RETURN:

Scenario Probability Stock Fund    (A) Bond Fund (B) a b
Rate of Return Rate of Return 2x3 2x4
Severe recession 0.1 -43 -10 -4.3 -1
Mild recession 0.2 -23 16 -4.6 3.2
Normal growth 0.4 28 9 11.2 3.6
Boom 0.3 33 -6 9.9 -1.8
Mean Return 12.2 4

2. Calculation Of Variance and Co Variance

Scenario Probability(Pro) Da=A-a Db=B-b Da SQRT Db SQRT Da SQRTxPro Db SQRTxPro Z=DaxDb Zx Pro
Severe recession 0.1 -55.2 -14 3047.04 196 304.704 19.6 772.8 77.28
Mild recession 0.2 -35.2 12 1239.04 144 247.808 28.8 -422.4 -84.48
Normal growth 0.4 15.8 5 249.64 25 99.856 10 79 31.6
Boom 0.3 20.8 -10 432.64 100 129.792 30 -208 -62.4
Variance 782.16 88.4
Co Variance -38

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.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...
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.15 −46% −20% Mild recession 0.20 −24.0% 20% Normal growth 0.30 8% 5% Boom 0.35 44% −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 %-Squared b. Calculate the value of the covariance between...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT