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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started