Nike Inc (NYSE:NKE) Model
Revenue Modeling Approach: This model uses growth rates for Footwear, Apparel, and Equipment for each segment to project future Revenue.
Expense Modeling Approach: We use EBIT Margin estimates for each segment to back into the operating expense line items: Demand Creation and Operating Overhead, using the prior quarter’s allocation. We use historic averages to estimate Interest and Other Expenses, 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 EBIT Margin estimates for each segment to back into the operating expense line items: Demand Creation and Operating Overhead, using the prior quarter’s allocation. We use historic averages to estimate Interest and Other Expenses, 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.