Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the data table to estimate the beta of Nike and HP Inc. stock based on their monthly returns from 2011-2017. Hint: You can use

Use the data table to estimate the beta of Nike and HP Inc. stock based on their monthly returns from 2011-2017.

Hint: You can use the slope() function in Excel.

The estimated monthly beta for Nike is _____. (Round to three decimal places.)

Date

NKE

HPQ

S&P 500

Jan-11

3.442%

8.527%

2.330%

Feb-11

7.941%

4.509%

3.474%

Mar-11

13.580%

5.693%

0.005%

Apr-11

8.745%

1.464%

2.896%

May-11

2.587%

7.406%

1.121%

Jun-11

8.017%

1.915%

1.706%

Jul-11

0.189%

3.379%

2.000%

Aug-11

3.882%

25.988%

5.498%

Sep-11

0.115%

12.738%

6.910%

Oct-11

12.677%

18.530%

10.915%

Nov-11

0.176%

5.036%

0.406%

Dec-11

1.695%

6.890%

1.024%

Jan-12

7.907%

8.618%

4.637%

Feb-12

3.779%

9.543%

4.341%

Mar-12

1.816%

4.803%

3.214%

Apr-12

3.163%

3.903%

0.668%

May-12

2.011%

8.401%

6.006%

Jun-12

18.857%

10.050%

4.045%

Jul-12

6.345%

9.299%

1.183%

Aug-12

5.838%

7.456%

2.505%

Sep-12

2.516%

2.788%

2.543%

Oct-12

3.719%

18.816%

1.820%

Nov-12

6.675%

6.209%

0.566%

Dec-12

7.591%

11.937%

0.902%

Jan-13

4.748%

15.860%

5.119%

Feb-13

1.536%

21.987%

1.276%

Mar-13

8.355%

19.815%

3.795%

Apr-13

7.778%

13.591%

1.921%

May-13

2.390%

18.544%

2.361%

Jun-13

3.276%

2.865%

1.340%

Jul-13

1.193%

3.548%

5.168%

Aug-13

0.509%

13.006%

2.999%

Sep-13

15.632%

4.612%

3.176%

Oct-13

4.295%

16.103%

4.631%

Nov-13

4.461%

12.228%

2.964%

Dec-13

0.025%

3.473%

2.580%

Jan-14

7.363%

3.645%

3.525%

Feb-14

8.140%

3.034%

4.552%

Mar-14

5.671%

9.370%

0.829%

Apr-14

1.232%

2.163%

0.695%

May-14

6.086%

1.331%

2.321%

Jun-14

0.832%

1.589%

2.064%

Jul-14

0.542%

5.730%

1.344%

Aug-14

2.463%

6.712%

3.946%

Sep-14

13.558%

5.731%

1.371%

Oct-14

4.226%

1.156%

2.355%

Nov-14

6.798%

8.863%

2.747%

Dec-14

2.598%

3.641%

0.253%

Jan-15

4.056%

9.968%

-2.963%

Feb-15

5.886%

3.570%

5.620%

Mar-15

3.305%

9.551%

1.566%

Apr-15

1.485%

5.809%

0.983%

May-15

3.430%

1.304%

1.286%

Jun-15

6.246%

8.989%

1.999%

Jul-15

6.665%

1.699%

2.215%

Aug-15

3.012%

8.060%

6.134%

Sep-15

10.541%

7.350%

2.489%

Oct-15

6.554%

5.271%

8.529%

Nov-15

0.954%

2.422%

0.366%

Dec-15

5.020%

4.593%

1.729%

Jan-16

0.784%

17.990%

4.979%

Feb-16

0.677%

10.093%

0.083%

Mar-16

0.065%

16.408%

6.721%

Apr-16

4.116%

0.406%

0.394%

May-16

6.311%

9.046%

1.701%

Jun-16

0.254%

5.277%

0.342%

Jul-16

0.543%

11.633%

3.647%

Aug-16

3.856%

2.570%

0.120%

Sep-16

8.380%

8.935%

0.001%

Oct-16

4.691%

6.697%

1.734%

Nov-16

0.219%

6.280%

3.684%

Dec-16

1.877%

2.775%

2.032%

Jan-17

4.072%

1.415%

1.789%

Feb-17

8.053%

15.415%

3.929%

Mar-17

2.187%

3.700%

0.128%

Apr-17

0.574%

5.257%

0.993%

May-17

4.367%

0.319%

1.411%

Jun-17

11.681%

6.116%

0.639%

Jul-17

0.085%

9.268%

2.055%

Aug-17

10.262%

0.105%

0.292%

Sep-17

1.818%

5.308%

2.010%

Oct-17

6.056%

7.966%

2.356%

Nov-17

9.875%

0.464%

3.057%

Dec-17

3.856%

1.402%

1.208%

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_2

Step: 3

blur-text-image_3

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

Pricing Analytics Models And Advanced Quantitative Techniques For Product Pricing

Authors: Walter R. Paczkowski

1st Edition

1138623938, 9781138623934

More Books

Students also viewed these Finance questions