Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Try to do on Excel with formulas if possible. begin{tabular}{|r|r|r|r|r|r|r|} hline 3/1/2021 & 230.0367 & 240.37 & 179.83 & 222.6433 & 222.6433 & 2827357200
Try to do on Excel with formulas if possible.
\begin{tabular}{|r|r|r|r|r|r|r|} \hline 3/1/2021 & 230.0367 & 240.37 & 179.83 & 222.6433 & 222.6433 & 2827357200 \\ \hline 4/1/2021 & 229.4567 & 260.2633 & 219.8067 & 236.48 & 236.48 & 2035619100 \\ \hline 5/1/2021 & 234.6 & 235.3333 & 182.3267 & 208.4067 & 208.4067 & 1875527400 \\ \hline 6/1/2021 & 209.2667 & 232.54 & 190.4067 & 226.5667 & 226.5667 & 1559765700 \\ \hline 7/1/2021 & 227.9733 & 233.3333 & 206.82 & 229.0667 & 229.0667 & 1345349400 \\ \hline 8/1/2021 & 233.3333 & 246.7967 & 216.28 & 245.24 & 245.24 & 1143974700 \\ \hline 9/1/2021 & 244.6933 & 266.3333 & 236.2833 & 258.4933 & 258.4933 & 1170513900 \\ \hline 10/1/2021 & 259.4667 & 371.7367 & 254.53 & 371.3333 & 371.3333 & 1586803800 \\ \hline 11/1/2021 & 381.6667 & 414.4967 & 326.2 & 381.5867 & 381.5867 & 1947334500 \\ \hline 12/1/2021 & 386.9 & 390.9467 & 295.3733 & 352.26 & 352.26 & 1530167700 \\ \hline 1/1/2022 & 382.5833 & 402.6667 & 264.0033 & 312.24 & 312.24 & 1916006400 \\ \hline 2/1/2022 & 311.7367 & 315.9233 & 233.3333 & 290.1433 & 290.1433 & 1391126700 \\ \hline 3/1/2022 & 289.8933 & 371.59 & 252.0133 & 359.2 & 359.2 & 1729272900 \\ \hline 4/1/2022 & 360.3833 & 384.29 & 273.9 & 290.2533 & 290.2533 & 1520959800 \\ \hline 5/1/2022 & 286.9233 & 318.5 & 206.8567 & 252.7533 & 252.7533 & 1948221600 \\ \hline 6/1/2022 & 251.72 & 264.21 & 208.6933 & 224.4733 & 224.4733 & 2011227900 \\ \hline 7/1/2022 & 227 & 298.32 & 216.1667 & 297.15 & 297.15 & 1744884000 \\ \hline 8/1/2022 & 301.2767 & 314.6667 & 271.81 & 275.61 & 275.61 & 1695263200 \\ \hline 9/1/2022 & 272.58 & 313.8 & 262.47 & 265.25 & 265.25 & 1299271000 \\ \hline 10/1/2022 & 254.5 & 257.5 & 198.59 & 227.54 & 227.54 & 1735263100 \\ \hline 11/1/2022 & 234.05 & 237.4 & 166.19 & 194.7 & 194.7 & 1885275300 \\ \hline 12/1/2022 & 197.08 & 198.92 & 108.24 & 123.18 & 123.18 & 2944247700 \\ \hline \end{tabular} Calculate the average monthly and annualized return, standard deviation, beta, Sharpe ratio, and Treynor's measure for each stock. \begin{tabular}{|r|r|r|r|r|r|r|} \hline 3/1/2021 & 230.0367 & 240.37 & 179.83 & 222.6433 & 222.6433 & 2827357200 \\ \hline 4/1/2021 & 229.4567 & 260.2633 & 219.8067 & 236.48 & 236.48 & 2035619100 \\ \hline 5/1/2021 & 234.6 & 235.3333 & 182.3267 & 208.4067 & 208.4067 & 1875527400 \\ \hline 6/1/2021 & 209.2667 & 232.54 & 190.4067 & 226.5667 & 226.5667 & 1559765700 \\ \hline 7/1/2021 & 227.9733 & 233.3333 & 206.82 & 229.0667 & 229.0667 & 1345349400 \\ \hline 8/1/2021 & 233.3333 & 246.7967 & 216.28 & 245.24 & 245.24 & 1143974700 \\ \hline 9/1/2021 & 244.6933 & 266.3333 & 236.2833 & 258.4933 & 258.4933 & 1170513900 \\ \hline 10/1/2021 & 259.4667 & 371.7367 & 254.53 & 371.3333 & 371.3333 & 1586803800 \\ \hline 11/1/2021 & 381.6667 & 414.4967 & 326.2 & 381.5867 & 381.5867 & 1947334500 \\ \hline 12/1/2021 & 386.9 & 390.9467 & 295.3733 & 352.26 & 352.26 & 1530167700 \\ \hline 1/1/2022 & 382.5833 & 402.6667 & 264.0033 & 312.24 & 312.24 & 1916006400 \\ \hline 2/1/2022 & 311.7367 & 315.9233 & 233.3333 & 290.1433 & 290.1433 & 1391126700 \\ \hline 3/1/2022 & 289.8933 & 371.59 & 252.0133 & 359.2 & 359.2 & 1729272900 \\ \hline 4/1/2022 & 360.3833 & 384.29 & 273.9 & 290.2533 & 290.2533 & 1520959800 \\ \hline 5/1/2022 & 286.9233 & 318.5 & 206.8567 & 252.7533 & 252.7533 & 1948221600 \\ \hline 6/1/2022 & 251.72 & 264.21 & 208.6933 & 224.4733 & 224.4733 & 2011227900 \\ \hline 7/1/2022 & 227 & 298.32 & 216.1667 & 297.15 & 297.15 & 1744884000 \\ \hline 8/1/2022 & 301.2767 & 314.6667 & 271.81 & 275.61 & 275.61 & 1695263200 \\ \hline 9/1/2022 & 272.58 & 313.8 & 262.47 & 265.25 & 265.25 & 1299271000 \\ \hline 10/1/2022 & 254.5 & 257.5 & 198.59 & 227.54 & 227.54 & 1735263100 \\ \hline 11/1/2022 & 234.05 & 237.4 & 166.19 & 194.7 & 194.7 & 1885275300 \\ \hline 12/1/2022 & 197.08 & 198.92 & 108.24 & 123.18 & 123.18 & 2944247700 \\ \hline \end{tabular} Calculate the average monthly and annualized return, standard deviation, beta, Sharpe ratio, and Treynor's measure for each stockStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started