Case #2
pdf
keyboard_arrow_up
School
New York University *
*We aren’t endorsed by this school
Course
3605
Subject
Finance
Date
Jan 9, 2024
Type
Pages
3
Uploaded by AdmiralWorld1098
1 FINC-UB 44 P
ORTFOLIO M
ANAGEMENT
Case #2: ProShares Hedge Fund Replication ETF The assignment consists of two sets of questions: (1) quantitative, Excel-based questions, which should be completed and submitted, and (2) more qualitative questions, which will form the basis for part of our in-class discussion, answers to which you do NOT need to turn in. The spreadsheet is due by the beginning of class (2:00pm). You may collaborate with your classmates in preparing the solutions to both sets of questions, but each student must hand in a separate assignment, and all students are responsible for participating in the discussion. Assignments should be submitted through Brightspace. Assignments that are late but within 24 hours of the deadline, will receive ½ credit. After 24 hours no assignments will be accepted (unless due to documented serious illness or family emergency)! For the quantitative questions, download the Excel spreadsheet “Case #2” from Brightspace. Please put your name and net ID in the blue boxes at the top of the worksheet. This spreadsheet contains monthly returns on the 4 global Fama-French-Carhart factors, and the excess returns on two US fixed income factors (level and slope), the HFR Fund of Funds Composite Index and 2 hedge fund replication ETFs (HDG and QAI, created by ProShares and IndexIQ, respectively). Note that some of the returns do not span the full sample. The worksheet also contains a template for entering your solutions. The cells where results need to be added are highlighted in yellow. Because your solutions will be computer-graded it is very important to follow the instructions: •
Please do NOT reformat the file or move the yellow cells. Do NOT add rows or columns to the worksheet. However, you can add additional calculations in non-highlighted cells if you wish. Everything in non-highlighted cells will be ignored for grading purposes. You can either enter the formula to calculate your answer in the yellow cells, or enter these formulas elsewhere and just put references to these answers in the yellow cells. •
Please do NOT round your answers or intermediate calculations. Excel will display rounded answers based on the formatting of the cells, but it will retain the unrounded numbers. •
Please do NOT add a new worksheet to the file. Do all of your calculations in the “Results” worksheet and submit a file with only a single worksheet. 1.
Over the full sample, calculate the annualized mean, standard deviation, and Sharpe ratio plus the skewness and excess kurtosis of the monthly returns on the 4 FFC factors, and the monthly excess returns on the HFR index, and the pairwise correlations between the hedge fund index and these monthly returns. (Do not attempt to annualize skewness or kurtosis.) 2.
Over three sample periods—(1) the full sample, (2) Jan. 1991 to Dec. 2010, and (3) Jan. 2011 through the end of the sample—run regressions of the monthly hedge fund index returns on the 4 Fama-French-Carhart factors. Report the annualized intercept (alpha), the associated annualized
standard error, the t-statistic, the slope coefficients on the independent variables, the associated standard errors, the t-statistics, and the regression R
2
s. Use the regression package within Analysis ToolPak, putting the output somewhere else in the Results worksheet and formulas that reference the results in the relevant cells.
2 3.
Over the period from Aug. 2011 to the end of the sample, calculate the annualized mean, standard deviation, and Sharpe ratio plus the skewness and excess kurtosis of the monthly returns on the 4 FFC factors, the excess returns on the HFR index, the two fixed income factors, and the 2 ETFs (HDG and QAI), and the pairwise correlations between the hedge fund-related returns and these monthly returns. (Do not attempt to annualize skewness or kurtosis.) 4.
Over the period Aug. 2011 to the end of the sample, run regressions of the monthly hedge fund index and the 2 ETF excess returns on the 4 Fama-French-Carhart factors and the two fixed income factors. Report the annualized intercept (alpha), the associated annualized
standard error, the t-statistics, the slope coefficients on the independent variables, the associated standard errors, the t-statistics, and the regression R
2
s. Use the regression package within Analysis ToolPak, putting the output somewhere else in the Results worksheet and formulas that reference the results in the relevant cells. 5.
Finally, over the period Aug. 2011 to the end of the sample, run regressions of the 2 monthly ETF excess returns on the excess return on the hedge fund index. Report the annualized intercept (alpha), the associated annualized
standard error, the t-statistics, the slope coefficient on the independent variable, the associated standard errors, the t-statistics, and the regression R
2
s. Use the regression package within Analysis ToolPak, putting the output somewhere else in the Results worksheet and formulas that reference the results in the relevant cells. For class discussion only! (Consider material in the case, including the video available at http://youtu.be/XEUa45fjOD4
, material in the lecture notes, and the HDG fact sheet https://www.proshares.com/globalassets/proshares/fact-sheet/prosharesfactsheethdg.pdf and the QAI fact sheet https://www.newyorklifeinvestments.com/assets/documents/index-iq/qai-iq-
hedge-multi-strategy-tracker-etf-fs.pdf ) 6.
What is the theoretical/conceptual case for investing in hedge funds? Based on the evidence from questions 1 & 2 above, is this case consistent with the data? What are the average returns, volatilities, Sharpe ratios, correlations, betas and alphas of hedge fund returns over this sample and over the shorter sample that ends in 2010? Are hedge funds market neutral? Are global factors the relevant benchmarks (as opposed to US factors)? What are the potential barriers or problems associated with hedge fund investing? 7.
What is hedge fund replication? Why might it work at the index level but not at the individual fund level? Does a factor-based (regression-based) replication of hedge fund returns make sense? Under what circumstances? 8.
Who are the natural customers for a hedge fund replication ETF? Why? 9.
Are HDG and QAI achieving their stated goals? Based on the results from questions 3, 4 and 5, do their returns (average returns, volatilities, Sharpe ratios, alphas, betas, etc.) resemble those of the fund of funds indexes? Is the fund of funds index the right benchmark? Does this more recent data change your perception of the value of hedge fund replication? How have
3 hedge funds performed in this later sample period? Again, are the global factors the relevant benchmarks? 10.
What are the differences between the methodologies underlying HDG and QAI? Do these differences explain the differing performance? Look at the fact sheets. What are the holdings of HDG and QAI? 11.
Has this segment of the market gained traction? What are the AUMs of HDG and QAI? 12.
Is there a future for these types of products? Do you view these products differently from the QuantShares products we examined in Case #1? If so, why?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
1. Choose three of the following five technologies/techniques and explain why you think it is helpful in accounting analytics based on your lab experience in this course. Use some examples in your explanation. Limit your answer to 500 words in total.
A. XBRL
B. Tableau
C. VLOOKUP function
D. Pivot table
E. Regression
arrow_forward
I need help with a and b
arrow_forward
What is forecasting risk and how can it affect decision making?
atting
re for you!
th your
chat
Edit View Insert Format Tools Table
12pt Paragraph
Paragraph
р
B IUA
BIUA
2
2
T² :
T² V
i
I
0 words
✓
arrow_forward
I need help with B, C, D on the attached assignment
arrow_forward
Ethics case: Uncollectible Accounts
Introduction
The purpose of this discussion forum is to give you an opportunity to apply your critical-thinking ability to the knowledge you’ve gained. The assignment provides you with an opportunity to develop your research, analysis, judgment, and communication skills. You also will work with other students, integrate what you’ve learned, apply it in real-world situations. This practice will broaden your knowledge and further develop your decision-making abilities. The assignment achieves learning objective 5.
The assignment information is given below;
You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held manufacturing company. Your immediate superior is the controller who, in turn, is responsible to the vice president of finance. The controller has assigned you the task of preparing the year-end adjusting entries. In the receivables area, you have prepared an aging of accounts receivable and have…
arrow_forward
Please correct answer and don't use hand rating
arrow_forward
Please write proposal which needs On the basis of which you will be writing APR. Write review of at least one article on the study area (Not title) of your interest, which can be finance related study area. Go through the 1. Study area selection (Topic Selection) 2. Review of Literature and development of research of framework 3. Topic Selection 4. Further review of literature and refinement of research fraework 5. Problem definition and research question…
arrow_forward
Question 2
Listen
Which linear regression equation matches the given data sets? Use your TI-84+
calculator to determine the equations.
Hint: Click STAT and chose option 1: EDIT. Enter your data into L1 (explanatory
variable) and L2 (response variable). Click STAT, choose CALC, and choose op-
tion 8.
Table A
x
y
X
Table B
y
0
7.5
0
6.8
1
7.7
1
5
2
8
2
7.5
3
8
3
7
4
8.5
4
9
Table C
Table D
X
y
X
y
0
11.2
0
15
1
7.7
1
77
2
8
NOT AN OPTION
3
4.5
3
6.5
4
4.6
4
3.2
ŷ=7.48+0.23x
a. Table B
ŷ-5.78+0.64x
b. Table C
y=10.48-1.64x
c. Table A
arrow_forward
Give typing answer with explanation and conclusion
arrow_forward
F
Mathematics In The Modern WorldNote: If you have already answered the problems in this post, kindly ignore it. If not, then answer it. Thank you, Tutor!Content Covered:- Engineering Economics- Simple Interest, Compound Interest, Annuity, Financial Mathematics & Comparison of AlternativesDirections:Solve the problem below by showing the complete solution. In return, I will give you a good rating. Thank you so much!Note: Please be careful with the calculations in the problem. Kindly double check the solution and answer if there is a deficiency. And also, box the final answer.Thank you so much!
arrow_forward
Page 2 of 2
Assignment 2: (CLO 5): MS Excel application:
Determine any four related variables, two of them are qualitative (Categorical)
and two are quantitative (Numerical).
a. Input sufficient data about the four variables (a random sample of 50 or more)
in MS-Excel sheet.
b. Prepare frequency distribution tables for one qualitative and one quantitative
variable.
c. Prepare appropriate graphs for each of the two tables.
d. Prepare a pivot table (cross tabulation) consists of two qualitative variables (in
rows and columns) and one quantitative variable as values.
e. Conduct descriptive analysis for the two quantitative variables (summary
measures).
f. Find the coefficient of variation (CV) and compare the dispersion of the two
variables.
arrow_forward
Milestone #1 – Research Project Overview (Week Two)
Introduction: Provide a brief overview of the research healthcare. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell.
Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the questionnaire. Creswell & Creswell (2023) discuss this in Chapter 6.
arrow_forward
Please answer practice question 9
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
For your initial post, answer the following questions on this course MGT 305
What has been the most confusing information from the course and why?
What has been the most interesting topic and why?
arrow_forward
Revisit
Choose the best option
Question # 25
A Report a Problem
O firm, individual
While redefining management phenomena, the management accounting professionals have to
focus on the
and the
O past, present
O issues, solutions
innovation, systems
+91 80 4719 0917
Deepanshu | Support +1 650-924-9221
metti
Type here to search
f9
144
f6
f5
f4
f3
IOI
f2
&
7
SC
6.
%23
3
5
@
2
4
1
%24
arrow_forward
Knowledge Check 01
Select the correct order of the following steps in the decision-making process.
1. Evaluate the costs and benefits of the alternatives
2. Determine the decision alternatives
3. Identify the decision problem
4. Review the results of the decision
5. Make the decision
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- 1. Choose three of the following five technologies/techniques and explain why you think it is helpful in accounting analytics based on your lab experience in this course. Use some examples in your explanation. Limit your answer to 500 words in total. A. XBRL B. Tableau C. VLOOKUP function D. Pivot table E. Regressionarrow_forwardI need help with a and barrow_forwardWhat is forecasting risk and how can it affect decision making? atting re for you! th your chat Edit View Insert Format Tools Table 12pt Paragraph Paragraph р B IUA BIUA 2 2 T² : T² V i I 0 words ✓arrow_forward
- I need help with B, C, D on the attached assignmentarrow_forwardEthics case: Uncollectible Accounts Introduction The purpose of this discussion forum is to give you an opportunity to apply your critical-thinking ability to the knowledge you’ve gained. The assignment provides you with an opportunity to develop your research, analysis, judgment, and communication skills. You also will work with other students, integrate what you’ve learned, apply it in real-world situations. This practice will broaden your knowledge and further develop your decision-making abilities. The assignment achieves learning objective 5. The assignment information is given below; You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held manufacturing company. Your immediate superior is the controller who, in turn, is responsible to the vice president of finance. The controller has assigned you the task of preparing the year-end adjusting entries. In the receivables area, you have prepared an aging of accounts receivable and have…arrow_forwardPlease correct answer and don't use hand ratingarrow_forward
- Please write proposal which needs On the basis of which you will be writing APR. Write review of at least one article on the study area (Not title) of your interest, which can be finance related study area. Go through the 1. Study area selection (Topic Selection) 2. Review of Literature and development of research of framework 3. Topic Selection 4. Further review of literature and refinement of research fraework 5. Problem definition and research question…arrow_forwardQuestion 2 Listen Which linear regression equation matches the given data sets? Use your TI-84+ calculator to determine the equations. Hint: Click STAT and chose option 1: EDIT. Enter your data into L1 (explanatory variable) and L2 (response variable). Click STAT, choose CALC, and choose op- tion 8. Table A x y X Table B y 0 7.5 0 6.8 1 7.7 1 5 2 8 2 7.5 3 8 3 7 4 8.5 4 9 Table C Table D X y X y 0 11.2 0 15 1 7.7 1 77 2 8 NOT AN OPTION 3 4.5 3 6.5 4 4.6 4 3.2 ŷ=7.48+0.23x a. Table B ŷ-5.78+0.64x b. Table C y=10.48-1.64x c. Table Aarrow_forwardGive typing answer with explanation and conclusionarrow_forward
- F Mathematics In The Modern WorldNote: If you have already answered the problems in this post, kindly ignore it. If not, then answer it. Thank you, Tutor!Content Covered:- Engineering Economics- Simple Interest, Compound Interest, Annuity, Financial Mathematics & Comparison of AlternativesDirections:Solve the problem below by showing the complete solution. In return, I will give you a good rating. Thank you so much!Note: Please be careful with the calculations in the problem. Kindly double check the solution and answer if there is a deficiency. And also, box the final answer.Thank you so much!arrow_forwardPage 2 of 2 Assignment 2: (CLO 5): MS Excel application: Determine any four related variables, two of them are qualitative (Categorical) and two are quantitative (Numerical). a. Input sufficient data about the four variables (a random sample of 50 or more) in MS-Excel sheet. b. Prepare frequency distribution tables for one qualitative and one quantitative variable. c. Prepare appropriate graphs for each of the two tables. d. Prepare a pivot table (cross tabulation) consists of two qualitative variables (in rows and columns) and one quantitative variable as values. e. Conduct descriptive analysis for the two quantitative variables (summary measures). f. Find the coefficient of variation (CV) and compare the dispersion of the two variables.arrow_forwardMilestone #1 – Research Project Overview (Week Two) Introduction: Provide a brief overview of the research healthcare. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell. Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the questionnaire. Creswell & Creswell (2023) discuss this in Chapter 6.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you