Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B C D G H M N O P Q R S RAW DATA NDX 100 S&P 500 Hi Yld Bond BITCOIN Monthly Return Set

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed
B C D G H M N O P Q R S RAW DATA NDX 100 S&P 500 Hi Yld Bond BITCOIN Monthly Return Set ETFs = 1.00 Equal Weight Portfolio : Change /Return! W N QQQ ETF SPY ETF HYG ETF XBT / USD QQQ ETF SPY ETF HYG ETF XBT / USD QQQ ETF SPY ETF HYG ETF XBT / USD PERIOD DATE Beta = 1.08 Beta = 1.01 Beta = 0.34 Beta = 0 24 10.2020 275.92 342.58 93.42 13,850 -2.95% 2.30% 0.43% 29.36% 1.625 1.266 1.108 2.198 L.549. 7.4%. 23 09.2020 284.30 350.64 93.03 10,707 -5.68% -3.94% -0.88% -8.32% 1.674 1.296 1.103 1.699 1.443 -5.2%- 22 08.2020 301.44 365.01 93.86 11,679 11.06% 7.19% 0.039% 2.93% 1.775 1.349 1.113 1.853 1.522 5.6% 21 07.2020 271.43 340.51 93.83 11,346 7.45% 6.10% 5.096 24.046 1.598 1.258 1.112 1.800 1.442 11.3% 4 00 20 06.2020 252.60 320.93 89.29 9,147 6.21% 1.53% -0.53% -3.77% 1.487 1.186 1.059 1.451 1.296 0.8% 10 19 05.2020 237.83 316.09 89.76 9,505 6.71% 4.979 2.94% 7.69% 1.401 1.168 1.064 1.508 1.285 5.8% 11 18 04.2020 222.88 301.12 87.20 8,827 15.09% 12.92% 4.83% 36.18% 1.312 1.113 1.034 1.401 1.215 17.4% 12 17 03.2020 193.66 266.66 33.18 6,481 -7.39% -12.82% 10.02% -24.93% 1.140 0.985 0.986 1.028 .035 -14.2%. 13 16 02.2020 209.12 305.88 92.45 8,633 -5.96% -7.73% -1.26% -7.71% 1.231 1.130 1.096 1.370 1.207 . -5.996. 15 01.2020 222.38 331.52 93.63 9,354 3.146 0.16% -0.029% 30.68% 1.309 1.225 1.110 1.484 1.282 . 8.2%- 14 12.2019 215.61 330.99 93.65 7,158 3.77% 2.61% 1.61% -7.16% 1.270 1.223 1.110 1.136 1.185 O. 16" 13 11.2019 207.78 322.58 92.17 7,710 4.179% 3.83% 0.60% -16.10% 1.224 1.192 1.093 1.223 1.183 2.8%' 12 10.2019 199.46 310.69 91.62 9,189 4.48% 2.41% 0.04% 11.51% 1.175 1.148 1.086 1.458 1.217 4.9%" 11 09.2019 190.90 303.36 91.58 8,241 0.82% 1.68% 0.46% -14.39% 1.124 1.121 1.086 1.308 1.160 3.9% 10 08.2019 189.35 298.35 91.16 9,626 -1.80% -1.48% 0.72% -3.99% 1.115 1.102 1.081 1.527 1.206 -1.9% 07.2019 192.83 302.83 90.51 10,027 2.44% 1.71% 0.16% -11.99% 1.135 1.119 1.073 1.591 1.230 -3.3%. 06.2019 188.24 297.72 90.37 11,393 7.46% 6.65% 3.159 33.98% 1.108 1.100 1.071 1.808 1.272 . 14.3%- 05.2019 175.17 279.15 87.61 8,503 -8.13% -6.19% -1.91% 62.34% 1.032 1.031 1.039 1.349 1.113 8.2%- 04.2019 190.68 297.57 89.31 5,238 5.60% 4.29% 1.00% 27.97% 1.123 1.100 1.059 0.831 1.028 7.8% 03.2019 180.56 285.32 88.43 4,093 3.84% 1.57% 1.299 7.646 1.063 1.054 1.048 0.649 .954 3.1%" OHNW AUT O OO C 02.2019 173.88 280.92 37.30 3,803 3.09% 3.459% 1.21% 11.28% 1.024 1.038 1.035 0.603 0.925 3.9% 01.2019 168.66 271.55 86.26 3,417 9.12% 8.22% 5.429 -7.00% 0.993 1.003 1.023 0.542 0.890 5.0% 12.2018 154.57 250.92 31.83 3,674 8.83% 9.15% 2.55% -6.52% 0.910 0.927 0.970 0.583 0.848 -6.8% 11.2018 169.54 276.20 83.98 3,930 -0.17% 2.06% -0.44% 37.646 0.998 1.021 0.996 0.624 0.910, 9.0%. 10.2018 169.82 270.63 84.35 6,302 0.00% 0.009% 0.00% 0.00% 1.000 1.000 1.000 1.000 1.000 0.0%. 12 month 25.70% 13.32% 5.4496 65.33 Annual Return 25.41% ST DEV 21.40% 20.04% 10.339 77.81% STDEV 26.50% Equity Risk Premium = 5.2% US Treasury 10Yr = 0.8% Annual Retun 24.46% Exp Mkt Return = 5.2% + 0.8% = 6.0% 38 39 40 41Beta Expected Return = R QQQ 1.08 ?? SPY 1.01 ?? HYG 0.34 ?? XBT 0.0 ? ? US-Treasury 0.0 0.8% Equity Risk Premium 1.0 5.2% Expected Market Return 1.0 6.0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Strategy

Authors: Mike W. Peng

5th Edition

0357512367, 978-0357512364

Students also viewed these Finance questions

Question

Maintaining an exercise program.

Answered: 1 week ago