Need help on the following question and the professor does not explain herself very well. The question is: 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 Date worksheet).

If someone could just help me with the formula that would be great. I found two questions that are like this in the HW help but they don't explain how they got their calculations. Thank you!

Insert Home Page Layout Formulas Data Review View Help Tell me what you want Arial 8 2 25 Wrap Text Ger & out Copy Format Painter B I U. A Merge & Center Clipboard Font Alignment fo Portfolio Value D E F G H A B Task 7 (4 stocks) Price x Wiby Nike Share 3/1/2.5 $46.66 4/1/2015 $45.96 5/1/2015 $47.28 6/1/2015 $50.51 3 7/1/2015 $53.87 8/1/2015 $52.25 10 9/1/2015 $57 50 11 10/1/2015 $61.58 12 11/1/2015 $62.17 13 12/1/2015 $58.74 14 1/1/2016 $58.57 15 2/1/2016 $58.17 16 3/1/2016 $58.06 17 4/1/2016 $55.81 18 5/1/2016 $52.29 19 6/1/2016 $52.27 20 7/1/2016 $52.71 21 8/1/2016 $54.74 22 9/1/2016 $50.00 23 10/1/2016 $17.92 24 11/1/2016 $47.81 25 12/1/2016 $49.39 28 1/1/2017 $50.70 27 2/1/2017 $54.78 28 3/1/2017 $53.41 4/1/2017 $93 27 CVS VZ GPS Price x WE Price x W1 Price x W1 Portfolio Verizon by Share Wells Fargo by Share CVS by Share Value $37.97 $ 4532 $89.90 $39.39 $ 45.90 $86.48 $39.04 $ 46.62 $89.48 $36.81 $ 47.17 $91 67 $36.95 $ 48.53 $98.30 $36.76 $ 45.31 $89.78 $34.76 $ 43.35 $84.59 $37.46 $ 45.70 $86.61 $36.78 $ 46.51 $82.78 $37.41 $ 46.20 $86.01 $40.44 $ 42 69 $84.98 $41.56 $ 39.88 $85.87 $44.31 $ 41.42 $91.67 $41.73 $ 42.81 $88.81 $42.14 $ 43 44 $85.58 $46.23 $ 40.85 $84.95 $45.88 $ 41.40 $82.27 $43.76 $ 43 84 $83.24 $43.47 $38.52 $79.31 $40.23 $ 40.03 $74.95 $42.21 $ 46.04 $68.87 $45.15 $ 48.35 $70.68 $41.45 $ 49.42 $70.59 $42.43 $ 50.78 $72.61 $41.67 $ 49.16 $70.73 $39 25 $ 47.55 $74 28 KSS CVX WMT JPM AFL BA WFC BAC DAL KO Type here to search o TT Updated 326 Stock and Portfolio Risk and Return Project Workbook 1 Insert Page Layout Formulas Data Review View Help Tell me what you want to do Arial 10 Wrap Text General at Paint BIU.B.A. $ .% Merge & Center Conditional Formatas Formatting-table- Font Alignment Number B D E F G H k 6 Stock Nike Verizon Wells Fargo & Company CVS Expected Portfolio Return for Upcoming 60 months Initial 1 Sept19 Closing Price # of Stock Weight by Shares Price Initial value value) Expected Return (1) Weighted 300 592.98 527,893.39 0 098% 0.09 0.0089% 350 $57.84 $20,245.56 0.001% 0.04 0.0021% 400 $48 25 $19,300.56 0.051% 0.02 0.0012% 450 $61.18 $27.532 25 0.084% 0.04 0.0025% Portfolio Value: $94.971.76 Er): 0.0148% B 9 0 M WC AHLHPO NA KO CVS VE GPS KSS cox WMT Tasca 14 Stock Type here to search c DOLL Share 2. Normal 3 E AutoSum - ATO Bad Fill - Insert Delete Format Clear Sort & Find & Filter - Select - Editing yles Cells P Q