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: Darsh Parekh, Published: October 23, 2021 Category: Earnings Preview (Prior to the F4Q2021 SBUX Results)

Notes From the Model Developer: My model assumptions are based on the following three points:
  • TAM expected to increase by 8-9%, and Starbucks is well adapted to meet consumers changing tastes.
  • International sales will decrease as Delta Variant hits other high population countries such as Japan, China and India.
  • Cold weather in Brazil will lead to increased coffee prices after the year 2022.
SBUX Model (D.Parekh).xlsx
File Size: 1485 kb
File Type: xlsx
Download File

ERP Model (D.Parekh).xlsx
File Size: 2352 kb
File Type: xlsx
Download File

Valuation: I have decided to use NTM P/E multiple based on historic monthly closing prices. This is mainly because I have changed the ERP model to have a relatively optimistic view of the economy. Therefore, in order to remain consistent with my beliefs, using estimates would not be accurate as they would not incorporate my assumptions about the economy made in the ERP model. 
Equity Risk Premium Forecast Assumptions: 
  • Fed Funds Rate: I have an optimistic view of the that the economy will continue to recover therefore have left them the same for most years, decreased by 10 basis points in 2023. 
  • Quarterly Spread: Remaining consistent, since I believe the economy will begin to recover, I have increased the spread by 15 basis points for the first starting Q4 2022, and then experience slower growth, therefore changed the spread to 10 basis points after that. 
  • Volatility: I believe that the economy will begin to recover mid 2022, therefore have increased volatility to 26 in Q3 2022, and 24 in Q4 2022. Do not expect it to reach COVID levels, so kept it somewhere in the middle. Also, expect it to reach historic volatility by the end of 2023, and have straight-lined it for the remaining year. 
  • Equity market return projections: I expect the market to recover in 2022 (10%), followed by a small correction in late 2022/early 2023 (-1.75% and -2.00%), after which I have kept the rates constant at 2.75%. 

​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.