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

Alibaba Group (NYSE:BABA) Earnings Model


​Model Tier: Tier 2, Consensus-based model. 
Model Summary: This model breaks down Alibaba’s results by segment: China Retail, China Wholesale, International Retail, International Wholesale, Cloud Computing, and Other Revenue. The China Retail Segment is the largest contributor of earnings and is further disaggregated into two categories: Mobile and PC. GMV (an estimate of the value of the total potential sales on the Alibaba network) and monetization rate estimates are used to forecast future period revenue. For the remaining segments we apply a basic quarter-over-quarter growth rate.
Download Model
Subscribe for BABA Model Updates

Alibaba Modeling Approach

​​Revenue Modeling Approach: This model breaks down Alibaba’s results by segment: China Retail, China Wholesale, International Retail, International Wholesale, Cloud Computing, and Other Revenue. The China Retail Segment is the largest contributor of earnings and is further disaggregated into two categories: Mobile and PC. GMV (an estimate of the value of the total potential sales on the Alibaba network) and monetization rate estimates are used to forecast future period revenue. For the remaining segments we apply a basic quarter-over-quarter growth rate.

Currency Translation: Management primarily discusses operating results in RMB, but we value shares in USD. To overcome this hurdle, we model earnings in RMB terms and translate the results back to USD before calculating the final share valuation.
​
Expense Modeling Approach: We use ratios for the three primary operating expense line items (Product Development, Sales & Marketing, and General & Administrative Expenses) as a percentage of revenue. We estimate amortization of intangibles, Interest & Investment Income/(Expense), Other Income, and Equity Investment and Non-Controlling Interest impact based on historic averages. We apply an effective tax rate to the future projected income to forecast the Provision for Income Tax.

Non-GAAP Adjustments: We project future Stock-Based Compensation (SBC) expense based on the historic ratio of SBC-to-Revenue, and allocated it between Cost of Revenue, and the three main operating expense line items based on the historic allocation. We then estimate the remaining non-GAAP line items based on historic averages.

Share Count Forecast: To forecast the future share count we calculate the historic change in share count, after removing the impact of share repurchases. We then make estimates for future share repurchase volume and prices, and deduct the resulting share reduction in our forecast periods.
​
Valuation Approach: We utilize a market multiple based valuation approach, specifically a Price-Earnings Multiple which we apply to

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.