Can someone please explain the Excel formulas from the graph at the bottom of this question? graph should be solved using Solver Tool in Excel.
QN1>030 Markowitt showed that the evpected return of the portfollo is Butiding a Furtfollis aptimization Bedtel - 5tock Selection E=0.062xy+0.146xy+0.128xy Stock Selection case study Markowitz won the Nobel Drize for his werk in stock portfolio theory. Me was the Ant to measure portfolie riak using the yarlance of returns.' He lntroduced stock selection based on an "efficlent frontier". namely, by picking the stocks that give the portfole "with minimum variance for a given return" and "masimum cetion for a given variance." An invester is conpldering buping a cembinatien of 3 stecks - "Alpad, "Mravo," and "Charle"+ using Marhewitr's pertfolio optimizatien methed. The expected returns and risk of these toeks are piven in Table 1 . Tashe 1. Meturn and anisk tbata for 3 stecks An invester would lik to purthase obree combination st the 3 socko te build a pertolis that gireb at leant a 1044 return at the lowest possibie risk ch.t. at minimam gertiota variance). A portholo' variasce fepends os hoe each indidual itedk'e price fuctuations are correlated with every other ateck's. kneme as the cevariance of returns. The covariances are ghen in the varlance covariance matris in Tatble 2. For example, the covariance between Atgha and Eravo is 0.0197. Table 2. Variance covariance Aatris ef Meturms Accerding to Markowitz, if xy,xy and x, is the proportion of the portolos invested in Alpha, Bravo, and Charlie, respectively, then x1+x2+x1=1. Markowitz won the Nobel Prize for his work in stock portfolio theory; he was the first to measure portfolio risk using the variance of returns. 1He introduced stock selection based on an "efficient frontier," namely, by picking the stocks that give the portfolio "with minimum variance for a given return" and "maximum return for a given variance." 2 An investor is considering buying a combination of 3 stocks - "Alpha," "Bravo," and "Charlie" - using Markowitz's portfolio optimization method. The expected returns and risk of these stocks are given in Table 2. An investor would like to purchase some combination of the 3 stocks to build a portfolio that gives at least a 10% return at the lowest possible risk (i.e., at minimum portfolio variance). A portfolio's variance depends on how each individual stock's price fluctuations are correlated with every other "His senninal paper is H.M. Markowitx, 1952, "Portfolio Seloction," Journal of Finanee, 7(1), 77-91. 2lbid, p. 82 . stock's, known as the covariance of returns, and so she identified the covariances given in Table 3 . For example, the covariance between Alpha and Bravo is 0.0187.3 She recalled that according to Markowitz, she should let x1,x2, and x3 be the proportion of the portfolio invested in Alpha, Bravo, and Charlie, respectively, with x1+x2+x3=1. Markowitz showed that the expected return of the portfolio is E=0.062x1+0.146x2+0.128x3
