4. [-/1 Points] DETAILS CAMMIMS16 8.E.016. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Data File Available: Download HauckData.xlsx As discussed in Section 8.3, the Markowitz model uses the variance of the portfolio as the measure of risk. However, variance includes deviations both below and above the mean return. Semivariance includes only deviations below the mean and is considered by many to be a better measure of risk. (a) Develop a model that minimizes semivariance for the Hauck Financial data given in the file HauckData with a required return of 10%. (Assume that the five planning scenarios in the Hauck Financial Services model are equally likely to occur. Hint: Modify model (8.10)-(8.19). Define a variable d for each scenario and let d R - R with d 0. Then make the objective function: Min 5 1 d2 5 s = 1 Let FS = proportion of portfolio invested in the foreign stock mutual fund IB = proportion of portfolio invested in the intermediate-term bond fund LG = proportion of portfolio invested in the large-cap growth fund LV = proportion of portfolio invested in the large-cap value fund SG = proportion of portfolio invested in the small-cap growth fund SV = proportion of portfolio invested in the small-cap value fund R = the expected return of the portfolio R$ the return of the portfolio in years. 5 Min s.t. 5-1 R R R3 RA = =