Fluent Essays

BacktestingIn Lecture 5, we saw that the risk parity strategy would have performed very favorably inallocating funds across major asset classes, including bonds, stocks and commodities over the1983-2014 sample. In this assignment, you will investigate whether the strategy would haveperformed similarly well when applied to allocating funds across different U.S. stocks only.To implement the risk parity strategy, you will employ the tools we studied in Lecture 6. Inparticular, you will compute risk parity portfolio weights based on forecasts of each asset’svolatility, i.e. you will rely on conditional volatility estimates that are allowed to change overtime. Your task will therefore consist of two steps. In the first step, you will need to estimateand forecast the realized volatility for each asset in each month of the sample (as in Lecture 6).Based on these volatility forecasts, you then need to compute risk parity portfolio weights instep two (as in Lecture 5).On Blackboard, you will find an Excel file containing historical net returns for 48 industryportfolios over 1976-2015. Each portfolio consists of the value-weighted average of all publicly-traded U.S. stocks within a certain industry. Think of each industry portfolio as one asset youcan invest in. 1 The file contains both daily and monthly net returns for each industry portfolio.STEPS:To complete this assignment, you’ll need to deal with large amounts of data. The easiest way toorganize the computations is with a set of tables that are stored in separate worksheets. Hereare the necessary tables:Table 1 On each day in the sample, compute each asset’s realized variance over the past 21trading days, i.e. computeRV i,t = (r ∗i,t−20 )2+ (r ∗i,t−19 )2+ ... + (r ∗i,t )2 ,1 The data is from Ken French’s website, http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data library.html.While these portfolios are not traded directly, their constituents are known and one could therefore trade themby trading the underlying stocks. Alternatively, industries can be traded via various ETFs. We will backtestthe risk parity strategy based on a set of stock portfolios rather than on individual stocks to avoid a numberof data issues that arise when dealing with individual stocks (e.g. earnings announcements induce seasonalitiesin the volatilities of individual stocks, stocks are frequently added and deleted from the sample due to mergers,bankruptcies etc.).1/3where r ∗i,t denotes asset i’s log return on day t (note: the spreadsheet contains net returns).Hint: The easiest way to implement this is via cell references in a table that contains thedates in the rows and the assets (industries) in the columns. The function ”sumproduct”may be helpful for computing the realized variance.Table 2 Create a second table that contains your realized volatility estimate (the square root ofthe realized variance you computed in the previous step) for all assets on the last day of each calendar month.Hint: An easy way to extract end-of-month values from the table of daily observations isa ”vlookup” table. A separate pdf document on Blackboard details the necessary steps.Table 3 For each month t, use the most recent 60 monthly RV estimates to make a predictionfor RV i,t+1 . To do so, estimate the regressionqRV i,s+1 = β 0 + β 1qRV i,s + ε s+1 s = t − 59,...,t − 1.Then use the coefficient estimates to compute the fitted value from the last observationas your prediction for month t + 1:dqRV i,t+1 =bβ 0 +bβ 1 ×qRV i,tHint: Use the ”intercept” and ”slope” functions in Excel to obtain coefficient estimates.This will allow you to estimate thousands of regressions without relying on Excel’s dataanalysis toolpack, so that you can use cell references to replicate the formulas many times.We worked through an example of this for the S&P 500 in lecture 6.Table 4 The next table is simply to facilitate the computation of the risk parity portfolioweights. It should contain the inverse of the predicted monthly realized volatility values,i.e. 1/dqRV i,t . Hint: These are the σ −1 -terms in the formula for risk parity portfolioweights.Table 5 The last table contains the risk parity weights, computed asw i,t =σ −1i,tP Nj=1 σ−1j,t, i = 1,...,N,where w i,t is the portfolio weight for industry i at the end of month t. Note that thisweight applies to the portfolio return in month t + 1, i.e. you choose the portfolio at theend of the previous month and then observe its return over the current month.QUESTIONS:A Create a plot that shows the monthly realized volatility (from Table 2) along with thepredicted monthly realized volatility (from Table 3) for the agriculture industry (ACRIC)for 1981-2015.B Report the average risk parity portfolio weights.2/3C Report the mean, standard deviation and Sharpe ratio of the monthly returns for the riskparity portfolio. To compute the Sharpe ratios, use a monthly risk-free rate of 0.37\%,which equals the average return on 1-month T-bills over the sample. Next, report thesame statistics for the equal-weighted (”1/N”) portfolio. Hint: The return of the equal-weighted portfolio equals the simple average over the 48 industry portfolio returns.D Suppose you would have invested $1 into each strategy at the end of December 1980 andrebalanced your portfolio monthly until 12/2015. How much would your investment beworth? Ignore transaction costs, taxes, etc. Construct a plot illustrating the evolution ofthe values of the two investments over time.E You should have found that the performance of the risk parity strategy relative to the 1/Nstrategy is much less impressive in this example than in the one we considered in Lecture5. Speculate why this may be the case. (no more than 3 sentences)