A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 5.5%. The characteristics of the risky funds are as follows: Expected Return  Standard Deviation Stock fund (S) 15% 32% Bond fund (B) 9  23 The correlation between the fund returns is .15 12.) if you were to use only the two risky funds and still require an expected return of 12% what would be the investment proportions of your portfolio? Compare its standard deviation to that of the optimal portfolio in the previous problem. What do you conclude?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question

A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 5.5%. The characteristics of the risky funds are as follows:

Expected Return  Standard Deviation

Stock fund (S) 15% 32%

Bond fund (B) 9  23

The correlation between the fund returns is .15

12.) if you were to use only the two risky funds and still require an expected return of 12% what would be the investment proportions of your portfolio? Compare its standard deviation to that of the optimal portfolio in the previous problem. What do you conclude? 

B21
=B10*(12%-B4)'(B11-B4)
A
В
1
Expected return
Standard deviation
2 Stock fund
3 Bond fund
4 Money market fund
0.32
|0.23
0.15
0.09
10.055
lo
5
6 Correlation (S,B)
7 Covariance (S,B)
0.15
=B6*C2*C3
8
9 Proportion of stock
10 Proportion of bond
11 Mean of portfolio
12 Standard deviation of portfolio
|=(B2-B4)*(C3^2))-(B3-B4)*B7))/(B2-B4)*C3^2)+((B3-B4)*C2^2)-((B2-B4+B3-B4)*B7))
I=1-B9
l=(B9*B2)+(B10*B3)
|=SQRT((B9^2*(C2^2))+(B10^2*(C3^2))+(2*B9*B10*B7))
|=B11-B4)/B12
13 Reward to variability ratio
14
15 Part a:
16 Standard deviation of optimal portfolio =(12%-B4)/B13
17
18 Part b:
19 Proportion of money market fund
20 Proportion of stock fund
21 Proportion of bond fund
=1-((12%-B4)/(B11-B4))
|=B9*(12%-B4)/(Bl1-B4)
=B10*(12%-B4)/(B11-B4)
Transcribed Image Text:B21 =B10*(12%-B4)'(B11-B4) A В 1 Expected return Standard deviation 2 Stock fund 3 Bond fund 4 Money market fund 0.32 |0.23 0.15 0.09 10.055 lo 5 6 Correlation (S,B) 7 Covariance (S,B) 0.15 =B6*C2*C3 8 9 Proportion of stock 10 Proportion of bond 11 Mean of portfolio 12 Standard deviation of portfolio |=(B2-B4)*(C3^2))-(B3-B4)*B7))/(B2-B4)*C3^2)+((B3-B4)*C2^2)-((B2-B4+B3-B4)*B7)) I=1-B9 l=(B9*B2)+(B10*B3) |=SQRT((B9^2*(C2^2))+(B10^2*(C3^2))+(2*B9*B10*B7)) |=B11-B4)/B12 13 Reward to variability ratio 14 15 Part a: 16 Standard deviation of optimal portfolio =(12%-B4)/B13 17 18 Part b: 19 Proportion of money market fund 20 Proportion of stock fund 21 Proportion of bond fund =1-((12%-B4)/(B11-B4)) |=B9*(12%-B4)/(Bl1-B4) =B10*(12%-B4)/(B11-B4)
В21
=B10*(12%-B4)/(B11-B4)
A
B
Expected return Standard deviation
15%
9%
5.50%
1
2 Stock fund
32%
23%
3 Bond fund
4 Money market fund
5
6 Correlation (S.B)
7 Covariance (S,B)
0.15
0.01104
8.
9 Proportion of stock
10 Proportion of bond
11 Mean of portfolio
12 Standard deviation of portfolio
13 Reward to variability ratio
64.66%
35.34%
12.88%
23.34%
31.62%
14
15 Part a:
| 16 Standard deviation of optimal portfolio
20.56%
17
18 Part b:
11.92%
19 Proportion of money market fund
20 Proportion of stock fund
21 Proportion of bond fund
56.95%
31.12%
Transcribed Image Text:В21 =B10*(12%-B4)/(B11-B4) A B Expected return Standard deviation 15% 9% 5.50% 1 2 Stock fund 32% 23% 3 Bond fund 4 Money market fund 5 6 Correlation (S.B) 7 Covariance (S,B) 0.15 0.01104 8. 9 Proportion of stock 10 Proportion of bond 11 Mean of portfolio 12 Standard deviation of portfolio 13 Reward to variability ratio 64.66% 35.34% 12.88% 23.34% 31.62% 14 15 Part a: | 16 Standard deviation of optimal portfolio 20.56% 17 18 Part b: 11.92% 19 Proportion of money market fund 20 Proportion of stock fund 21 Proportion of bond fund 56.95% 31.12%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman