Equity Risk Premium Model

ERP Model (11-5-2019).xlsx
File Size: 2168 kb
File Type: xlsx
Download File
​Latest Update: November 5, 2019
Updated by: John Moschella
Model Summary: This model uses the Fed Funds rate, 10-year U.S. Treasury rate, implied volatility, equity market returns, and the Constant Sharpe Approach, to estimate the Equity Risk Premium (ERP). The ERP and the Capital Asset Pricing Model (CAPM) are used together to calculate the required return on equity for our DCF-based share valuation models.​

Summary of Forecast Approach and Latest Data Changes in the ERP Model: Each quarter the new interest rate, market return, and volatility results must be input into the Equity Risk Premium model. In addition, new estimates must be entered for each metric. This section clarifies the approach used to form the future expectations in the “base-case” version of the ERP model.
  • Volatility: We assume volatility will regress toward the long-term historic average. We take the difference between the current quarterly average VIX and the long-term average, and divided it by the remaining number of quarters contained within the model. We then add the incremental change in volatility each quarter to smooth the forecast back to the historic average. 
    • Latest Forecast for Volatility: The trailing one-year average VIX estimate used in the ERP model has decreased from 17.22% to 16.52%.
    • User Input: If you believe the market is headed for a period of uncertainty, you can change the blue input cells to increase the future volatility assumptions. If you believe the market will stabilize, you can decrease the volatility assumptions within the ERP model. 
  • Fed Funds Rate: In our base-case scenario we assume the Fed Funds rate will increase or decrease based on the market's expectations as approximated by the CME's FedWatch tool, which uses Fed Funds futures contracts to asses the probability of future rate changes. The market's expectations are periodically compared to the FOMC's latest Projection Material, to determine if the market outlook is dislocated from that of the FOMC members.
    • Latest Forecast for the Fed Funds Rate: Based on the month-end market expected Fed Funds rates using the CME estimates, the forecasted average Federal Funds rate by quarter has been updated as follows: 4Q2019E 1.70% (no change from the previous 1.70%), 1Q2020E 1.55% (up from 1.35%), and 2Q2020E 1.48% (up from 1.32%).
    • User Input: If you believe rates will be higher/lower in the future, then change the Fed Funds input cells.
  • Spread Between 10-year Treasury and Fed Funds Rate: We use 10-year futures contracts to determine the expected spread for the next quarter. Then smooth the spread towards the long-term average spread adjusting by 25 basis points per quarter, which reflects the fact that spreads can persist above or below the historic average for long periods of time. 
    • Latest Spread/RF Rate Forecast: The model risk-free rate, which is the average 10-year U.S. Treasury rate based on the Federal Funds forecast and spread projections is now 1.58%, down 8 basis points from the previous 1.66%.
    • User Input: In general, if the market expects the economy to expand, the yield curve will steepen and the spread will increase. If the market expects the economy to contract the spread will decrease. If you believe we are headed for an expansion, then you may want to increase the spread assumption in the model. If you believe we are headed for a contraction, then you may want to decrease the spread assumption in the model.
  • Market Return/Sharpe Ratio Assumption: The average total return for the S&P500 through 1963 has been 11.4%. The market return assumptions in our base case scenario assume that the average annual return in the future will be approximately equal to the historic average.
    • Latest Forecast For Market Returns: The projected Constant Sharpe ratio based on the market return expectations and risk-free rate forecast is now 0.329.
    • User Input: If you believe market returns will be higher or lower in the future, then adjust the forecast returns in the model.
Resulting ERP Related Metrics: The latest estimates from the revised ERP model used for the DCF-based valuation in all of our Premium Models include the following:
  • Expected average market volatility: 16.52% (below the historic average of 18.5%, and above the current quarter average of 15.33%)
  • Expected average risk-free rate of return: 2.03% (above the current 10-year U.S. Treasury rate of 1.8%) 
  • Resulting forward stage-one ERP estimate: 5.55%
  • Required return on equity assuming a beta of 1.0: 7.6%
Disagree with this projection? We maintain "base-case" models for our community members to download and input their own forecast. There are many factors you can change in the ERP model including: the timing of Fed rate changes, the spread in the 10-year Treasury vs the Fed Funds rate, volatility assumptions, and equity market return projections. Try it today, and share your forecast with the Gutenberg Community. 
Planned ERP Model updates:​​​​​
  • December 10, 2019: FOMC meeting.   Target Fed Funds rate update. 
  • December 31, 2019: Quarterly data Maintenance (update equity returns, volatility, and interest rates).

About Gutenberg Research

​​We are an interactive earnings modeling community, driving the evolution of equity research. Our mission is to make dynamic earnings models, available to everyone. We are currently building an inventory of models covering companies...continue reading 

Modeling Training Program

Our Certificate in Financial Modeling Program provides an easy to follow, step-by-step approach to financial modeling training.  In this program we build a financial model from the ground up..continue reading

Modeling Textbook