Trending Earnings Models

Facebook Inc (NASDAQ:FB)
​This model uses Monthly Active User growth rates and Average Revenue Per User to project future Revenue. Our Facebook model includes two valuations methods: Discounted Cash Flow and Market-Multiple. 
Starbucks (NASDAQ:SBUX)
This model uses estimates of new stores, revenue per store, and operating margin by geographic region, to project future revenue, and completes the financial statements using ratio analysis.
Netflix Inc (NASDAQ:NFLX)
This model predicts future earnings based on subscriber growth and revenue per subscriber, for domestic and international users, and applies a basic growth rate to the DVD segment.
Apple Inc (NASDAQ:AAPL)
This model uses iPhone, iPad, Mac, and iWatch unit sales growth rates and average selling price to project future revenue. We use ratio analysis to project operating expenses and provisions for income tax.
Amazon Inc (NASDAQ:AMZN)
This model disaggregates Amazon’s results by the company’s primary segments: North America, International & Amazon Web Services (AWS), and applies growth rates for projections.
​Alphabet Inc (NASDAQ:GOOGL)
This model breaks down Alphabet’s results by segment: Google and Other Bets, and disaggregates the Google Segment by Google Websites and Google Network Member Websites.

Contributors

Contributor models appear at the top of each company's model page on the day they are published, with one up-vote and one down-vote (50% up-vote to total votes). After that, models appear in order of up-vote percentage. You can vote a contributor model up or down (one vote per IP address per day). Follow your favorite contributor for new model alerts.

Become a Contributor

Step 1) Download an earnings model.
​Step 2) Change the blue input cells.
Step 3) Submit your model for review.

Our Approach

We model earnings based on consensus estimates, not our own opinion of the earning capacity of any of the companies we cover. This serves two purposes: 1) It gives our model users a base-line starting point from which they can make adjustments using their own expectations for the company, and 2) It allows our users to isolate the impact of new earnings results each quarter to determine if the price movement after each release is logical.

We have two categories of models: Tier 1 and Tier 2. Each of our Tier 1 Excel-based models include the Income Statement, Segment details, Balance Sheet, Cash Flow Statement, Market Multiple share valuation, and Discounted Cash Flow Valuation. Each Tier 2 model includes the Income Statement, Segment details, and a Market Multiple share price target.  The financial statements and price target sections for both tiers are linked through equations, which allow our users to seamlessly change assumptions and instantly see an estimate of the impact on earnings and the price target.