Question: Please help solve this case study for my business analytics class: The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to design a minimum variance

Please help solve this case study for my business analytics class:

The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to design a minimum variance portfolio of index funds to invest some of the firm's cash reserves. The funds selected for consideration and their variance-covariance matrix and average returns are given in the table below.

a. The firm would like to achieve a target return of 0.19%. What mix of investments would achieve this?

b. To obtain better diversification, the CFO would like to restrict the percentage of investments in each fund as follows:

BOND: between 10% and 50%

S&P 500: between 30% and 50%

SMALL CAP: no more than 20%

MID CAP: no more than 20%

LARGE CAP: no more than 25%

EMERGING MARKET: no more than 10%

COMMODITY: no more than 20%

How would the optimal portfolio and objective change? Summarize your findings in a short memo to Mr. Ferguson

Bond S&P 500 Small Cap Mid Cap Large Cap Emerging Market Commodity

Bond

0.002%

S&P 500 -0.001% 0.020%
Small Cap

-0.001%

0.027% 0.047%
Mid Cap -0.001% 0.024% 0.039% 0.033%
Large Cap -0.001% 0.019% 0.027% 0.023% 0.027%
Emerging market 0.000% 0.032% 0.050% 0.043% 0.041% 0.085%
Commodity 0.000% 0.000% 0.005% 0.005% 0.009% 0.015% 0.054%
Avg Weekly Return 0.044% 0.118% 0.256% 0.226% 0.242% 0.0447% 0.053%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!