Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 30, 2024

Question 14 [5 points] For this question, refer to the Excel file with the tab Question 14. This tab contains the daily closing stock price

Question 14

[5 points]

For this question, refer to the Excel file with the tab "Question 14." This tab contains the daily closing stock price for Energy Corp. from January 3, 2022 until June 30, 2022. It also contains closing prices for the S&P 500 index (using the SPY ETF). As you know, the SPY represents the performance of the aggregate market. Assume that the risk-free rate is zero over this sample period.

The Treynor Ratio for Energy Corp. over this given sample period is _________.

In your answer, round off to two decimal places. For example, 2.94516 can be rounded off to 2.95. Use the market model to estimate beta where appropriate.

Directions: This is a fill in the blank question. Round off to two decimal places.

Date Closing Price for Energy Corp. Closing Price for SPY

1/3/22 45.57 477.709991

1/4/22 47.66 477.549988

1/5/22 46.610001 468.380005

1/6/22 48.369999 467.940002

1/7/22 48.889999 466.089996

1/10/22 48.5 465.51001

1/11/22 49.799999 469.75

1/12/22 49.900002 471.019989

1/13/22 49.639999 464.529999

1/14/22 50.389999 464.720001

1/18/22 50.360001 456.48999

1/19/22 48.93 451.75

1/20/22 48.630001 446.75

1/21/22 46.119999 437.980011

1/24/22 48.330002 439.839996

1/25/22 51.259998 434.470001

1/26/22 51.790001 433.380005

1/27/22 51.740002 431.23999

1/28/22 51.549999 441.950012

1/31/22 50.57 449.910004

2/1/22 52.560001 452.950012

2/2/22 53.240002 457.350006

2/3/22 53.009998 446.600006

2/4/22 52.869999 448.700012

2/7/22 52.59 447.26001

2/8/22 51.189999 450.940002

2/9/22 52.119999 457.540009

2/10/22 52.220001 449.320007

2/11/22 54.110001 440.459991

2/14/22 52.259998 439.019989

2/15/22 51.419998 446.100006

2/16/22 53.849998 446.600006

2/17/22 55.25 437.059998

2/18/22 54.779999 434.230011

2/22/22 52.669998 429.570007

2/23/22 53.549999 421.950012

2/24/22 52.75 428.299988

2/25/22 55.200001 437.75

2/28/22 59.549999 436.630005

3/1/22 59.25 429.980011

3/2/22 58.650002 437.890015

3/3/22 58.849998 435.709991

3/4/22 59.57 432.170013

3/7/22 59.889999 419.429993

3/8/22 59.48 416.25

3/9/22 58.939999 427.410004

3/10/22 60.57 425.480011

3/11/22 58.639999 420.070007

3/14/22 52.689999 417

3/15/22 53.009998 426.170013

3/16/22 52.459999 435.619995

3/17/22 57.52 441.070007

3/18/22 58.27 444.519989

3/21/22 61.439999 444.390015

3/22/22 60.630001 449.589996

3/23/22 61.669998 443.799988

3/24/22 61.540001 450.48999

3/25/22 62.5 452.690002

3/28/22 60.450001 455.910004

3/29/22 60.509998 461.549988

3/30/22 60.560001 458.700012

3/31/22 59.130001 451.640015

4/1/22 60.349998 452.920013

4/4/22 60.849998 456.799988

4/5/22 58.470001 451.029999

4/6/22 58.34 446.519989

4/7/22 60.23 448.769989

4/8/22 62.369999 447.570007

4/11/22 60.029999 439.920013

4/12/22 62.259998 438.290009

4/13/22 63.75 443.309998

4/14/22 62.560001 437.790009

4/18/22 63.540001 437.970001

4/19/22 63 445.040009

4/20/22 64.610001 444.709991

4/21/22 61.150002 438.059998

4/22/22 58.07 426.040009

4/25/22 56.18 428.51001

4/26/22 56.400002 416.100006

4/27/22 58.07 417.269989

4/28/22 59.889999 427.809998

4/29/22 58.169998 412

5/2/22 58.349998 414.480011

5/3/22 64.279999 416.380005

5/4/22 67.739998 429.059998

5/5/22 67.150002 413.809998

5/6/22 69.690002 411.339996

5/9/22 62.02 398.170013

5/10/22 63.759998 399.089996

5/11/22 64.68 392.75

5/12/22 64.610001 392.339996

5/13/22 68.699997 401.720001

5/16/22 70.989998 400.089996

5/17/22 72.580002 408.320007

5/18/22 69.919998 391.859985

5/19/22 69.510002 389.459991

5/20/22 69.919998 389.630005

5/23/22 71.059998 396.920013

5/24/22 70.389999 393.890015

5/25/22 71.940002 397.369995

5/26/22 73.809998 405.309998

5/27/22 75.800003 415.26001

5/31/22 74.900002 412.929993

6/1/22 76.480003 409.589996

6/2/22 76.309998 417.390015

6/3/22 77.019997 410.540009

6/6/22 77.050003 411.790009

6/7/22 78.040001 415.73999

6/8/22 77.93 411.220001

6/9/22 77.849998 401.440002

6/10/22 74.059998 389.799988

6/13/22 69.239998 375

6/14/22 70.589996 373.869995

6/15/22 68.459999 379.200012

6/16/22 63.27 366.649994

6/17/22 58.02 365.859985

6/21/22 60.560001 375.070007

6/22/22 57.549999 374.390015

6/23/22 54.740002 378.059998

6/24/22 53.77 390.079987

6/27/22 57.790001 388.589996

6/28/22 59.459999 380.649994

6/29/22 55.82 380.339996

6/30/22 55.110001 377.25

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions

Question

2. Now that you have studied the various ways that sport psychologists measure personality, which inventory would you recommend for use? Why?

Answered: 1 week ago

Question

★★★★★

Determine when a firm must pay for purchases made and invoices dated on November 25 under each of the following credit terms: a. Net 30 date of invoice b. Net 30 EOM c. Net 45 date of invoice d. Net...

Answered: 1 week ago

Question

★★★★★

If the price of the stock increases to $91 within six months, the six-month return on this transaction is \%. (Round to two decimal places.)

Answered: 1 week ago

Question

★★★★★

Check My Work Watershed is a media services company that provides online streaming movie and television content. As a result of the competitive market of streaming service providers, Watershed is...

Answered: 1 week ago

Question

★★★★★

Different types of Grading?

Answered: 1 week ago

Question

★★★★★

Simpson applies revaluation accounting to plant assets with a carrying value of 1, 600, 000, a useful life of 4 years, and zero salvage value. Depreciation is calculated on a straight line basis. At...

Answered: 1 week ago

Question

★★★★★

Explain the functions of financial management.

Answered: 1 week ago

Question

★★★★★

HOW MANY TOTAL WORLD WAR?

Answered: 1 week ago

Question

★★★★★

Discuss the scope of financial management.

Answered: 1 week ago

Previous Question Next Question

Date	Closing Price for Energy Corp.	Closing Price for SPY
1/3/22	45.57	477.709991
1/4/22	47.66	477.549988
1/5/22	46.610001	468.380005
1/6/22	48.369999	467.940002
1/7/22	48.889999	466.089996
1/10/22	48.5	465.51001
1/11/22	49.799999	469.75
1/12/22	49.900002	471.019989
1/13/22	49.639999	464.529999
1/14/22	50.389999	464.720001
1/18/22	50.360001	456.48999
1/19/22	48.93	451.75
1/20/22	48.630001	446.75
1/21/22	46.119999	437.980011
1/24/22	48.330002	439.839996
1/25/22	51.259998	434.470001
1/26/22	51.790001	433.380005
1/27/22	51.740002	431.23999
1/28/22	51.549999	441.950012
1/31/22	50.57	449.910004
2/1/22	52.560001	452.950012
2/2/22	53.240002	457.350006
2/3/22	53.009998	446.600006
2/4/22	52.869999	448.700012
2/7/22	52.59	447.26001
2/8/22	51.189999	450.940002
2/9/22	52.119999	457.540009
2/10/22	52.220001	449.320007
2/11/22	54.110001	440.459991
2/14/22	52.259998	439.019989
2/15/22	51.419998	446.100006
2/16/22	53.849998	446.600006
2/17/22	55.25	437.059998
2/18/22	54.779999	434.230011
2/22/22	52.669998	429.570007
2/23/22	53.549999	421.950012
2/24/22	52.75	428.299988
2/25/22	55.200001	437.75
2/28/22	59.549999	436.630005
3/1/22	59.25	429.980011
3/2/22	58.650002	437.890015
3/3/22	58.849998	435.709991
3/4/22	59.57	432.170013
3/7/22	59.889999	419.429993
3/8/22	59.48	416.25
3/9/22	58.939999	427.410004
3/10/22	60.57	425.480011
3/11/22	58.639999	420.070007
3/14/22	52.689999	417
3/15/22	53.009998	426.170013
3/16/22	52.459999	435.619995
3/17/22	57.52	441.070007
3/18/22	58.27	444.519989
3/21/22	61.439999	444.390015
3/22/22	60.630001	449.589996
3/23/22	61.669998	443.799988
3/24/22	61.540001	450.48999
3/25/22	62.5	452.690002
3/28/22	60.450001	455.910004
3/29/22	60.509998	461.549988
3/30/22	60.560001	458.700012
3/31/22	59.130001	451.640015
4/1/22	60.349998	452.920013
4/4/22	60.849998	456.799988
4/5/22	58.470001	451.029999
4/6/22	58.34	446.519989
4/7/22	60.23	448.769989
4/8/22	62.369999	447.570007
4/11/22	60.029999	439.920013
4/12/22	62.259998	438.290009
4/13/22	63.75	443.309998
4/14/22	62.560001	437.790009
4/18/22	63.540001	437.970001
4/19/22	63	445.040009
4/20/22	64.610001	444.709991
4/21/22	61.150002	438.059998
4/22/22	58.07	426.040009
4/25/22	56.18	428.51001
4/26/22	56.400002	416.100006
4/27/22	58.07	417.269989
4/28/22	59.889999	427.809998
4/29/22	58.169998	412
5/2/22	58.349998	414.480011
5/3/22	64.279999	416.380005
5/4/22	67.739998	429.059998
5/5/22	67.150002	413.809998
5/6/22	69.690002	411.339996
5/9/22	62.02	398.170013
5/10/22	63.759998	399.089996
5/11/22	64.68	392.75
5/12/22	64.610001	392.339996
5/13/22	68.699997	401.720001
5/16/22	70.989998	400.089996
5/17/22	72.580002	408.320007
5/18/22	69.919998	391.859985
5/19/22	69.510002	389.459991
5/20/22	69.919998	389.630005
5/23/22	71.059998	396.920013
5/24/22	70.389999	393.890015
5/25/22	71.940002	397.369995
5/26/22	73.809998	405.309998
5/27/22	75.800003	415.26001
5/31/22	74.900002	412.929993
6/1/22	76.480003	409.589996
6/2/22	76.309998	417.390015
6/3/22	77.019997	410.540009
6/6/22	77.050003	411.790009
6/7/22	78.040001	415.73999
6/8/22	77.93	411.220001
6/9/22	77.849998	401.440002
6/10/22	74.059998	389.799988
6/13/22	69.239998	375
6/14/22	70.589996	373.869995
6/15/22	68.459999	379.200012
6/16/22	63.27	366.649994
6/17/22	58.02	365.859985
6/21/22	60.560001	375.070007
6/22/22	57.549999	374.390015
6/23/22	54.740002	378.059998
6/24/22	53.77	390.079987
6/27/22	57.790001	388.589996
6/28/22	59.459999	380.649994
6/29/22	55.82	380.339996
6/30/22	55.110001	377.25