ZZBU8701 Active Investing and Multi-factor Models Assignment

Project 3

1 Task

You are a portfolio analyst determining an optimal active portfolio management strategy for your Portfolio Manager. You are required to construct an appropriately weighted active portfolio and allocate between this active portfolio and the market portfolio. You will then determine whether the Carhart 4- factor model significantly increases the explanatory power of your active portfolio’s returns in comparison to the SIM. Finally, you will prepare a 3-minute presentation video to your Portfolio Manager, where you will present an analysis and comparison of your results.

2 Context

• After evaluating various U.S. equities drawn from the S&P500, a number of stocks which exhibitsignificant alpha during the period from January 2014 to December 2018 have been identified. Your Portfolio Manager wants you to carry out an ex-post analysis which examines how an optimal active portfolio could have been formed from these alpha stocks which, when combined with an S&P 500 index ETF, would have maximised the combination’s Sharpe 
• Theportfolio manager decides to randomly allocate five unique stocks which exhibited alpha during the sample period to each portfolio analyst to undertake their analysis. Each portfolio analyst will use only these five unique allocated stocks to construct their active portfolio.

3 Allocated Stocks and Data Download

• Youhave been allocated 5 alpha  (Note that these stocks are unique to you and each student will have a different combination of stocks). Your allocated stocks will be posted on Moodle with your Student ID in the Project 3 Stock Allocation Lookup.xls excel file in the Project 3 Assessments tab.
• Each stock in the spreadsheet is identified by its Factset identifier. Using these identifiers, for theperiod from January 2014 through December 2018, download the monthly returns for each allocated stock from FactSet (60 observations). All returns should be inclusive of dividends - in the FactSet dropdown box "Total Return" select “% "
• For the period from January 2014 through December 2018, download from FactSet the monthlyreturns for the S&P 500 Index (FactSet identifier: SP50) (60 observations). All returns should be total returns inclusive of dividends - FactSet dropdown box: “Total Return” select “% Return (Gross, Unhedged)”.

4 Single Index Model Regressions (Security Characteristics Line)

• Usea risk-free rate of 00% APR (i.e. fixed at 0.25% monthly) for this analysis.
• Foreach of the five stocks in your active portfolio, calculate monthly excess return:

  =   ?   where   is the return on stock  for month , and   is the risk-free rate. (Note: make sure you use the fixed monthly risk-free rate above).

• For the S&P 500 index, calculate monthly excess return: = ? where, is the returnon the S&P 500 for month . Compute the annualised average excess return for the S&P 500 (simply by multiplying the monthly excess return by 12). This will be the proxy for the average annual market risk premium over the sample period.
• Estimatethe Single Index Model alpha   and beta , (i.e. the Security Characteristic Line) for each stock in your active portfolio using the regression equation:

  =   +   + 

• Determine the residual variance (²) (unsystematic risk) for each stock in your active portfolio, either by using the following equation:

² = ^2 2 + ²

Or by using the Excel regression tools.

• Annualise the alpha and the residual variance (unsystematic risk) by multiplying by 12. (Note:ensure your alphas are generated by regressing excess returns above the risk-free rate, not raw returns).

5 Construct the Active Portfolio

• Conduct confidence interval testing for each of your 5 stocks to confirm that the alpha is non-zero(significant) at the 90% confidence 
• As your Portfolio Manager is concerned that past alpha may not be reflected in future alpha, youare required to risk-weight the alphas as follows:
  • Only include a stock in the active portfolio if its alpha is significant. Any stock that doesnot exhibit non-zero alpha at the 90% confidence level should be excluded from the active portfolio
  • Risk-weightthe alpha by multiplying it by 10% when calculating each stock’s reward-to-risk  For example, if the ex-post alpha was 20% p.a. from the SIM regression, the numerator in your reward to risk-calculation for that stock will be 2% p.a.
• Usingthe Treynor-Black model, appropriately weight your active 

6 Optimally Combine the Active Portfolio and the Market Portfolio

• Assumean ETF that tracks the S&P500 is an appropriate proxy for the market portfolio.
• Derivethe sample variance (² ) of the S&P500 over the sample period and annualise it.
• Usingthe active portfolio weightings derived in 5 above, calculate the annualised active portfolio

alpha , beta , and residual variance ( ). Calculate the reward-to-risk ratio for the active

portfolio (as a whole).

• Based on the reward-to-risk ratio of the market portfolio over the sample period. appropriatelyweight between the active portfolio and the market (passive) portfolio using the Treynor-Black 
• Calculatethe annualised information ratio for each stock in your portfolio, as well as the information ratio for the active portfolio as a whole.
• Calculate the potential improvement in your Sharpe ratio compared to a stand-alone investment inthe market (passive) portfolio as a result of this strategy. Verify how this result relates to the information ratio of the active portfolio (as a whole).

7 Active Portfolio Returns

• Usingthe active portfolio weightings derived in 5 above, as well as the monthly returns downloaded in 3, calculate the monthly weighted active portfolio returns for the sample 
• Estimate the Single Index Model alpha and beta , for your weighted active portfolio (notethis is the active portfolio Security Characteristic Line) using the regression equation:

  =   +   + 

• Annualise the weighted active portfolio alpha , and determine if the alpha and beta are significant, as well as deriving the R² for the model over the sample period. Verify that the alpha and beta for the active portfolio ( and ) are the same as your answer to 6 above. (Note: remember that your alpha in 6 was risk-weighted to be only 10% of the actual alpha, so the alpha derived from this portfolio regression should be exactly 10x the active portfolio alpha calculated in 6).

8 Multi-factor Model

• Open the excel file “Fama French Carhart Factors.xls”. This file contains the monthly riskpremiums (stated as decimals/percentages) for the Carhart 4-factor model over the sample period. (Note: check that this is in a compatible format to your existing data in terms of decimals).
• Usingthe Fama-French and Carhart monthly factor portfolio data provided (SMB, HML and WML) undertake a multi-factor regression analysis for each stock in your active portfolio. Derive the alpha (including its significance level) and R² for these 4-factor models for each stock in your active 
• Using the Fama-French and Carhart monthly factor portfolio data provided, undertake a multi-factor regression analysis for your weighted active portfolio (using the active portfolio weightings derived in 5 above, as well as the monthly returns downloaded in 3). Use the regression equation:

• Derivethe alpha (including its significance level) and R² for this 4-factor model regression of your weighted active portfolio (Note: this is one single regression).

9 Video Presentation

• Prepare a video for your Portfolio Manager of no longer than 3 minutes which discusses yourresults, as well as the limitations of your analysis. Some suggestions of what could be covered in your video include:
  • A brief discussion of the alpha of each stock in your active portfolio and why you believeit exists
  • Howyou constructed the active portfolio and allocated between it and the S&P500 ETF
  • A brief comment on the improvement in your Sharpe ratio arising from the addition of theactive portfolio, compared to holding the S&P500 ETF alone
  • Anexamination of the differences in the results derived from the individual stock regressions compared to the active portfolio regression, referencing such statistical measures as the R² and the alpha, and any other statistical measures you believe are relevant
  • A discussion of what happens to your R²and alpha (including its significance), and any other statistical measures you believe are relevant, when the additional Carhart factors are added to the model, as well as an explanation for why you believe this occurs
  • A discussion of the differences between your multi-factor model individual stock resultsand your multi-factor model portfolio result
  • Considerationof any limitations or shortcomings you believe exist in your models, addressing issues such as the risk weighting methodology, allocation methodologies, concentration issues and the unconstrained nature of the outcomes