Question
In: Finance
Show work in excel please A pension fund manager is considering three mutual funds. The first...
Show work in excel please
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a sure rate of 4.8%. The probability distributions of the risky funds are:
| Expected Return | Standard Deviation | |
| Stock Fund (s) | 18% | 38% |
| Stock Fund (b) | 9% | 32% |
b. The correlation between the fund returns is .1313. Suppose now that your portfolio must yield an expected return of 15% and be efficient, that is, on the best feasible CAL. a. What is the standard deviation of your portfolio? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
b-1. What is the proportion invested in the T-bill fund? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
b-2. What is the proportion invested in each of the two risky funds? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Solutions
jeff jeffy answered 2 weeks agoRelated Solutions
A pension fund manager is considering three mutual funds. The first is a stock fund,...
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a sure rate of 5.5%. The stock fund has an expected return of 15% and a standard deviation of 23%. The bond fund has an expected return of 9% and a standard deviation of 23%. The correlation between the fund returns is.15. a) What...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 5.5%. The probability distributions of
the risky funds are:
Expected Return
Standard Deviation
Stock fund (S)
16%
45%
Bond fund (B)
7%
39%
The correlation between the fund returns is 0.0385.
What is the expected return and standard deviation for...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 5.5%. The probability distributions of
the risky funds are:
Expected Return
Standard Deviation
Stock fund (S)
16%
45%
Bond fund (B)
7%
39%
The correlation between the fund returns is 0.0385.
What is the expected return and standard deviation for...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 4.7%. The probability distributions of
the risky funds are:
Expected Return
Standard Deviation
Stock fund (S)
17%
37%
Bond fund (B)
8%
31%
The correlation between the fund returns is 0.1065.
What is the Sharpe ratio of the best feasible...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a rate of 8%. The probability distribution of the risky
funds is as follows:
Expected Return
Standard Deviation
Stock fund (S)
17
%
30
%
Bond fund (B)
11
22
The correlation between the fund returns is 0.10.
a-1. What are the investment proportions...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 5.8%. The probability distributions of
the risky funds are:
Expected Return Standard Deviation
Stock fund (S) 19% 48%
Bond fund (B) 9% 42%
The correlation between the fund returns is 0.0762.
What is the Sharpe ratio of the best feasible...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a sure rate of 5.5%. The probability distributions of the risky funds are:Expected ReturnStandard DeviationStock fund (S)15%32%Bond fund (B)9%23%The correlation between the fund returns is .15 What is the expected return and standard deviation for the minimum-variance portfolio of the two risky funds? (Do not...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 4.1%. The probability distributions of
the risky funds are:
Expected Return
Standard Deviation
Stock fund (S)
11
%
33
%
Bond fund (B)
8
%
25
%
The correlation between the fund returns is .1560.
Suppose now that your portfolio...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 5.9%. The probability distributions of
the risky funds are:
Expected Return
Standard Deviation
Stock fund (S)
20%
49%
Bond fund (B)
9%
43%
The correlation between the fund returns is 0.0721.
What is the expected return and standard deviation for...
A pension fund manager is considering three mutual funds. The first is a stock fund, the...
A pension fund manager is considering three mutual funds. The
first is a stock fund, the second is a long-term government and
corporate bond fund, and the third is a T-bill money market fund
that yields a sure rate of 5.0%. The probability distributions of
the risky funds are:
Expected Return
Standard Deviation
Stock fund (S)
11%
40%
Bond fund (B)
6%
20%
The correlation between the fund returns is 0.0500.
What is the Sharpe ratio of the best feasible...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Below we are investigating the racial differences in occupational prestige. You will be asked to determine...
- To the TwoDArray class, add a method called sumCols() that sums the elements in each column...
- What are two of the best practices for developing and applying a training intervention in organizations?
- Explore the website about Emerging Measures and Models. After exploring this site and completing the reading...
- Write a short message of between 15 and 40 characters to your classmates. Encode it using...
- A single phase motor load draws 5.5 A of current at a 0.83 power factor lagging...
- what do you think the coding for carplay is ? give some examples of the code...
ADVERTISEMENT