-4.15% 1.75% 4.12% -3.97% 15.25 70.86 72.10 75.07 72.09 79.35 77.63 76.45 73.86 80.36 81.12 11 12/1/15 1/1/16 2/1/16 3/1/16 4/1/16 5/1/16 6/1/16 7/1/16 8/1/16 9/1/16 10/1/16 11/1/16 12/1/16 1/1/17 2/1/17 3/1/17 4/1/17 5/1/17 6/1/17 7/1/17 8/1/17 9/1/17 10/1/17 11/1/17 12/1/17 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 12/1/18 1/1/19 2/1/19 L . 114.38 91.84 93.41 102.23 90.03 102.57 91.48 91.25 97.45 98.55 124.87 117.00 123.80 140.71 142.13 147.81 152.20 163.07 149.41 181.66 174.71 181.35 196.43 195.51 191.96 270.30 291.38 295.35 312.46 351.60 391.43 337.45 367.68 374.13 301.78 286.13 267.66 339.50 358.10 -7.26% -19.71% 1.71% 9.44% -11.93% 13.93% -10.81% -0.25% 6.79% 1.13% 26.71% -6.30% 5.81% 13.66% 1.01% 4.00% 2.97% 7.14% -8.38% 21.58% -3.83% 3.80% 8.32% -0.47% -1.82% 40.81% 7.80% 1.36% 5.79% 12.53% 11.33% -13.79% 8.96% 1.75% -19.34% -5.19% -6.46% 26.84% 5.48% 84.53 95.93 98.64 103.08 105.43 104.82 108.07 118.57 119.67 124.82 112.81 122.21 129.93 146.53 153.04 163.35 157.90 152.45 133.36 147.33 137.76 143.39 142.41 148.87 134.74 154.08 148.40 164.00 164.04 10.07% -2.17% -1.52% -3.39% 8.80% 0.95% 4.20% 13.49% 2.82% 4.50% 2.28% -0.58% 3.10% 9.72% 0.93% 4.30% -9.62% 8.33% 6.32% 12.78% 4.44% 6.74% -3.34% -3.45% -12.52% 10.48% -6.50% 4.09% -0.68% 4.54% -9.49% 14.35% -3.69% 10.51% 0.02% 193.31 190.99 182.56 182.41 193.68 195.45 198.77 198.43 206.74 206.99 205.96 203.41 210.90 213.92 219.03 227.64 226.93 230.18 233.43 233.78 239.75 240.45 244.08 251.07 258.75 260.55 276.65 266.59 258.24 260.62 266.95 267.29 278.44 287.32 287.73 269.06 274.05 248.47 269.93 278.68 -2.31% -4.41% -0.08% 6.18% 0.91% 1.70% -0.17% 4.19% 0.12% -0.50% - 1.24% 3.68% 1.43% 2.39% 3.93% -0.31% 1.43% 1.41% 0.15% 2.55% 0.29% 1.51% 2.86% 3.06% 0.70% 6.18% -3.64% -3.13% 0.92% 2.43% 0.13% 4.17% 3.19% 0.14% -6.49% 1.85% -9.33% 8.64% 3.24% Answer the following questions. St. Deviation Netflix St. Deviation Deere St. Deviation S&P 500 Correlation Netflix/S&P Correlation Deere/S&P Beta Netflix Beta Deere 0.131738 6.12% 3.36% 0.35 0.49 1.37 1. Which stock is riskier by itself? Why? 2. Which stock is riskier as part of a portfolio? Why? Date 12.985 Netflix % Return Deere % Return 12/1/13 52.60 80.46 1/1/14 58.48 11.18% 76.16 -5.34% 2/1/14 63.66 8.86% 76.13 -0.04% 3/1/14 50.29 -21.00% 80.45 5.67% 4/1/14 4 601 -8.51% 83.18 3.39% 5/1/14 59.69 29.73% 81.24 -2.33% 6/1/14 62.94 5.44% 80.69 -0.68% 7/1/14 60.39 -4.05% 76.35 -5.38% 8/1/14 68.23 75.43 -1.20% 9/1/14 64.45 -5.54% 73.55 -2.49% 10/1/14 56.11 -12.94% 77.29 5.08% 11/1/14 49.51 -11.76% 78.27 1.27% 12/1/14 48.80 -1.43% 79.94 2.13% 1/1/15 63.11 29.32% 77.49 -3.06% 2/1/15 67.84 7.49% 82.41 6.35% 3/1/15 59.53 - 12.25% 79.76 -3.22% 4/1/15 79.50 33.55% 82.90 3.94% 5/1/15 89.15 12.14% 85.80 3.50% 6/1/15 93.85 5.27% 88.88 3.59% 7/1/15 114.31 21.809 87.17 -1.92% 8/1/15 115.03 0.63% 75.38 - 13.53% 9/1/15 103.26 - 10.23% 68.21 -9.51% 10/1/15 108.38 4.96% 72.47 6.25% 11/1/15 123.33 13.79% 73.93 2.01% 12/1/15 114.38 -7.26% 70.86 -4.15% 1/1/16 91.84 -19.71% 72.10 1.75% 2/1/16 93.41 1.71% 75.07 4.12% 3/1/16 102.23 9.44% 72.09 -3.97% 4/1/16 90.03 -11.93% 79.35 10.07% 5/1/16 102.57 13.93% 77.63 -2.17% 6/1/16 91.48 -10.81% 76.45 -1.52% 7/1/16 91.25 -0.25% 73.86 -3.39% 8/1/16 97.45 6.79% 80.36 8.80% 9/1/16 98.55 1.13% 81.12 0.95% 10/1/16 124.87 26.71% 84.53 4.20% 11/1/16 117.00 -6.30% 95.93 13.49% 12/1/16 123.80 5.81% 98.64 2.82% 1/1/17 140.71 13.66% 103.08 4.50% 2/1/17 142.13 1.01% 105.43 2.28% 3/1/17 147.81 4.00% 104.82 -0.58% 4/1/17 152.20 2.97% 108.07 3.10% 5/1/17 163.07 7.14% 118.57 9.72% 6/1/17 149.41 -8.38% 119.67 0.93% 7/1/17 181.66 21.58% 124.82 4.30% 8/1/17 174.71 -3.8396 -9.62% 9/1/17 181.35 3.80% 122.21 8.33% 10/1/17 196.43 8.32% 129.93 6.32% 11/1/17 195.51 -0.47% 146.53 12.78% 12/1/17 191.96 -1.82% 153.04 4.44% 1/1/18 270.30 40.81% 163.35 6.74% 2/1/18 291.38 7.80% 157.90 -3.34% 3/1/18 295.35 1.36% 152.45 -3.45% 4/1/18 312.46 5.79% 133.36 12.52% S&P 500 ETF % Return 166.36 161.37 -3.00% 168.71 4.55% 169.37 0.39% 171.30 1.14% 175.27 2.32% 178.04 1.58% 176.49 -0.87% 183.45 3.94% 180.08 -1.84% 185.18 2.83% 190.27 2.75% 188.74 -0.80% 184.16 -2.43% 194.51 5.62% 190.61 -2.01% 193.34 1.43% 195.83 1.29% 190.96 -2.49% 196.14 2.71% 185.61 -5.37% 178.56 -3.80% 195.70 9.60% 195.51 -0.10% 190.99 -2.31% 182.56 -4.41% 182.41 -0.08% 193.68 6.18% 195.45 0.91% 198.77 1.70% 198.43 -0.17% 206.74 4.19% 206.99 0.12% 205.96 -0.50% 203.41 - 1.24% 210.90 3.68% 213.92 1.43% 219.03 2.39% 227.64 3.93% 226.93 -0.31% 230.18 1.43% 233.43 1.41% 233.78 0.15% 239.75 2.55% 240.45 0.29% 244.08 1.51% 251.07 2.86% 258.75 3.06% 260.55 0.70% 276.65 6.18% 266.59 -3.64% 258.24 -3.13% 260.62 0.92% 112.81 -4.15% 1.75% 4.12% -3.97% 15.25 70.86 72.10 75.07 72.09 79.35 77.63 76.45 73.86 80.36 81.12 11 12/1/15 1/1/16 2/1/16 3/1/16 4/1/16 5/1/16 6/1/16 7/1/16 8/1/16 9/1/16 10/1/16 11/1/16 12/1/16 1/1/17 2/1/17 3/1/17 4/1/17 5/1/17 6/1/17 7/1/17 8/1/17 9/1/17 10/1/17 11/1/17 12/1/17 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/18 11/1/18 12/1/18 1/1/19 2/1/19 L . 114.38 91.84 93.41 102.23 90.03 102.57 91.48 91.25 97.45 98.55 124.87 117.00 123.80 140.71 142.13 147.81 152.20 163.07 149.41 181.66 174.71 181.35 196.43 195.51 191.96 270.30 291.38 295.35 312.46 351.60 391.43 337.45 367.68 374.13 301.78 286.13 267.66 339.50 358.10 -7.26% -19.71% 1.71% 9.44% -11.93% 13.93% -10.81% -0.25% 6.79% 1.13% 26.71% -6.30% 5.81% 13.66% 1.01% 4.00% 2.97% 7.14% -8.38% 21.58% -3.83% 3.80% 8.32% -0.47% -1.82% 40.81% 7.80% 1.36% 5.79% 12.53% 11.33% -13.79% 8.96% 1.75% -19.34% -5.19% -6.46% 26.84% 5.48% 84.53 95.93 98.64 103.08 105.43 104.82 108.07 118.57 119.67 124.82 112.81 122.21 129.93 146.53 153.04 163.35 157.90 152.45 133.36 147.33 137.76 143.39 142.41 148.87 134.74 154.08 148.40 164.00 164.04 10.07% -2.17% -1.52% -3.39% 8.80% 0.95% 4.20% 13.49% 2.82% 4.50% 2.28% -0.58% 3.10% 9.72% 0.93% 4.30% -9.62% 8.33% 6.32% 12.78% 4.44% 6.74% -3.34% -3.45% -12.52% 10.48% -6.50% 4.09% -0.68% 4.54% -9.49% 14.35% -3.69% 10.51% 0.02% 193.31 190.99 182.56 182.41 193.68 195.45 198.77 198.43 206.74 206.99 205.96 203.41 210.90 213.92 219.03 227.64 226.93 230.18 233.43 233.78 239.75 240.45 244.08 251.07 258.75 260.55 276.65 266.59 258.24 260.62 266.95 267.29 278.44 287.32 287.73 269.06 274.05 248.47 269.93 278.68 -2.31% -4.41% -0.08% 6.18% 0.91% 1.70% -0.17% 4.19% 0.12% -0.50% - 1.24% 3.68% 1.43% 2.39% 3.93% -0.31% 1.43% 1.41% 0.15% 2.55% 0.29% 1.51% 2.86% 3.06% 0.70% 6.18% -3.64% -3.13% 0.92% 2.43% 0.13% 4.17% 3.19% 0.14% -6.49% 1.85% -9.33% 8.64% 3.24% Answer the following questions. St. Deviation Netflix St. Deviation Deere St. Deviation S&P 500 Correlation Netflix/S&P Correlation Deere/S&P Beta Netflix Beta Deere 0.131738 6.12% 3.36% 0.35 0.49 1.37 1. Which stock is riskier by itself? Why? 2. Which stock is riskier as part of a portfolio? Why? Date 12.985 Netflix % Return Deere % Return 12/1/13 52.60 80.46 1/1/14 58.48 11.18% 76.16 -5.34% 2/1/14 63.66 8.86% 76.13 -0.04% 3/1/14 50.29 -21.00% 80.45 5.67% 4/1/14 4 601 -8.51% 83.18 3.39% 5/1/14 59.69 29.73% 81.24 -2.33% 6/1/14 62.94 5.44% 80.69 -0.68% 7/1/14 60.39 -4.05% 76.35 -5.38% 8/1/14 68.23 75.43 -1.20% 9/1/14 64.45 -5.54% 73.55 -2.49% 10/1/14 56.11 -12.94% 77.29 5.08% 11/1/14 49.51 -11.76% 78.27 1.27% 12/1/14 48.80 -1.43% 79.94 2.13% 1/1/15 63.11 29.32% 77.49 -3.06% 2/1/15 67.84 7.49% 82.41 6.35% 3/1/15 59.53 - 12.25% 79.76 -3.22% 4/1/15 79.50 33.55% 82.90 3.94% 5/1/15 89.15 12.14% 85.80 3.50% 6/1/15 93.85 5.27% 88.88 3.59% 7/1/15 114.31 21.809 87.17 -1.92% 8/1/15 115.03 0.63% 75.38 - 13.53% 9/1/15 103.26 - 10.23% 68.21 -9.51% 10/1/15 108.38 4.96% 72.47 6.25% 11/1/15 123.33 13.79% 73.93 2.01% 12/1/15 114.38 -7.26% 70.86 -4.15% 1/1/16 91.84 -19.71% 72.10 1.75% 2/1/16 93.41 1.71% 75.07 4.12% 3/1/16 102.23 9.44% 72.09 -3.97% 4/1/16 90.03 -11.93% 79.35 10.07% 5/1/16 102.57 13.93% 77.63 -2.17% 6/1/16 91.48 -10.81% 76.45 -1.52% 7/1/16 91.25 -0.25% 73.86 -3.39% 8/1/16 97.45 6.79% 80.36 8.80% 9/1/16 98.55 1.13% 81.12 0.95% 10/1/16 124.87 26.71% 84.53 4.20% 11/1/16 117.00 -6.30% 95.93 13.49% 12/1/16 123.80 5.81% 98.64 2.82% 1/1/17 140.71 13.66% 103.08 4.50% 2/1/17 142.13 1.01% 105.43 2.28% 3/1/17 147.81 4.00% 104.82 -0.58% 4/1/17 152.20 2.97% 108.07 3.10% 5/1/17 163.07 7.14% 118.57 9.72% 6/1/17 149.41 -8.38% 119.67 0.93% 7/1/17 181.66 21.58% 124.82 4.30% 8/1/17 174.71 -3.8396 -9.62% 9/1/17 181.35 3.80% 122.21 8.33% 10/1/17 196.43 8.32% 129.93 6.32% 11/1/17 195.51 -0.47% 146.53 12.78% 12/1/17 191.96 -1.82% 153.04 4.44% 1/1/18 270.30 40.81% 163.35 6.74% 2/1/18 291.38 7.80% 157.90 -3.34% 3/1/18 295.35 1.36% 152.45 -3.45% 4/1/18 312.46 5.79% 133.36 12.52% S&P 500 ETF % Return 166.36 161.37 -3.00% 168.71 4.55% 169.37 0.39% 171.30 1.14% 175.27 2.32% 178.04 1.58% 176.49 -0.87% 183.45 3.94% 180.08 -1.84% 185.18 2.83% 190.27 2.75% 188.74 -0.80% 184.16 -2.43% 194.51 5.62% 190.61 -2.01% 193.34 1.43% 195.83 1.29% 190.96 -2.49% 196.14 2.71% 185.61 -5.37% 178.56 -3.80% 195.70 9.60% 195.51 -0.10% 190.99 -2.31% 182.56 -4.41% 182.41 -0.08% 193.68 6.18% 195.45 0.91% 198.77 1.70% 198.43 -0.17% 206.74 4.19% 206.99 0.12% 205.96 -0.50% 203.41 - 1.24% 210.90 3.68% 213.92 1.43% 219.03 2.39% 227.64 3.93% 226.93 -0.31% 230.18 1.43% 233.43 1.41% 233.78 0.15% 239.75 2.55% 240.45 0.29% 244.08 1.51% 251.07 2.86% 258.75 3.06% 260.55 0.70% 276.65 6.18% 266.59 -3.64% 258.24 -3.13% 260.62 0.92% 112.81