Below are the monthly returns for the stocks ABL and HHT as well as the returns...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Below are the monthly returns for the stocks ABL and HHT as well as the returns on the market. ABL's returns: (7.6%, 3.3%, -3.3%, 8.6 %, 0.5%, 1.3 %, -1.4 %, 1.9 %, 21.3 %, -3.7 % , -1.9%, 2.5%) HHT's returns: (4.5%, -4.9%, 4.7%, 4.4%, -0.8 %, -4.5%, 0.1%, 3.7 % , -6.1%, - 1.1%, 1%, 18.4%) The market returns were: (1.6 %, -6.8 %, 5.2%, 7.6 %, 0%, -1%, 3.6 %, -6.2 %, -1.4%, 1.8%, 2.5%, 9.2%) 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? Below are the monthly returns for the stocks ABL and HHT as well as the returns on the market. ABL's returns: (7.6%, 3.3%, -3.3%, 8.6 %, 0.5%, 1.3 %, -1.4 %, 1.9 %, 21.3 %, -3.7 % , -1.9%, 2.5%) HHT's returns: (4.5%, -4.9%, 4.7%, 4.4%, -0.8 %, -4.5%, 0.1%, 3.7 % , -6.1%, - 1.1%, 1%, 18.4%) The market returns were: (1.6 %, -6.8 %, 5.2%, 7.6 %, 0%, -1%, 3.6 %, -6.2 %, -1.4%, 1.8%, 2.5%, 9.2%) 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?
Expert Answer:
Answer rating: 100% (QA)
a Compute the first four moments mean standard deviation skew kurtosis for the returns for ABL Mean ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Following are the monthly returns for October 2007 to March 2013 of three international stock indices; All Ordinaries of Australia, Nikkei 225 of Japan, and FTSE 100 of England. A. Compute and...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1 and 2. On September 1, Irene opened a retail store that specializes in sports car...
-
A 1200-kg car has a maximum power output of 120hp. How steep a hill can it climb at a constant speed of 75km/h if the frictional forces add up to 650 N?
-
At room temperature, an oxygen molecule, with mass of 5.31 x 10-26 kg, typically has a KE of about 6.21 x 10-21 J. How fast is the molecule moving?
-
A pitched flat roof truss is loaded as shown. Determine the force in members EG, GH, and HJ. 2 kips 4 kips 4 kips 4 kips 2 kips 1.5 ft 7.5 ft EJ 7 ft 7ft 7 ft
-
In its 2014 annual report to shareholders, Johnson & Johnson, a consumerproducts company, reported the following financial results: 1. Revenues increased from \($71.3\) to \($74.3\) billion. 2. Net...
-
The payroll records of Grove Machining Co. show the following information for the week ended April 17: Hourly workers are paid time-and-a-half for overtime. a. Determine the net earnings of each...
-
D Question 2 0.2 pts Which shows the discounted payback period at an interest rate of 15% for each project for each project? TABLE P5 6 Project's Cash Flow ($) n A B C D 0 -$3,800 -$5,200 -$3,800...
-
Comment upon each of the following statements you heard in a conversation between two newly- hired staff auditors. a.Of course, Im qualified to be assigned to this engagement. I have an accounting...
-
https://www.youtube.com/watch?v=HIK9Ink_768 After watching the video of a guest checking in and has some challenges. I want you to process it and be creative in conceptualizing procedures or process...
-
Lobster A=4.5 kg. According to Webster's Law, how much does Lobster B have to weight in order for this lobster fisherman to be able to tell that Lobster B is heavier than Lobster A? (The constant (K)...
-
A complex sound consists of the following frequencies: 300 Hz, 400 Hz, and 500 Hz. The perceived pitch of the sound would equal to the pitch of what frequency?
-
A 55 g mouse runs out to the end of the 17 cm -long minute hand of a grandfather clock when the clock reads 10 minutes past the hour. What torque does the mouse's weight exert about the rotation axis...
-
Short Term Cash Flow Management Is it possible for a firm to have negative net working capital? If so, how? Would it be possible for a firm to have a negative cash cycle? If so, how? What purpose...
-
Pizza Demand and Supply Use the demand and supply model to analyze the impact of the following events on demand, supply, price, and quantity of pizzas sold in pizza restaurants (such as Dominos,...
-
. Consider the linear regression model y = X+E, where y (Y,..., Y) is an n x 1 response vector, = 1 11 212 21,p-1 1 221 T22 12,p-1 X= [1,x1, x2, , xp-1] = In In2 is an n xp design matrix with rank(X)...
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
Suppose that the 2016 actual and 2017 projected financial statements for Comfy Corners Catbeds are initially shown as follows. In these tables, sales are projected to rise by 22 percent in the coming...
-
If a firm follows the modified residual dividend model discussed in this chapter, are extraordinary dividends paid out of residual net income?
-
Cisco Systems has a beta of 1.25. Does this mean that you should expect Cisco to earn a return 25 percent higher than the S&P 500 Index return? Explain.
-
The opening quote in this chapter includes the statement: By certifying the public reports that collectively depict a corporations financial status, the independent auditor assumes a public...
-
On the evening of January 27, 1986, the temperature outside the Kennedy Space Center in Florida dropped below freezing. The National Aeronautics and Space Administration (NASA) had a dilemma. In...
-
Companies are sometimes faced with crisis management decisions. A good example is that of Ford with its Pinto brand. Compare Fords reaction, from an ethical perspective, to the gas tank problem in...
Study smarter with the SolutionInn App