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 −32% −10%
Mild recession 0.15 −10% 6%
Normal growth 0.35 22% 10%
Boom 0.40 37% 7%


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.)

Mean return %
Variance


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.)

Covariance=   

Solutions

Expert Solution

Answer a.

Computation of mean return of Stock fund

Calculation of mean return of Stock

Possible returns

Probability

Product

Xᵢ

p(Xᵢ)

Xᵢ p(Xᵢ)

-0.32

0.1

-0.032

-0.1

0.15

-0.015

0.22

0.35

0.077

0.37

0.4

0.148

0.178

Mean return of stock fund(X̅)= 17.8%

Calculation of variance of

Possible returns

Probability

Deviation

(Deviation)^2

Product

Xᵢ

p(Xᵢ)

(Xᵢ-X̅)^2

(Xᵢ-X̅)^2 ˣ p(Xᵢ)

-0.32

0.1

-0.498

0.248004

0.0248004

-0.1

0.15

-0.278

0.077284

0.0115926

0.22

0.35

0.042

0.001764

0.0006174

0.37

0.4

0.192

0.036864

0.0147456

Variance

0.051756

Variance = .05 ( Round to two decimal places)

Standard deviation = variance

                               =.05

                               =.2236

                               = 22.36%

Answer b.

Calculation of mean return of Bond

Possible returns

Probability

Product

Xᵢ

p(Xᵢ)

Xᵢ p(Xᵢ)

-0.1

0.1

-0.01

0.06

0.15

0.009

0.1

0.35

0.035

0.07

0.4

0.028

Mean (X̅)

0.062

Calculation of Deviation of Bond

Possible returns

Probability

Deviation

Xᵢ

p(Xᵢ)

(Xᵢ-X̅)

-0.1

0.1

-0.162

0.06

0.15

-0.002

0.1

0.35

0.038

0.07

0.4

0.008

Calculation of Covariance of stock and bond

Stock fund

Bond fund

Stcok ˣ Bond

Probability

Deviation

Product

Probability

Deviation

Product

0.1

-0.498

-0.0498

0.1

-0.162

-0.0162

0.00080676

0.15

-0.278

-0.0417

0.15

-0.002

-0.0003

0.00001251

0.35

0.042

0.0147

0.35

0.038

0.0133

0.00019551

0.4

0.192

0.0768

0.4

0.008

0.0032

0.00024576

Cov

0.00126054

Covariance = .001


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