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

Facebook Inc Earnings Model (Kishan Patel)​

Author: Kishan Patel, Published: July 28, 2020 8:26pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​My model illustrates the assumption that the COVID-19 restrictions across the globe, leads to an increase in MAU for 2Q 2020. With the second rise of COVID-19, the later quarters have been shown to reflect a decent increase in MAU towards an eventual return to normalcy of 2019 levels. Specifically, I expect a strong boost in MAU with the release in Instagram Reels for 3Q 2020. With rival TikTok being criticized for its operations, Reels has the potential to increase loyalty to Instagram and capture a greater market share in India. Further, this model assumes the long term increase in MAU in the Asia Pacific region due to a decent-sized investment in Jio Platforms Industries which already has a strong market share in information technology in the region.

This model reflects lower operating expenses due to the increase in work from home during the 2nd quarter. With the assumption that there will be a return to normal expenditure levels as the COVID-19 pandemic fades, this model also takes into account the outlook CEO, Mark Zuckerberg, gave of having 50% of Facebook’s workforce work remotely in the near future.

In this model, I have implemented a short term decrease in average revenue per user as advertisers have lesser clients to which they can advertise to amidst the global pandemic. Further, the short term decrease in average revenue per user was also implemented as a result of the boycotts of Facebook’s advertisements by many big businesses.

As a result of these occurrences affecting its ARPU, I believe it reasonable to expect that Facebook would push more out into it’s marketing efforts to gain more clients for its advertising services. As a result, I added in the estimate that 2Q 2020 will see an increase in marketing expenses and would thereafter have a gradual decrease to 2019 levels.

FB Earnings Model (Kishan Patel).xlsx
File Size: 143 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.