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