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

Starbucks Corp (NASDAQ:SBUX) Earnings Model  

Author: Fadi Badlissi, Published: October 27, 2020 8:36pm Category: Earnings Preview (Fiscal 4Q2020)

Description of Model Assumptions - Calibration & Forecasting, DCF and Multiple Analysis
  1. Historic trend and seasonality have been considered within the model forecast.
  2. Based on COVID effect in 2019 with another wave anticipated in the US with a more significant impact compared to the international market, I reduced the comp store sales total for the US more than international stores.
  3. Similarly due to COVID, I reduced the revenues from licensed stores in the US more than international.
  4. I also increased the operating expenses in consideration of fixed costs, for the US more than international, but reduced slightly the international licensed stores expenses as there will be less need to support licensees per management guidance.
  5. I increased the dividends by 10% for Q42020 based on SBUX board decision on 9/30.
  6. I increased the repurchase price of shares based on the current share value.
  7. I increased the Channel Development Segment year-over-year growth due to the reported increased sales of packaged coffee and single serving products primarily through Nestle.
  8. I tapered down the comp stores sale from FY2022 onward especially for  Q2 through Q4 to keep the seasonality post-COVID recovery and to counter the compounding effect of growth from the post-COVID recovery.
  9. I ran into negative cash balance in FY2023-25, hence I reduced the stock repurchase amount and the payments of the long-term debt (especially with the current low interest rates which may last at least for couple of years).
  10. Overall my modelled forecast is consistent with historic results and reasonable relative to consensus estimates including revenues, free cash flow, and operating margins. My growth rates for 2021 are consistent with the COVID impact in 2019.
  11. My estimates are not far off from management guidance, except for my opinion of more loss of revenues in Q1 and Q2 2021.
Discount Cash Flow Valuation Assumptions:
  • I estimated an increase in volatility for 4Q2020 and 1Q2021.
  • I decreased the S&P500 return forecast due to uncertainties in 4Q2020, 1Q and 2Q2021, with a rebound after.
  • I adjusted the 10 yr. treasury yield according to the slowdown due to COVID and rebound after. 
  • I completed the rest of the DCF calculation based on the above assumptions.
Market Multiple Valuation Assumptions:
  • I calculated a multiple based on estimates for FY20 and FY21, and chose a multiple on the higher side of historic valuations considering the recent trend for SBUX.
  • I calculated the potential price range based on the historic mean return and standard deviation in returns.
  • I calculated different FY2021 scenarios based on low to high PE multiples and EPS, a form of sensitivity analysis.
  • I compared my target share price and EPS to the consensus and the PE multiple I used, to make sure that there were no extreme deviations, and they seem to fall within the range albeit on the lower side.

SBUX Earnings Model (Fadi Badlissi).xlsx
File Size: 753 kb
File Type: xlsx
Download File

ERP Model (Fadi Badlissi).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.