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

Author: Mansi Patel, Published: July 28, 2020 6:10pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​As Facebook’s second-quarter earnings are forthcoming, these are my personal predictions for the company’s earnings regarding the remainder of this fiscal year and next year. This global pandemic is unprecedented, and not only has it changed the everyday routines of people but has also disrupted the economy and significantly impacted the NASDAQ stock exchange. Considering the effects of COIVD-19 and the majority of people being in quarantine has led to an increased usage of social media platforms, like Facebook and their parent companies: Messenger, Instagram, and WhatsApp. Sheryl Sandberg, COO of Facebook mentioned “we’ve seen strong growth in gaming and relative stability in technology and e-commerce, which is one of our largest sectors”. I predict that stay-home orders have made people more active on these sites, hence I reported a bullish market for Facebook's future earnings. I will dive more deeply into the changes I made into the model, followed by my reasoning.

Monthly Active Users: MAU, is an important evaluation for companies, as it determines key metrics of how many unique users have logged-in to their site. There are several reasons why I believe this number has increased, first and foremost is due to quarantine. At the start of March, many individuals took shelter within their homes, and to ease their stress level, many relied on social media platforms like Facebook. Dave Wehner, CFO of Facebook stated, “In March, we estimate that on average over 2.3 billion people used at least one of our services on a daily basis, and that approximately 3 billion people were active on a monthly basis”. Additionally, I believe MAU is increasing due to the constant engagement of social events that occurred during April- June. Many users on these social platforms shared and posted content relevant to Black Lives Matter, while also creating multiple Facebook groups geared towards the topic. Not only is this impact occurring within North America, but also other countries. India, for instance, has the leading audience for Facebook, around 280 million users. Along with that, India has been hit hard with coronavirus cases, resulting in quarantine for the majority of the population. This then increased leisure time and allows more for engagement on Facebook and their parent companies. However, going into the year 2021, I decreased MAU for all countries. Since cases of COVID-19 will decline and people will shift back to their daily norms, becoming less active on social platforms.

Average Revenue Per User: ARPU, yields the amount of revenue Facebook will earn. The majority of Facebook’s revenue is dominated by ads. The effects of COVID-19 have created a drop in ARPU since there was a decline in ad demand. Further events, such as the boycott of advertisers on social media has led to a significant decrease in revenue. These boycotts have significantly damaged Facebook, their shares had dropped 8.3% and $56 billion from the company’s market value. Accordingly, to these measures, for 2020 I decreased the ARPU, as many companies have put a pause on their ads and there has been a decline in ad engagement. Although there is currently a decline, ad engagement will begin to increase as COVID-19 becomes less relevant. Therefore, I began to increase the ARPU for 2021, since companies will no longer pause their ads.

Overall: Facebook is a strong company, and even during unprecedented times they still have growth. Even though ARPU has been low for this quarter as the economy faces recession, it is bound to bounce back up for 2021 as coronavirus cases decline.

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