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

Author: Manleen Kohli, Published: July 28, 2020 9:54pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​With Facebook’s second-quarter earnings report releasing soon, in my forecasting model, I have illustrated how the impacts of COVID will have a lasting effect on Facebook in the upcoming quarters. The major contributors to revenue are the Monthly Average Users and Average Revenue Per User, which have been divided by region.

Monthly Average Users (MAU): Being one of the biggest platforms, Facebook has taken advantage of its resources to increase its users. Especially during a time like this, Facebook and Instagram have not only allowed people to post socially but provide an easy way for small businesses to transition to an online platform. We see this with Facebook’s recent partnership with JIO Platforms in India, thus increasing user engagement significantly.

I approached this data by assessing the situation in various regions. Through much of the second quarter, we saw COVID trends slowly decreasing in certain regions, specifically Europe and several countries in Asia Pacific. As we approach the end of the second quarter, many of the stay-at-home restrictions implemented had been removed and are slowly heading back to normal life. In my model, I have shown an increase in the second quarter. However, as they remove restrictions, although many people may engage in social media, it will be slightly less than the trends we have seen in the last quarter or two. I intend the same for US/Canada, but at a much slower rate since many restrictions are still in place and as COVID rises in this region, the MAU trends will decline in further quarters.

Average Revenue Per User (APRU): Being another major contributor to Facebook’s revenue, advertisement demand has taken a hit during the pandemic. Although advertisement prices and demand are currently at a low, I project this trend to be temporary during the second and third quarters. With many countries shifting back to normalcy, APRU will increase. I have only shown a generous linear increase in the upcoming quarters of 2021 since several factors regarding COVID are still unknown. With that said, I have also taken into account seasonality especially in the fourth quarter in the US/Canada region since the holiday season as well as the upcoming election season may show a modest rise in APRU.

FB Earnings Model (Manleen Kohli).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.