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?
-
When the 40-lb wheel shown is attached to a balancing machine and made to spin at a rate of 750 rpm, it is found that the forces exerted by the wheel on the machine are equivalent to a force-couple...
-
Outline five key objectives of audit tests for financial statements.
-
Statistical Research Service, Inc. (SRSI) ended 2008 with retained earnings of \(\$ 75,000\). During 2009 SRSI earned net income of \(\$ 90,000\) and declared dividends of \(\$ 30,000\). Also during...
-
Smith Accounting Services is considering a special order that it received from one of its corporate clients. The special order calls for Smith to prepare the individual tax returns of the...
-
1. What is identity theft? adware, phishing and keylogging? Who are hackers? Black hat vs White hat hackers.. Should company hire black/white hackers? 2. Social networking sites like Facebook,...
-
You will play the roles of a Freight Forwarder and a materials and distribution manager for Apotex Pharmaceuticals in Toronto. Your role is the materials and distribution manager for Apotex...
-
In the context of a local/regional organization, explain the idea of cost object . Discuss the four responsibility centres , in the selected organization, which are linked to responsibility...
-
What are the quantitative criticisms of the VC Method? In spite of its shortcomings, why is this valuation approach still popular?
-
How would you reconcile the following? (a) VCs often use very high hurdle rates when valuing potential new investments. (b) The historical average return for a large sample of VC funds is around 14%.
-
If a group of people stop the discussion of an important decision for fear of an argu- ment between two members, the outcome of that decision is in danger of suffering from what?
-
If an event is unforeseeable, how can a good contingency plan help?
-
Someone complains about a supplier who makes mistakes and a manager shrugs and says, "At least they're consistent." Did the manager just comment on the reli- ability or the robustness of the...
-
As society becomes more reliant on digital technology, there's an ever-growing necessity for strong cybersecurity measures. One integral aspect of cybersecurity is creating secure passcodes. Like a...
-
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.
-
For each of the following procedures, indicate whether sampling would or would not be used. Give reasons for your answers. a. Examinations of marketable securities. b. Confirmation letters sent to...
-
What are control risk assessment procedures?
-
Which of the following statements concerning working papers is incorrect? a. An auditor may support an opinion by other means in addition to working papers. b. The form of working papers should be...
Study smarter with the SolutionInn App