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 (NASDAQ:FB) Earnings Model


Picture
Picture
Model Description: This model uses Monthly Active User (MAU) growth rates and Average Revenue Per User (ARPU) to project future revenue. Ratio analysis is used to complete the Income Statement. The model is calibrated to meet management's guidance and consensus estimates as a "base-case" scenario. You can enter your own assumptions into the blue cells to form your own earnings forecast.
Basic Version: Includes 4 quarters of Income Statement forecasts.
Premium Version: Includes ~5 years of forecasts, Income Statement, Segment details, Balance Sheet, Cash Flow, and target valuation.​​
Model Developer: John Moschella, CFA, CPA
Subscribe for FB Model Updates

Facebook Models From Our Community

Contributor: John Balafoutas​
Date of publication: July 18, 2020
View on Facebook: Bearish
2Q2020 revenue & EPS forecast: $17.3B and $1.39 per share.
12-month revenue & EPS forecast: $79.7B and $6.65 per share.
FB Earnings Model (John Balafoutas).xlsx
File Size: 145 kb
File Type: xlsx
Download File

Model Description

Contributor: Owen Carney
Date of publication: July 18, 2020
View on Facebook: Bearish
2Q2020 revenue & EPS forecast: $17.5B and $1.50 per share.
12-month revenue & EPS forecast: $75.0B and $5.91 per share.
FB Earnings Model (Owen Carney).xlsx
File Size: 146 kb
File Type: xlsx
Download File

Model Description

Contributor: Albert Chen
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $17.9B and $1.43 per share.
12-month revenue & EPS forecast: $83.1B and $7.68 per share.
FB Earnings Model (Albert Chen).xlsx
File Size: 142 kb
File Type: xlsx
Download File

Model Description

Contributor: Jane Xiong
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $18.0B and $1.45 per share.
12-month revenue & EPS forecast: $83.8B and $7.75 per share.
FB Earnings Model (Jane Xiong).xlsx
File Size: 142 kb
File Type: xlsx
Download File

Model Description

Contributor: Vedant Chintawar
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $17.5B and $1.06 per share.
12-month revenue & EPS forecast: $82.4B and $7.25 per share.
FB Earnings Model (Vedant Chintawa).xlsx
File Size: 141 kb
File Type: xlsx
Download File

Model Description

Contributor: Aryan Khonde
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $17.8B and $1.42 per share.
12-month revenue & EPS forecast: $83.8B and $7.78 per share.
FB Earnings Model (Aryan Khonde).xlsx
File Size: 142 kb
File Type: xlsx
Download File

Model Description

Contributor: Sriven Sikhinam
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $19.1B and $1.47 per share.
12-month revenue & EPS forecast: $85.2B and $7.82 per share.
FB Earnings Model (Sriven Sikhinam).xlsx
File Size: 146 kb
File Type: xlsx
Download File

Model Description

Contributor: Nilay Neelaveni
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $17.4B and $1.44 per share.
12-month revenue & EPS forecast: $81.9B and $7.60 per share.
FB Earnings Model (Nilay Neelaveni).xlsx
File Size: 152 kb
File Type: xlsx
Download File

Model Description

Contributor: Aman Bhardwaj
Date of publication: July 18, 2020
View on Facebook: Bullish
2Q2020 revenue & EPS forecast: $17.4B and $1.39 per share.
12-month revenue & EPS forecast: $77.5B and $6.78 per share.
FB Earnings Model (Aman Bhardwaj).xlsx
File Size: 143 kb
File Type: xlsx
Download File

Model Description

Facebook Model

Use our Facebook earnings model to help forecast the company's future results by changing our inputs for Monthly Active Users and Average Revenue Per User. 

About Gutenberg

​​We are an earnings modeling community, driving the evolution of equity research. Our mission is to make earnings models, available to everyone...continue reading 

Modeling Training

Our Certificate in Financial Modeling Program provides an easy to follow, step-by-step approach to financial modeling training...continue reading

New to Earnings Modeling? Try Our Training Program or Textbook

Certificate in Financial Modeling Program
In this program we build a financial model from the ground up, starting with a blank spreadsheet, and ending with a comprehensive set of interrelated financial statements and share valuation estimates. There are three primary components to the program, all designed to add various elements to your training: 1) the written curriculum, 2) demonstration videos, and 3) supporting spreadsheets.  At the completion of this training program you will receive a Certificate in Financial Modeling from The Equity Research Institute at Gutenberg Research. In order to qualify for the Certificate, you must pass our financial modeling exam which covers the topics in the program curriculum, and submit an earnings model based on the methods described in the program curriculum.
Click for Program Details

Financial Modeling for Equity Research
This book demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street equity research analysts. The accompanying spreadsheets demonstrate the key concepts and can be used as templates to create an earnings model for nearly any company. Readers without prior financial analysis experience will gain a fundamental understanding of exactly what modeling entails, and will learn how to create a basic form of an earnings model. Advanced readers will be introduced to more complex topics such as linking the financial statements, future period calibration, and incorporating macroeconomic variables into discounted valuation analysis through the equity risk premium and application of the capital asset pricing model.
Click for Paperback
Click for eBook
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.