Walt Disney Co (NYSE:DIS) Earnings Model
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.
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.