[SOLVED] FINM36700 Homework 2

The ProShares ETF Product

This section is not graded, and you do not need to submit your answers.

But you are expected to consider these issues and be ready to discuss them.

This section requires no empirical analysis; answer solely based on the material given in the case.

“Alternative ETFs”
Describe the two types of investments referenced by this term.

Hedge Funds.

1. (a)  Using just the information in the case, what are two measures by which hedge funds are an attractive investment?
2. (b)  What are the main benefits of investing in hedge funds via an ETF instead of directly?

The Benchmarks

1. (a)  Explain as simply as possible how HFRI, MLFM, MLFM-ES, and HDG differ in their construction and purpose.
2. (b)  How well does the Merrill Lynch Factor Model (MLFM) track the HFRI?
3. (c)  In which factor does the MLFM have the largest loading? (See a slide in Exhibit 1.)
4. (d)  What are the main concerns you have for how the MLFM attempts to replicate the HFRI?

The HDG Product

1. (a)  What does ProShares ETF, HDG, attempt to track? Is the tracking error small?
2. (b)  HDG is, by construction, delivering beta for investors. Isn’t the point of hedge funds to generate alpha? Then why would HDG be valuable?
3. (c)  The fees of a typical hedge-fund are 2% on total assets plus 20% of excess returns if positive. HDG’s expense ratio is roughly 1% on total assets. What would their respective net Sharpe Ratios be, assuming both have a gross excess returns of 10% and volatility of 20%?

1

2 Analyzing the Data

Use the data found on Canvas, in ‘proshares analysis data.xlsx’. It has monthly data on financial indexes and ETFs from Aug 2011 through Sep 2021.

1. For the series in the “hedge fund series” tab, report the following summary statistics:1

   (a) mean (b) volatility

   (c) Sharpe ratio Annualize these statistics.

2. For the series in the “hedge fund series” tab, , calculate the following statistics related to tail- risk.
   1. (a)  Skewness
   2. (b)  Excess Kurtosis (in excess of 3)
   3. (c)  VaR (.05) – the fifth quantile of historic returns
   4. (d)  CVaR (.05) – the mean of the returns at or below the fifth quantile
   5. (e)  Maximumdrawdown-includethedatesofthemax/min/recoverywithinthemaxdrawdown period.

   There is no need to annualize any of these statistics.

3. For the series in the “hedge fund series” tab, run a regression of each against SPY (found in the “merrill factors” tab.) Include an intercept. Report the following regression-based statistics:

   (a) Market Beta (b) Treynor Ratio

   (c) Information ratio
   Annualize these three statistics as appropriate.

4. Relative Performance
   Discuss the previous statistics, and what they tell us about…

   (a) the differences between SPY and the hedge-fund series? (b) which performs better between HDG and QAI.

   (c) whether HDG and the ML series capture the most notable properties of HFRI.

5. Report the correlation matrix for these assets.

   (a) Show the correlations as a heat map.

   (b) Which series have the highest and lowest correlations?

1Technically, the Sharpe Ratio is calculated as the mean over volatility of excess returns. Here we are using total returns, but we still refer to this mean-volatility ratio as the Sharpe ratio.

2

6. Replicate HFRI with the six factors listed on the “merrill factors” tab. Include a constant, and run the unrestricted regression,2

rhfri = αmerr + xmerrβmerr + εmerr (1) ttt

hfri merr merr ˆmerr
rˆ ≡αˆ +x β (2)

tt

Note that the second equation is just our notation for the fitted replication.3

(a) Report the intercept and betas.
(b) Are the betas realistic position sizes, or do they require huge long-short positions?

(c) Report the R-squared.
(d) Report the volatility of εmerr, (the tracking error.)

7. Let’s examine the replication out-of-sample.
Starting with t = 61 month of the sample, do the following:

• Use the previous 60 months of data to estimate the regression equation, (1). This gives

  merr

  merr 􏰑 time-t estimates of the regression parameters, α􏰑t and βt

• Use the estimated regression parameters, along with the time-t regressor values, xmerr, to t

  calculate the time-t replication value4 that is, with respect to the regression estimate, built “out-of-sample” (OOS).

hfri merr merr ′ merr r􏰑 ≡α􏰑 +(x )β􏰑

tttt

• Step forward to t = 62, and now use t = 2 through t = 61 for the estimation. Re-run the steps above, and continue this process throughout the data series. Thus, we are running a rolling, 60-month regression for each point-in-time.

How well does the out-of-sample replication perform with respect to the target?

8. We estimated the replications using an intercept. Try the full-sample estimation, but this time without an intercept.

rhfri = αmerr + xmerrβmerr + εmerr ttt

hfri merr merr ˇmerr rˇ ≡αˇ +x β

tt

Report
(a) the regression beta. How does it compare to the estimated beta with an intercept, βˆmerr?

hfri

(c) the correlations of the fitted values, rˇ to the HFRI. How does the correlation compare to t

hfri

Do you think Merrill and ProShares fit their replicators with an intercept or not?

2ML restricts their regression to ensure the position sizes stay within certain bounds. We leave it unrestricted.

3This is just the fitted value of your regression, which in classic regression notation would be yˆ, and based on your regression fit for y.

4This is just a single number!

(b) the mean of the fitted value, rˇ . How does it compare to the mean of the HFRI? t

hfri

that of the fitted values with an intercept, rˆ t

3

3 Extensions

ms This section is not graded, and you do not need to submit your answers. We may discuss some of these extensions.

1. Merrill constrains the weights of each asset in its replication regression of HFRI. Try constraining your weights by re-doing 2.6.
   1. (a)  Use Non-Negative Least Squares (NNLS) instead of OLS.5
   2. (b)  Go further by using a Generalized Linear Model to put separate interval constraints on

      each beta, rather than simply constraining them to be non-negative.6

2. Let’s decompose a few other targets to see if they behave as their name suggests.
   1. (a)  Regress HEFA on the same style factors used to decompose HFRI. Does HEFA appear to be a currency-hedged version of EFA?
   2. (b)  Decompose TRVCI with the same style factors used to decompose HFRI. The TRVCI Index tracks venture capital funds–in terms of our styles, what best describes venture capital?
   3. (c)  TAIL is an ETF that tracks SPY, but that also buys put options to protect against market downturns. Calculate the statistics in questions 2.1-2.3 for TAIL. Does it seem to behave as indicated by this description? That is, does it have high correlation to SPY while delivering lower tail risk?

3. The
through levered, or “geared” ETFs.

ProShares case introduces Levered ETFs. ProShares made much of its name originally

1. (a)  Explain conceptually why Levered ETFs may track their index well for a given day but diverge over time. How is this exacerbated in volatile periods like 2008?
2. (b)  Analyze SPXU and UPRO relative to SPY.
   • SPXU is ProShares -3x SPX ETF.
   • UPRO is ProShres +3x SPX ETF.
   1. Analyze them with the statistics from 2.1-2.3. Do these two ETFs seem to live up to their names?
   2. Plot the cumulative returns of both these ETFs along with SPY.

   What do you conclude about levered ETFs?