Spreadsheet Exercises 8.1 Closing prices for SilTech and New Mines for the years 2003-2018 are shown below. 1 Closing prices for SilTech and New Mines for the years 20032018 are shown below.A. Calculate the return for each stock for each year to three decimal places.B. Assume that similar returns will continue in the future (i.e., average returns = expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use AVERAGE, VAR.S, and STDEV functions.C. Calculate the covariance between the two stocks.D. Using the 11 different proportions that SilTech could constitute of the portfolio ranging from 0 to 100 percent in 10 percent increments, calculate the portfolio variance, standard deviation, and expected return.E. Plot the trade-off between return and risk for these two stocks based on the calculation in (D) Use the XY scatter diagram in Excel.\begin{tabular}{|c|c|c|}\hline & SilTech & NewMines \\\hline 2018 & 198.08 & 21.634\\\hline 2017 & 84.84 & 34.867\\\hline 2016 & 71.89 & 44.67\\\hline 2015 & 32.2 & 49.8\\\hline 2014 & 10.69 & 49.55\\\hline 2013 & 7.16 & 46.86\\\hline 2012 & 10.95 & 53.11\\\hline 2011 & 7.44 & 48.75\\\hline 2010 & 25.7 & 63.12\\\hline 2009 & 10.23 & 37.04\\\hline 2008 & 3.28 & 31.67\\\hline 2007 & 5.22 & 21.78\\\hline 2006 & 7.97 & 14.45\\\hline 2005 & 9.64 & 9.39\\\hline 2004 & 7.13 & 14.99\\\hline 2003 & 14.39 & 10.72\\\hline \end{tabular}