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

Author: Ameel Jani, Published: July 28, 2020 8:30pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​I have completed/helped modify an earnings model for Facebook from the 2nd Quarter of 2020 through the 4th Quarter of 2021 through the Gutenberg Research Intern Program. I believe that COVID-19 will continue to be a major problem/have a major impact in terms of lockdowns and infections in the US and Canada region through the end of 2020 and into the first quarter of 2021. I also believe that the pandemic will continue to have a major impact in Europe through Q3 of 2020. Looking at current trends, I also believe that the virus has been largely contained in the Asia/Pacific Region (major countries there such as Japan, China, South Korea, and New Zealand have already mostly reopened) and will have little impact beyond Q2 of 2020. Finally, in terms of the virus and looking at timetables for a potential vaccine, I believe that the coronavirus pandemic will have mostly subsided in all regions by Q2 of 2021.

Based on information presented in the Facebook earnings calls and presentations, I think that the virus will have the effect of increasing MAU's as more people are encouraged to stay at home but reducing ARPU's as overall economic activity reduces there in the regions which it is epidemic in. In terms of non-coronavirus related news, I believe that the recent ad boycotts against Facebook will contribute to reducing APRU's in the US/Canada and Europe regions through the rest of 2020 and that Facebook's new partnership with Jio Platforms as well as its increased investment into secondary apps such as Instagram and Whatsapp will contribute to increasing its ARPU and MAU in the Asia-Pacific and "Rest of the World" regions into 2021.

Based on the earnings conference calls, I also included the assumptions that its cost of goods sold will be slightly lower than past quarters and that its operating costs (especially its G&A as a percentage of revenue) will be higher than normal due to payouts from the FTIC settlement in 2020 and focus on VR/Oculus development in 2020 as well as 2021.

When including all of these assumptions into the model, the profit came out to be slightly larger than the consensus estimates through 2020 and 2021, largely due to increases in revenue related to increases in MAU's and substantial increases in both MAU's and APRU's in the Asia-Pacific region overwhelming costs within management's guidance for 2020.

FB Earnings Model (Ameel Jani).xlsx
File Size: 155 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.