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)
    • 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

Starbucks Corp (NASDAQ:SBUX) Earnings Model  

Author: Jacob Conecoff, Published: October 28, 2020 1:23pm Category: Earnings Preview (Fiscal 4Q2020)

Model Description: This model predicts earnings and cash flows for Starbucks Corp (NASDAQ:SBUX) driven by estimates of comp-store sales and store count estimates. Ratio analysis is used to complete the financial statements. The Equity Risk Premium Model (ERP) 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 the DCF-based share valuation within the Starbucks model.
Notes From The Model Developer: ​I have a fairly neutral view on SBUX at this point. Recovery has been slower than anticipated in the United States and COVID cases have seen an uptick in recent months. As we move into colder months, I forecast cases to continue to rise as people can no longer congregate outside in many parts of the country. SBUX has done well in updating their touchless ordering which will benefit them during this time although I predict comp store sales to remain sales percentages to remain negative until F2Q21. Additionally, operating expenses will be a larger percentage of revenue as sales decrease and SBUX is forced to spend more on COVID precautions to keep stores open. International segments have recovered more rapidly, specifically in China and Japan. I believe a vaccine will become available for distribution Q1 '21, but full recovery lagging. The model also incorporates a Biden win in November. I predict rates to remain low during this time to help stimulate the economy, similar to Obama era. Additional comments have been embedded within both models as well.

SBUX Model (Conecoff).xlsx
File Size: 216 kb
File Type: xlsx
Download File

ERP Model (Conecoff).xlsx
File Size: 2298 kb
File Type: xlsx
Download File


​Disclosure: ​The author of this article/model has no financial investment or other conflict of interest related to the subject company or other companies discussed. Any views made or implied in the content represent the author’s opinions.
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.