Using the Tutorial 3.xlsx spreadsheet on Moodle. Using all of the data provided, determine the risk and historical return of a portfolio that invests an equal amount in both stocks. How does it compare to each stock individually? Please explain all calculations.

148 4 x fx A D F H L M N IATLAS ARTERIA ALUMINA NEWCREST MINING TRANSURBAN 1.45% 1.78% 191% 1.08% ER) I ATLAS ARTERIA Correlation ATLAS ARTERIA ALUMINA NEWCREST MINING TRANS URBAN ALUMINA NEWCREST MINING TRANS URBAN 1.00000 0.46241 0.44574 0.69021 0.46241 1.00000 0.49127 0.39708 0.44574 0.49127 1.00000 051717 0.69021 0.39708 0.51717 100000 Correlation ATLAS ARTERIA ALUMINA NEWCREST MINING TRANSURBAN ATLAS ARTERIA 1 0.462409787 0.445741399 0.69021098 ALUMINA 0.462409787 1 0.491274791 0.397075301 NEWCREST MING 0.445741399 0.491274791 TRANS URBAN 0.69021098 0.397075301 0.517167766 0.517167766 ATLAS ARTERIA Covariance ATLAS ARTERIA ALUMINA NEWCREST MINING TRANSURBAN ALUMINA NEWCREST MINING TRANSURBAN 0.00517 0.00292 0.00296 0.00254 0.00292 0.00772 0.00398 0.00178 0.00296 0.00398 0.00852 0.00244 0.00254 0.00178 0.00244 0.00261 Sumweights) 100.00% Weights 16.55% 31.74% 34 32% 17 39 ERO) ER) ER) 1650% 1.650% 1.650% 1 Date ATLAS ARTERIA ALUMINA NEWCREST MINING TRANS URBAN 2 29/1/16 4.91% 9.84% 096 3 29/2/16 10.54% 30.69% 5.63% 4 31/3/16 2.77% 3.08% 0.35% 5 29/4/15 1.46% 15.61% 11.85% 2.35% 6 31/5/16 7.60% 4.84% 0.53% 438% 7 30/6/16 114% -7.97% 20.61% 0.17% 8 29/7/16 12 35% 2.86% 8.70% 5.07% 9 31/8/16 4.81% 0.92% -11 22% 8.45 10 30/9/16 8.27% 10.20% 0.04% 0.44% 11 31/10/16 5.41% 8.59% 1.70% 8.30% 12 30/11/16 0.42% 5.09% -13.35% 1 83% 13 30/12/16 7.45% 10.91% -1.70% 31/1/17 0.59% 6.32% 6.36% 0.78% 15 28/2/17 2.39% 2 88% 8.51% 16 31/3/17 6.5496 2.61% 0.65% 6.20% 17 28/4/17 430% 3.14 4.9% 4.87% 18 31/5/17 9.55% 4.75% 0.03% 1 35% 19 30/6/17 4.10% 0.35% 4.58% 3.46% 20 31/7/17 0.89% 0.72% 0.26% 3.34% 21 31/8/17 2.16% 11 997 13.20% 7.01% 29/9/17 -1.72% 4.13% 194% 31/10/17 9.76% 6.73% 6.69% 2. 50% 24 30/11/17 2.52% 4.80% 4.09% 3.84% 25 29/12/17 2.95% 9.82% 0.06% 26 31/1/18 8.74% 0.49% 0.58% 2 90% 27 28/2/18 3.48% -7.12% 6.21% 330% 28 30/3/18 4.33% 6.49% -7.89% 29 30/4/18 13.66% 12.47% 8.20% 1 98% 31/5/18 3.42% 2.09% 1.77% 2.76% 31 29/5/18 3.31% 5.01% 5.08% 1 23% 32 31/7/18 1.71% 159 0.71% 31/8/18 5.20% 237% -10.28% 3.52% 28/9/18 3.23% 3.18% 0.20% 5.13% 35 31/10/18 2.15% -7.21% 6.30 1 52% -- 30/11/18 190% -11 81% 0.78% 0.86% 31/12/18 6.57% 4.02% 5.16% 31/1/19 6.23% 6.61% 12 26% 4.9296 39 28/2/19 7.07% 5.75% 0.49% 2 84% 29/3/19 3.56% 4.15% 4.98% 6.25% 30/4/19 3.05% 6.42% 188% 2.19% 42 31/5/19 1.14% 7.97% 8.89% 43 28/6/19 10.73% -1 53% 17.30 6.15% 44 31/7/19 4.46% 164% 11.44% 5.87% 45 30/8/19 3.79% 6.20% 4.05% 3.53% 6 30/9/19 6.47% 10.20% 6.01% 1.41% 31/10/19 2.95% 3.25% 9.85% 1 39% 29/11/19 3.23% 2.66% 1.66% 49 31/12/19 2.35% 0.52% -1.57% 2.53% 31/1/20 3.83% 4.25% 2.29% 5.68% 51 28/2/20 -1 35% -10.26% 10.85% 5.13% 52 31/3/20 3130% 24.26% 12 26% -18.58% 53 30/4/20 13.43% 19.66% 19.60 15.11% VaR) Std Dev Rol 0.004146203 XVX 6.44% 148 4 x fx A D F H L M N IATLAS ARTERIA ALUMINA NEWCREST MINING TRANSURBAN 1.45% 1.78% 191% 1.08% ER) I ATLAS ARTERIA Correlation ATLAS ARTERIA ALUMINA NEWCREST MINING TRANS URBAN ALUMINA NEWCREST MINING TRANS URBAN 1.00000 0.46241 0.44574 0.69021 0.46241 1.00000 0.49127 0.39708 0.44574 0.49127 1.00000 051717 0.69021 0.39708 0.51717 100000 Correlation ATLAS ARTERIA ALUMINA NEWCREST MINING TRANSURBAN ATLAS ARTERIA 1 0.462409787 0.445741399 0.69021098 ALUMINA 0.462409787 1 0.491274791 0.397075301 NEWCREST MING 0.445741399 0.491274791 TRANS URBAN 0.69021098 0.397075301 0.517167766 0.517167766 ATLAS ARTERIA Covariance ATLAS ARTERIA ALUMINA NEWCREST MINING TRANSURBAN ALUMINA NEWCREST MINING TRANSURBAN 0.00517 0.00292 0.00296 0.00254 0.00292 0.00772 0.00398 0.00178 0.00296 0.00398 0.00852 0.00244 0.00254 0.00178 0.00244 0.00261 Sumweights) 100.00% Weights 16.55% 31.74% 34 32% 17 39 ERO) ER) ER) 1650% 1.650% 1.650% 1 Date ATLAS ARTERIA ALUMINA NEWCREST MINING TRANS URBAN 2 29/1/16 4.91% 9.84% 096 3 29/2/16 10.54% 30.69% 5.63% 4 31/3/16 2.77% 3.08% 0.35% 5 29/4/15 1.46% 15.61% 11.85% 2.35% 6 31/5/16 7.60% 4.84% 0.53% 438% 7 30/6/16 114% -7.97% 20.61% 0.17% 8 29/7/16 12 35% 2.86% 8.70% 5.07% 9 31/8/16 4.81% 0.92% -11 22% 8.45 10 30/9/16 8.27% 10.20% 0.04% 0.44% 11 31/10/16 5.41% 8.59% 1.70% 8.30% 12 30/11/16 0.42% 5.09% -13.35% 1 83% 13 30/12/16 7.45% 10.91% -1.70% 31/1/17 0.59% 6.32% 6.36% 0.78% 15 28/2/17 2.39% 2 88% 8.51% 16 31/3/17 6.5496 2.61% 0.65% 6.20% 17 28/4/17 430% 3.14 4.9% 4.87% 18 31/5/17 9.55% 4.75% 0.03% 1 35% 19 30/6/17 4.10% 0.35% 4.58% 3.46% 20 31/7/17 0.89% 0.72% 0.26% 3.34% 21 31/8/17 2.16% 11 997 13.20% 7.01% 29/9/17 -1.72% 4.13% 194% 31/10/17 9.76% 6.73% 6.69% 2. 50% 24 30/11/17 2.52% 4.80% 4.09% 3.84% 25 29/12/17 2.95% 9.82% 0.06% 26 31/1/18 8.74% 0.49% 0.58% 2 90% 27 28/2/18 3.48% -7.12% 6.21% 330% 28 30/3/18 4.33% 6.49% -7.89% 29 30/4/18 13.66% 12.47% 8.20% 1 98% 31/5/18 3.42% 2.09% 1.77% 2.76% 31 29/5/18 3.31% 5.01% 5.08% 1 23% 32 31/7/18 1.71% 159 0.71% 31/8/18 5.20% 237% -10.28% 3.52% 28/9/18 3.23% 3.18% 0.20% 5.13% 35 31/10/18 2.15% -7.21% 6.30 1 52% -- 30/11/18 190% -11 81% 0.78% 0.86% 31/12/18 6.57% 4.02% 5.16% 31/1/19 6.23% 6.61% 12 26% 4.9296 39 28/2/19 7.07% 5.75% 0.49% 2 84% 29/3/19 3.56% 4.15% 4.98% 6.25% 30/4/19 3.05% 6.42% 188% 2.19% 42 31/5/19 1.14% 7.97% 8.89% 43 28/6/19 10.73% -1 53% 17.30 6.15% 44 31/7/19 4.46% 164% 11.44% 5.87% 45 30/8/19 3.79% 6.20% 4.05% 3.53% 6 30/9/19 6.47% 10.20% 6.01% 1.41% 31/10/19 2.95% 3.25% 9.85% 1 39% 29/11/19 3.23% 2.66% 1.66% 49 31/12/19 2.35% 0.52% -1.57% 2.53% 31/1/20 3.83% 4.25% 2.29% 5.68% 51 28/2/20 -1 35% -10.26% 10.85% 5.13% 52 31/3/20 3130% 24.26% 12 26% -18.58% 53 30/4/20 13.43% 19.66% 19.60 15.11% VaR) Std Dev Rol 0.004146203 XVX 6.44%