Please find the formulas for the following excel problems with solution.

Home Insert Page Layout Formulas Data Review View Times New R... * 11 . A- A = = Wrap Text General Paste B I U. . . A. Merge & Center $ ~ % " .00 $.0 Conditional Format Cell Formatting as Table Styles X fx A B C D G H I J K L M N P Statistics Basic Points Lost 25 Points Q Given the data table of year end stock prices below, please fill in the apporpriate information in the green boxes fo each asset Stock A Stock B Stock C Stock D Year 1 Stock E Stock F 5.30% 3.10% 5.009 5.70% 4.70% 2.50% Year 2 5.90% 3.00 3.00% Year 3 5.00% 4.30% 0.00% 2.00% 2.70% 5.50% 10 3.80% Year 4 3.80% 3.90% Year 5 .00% 2.20% 2.80% 4.20% 5.50% 3.40% .90% 5.70% 4.50% 12 5.80% 3.30% 2.30% Year 6 .00% 2.30% 5.40% 13 4.50% 2.00% 14 Average 15 Variance Std. Dev. 16 17 19 8 Given the data table of year end stock prices below, please fill in the apporpriate information in the green boxes fo each asset 20 Stock A Stock B 11.0% 0.5% 8.0% 6.0% 6.0% 5.0% -6.0% 3.0% -7.6% 2.0% 8.0% 7.0% 5.0% 3.3% 7.0% 6.5% 4.3% 9.7% .5.3% 3.2% 9.0% 2.0% 5.4% 3.4% 7.2% 6.8% 1.5% 6.7% 3.6% 5.1% 9.8% 3.2% 6.4% 4.6% 0.8% 9.0% CorrelationM N o P Q R S Portfolio - 3 Stocks You are finally able to invest in the stock market. You know a bit about a well diversified portfolio and decide to invest in 3 stocks. Their monthly returns are presented below: Date AMZN GIS Monthly Returns A. Fill in the information on each stock below: 1/1/15 6.14% 14.24% -1.59% -3.03% AAPL AMZN GIS TGT Use the INDIRECT function in all cells for a more advanced approach 2/1/15 9.64% 7.23% 2.50% 4.37% Expected Return 3/1/15 -3 -2.12% 5.22% 6.82% Standard Deviation 4/1/15 0.58% 13.35% -2.23% -3.95% Risk Free 0.05%