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

Company Earnings Models

Download our consensus-based earnings models, and plug in your own forecast. We are currently building our inventory of models, starting with the companies listed below. If you do not see the company you want, be sure to check back soon, or you can join our team of contributors and build the model yourself. Please keep in mind that by accessing our models you are deemed to have read and agreed to our Terms of Use. For details of our modeling approach visit our modeling approach summary page. We strive to keep our consensus-based models up-to-date; However, some of our models may not reflect the latest available information.  Before you download a model, check the date to make sure it includes the last reported results. If it does not, consider joining our mailing list to receive notifications of future model updates. 

Adobe Inc (NASDAQ ADBE)
Adobe Systems Inc (NASDAQ: ADBE)
​This model projects future earnings based on revenue growth and margin assumptions for the company's three main segments: Digital Media, Digital Marketing, and Print & Publishing.

Alibaba Group Holding (NYSE BABA)
Alibaba Group (NYSE:BABA)
This model breaks down Alibaba’s results by segment. GMV and monetization rate estimates are used to forecast future period revenue.

Alphabet Inc (NASDAQ GOOGL)
Alphabet Inc (NASDAQ:GOOGL)
This model breaks down Alphabet’s results by segment. Revenue is shown gross and net of Traffic Acquisition Costs (TAC). Ratio analysis is used to complete the financial statements.


Amazon.com Inc (NASDAQ AMZN)
Amazon.com Inc (NASDAQ:AMZN)
​This model breaks down Amazon’s results by segment: North America, International and Amazon Web Services (AWS). Growth rates and historic seasonality are used to project future earnings.

Apple Inc (NASDAQ AAPL)
Apple Inc (NASDAQ:AAPL)
​This model uses iPhone, iPad, Mac, services, and Wearables, Home & Accessories growth rates to project future revenue. Ratio analysis is used to complete the Income Statement. Ratio analysis is used to complete the Income Statement.

Boeing Co (NYSE BA)
Boeing Co (NYSE:BA)
​​This model uses revenue growth rates and operating margin estimates to predict future earnings for Boeing's three primary segments: Commercial Airplanes, Defense Space & Security, and Boeing Capital.


Box Inc (NYSE BOX)
Box Inc (NYSE:BOX)
​This model uses revenue growth rates and ratio analysis to project future earnings. 

Cisco Systems Inc (NASDAQ CSCO)
Cisco Systems Inc (NASDAQ:CSCO)
​​This model disaggregates Cisco's earnings by Segment: Switching, NGN Routing, Collaboration, Service Provider Video, Data Centers, Wireless, and Security.

Electronic Arts (NASDAQ EA)
Electronic Arts (NASDAQ:EA)
​​This model uses growth rate estimates for products and services, and margin assumptions to predict future earnings.


Etsy Inc (NASDAQ ETSY)
Etsy Inc (NASDAQ:ETSY)
​This model uses GMS to project Marketplace revenue, and active sellers to project Seller Service Revenue.

Facebook (NASDAQ FB)
Facebook Inc (NASDAQ:FB)
​This model uses Monthly Active User growth rates and Average Revenue Per User to project future Revenue.

Foot Locker Inc (NYSE FL)
Foot Locker Inc (NYSE:FL)
This model uses estimates for store counts, square footage, and sales per square foot to forecast revenue.


Ferrari NV (NYSE RACE)
Ferrari NV (NYSE:RACE)
​This model breaks down Ferrari’s results by segment, and projects revenue based on the number of cars sold and average selling price per car.

Home Depot Inc (NYSE HD)
Home Depot Inc (NYSE:HD)
This model uses comparable store sales, store count estimates, and ratio analysis to forecast earnings.

Host Hotels & Resorts Inc (NYSE HST)
Host Hotels & Resorts (NYSE:HST)
​This model projects future earnings using assumptions for hotel rooms, average room rates, occupancy rates and RevPAR.


iRobot Corp (NASDAQ IRBT)
iRobot Corp (NASDAQ:IRBT)
​This model projects future earnings using product unit growth and gross margin assumptions.

Macy's Inc (NYSE M)
Macy's Inc (NYSE:M)
​​This model projects future earnings using an estimate of store counts, and same store sales growth.

Marriott International Inc (NASDAQ MAR)
Marriott Intl Inc (NYSE:MAR)
​This model projects future earnings using assumptions for hotel rooms, average room rates, occupancy rates and RevPAR.


McDonalds Corp (NYSE MCD)
McDonald's Corp (NYSE:MCD)
This model breaks down McDonald’s results by Company Operated and Franchised Restaurants. The number of each type of restaurant is forecasted and an estimate of revenue per restaurant is used to determine future revenue.

Microsoft Corp (NASDAQ MSFT)
Microsoft Corp (NASDAQ:MSFT)
​To forecast revenue, this model applies growth rates to the four reportable segments: Productivity & Business Processes, Intelligent Cloud, More Personal Computing, and Corporate & Other.


Monster Beverage Corporation (NASDAQ MNST)
Monster Beverage (NASDAQ:MNST)
This model uses the unit case sales and average revenue per case to forecast Monster’s future period revenue. Ratio analysis is applied to the revenue estimate to forecast costs and other Income Statement line items.


Netflix Inc (NASDAQ NFLX)
Netflix Inc (NASDAQ:NFLX)
​This model breaks down Netflix’s earnings into three segments: Domestic Streaming, International Streaming, and DVD. For each segment the growth in users and revenue per user are forecasted, and used to estimate total revenue.


Nike Inc (NYSE NKE)
Nike Inc (NYSE:NKE)
​This model uses growth rates for Footwear, Apparel, and Equipment for each segment to project future revenue. Ratio analysis is used to complete the Income Statement.

Pepsico Inc (NYSE PEP)
PepsiCo Inc (NYSE:PEP)
​This model uses revenue growth rates and operating margin by segment to project future earnings.


Sketchers USA Inc (NYSE SKX)
Sketchers USA Inc (NYSE:SKX)
​This model uses growth rates and margin assumptions for the Domestic and International Wholesale Segments, and uses store counts and sales per store to forecast Retail Segment earnings.

Square Inc (NYSE SQ)
Square Inc (NYSE:SQ)
​This model projects future earnings based on Gross Payment Volume (GPV) estimates and segment margin forecasts.

Starbucks Corporation (NASDAQ SBUX)
Starbucks Corp (NASDAQ:SBUX)
​This model uses estimates of new stores and revenue per store by geographic region to project future revenue.


Picture
Tesla Motors Inc (NASDAQ:TSLA)
​This model uses estimates of vehicle deliveries and average selling price per vehicle to project future revenue.

Twitter Inc (NYSE TWTR)
Twitter Inc (NYSE:TWTR)
​This model breaks down Twitter’s earnings into two segments: United States and International, and forecasts user growth rates and average revenue per user for each segment. Forecasts of gross margin percentage, including Traffic Acquisition Costs (TAC)are used t
o estimate cost of revenue. 

Under Armour Inc (NYSE UA)
Under Armour Inc (NYSE:UA)
This model breaks down Under Armour’s results by segment: North America, International and Connected Fitness.


United Continental Holdings (NYSE UAL)
United Continental (NYSE:UAL)
​This model uses revenue passenger miles, Available Seat Miles (ASM), passenger load factors, Passenger Revenue per ASM (PRASM), and Cost per Average Seat Mile (CASM) to project future earnings.

Visa Inc (NYSE V)
Visa Inc (NYSE:V)
​
This model uses estimates for payment volume and transaction estimates to forecast revenue, and ratio analysis is applied to the revenue estimate to forecast costs and other Income Statement line items.

Walt Disney Company (NYSE DIS)
Walt Disney Co (NYSE:DIS)
​This model applies growth rates to each segment (Cable Networks, Broadcasting, Parks, Studio, Consumer, and Interactive) to forecast earnings. Ratio analysis is used to complete the Income Statement.


Amazon.com Inc (NASDAQ AMZN)
FedEx Corp (NYSE:FDX)
​This model uses Average Daily shipping Volume (ADV) and package yield (revenue per package), to project future revenue. Expenses are driven by assumptions for fuel expense, and capex.

The Federal Reserve Washington
Equity Risk Premium Model
In this spreadsheet we estimate the market Equity Risk Premium (ERP) using the Constant Sharpe approach, and forecasts for interest rates, volatility, and equity market returns.

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.