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

Netflix Inc (NASDAQ:NFLX) Model Demonstration

Return to NFLX Model Page

Overview: This page is a step-by-step guide of how to input your own assumptions into our Netflix Earnings Model. Remember none of the cells in our models are locked, so you are free to change the model however you wish, however, it is much easier to stick to the primary assumption cells shaded in blue. Be sure to download the model (click to download) and follow along.
​Remember: All of our models use the same color code. Blue cells represent our primary assumptions, purple cells indicate the value was calibrated to meet management's guidance, and orange cells represent consensus estimates. Columns with dark gray headings represent historic results, and light gray headings indicate future period estimates.
​Keep in Mind: All models change over time as new information is released. The images and values shown on this page may be out-of-date, but remember this page is designed to demonstrate the model's methodology, which in general does not change. To see our latest estimates download the model from our model page. 
​Netflix Model Basics: Our Netflix model breaks-down the company's earnings into three segments: Domestic Streaming, International Streaming, and DVD. For each segment we estimate the growth in users and revenue per user, and multiply these two metrics to arrive at total revenue. In this demonstration we will show how to change the assumptions for each segment.

Step 1 - Domestic Streaming Segment (Next Quarter): There are four metrics we use to project Domestic Streaming earnings: 1) Paid member growth Quarter-over-Quarter, 2) revenue per average paid member, 3) gross margin, and 4) marketing expense per paid member.    
Picture
Step 1a - Domestic Streaming Revenue: To project revenue for the segment we start by estimating the revenue per average member in cell Q45. We use historic trends and the result from the prior quarter to shape our forecast. In the example above we selected $29.40 which means we expect Netflix to earn $29.40 on average from each of their subscribers over the three month period ending December 31, 2016.

Next we estimate the total growth in members over the period, which we set at 0.3% Quarter-over-Quarter. We backed into this number to get to management's guidance of 47.6M subscribers. Now that we have the total average members and revenue per member, we can multiply to two metrics to get to revenue for the Domestic Streaming Segment (the calculation is in cell Q44). To incorporate your assumptions, change the estimates in rows 42 and 45.
Step 1b - Segment Margin: Next we estimate the gross margin for the segment which we base on historic results (44% in cell Q47). We also estimate the marketing expense per average paid member in cell Q49. These estimates drive the total contribution margin for the segment in cell Q50. To incorporate your assumptions, change the estimates in rows 47.

Step 2 - Domestic Streaming Segment (Next Few Years): After you understand how the estimates work for the next quarter you can easily replicate the inputs in the next few quarters or years. To decide what estimates you would like to plug in, look at the historic trends. If earnings fluctuate with the calendar quarters then introduce seasonality into the model by increasing or decreasing the growth rates and margins. If there is a new product launch approaching consider how you would expect it to impact results.  
​
The image below shows our assumptions for 2017. We kept the average revenue per member, gross margin, and marketing expense in-line with our estimates for the fourth quarter of 2017. To incorporate your assumptions, change the estimates in rows 42, 45, 47, and/or 49.
Picture

Step 3 - International Streaming Segment: We use the same methodology for the International Streaming Segment as we do for Domestic, except our estimates are a bit different. The image below shows that we have calibrated the fourth quarter to meet management's guidance. We assume the growth rate in International members, revenue per member, and gross margin will increase in 2017, and the marketing expense per member will decrease. To incorporate your assumptions, change the estimates in rows 53, 56, 58, and/or 60.
Picture

Step 4 - DVD Segment: Netflix' DVD Segment has been in decline and has not been a meaningful contributor to overall earnings. We project similar decline in our future period forecast. To incorporate your assumptions, change the estimates in rows 64, 67, 69, and/or 71.
Picture

Step 5 - Remaining Income Statement Assumptions: Our model will bring the revenue and contribution margin assumptions from the segment section up to the Income Statement automatically, but there are five more assumptions that must be made to finish the Income Statement: 1) Technology & Development expense as a percentage of revenue, 2) General & Administrative Expense as a percentage of revenue, 3) Interest Expense to average debt, 4) Other Income to revenue, and 5) Effective tax rate. You can use historic results to project the ratios in future periods. To incorporate your assumptions, change the estimates in rows 77, 78, 79, 80, and/or 81.
Picture

Step 6 - Analyze Your Results: After completing steps one through five you will have your own complete earnings model. You may also change the Balance Sheet and Cash Flow Statement assumptions, or the share valuation estimates.  If you would like to share your results with our community, submit it using the form on this page with either a summary of the changes you made or an article and we will post it on our website.

NFLX Model Demo Video

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.