7a.Plot the price history of your four stocks from Task 6 for the 5 year period and the price history of your 4-stock portfolio for the same period. The portfolio value is the weighted average of the individual stock prices.You will use weight by share, not weight by value (pay attention to the note on the Task 7 Data worksheet).Ensure that the names of the companies appear at the top of each column instead of the generic labels (Stock1,Stock 2, etc.)

Texas Instruments Incorporated A B C D E F G H I J K L M N 0 P Q R Task 6a Expected Portfolio Return for Upcoming 60 months Initial # of Stock Weight (by Expected Stock Shares Price Initial Value value) Return (r) Weighted r The Clorox Company 300 $207.25 562, 175.00 27.9066% 1.3236% 0.3694% Johnson & Johnson 350 $137.11 547,988.50 21.5391% 0.9668% 0.2082% Nike 400 $120.08 548,032.00 21.5586% 1.4110% 0.3042% Texas Instruments Incorporated 450 $143.56 564,601.39 28.9956% 2.1916% 0.6355% Portfolio Value: $222,796.90 E(rP): 1.5173%mpany name. Weights (by share) Stock A Stock B Stock C Stock D 20.00% 23.33% 26.67% 30.00% 300/1500 = Note: The value (price) of the portfolio is a weighted average of the to prices of the component stocks. However, we're using a different way compute the weights for this task. In Task 6 we used "weight by value". For Task 7 we're using "weight by share". The weight of each stock is the number of shares divided by total number of shares in the portfolio (1500). This provides consistent weights throughout the time span in .questionIn 100% % .0 .00 123- Arial 10 B 2 A B C D E F G H J K L M N 0 P Q R S Task 7 (4 stocks) Johnson Texas The Clorox Price x Wt & Price x Wt Price x Wt Instruments Price x Wt Portfolio Date Company by Share Johnson by Share Nike by Share Incorporated by Share Value Change heading to the appropriate company name. Do this for all column headings Weights (by share) 9/1/2015 9/2/2015 9/3/2015 Stock A Stock B Stock C Sto 9/4/2015 20.00% 23.33% 26.67% 30.1 9/5/2015 9/6/2015 9/7/2015 300/1500 = 9/8/2015 9/9/2015 9/10/2015 Note: The value (price) of the portfolio is a weighted to prices of the component stocks. However, we're u 9/11/2015 compute the weights for this task. In Task 6 we used 9/12/2015 For Task 7 we're using "weight by share". The weigh 9/13/2015 the number of shares divided by total number of sha (1500). This provides consistent weights throughout 9/14/2015 question 9/15/2015 9/16/2015 9/17/2015 9/18/2015 9/19/2015