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

Facebook Inc Earnings Model (Vitenzon)​

Author: Marc Vitenzon, Published: July 28, 2020 8:16pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​For fiscal quarter 2 in year 2020, a minor earnings beat of the consensus estimate for Facebook's EPS is expected. This expectation is largely driven by the assumption of smaller quarter-over-quarter (QoQ) drop-offs in average-revenue-per-user (ARPU), specifically in the U.S. and Canada, during the pandemic. ARPU in U.S. and Canada is projected to continue to marginally increase in Q2 and Q3 as a result of further expected fiscal stimulus and heightened user engagement as other forms of entertainment remain limited while social tensions are elevated. This means that this region should feel a negative impact when it comes to ARPU once fiscal stimulus begin to dry-up. However, this impact should be mitigated by revenues stemming from other regions which are expected to have had the pandemic under control for longer.

Elsewhere, ARPU is expected to decline QoQ as economic conditions continue to stagnate even as the virus comes under control in various parts of the EU and Asia.

The monthly-average-users (MAU) metrics are expected to face small drop-offs worldwide, as people begin to come out of the unprecedented period of stasis which existed in quarantine.

With regards to other aspects of this income-statement driven earnings model, the QoQ trends that have been set with 2020Q1 results are expected to continue--in-line with management's expectations expressed in the 2020Q1 earnings call. Increases in R&D expenses and interest expenses as a percentage of revenue are expected to remain the same, while marketing spend is expected to increase as Facebook aims up for this quarter's slack in MAUs from 2020Q1. Meanwhile, CapEx is expected to further decrease as Facebook pushes portions of it back to 2021H1. In the end, total expected OpEx for 2020 comes in at an expected $52,965B, which is at lower end of management's guidance between $52B and $56B.

The topical Facebook ad-boycott was given little weighting in the earnings forecast due to its limited effect on the company's bottom line, and the related-revenues are expected to be made back by the end of 2020 at the latest.

With regards to Facebook's long-term (3-5 years) picture, the current developments with the company's attempts to monetize WhatsApp in India via JioMart and the eventual mass consumption of VR content have been taken into account.

Given that both of the aforementioned developments are still very much in their nascent stages (in the context of the 3-5 year timeline), their effects are only expected to truly impact Facebook's revenue growth rate towards the later end of this five year period. Meanwhile, the digital advertising and social media market is expected to approach full saturation, with less and less market share up for grabs.

Thus, in the short term, Facebook is expected to beat earnings and eventually make a return to status quo by 2021H1. In this bullish model, Facebook returns to its pre-pandemic revenue growth of ~20% QoQ by the end of the year. In the long term, Facebook's growth profile seems significantly more limited, as its attempts to diversify revenue are still in their early stages of development.

FB Earnings Model (Marc Vitenzon).xlsx
File Size: 141 kb
File Type: xlsx
Download File

About the Model Developer

​Disclosure of Potential Conflicts of Interest: ​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.