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
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
ngageNOWv2 | Online teachin x
Chapter 4 Corporate Financial Ac x +
/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false
☆
E
1 Welcome - Login.gov
Sign in to your acco...
Control Center
Part 9:
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the
concepts.
Note: You must complete parts 1, 2, 3, 4, 6, 7 and 8 before completing part 9. Part 5 is optional.
Part 9: Prepare the closing entries below. Then, using the attached spreadsheet from part 2, post the entries to your general ledger. If an amount box does not require an entry, leave it blank.
Date
Account Name
Post. Ref.
Debit
Credit
20Y8 Closing Entries
May 31 Fees Earned
40,000 ✓
0
✓
1,705 ✓
0✔
0✓
1,600 ✔
0 ✓
1,370 ✔
0✓
330
0✔
275
✓
1,295 ✔
33,425 ✔
0
10,500
<
Previous
Next
Email Instructor Save and Exit Submit Assignment for Gradin
10:53 PE
--
6/13/202
WIS
V…
arrow_forward
19-
Which of the following provides a decentralized database or digital ledger of transactions that everyone on the network can see:
a.
Investment banking
b.
Block chain technologies
c.
Crowd funding
d.
Mutual fund
arrow_forward
Can you help solve this problem. I have one more try.
arrow_forward
I need help with B, C, D on the attached assignment
arrow_forward
e 1:E1
OMANTEL
Practice (page 6 ..
moodle.nct.edu.om
Which of the following provides a
decentralized database or digital ledger of
transactions that everyone on the network
can see
а.
Crowd funding
Block Chain Technologies
С.
Crypto currencies
d.
Investment Banking,
II
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
Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".
arrow_forward
How to solve this?
arrow_forward
Revisit
Choose the best option
Question # 1
A Repoa Problem
O Strategy
In the decision making process in an organisation, all these are phases of planning except for
OBudgets
this.
O Positioning
OScorecard
+9180 47190917
Deepanshu | Support +1650-924-9221
x
metti
%23
N
(3
O Type here to search
hp
18
14
f7
f6
f5
10
f4
f3
米
f2
%24
林
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
LinkedIn Learning
Free App for Android
in
Question 3 of 14:
Select an answer:
The US GAAP provides rules and guidance
for what two primary financial reporting
purposes?
Return to course
recognition and measurement
risk assessment and presentation
recognition and presentation
Open
initial and subsequent measurement
Previous
Skip
arrow_forward
How would I calculate this problem? I just guessed on which answer made sense to me. Please help. thank you in advance.
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
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
DA. 7-2 Project: Company Accour x
D2L 7-1 Problem Set: Module Sev X
CengageNOWv2 |Online tea X
Cengage Learning
+ x
ngagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=&inprogress%3Dfalse
电 手
eBook
Show Me How
Long-Term Solvency Analysis
The following information was taken from Celebrate Company's balance sheet:
Fixed assets (net)
006'86$
000
1,471,050
Long-term liabilities
Total liabilities
Total stockholders' equity
1,634,500
Determine the company's (a) ratio of fixed assets to long-term liabilities and (b) ratio of liabilities to stockholders' equity. If required, round your answers
to one decimal place.
a. Ratio of fixed assets to long-term liabilities
b. Ratio of liabilities to stockholders equity
(Previous
Check My Work
330 PM
hp
144
114
arrow_forward
Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this
question. I will grade this question on the accuracy of your () spreadsheet model (decision variables, objective, and constraints), (i) Solver
parameters, (i optimal solution. Partial credit is available.
The personnel-planning problem of Lexington Bank. The main branch of Lexington Bank is open for retail business from 8:00 AM to
4:00 PM on weekdays. The staffing requires from 8 to 15 tellers on duty depending on the time of day, as indicated in the following table.
Time Period
Minimum No. of Tellers
8:00 AM - 10:00 AM
10:00 AM - 12:00 PM
12:00 PM - 2:00 PM
10
15
2:00 PM - 4:00 PM
12
Full-time tellers work 8 consecutive hours (from 8:00 AM to 4:00 PM) at $15 per hour. Part-time workers work 4 consecutive hours at $8
per hour starting at 8:00 AM, 10:00 AM, or 12:00 noon. Assume workers never take breaks. Union regulations require that all…
arrow_forward
ngageNOWv2 | Online teachin x
= Ch. 12 Key Terms - Principles of A X
takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Cancel Your...
F Startup Opportuniti. V How brands are co..
Assignment Practic...
COVID-19 Student..
C20-128PR01-2016...
O Final Exam Review
Eli Inc. issued $110,000 of 10% annual, 4-year bonds for $112,800. What is the total amount of interest expense over the life of the bonds?
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
Is this an equation I have deducted from an answer provided by a tutor? If it is right, what is it for because I’ve since been given these other formulas in the second pic
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
PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.
I REPEAT, ONLY EXCEL
arrow_forward
E Managerial Accountin x
B 3-1 Problem Set: Mod X
* CengageNOWv2 |On x
b My Questions | bartlel x
* Cengage Learning
Cengage Learning
+
A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Update :
Problem Set: Module 6
O eBook
I Show Me How
1. EX.07.02.ALGO
Income Statements under Absorption Costing and Variable Costing
Gallatin County Motors Inc. assembles and sells snowmobile engines. The company began operations on July 1 and operated at 100% of capacity during
2. TMM.07,01
the first month. The following data summarize the results for July:
3. EX.07.12.ALGO
Sales (18,500 units)
$2,405,000
Production costs (24,000 units):
4. EX.07.05.ALGO
Direct materials
$1,154,400
5. TMM.07.05
Direct labor
554,400
Variable factory overhead
276,000
Fixed factory overhead
184,800
2,169,600
Selling and administrative expenses:
Variable selling and administrative expenses
$336,300
Fixed selling and administrative expenses
130,200
466,500…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
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
- ngageNOWv2 | Online teachin x Chapter 4 Corporate Financial Ac x + /ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false ☆ E 1 Welcome - Login.gov Sign in to your acco... Control Center Part 9: The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts 1, 2, 3, 4, 6, 7 and 8 before completing part 9. Part 5 is optional. Part 9: Prepare the closing entries below. Then, using the attached spreadsheet from part 2, post the entries to your general ledger. If an amount box does not require an entry, leave it blank. Date Account Name Post. Ref. Debit Credit 20Y8 Closing Entries May 31 Fees Earned 40,000 ✓ 0 ✓ 1,705 ✓ 0✔ 0✓ 1,600 ✔ 0 ✓ 1,370 ✔ 0✓ 330 0✔ 275 ✓ 1,295 ✔ 33,425 ✔ 0 10,500 < Previous Next Email Instructor Save and Exit Submit Assignment for Gradin 10:53 PE -- 6/13/202 WIS V…arrow_forward19- Which of the following provides a decentralized database or digital ledger of transactions that everyone on the network can see: a. Investment banking b. Block chain technologies c. Crowd funding d. Mutual fundarrow_forwardCan you help solve this problem. I have one more try.arrow_forward
- I need help with B, C, D on the attached assignmentarrow_forwarde 1:E1 OMANTEL Practice (page 6 .. moodle.nct.edu.om Which of the following provides a decentralized database or digital ledger of transactions that everyone on the network can see а. Crowd funding Block Chain Technologies С. Crypto currencies d. Investment Banking, IIarrow_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_forward
- Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".arrow_forwardHow to solve this?arrow_forwardRevisit Choose the best option Question # 1 A Repoa Problem O Strategy In the decision making process in an organisation, all these are phases of planning except for OBudgets this. O Positioning OScorecard +9180 47190917 Deepanshu | Support +1650-924-9221 x metti %23 N (3 O Type here to search hp 18 14 f7 f6 f5 10 f4 f3 米 f2 %24 林arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education