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)
        • Other Program Links >
          • About the Exam
          • Co-op Program Exam
          • Model Submission (Winter'22-'23)
          • Co-op Bio Form
          • Co-op Q&A (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 (425)​

Author: Gutenberg Contributor  425​, Published: July 28, 2020 9:09pm, Category: Earnings Preview (Prior to the 2Q2019 earnings release)

Summary of Model: ​My model presents a slightly bullish view on Facebook. Due to the pandemic, I reasoned that more people would be using the company's products, increasing user growth rates.

I first increased interest and other income because it probably will be similar to the average from the past few quarters, and the second quarter of 2019 was 206, so I shifted the projections up a little bit. I increased the YOY growth rates in each region for the second quarter and then decreased them going forward because due to the pandemic, Facebook has most likely increased its monthly active users. I did the same thing for ARPU. Due to a growth in the number of monthly users, costs will increase which will, as a result, decrease the gross profit. Therefore, I decreased the gross margin. Due to COVID, R&D, marketing, and G&A expenses will more than likely decrease for this quarter and the next, which will also help balance out the total operating expenses to meet management's guidance.

I increased the effective tax rate because in Q1, management's guidance estimated that the rate would be in the high teens but it ended up being 30.2%. Thus, I stuck to management's guidance but increased the projected rate to 19.8%. Since the strength of the USD likely resulted in a slight headwind in European Average Revenue Per User, I used prior-year values to estimate the FX effect on revenue, slightly increasing the values. FB announced an increase of $10B in stock repurchase authorization in Q1, so I slightly increased the share repurchase amounts. I kept the share-based compensation relatively the same because over the years, these costs have remained relatively similar across quarters, and the pandemic would not have too much of an effect on these.

Thus, overall, I have a bullish outlook on this company, with an increase in revenue to $18.2 billion along with an EPS estimation of 1.56, slightly above analysts' predictions of 1.37. Moreover, I predict that over the next year, the share price of the company will relatively increase due to increased usage of social media and inventions of new platforms such as Instagram Reels. In this way, Facebook is a great company to invest in and a definite buy.
FB Earnings Model (Gutenberg User 425).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.