Question 1: Below are the monthly returns for the stocks ABL and HHT as well as the returns on the market. ABL's returns: (5.4%,5%,2.1%,6.2%,1.1%,0.1%,2.8%,3.1%,19.2%,4.9%,0%,1.1%) HHT's returns: (4.1%,4.1%,4.1%,3.1%,1.1%,4.1%,0.9%,3.1%,6.9%,1.9%,0.1%,17.1%) The market returns were: (1.4%,6.1%,4.2%,3.5%,1%,0.1%,2.2%,5.2%,2.8%,0.2%,0.5%,7.5%) Using the information above, perform each of the following tasks: a) Compute the first four moments (mean, standard deviation, skew, kurtosis) for the returns for ABL [use stdev/skew/kurt in excel] b) Compute the geo-metric average return for HHT c) Compute the correlation between the returns of ABL and HTT d) Compute the standard deviation and Sharpe ratio for a portfolio that has 40% of funds invested in ABL and the remainder in HHT if the risk-free rate is 0.18% per year. e) Find the beta for ABL and HHT. Which stock of the two is more defensive? Question 1: Below are the monthly returns for the stocks ABL and HHT as well as the returns on the market. ABL's returns: (5.4%,5%,2.1%,6.2%,1.1%,0.1%,2.8%,3.1%,19.2%,4.9%,0%,1.1%) HHT's returns: (4.1%,4.1%,4.1%,3.1%,1.1%,4.1%,0.9%,3.1%,6.9%,1.9%,0.1%,17.1%) The market returns were: (1.4%,6.1%,4.2%,3.5%,1%,0.1%,2.2%,5.2%,2.8%,0.2%,0.5%,7.5%) Using the information above, perform each of the following tasks: a) Compute the first four moments (mean, standard deviation, skew, kurtosis) for the returns for ABL [use stdev/skew/kurt in excel] b) Compute the geo-metric average return for HHT c) Compute the correlation between the returns of ABL and HTT d) Compute the standard deviation and Sharpe ratio for a portfolio that has 40% of funds invested in ABL and the remainder in HHT if the risk-free rate is 0.18% per year. e) Find the beta for ABL and HHT. Which stock of the two is more defensive