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

Author: Natasha Madhalam, Published: July 28, 2020 8:59pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​This model predicts Facebook Inc.’s (NYSE:HD) second quarter earnings for 2020 to be bullish based on current economic conditions, key metrics and analyst estimates. Facebook has been largely impacted due to the COVID-19 pandemic which was reflective of a steep decrease of its stock on the S&P 500 index. Alongside the current pandemic, the Black Lives Matter movement had instigated a controversy involving Facebook’s use of ads. Many ads were linked to exploitation for profit as a result many companies backed out of posting ads on Facebook. Although Facebook is facing financial losses related to ad revenues currently, I believe that the Average Revenue per User will steadily increase as a result of the masses staying at home and feeling apprehensive to leave during the reopening phases of COVID. Recent updates to several features including Facebook Messenger, collection lists, and game streaming is gaining popularity and attracting more users to Facebook. Facebook is also investing in acquisitions which help provide better user experiences. These features also encourage current users to engage more time on Facebook along with the quarantine restrictions due to the pandemic. An increase in the number of new users to Facebook and increase in time spent by existing users is reflected in the average revenue per user rate. Due to social distancing, curfews, health risks and less time spent outside on a general basis among the populace, I believe that people will be more likely to connect on social media outlets like Facebook. Accompanied with the latest updates to the features on Facebook, this model predicts a steady increase in average rate per user. For the average price of share repurchase assumptions I started with the price of $230 during June of 2020 and then increased to $240 during December 2020 as Facebook starts repurchasing. In terms of 2021 quarterly earnings, I felt that the share value would decrease as there would be less repurchasing once the pandemic is not as severe as it was in 2020. This assumption is based on the idea that there would be less users and time spent on Facebook once society begins to move into normalcy.
FB Earnings Model (Natasha Madhalam).xlsx
File Size: 143 kb
File Type: xlsx
Download File


​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.