Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B C D E F 1 Date Close (P) Dividend (D) Close price for the market index (m) Monthly realised return for Stock Monthly

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed
A B C D E F 1 Date Close (P) Dividend (D) Close price for the market index (m) Monthly realised return for Stock Monthly realised return for market index 1/7/15 101.260002 5699.200195 1/8/15 100.699997 207 0.55% -8.64% 1/9/15 87.379997 0.3 5021.600098 12.93% -3.56% 1/10/15 87 5239.399902 0.43% 4.34% 1/11/15 88.449997 5166.5 1.60%% 1.39% 1/12/15 88.690002 0.3 5295.899902 0.61 2.50% 1/1/16 83.68 5005.5 -5.65% -5.48% 1/2/16 90.160004 4880.899902 7.74% -2.49%% 1/3/16 19.5 0.3 5082.799805 10.69% 4.14% 1/4/16 101.900002 5252.200195 2.40% 3.33% 1/5/16 103.82 5378.600098 1.88% 2.41%% 1/6/16 105.68 0.3 5233.399902 2.08% -2.70% 14 1/7/16 103.290001 6562.299805 -2.26 6.28% 15 1/8/16 104.860001 5433 1.52% -2.32%% 16 1/9/16 102.57 0.35 5435.899902 -1.85% 0.05% 17 1/10/16 104.849998 5317.700195 2.22% 2.17% 18 1/11/16 112.169998 5440.5 6.98% 2.31% 19 1/12/16 110.290001 0.35 5665.799805 -1.36% 4.14% 20 1/1/17 109.110001 5620.899902 -1.06% -0.79% 21 1/2/17 103.300003 5712.200195 -5.32% 1.62% 22 1/3/17 106.410004 0.35 5864.899902 3.35% 2.67% 23 1/4/17 101.389999 5924.100098 4.72% 1.01% 24 1/5/17 101.330002 5724.600098 -0.06% -3.37% 25 1/6/17 95.400002 0.35 5721.5 -5.51% 0.05% 26 1/7/17 97.589996 5720.600098 2.30% -0.02%% 27 1/8/17 94.690002 5714.5 -2.97% -0.11% 28 1/9/17 100.290001 0.37 5681.600098 6.30% 0.58% 29 1/10/17 109.830002 5909 9.50% 4.00% 30 1/11/17 114.970001 5969.899902 4.68% 1.03% 31 1/12/17 113.650002 0.37 6065.100098 0.83% 1.59% 32 1/1/18 114.209999 6037.700195 0.49% -0.45% 33 1/2/18 102.910004 5016 9.89 0.36% 34 1/3/18 104.410004 0.37 5759.399902 1.82% 4.27%% 35 1/4/18 107.730003 5982.700195 3.18% 3.88% 36 1/5/18 107.389999 6011.899902 0.32% 0.49% 37 1/6/18 108.309998 0.37 6194.600098 1.20% 3.04% 38 1/7/18 122.839996 6280.200195 13.42% 1.38% 39 1/8/18 126.809998 6319.5 3.23% 0.63%% 40 1/9/18 121.800003 0.4 6207.600098 -3.64% -1.77% 1/10/18 96.589996 5830.299805 -20.70% -6.08% 42 1/11/18 105.519997 5667.200195 9.25% -2.80%% 1/12/18 100.519997 0.4 5646.399902 -4.36% -0.37%A B C D E F 32 1/1/18 114.209999 6037.700195 D.49% 0.45%% 33 1/2/18 102.910004 6016 -9.89% 0.36% 34 1/3/18 104.410004 0.37 5759.399902 1.82% -4.27% 35 1/4/18 107.730003 5982.700195 3.18% 3.88% 36 1/5/18 107.389999 6011.899902 -0.32% 0.49% 37 1/6/18 108.309998 0.37 6194.600098 1.20% 3.04% 38 1/7/18 122.839996 6280.200195 13.42% 1.38% 39 1/8/18 126.809998 6319.5 3.23% 0.63% 40 1/9/18 121.800003 D.4 6207.600098 -3.64% 1.77 1/10/18 96.589996 5830.299805 -20.70% -6.08% 1/11/18 105.519997 5667.200195 9.25% -2.80% 43 1/12/18 100.519997 0.4 5646.399902 -4.36% -0.37 44 1/1/19 107.730003 5864.700195 7.17% 3.87% 45 1/2/19 123.080002 6169 14.25% 5.19% 46 1/3/19 122.620003 0.4 6180.700195 -0.05% 0.19% 1/4/19 141.419998 6325.5 15.33% 2.34%% 48 1/5/19 133.309998 6396.899902 -5.73% 1.13% 49 1/6/19 140.410004 0.4 6618.799805 5.63% 3.47% 50 1/7/19 144.210007 6812.600098 2.71% 2.93% 1/8/19 144.960007 6604.200195 0.52% -3.06% 1/9/19 145.539993 0.5 6688.299805 0.75% 1.27%% 1/10/19 152.270004 6663.399902 4.62%% 0.37% 54 1/11/19 155.979996 6846 2.44% 2.74% 55 1/12/19 161.839996 D.5 6684.100098 4.08% -2.36% 56 1/1/20 156.229996 7017.200195 -3.47% 4.98% 1/2/20 145.289993 6441.200195 -7.00% -8.20% 58 1/3/20 125.279999 0.5 5076.799805 -13.43% -21.18% 59 1/4/20 120.959999 5522.399902 -3.45% 8.78% 60 1/5/20 119.860001 5755.700195 0.90% 4.22% 1/6/20 119.669998 0.5 5897.899902 0.26% 2.47% 62 1/7/20 119.080002 5927.799805 0.49% 0.51% 63 Average 0.59% 0.17% 64 Variance D.004078468 0.001921737 65 Standard Deviation 0.063862886 0.043837616 66 Covariance 0.001207118 67 Correlation Coefficient .431175819 68 Beta step 1 0.628139367 Beta Step 2 70 leta Step 3 Regression Analysis is on Sheet 2 0.628139367

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

International Business The Challenges Of Globalization

Authors: John J. Wild, Kenneth L. Wild

9th Edition

0134729226, 978-0134729220

More Books

Students also viewed these Finance questions