Walt Disney Co (NYSE:DIS) Earnings Model

Latest Update: March 7, 2016​
This model needs an update for the last release...Earnings season got away from us! We will make the updates soon. Sign-up for update alerts below.
Model Type: Tier 1​, Consensus-based model.​
Financial Statements: Income Statement, Balance Sheet, Cash Flow Statement and Segment Details.
DIS Consensus-Based Earnings Model.xlsx
File Size: 236 kb
File Type: xlsx
Download File
Revenue Modeling Approach: This model applies growth rates to each segment (Cable Networks, Broadcasting, Parks, Studio, Consumer, and Interactive) to arrive at total Revenue.

Expense Modeling Approach: We use Operating Margin and Depreciation & Amortization by segment to back into the Cost of Revenue and Operating Expense line items. We use historic averages to estimate Interest & Other Income, and apply an effective tax rate to the future projected income to forecast the Provision for Income Tax.

Share Count Forecast: To forecast the future share count we calculate the historic change in share count, after removing the impact of share repurchases. We then make estimates for future share repurchase volume and prices, and deduct the resulting share reduction in our forecast periods.

Balance Sheet & Cash Flow Modeling Approach: We use operating ratios to project the primary accounts on the Balance Sheet, and Balance Sheet changes and earnings estimates to forecast the Cash Flow Statement.

Valuation Approach: We utilize two valuation methods: A Market Multiple-based approach, and a Discounted Cash Flow (DCF) valuation. We apply a Price-Earnings Multiple to the Next Twelve Month consensus EPS estimate, on an exCash basis. Our DCF is based on a two-stage approach which discounts the company’s expected cash flows using our estimate of the Weighted Average Cost of Capital.

    Sign-Up For Disney Earnings Model Alerts

    Want to get email alerts when we update our Earnings Model? Submit your email address and we will add you to our distribution list.

    Suggest a Change to This Model

Models From Our Community 

Be the first to submit a model for Disney, and we will post it here for our community to download. Use the form to the right to submit a model today.

    Become a DIS Contributor

    There are many ways to break down a company's earnings, and an infinite number of assumptions which can go into an earnings model. Our consensus-based earnings models represent templates which our financial modeling community can use to input their own assumptions and estimates. If you disagree with any of the assumptions, we have made let us know by becoming a contributor. It's simple:
    ​Step 1) Download our model from this page.
    Step 2) Change the input assumptions in the blue cells (or change anything else you see fit).
    Step 3) Submit your model using this form with a summary of the changes you made.

    We will include your model here for our community to download. We will also setup a contributor page to showcase your modeling skills and to track your downloads.
    Max file size: 10MB
    Max file size: 20MB
Share on StockTwits