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 (Chan)​

Author: Shirley Chan, Published: July 28, 2020 6:16pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​FB’s main drivers to project future revenue in this model are Monthly Active User (MAU) growth rates and Average Revenue Per User (ARPU).

A key assumption is that the impact of COVID-19 will continue through 2020. After COVID-19 was announced as a global pandemic in mid-March, FB saw a surge in users across their products. I projected FB to have higher than usual MAU growth rates this quarter due to shelter-in place restrictions. As these restrictions are lifted, MAU growth rates will start to slow down. Taking the next COVID-19 outbreak into consideration, FB will have another high growth in MAUs this fall. I further projected that MAUs will stabilize in 2021 as conditions begin to improve.

Along with growing MAUs, FB saw a significant decline in ad revenue in March due to COVID-19. This impact was mitigated by factors such as growing ad demand in the gaming industry, allowing FB to achieve relative flat YoY ad revenue in April. Starting late June, however, FB has been facing ad boycotts from their top advertisers due to hate speech policies. As a result, I projected negative single-digit ARPU growth rates this quarter. I believe COVID-19 and ad boycotts will continue to affect ARPU for the rest of the year and stabilize in 2021.

Some other assumptions for the quarter or beyond include faster recovery of Asia Pacific regions, higher R&D expense to invest in user engagement and SMBs, higher marketing expenses to attract back ad customers, and higher G&A expenses to account for bad debt from COVID-19.

FB Earnings Model (Shirley Chan).xlsx
File Size: 134 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.