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

Author: Mansoor Tariq Khan, Published: July 28, 2020 6:27pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​For the Q2 2020 and onwards for the year 2020, I forecast Facebook’s financial performance and as a result the stock price to be slightly bullish on a YoY basis while taking a small loss in revenue on a QoQ basis. The forecasted revenue for Q2 is $17.5B with a Diluted EPS of $1.43. My estimates are based on the following factors that I see affecting Facebook’s performance positively or negatively. Firstly, Monthly Active Users (MAU’s) across all regions except Asia-Pacific would see a lower positive growth in Q2 as compared to the spike seen in growth during Q1. Due to Facebook’s partnership with Jio in India to facilitate e-commerce activities for SMB’s and China’s increased activity in both the e-commerce and gaming sector, I forecast the MAU’s to grow by 13% as compared to the 11% growth in the first quarter in the Asia-Pacific region. The general positive growth in MAU’s for all the regions can also be attributed to the shelter-in restrictions placed due to COVID-19, allowing more people to use Facebook and its other social media platforms, WhatsApp and Instagram. As the social distancing SOP’s get relaxed, we see the MAU’s growth returning to their average rates seen in 2019.
​
Facebook’s major source of revenue, advertising, has been largely hit with the demand for advertisement diminishing. We have already seen the growth rate in Average Revenue per User (ARPU) halving in Q1 2020 on a QoQ basis. I see this trend continuing and the growth rate actually shrinking and going into negative for the second quarter with a total ARPU of $6.69. Only Asia-Pacific region would see a flat 0% rate for ARPU because the increase in ad impressions in India and China would offset the decrease in prices. Even though we see the covid situation improving, the after effects of the virus would still be felt in the Q3 hence the single digit positive growth in ARPU across all regions for 2020. The marketing expense would also reduce as a result of low business and achieving efficiency. Facebook also accrued legal costs, which would reflect by the increase in the G&A expense as a percentage of revenue. The loss in share prices would also allow Facebook to repurchase 6.8m shares, up from 6.3m in Q1 2020. It would allow Facebook to end 2020 with a total operating expense of $53.5B.

FB Earnings Model (Mansoor Tariq Khan).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.