McDonald's Corp (NYSE:MCD) Earnings Model

    ​Latest Update: This model needs an update to include the latest results...Feel free to update the model yourself, or sign-up to get an email alert after an update has been posted.
    Model Type: Tier 1​, Consensus-based model. ​

McDonald's Modeling Approach

Revenue Modeling Approach: This model breaks-down McDonald’s results into Company Operated and Franchised Restaurants. We estimate the number of each type of restaurant and apply an estimate of Revenue per restaurant to determine future revenue.
Expense Modeling Approach: We use operating margin estimates for each restaurant type to back into the four primary operating expense line items.
We use historic averages to estimate Interest & Non-Operating 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.
StockTwits

Gutenberg Modeling Guide

New to earnings modeling?
​Our modeling guide demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street Analysts.
Paperback
eBook

Become a Contributor

Step 1) Download the model above.
Step 2) Change the blue input cells.
Step 3) Submit your model for review.
Share on StockTwits