Gutenberg Research
  • Home
  • Models
  • Education
    • Cooperative Education Program >
      • Enroll Today >
        • Program Enrollment (Virtual)
        • Program Enrollment (Bootcamp - Boston)
        • Program Enrollment (Bootcamp - New York)
      • Training Hub (Winter'22-'23) >
        • Meetings >
          • Kick-off Call/Orientation (Winter'22-'23)
          • Meeting 1: Building the Model (Winter'22-'23)
          • Meeting 2: Entering Your Forecast Into The Model (Winter'22-'23)
          • Meeting 3: Target Valuation (Winter'22-'23)
          • Meeting 4: Live Starbucks Release (Winter'22-'23)
          • Meeting 5: Live FOMC Policy Release & ERP Update (Winter'22-'23)
        • Classes >
          • Class 1 - Introduction to Financial Modeling (Winter'22-'23)
          • Class 2 - Building the Income Statement (Winter'22-'23)
          • Class 3 - Balance Sheet and Cash Flow Modeling (Winter'22-'23)
          • Class 4 - Model Calibration & Forecasting (Winter'22-'23)
          • Class 5 - The DCF Inputs: Beta, ERP, CAPM, & WACC (Winter'22-'23)
          • Class 6 - Discounted Cash Flow Valuation (Winter'22-'23)
          • Class 7 - Market Multiple-Based Valuation (Winter'22-'23)
          • Class 8 - How to Use Your Earnings Model (Winter'22-'23)
        • Other Program Links >
          • About the Exam
          • Co-op Program Exam
          • Model Submission (Winter'22-'23)
          • Co-op Bio Form
          • Co-op Q&A (Winter'22-'23)
    • Books >
      • Procrastinator's Guide - SBUX >
        • Templates - SBUX
      • Book Registration - Third Edition >
        • Templates - Third Edition
      • Book Registration - Second Edition >
        • Templates - Second Edition
  • About
    • Contact
    • Email Distribution Sign-up
    • Terms of Use
    • Privacy Policy

Equity Risk Premium Model


ERP Model (8-17-2020).xlsx
File Size: 2292 kb
File Type: xlsx
Download File

Subscribe for ERP Updates
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).

Submit an ERP Model
July-2019 Fed Statement
NY Fed Survey
Fed Funds Futures Info
CME FedWatch Tool

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

Financial Modeling for Equity Research
Paperback
eBook
Gutenberg Research is a media and education company. The information presented on our website and within Gutenberg Research models, files, or other content does not represent investment advice. Data and information presented on this website, or on third party websites posted by us, within our models, files, and other content is for demonstration only, and is presented “as is”. Neither Gutenberg Research nor any Gutenberg Research agents or associates are liable for any errors, delays, incompleteness of data presented, or for actions taken based on reliance on any information contained on this website or within Gutenberg Research models or other content. Investors should consult a professional investment adviser prior to making investment decisions. By accessing this site and/or receiving our models or other content you are deemed to have read and agreed to our Terms of Use posted on this website. This website uses Cookies, refer to our Privacy Policy for details. The Gutenberg Research logo is among the registered and unregistered trademarks of Gutenberg Research LLC. © Gutenberg Research LLC 2023. All Rights Reserved.