Use the ETF data below:
a) Create a variance/covariance matrix using the data from the table.
b) Determine the weights for the minimum variance portfolio using Solver, excluding the world ETF (VT). Assume that short sales are allowed and that the proceeds from the shorted securities can be used to purchase more of the long positions.
c) Determine the weights of four additional portfolios that are in the efficient frontier using Solver excluding the world ETF (VT). Make sure that the target return of the last portfolio is equal to that of the ETF with the highest return.
d) Create a chart of the efficient frontier based on the portfolios created in part c, and that also includes the returns and standard deviations of the individual ETFs.
You might also like to view...
Factor analysis may not be appropriate in all of the following situations except ________
A) a small value for Bartlett's test of sphericity is found B) small values of the KMO statistic are found C) the variables are not correlated D) the variables are correlated
Job control unionism, which has dominated U.S. unions since WWII, is characterized by all of the following except:
A. Detailed and legalistic union contracts. B. Informal grievance procedures. C. Narrowly defined jobs. D. Low levels of employee input.
Use Scenario 2.6 to answer this question. What are total costs under the General-Purpose Equipment option for an annual quantity of 40,000 units?
A) $400,000 B) $450,000 C) $800,000 D) $850,000
The following data have been provided by Moretta Corporation, a company that produces forklift trucks: Budgeted production 3,400trucksStandard machine-hours per truck 2.9machine-hoursStandard supplies cost$1.50per machine-hourActual production 3,800trucksActual machine-hours 10,930machine-hoursActual supplies cost (total)$17,496 Supplies cost is an element of variable manufacturing overhead. The variable overhead efficiency variance for supplies cost is:
A. $135 F B. $135 U C. $966 U D. $966 F