MCD.xlsx - Raw Data Used shares outstanding(from Reuters.com(mil From msn.money.com Values in Millions Total Revenue Operating Income(EBIT Provision for

MCD.xlsx - Raw Data Used shares outstanding(from...

This preview shows page 1 - 4 out of 4 pages.

Raw Data Used # shares outstanding (from Reuters.com) (mil) 5,369.40 From msn.money.com Values in Millions 2015 Total Revenue 25,413.00 Operating Income (EBIT) 7,354.90 Provision for Income Tax 2,026.40 Pre-tax Income 6,555.70 Depreciation, Amortization, and Depletion 1,555.70 Purchase/Sale of Prop, Plant, Equip: Net (PP&E: Net) 23,117.60 7,685.50 9,643.00 2,950.40 0.00 24,112.10 Ratios 2015 EBIT-to-sales ratio (EBIT/Total Revenue) 0.28941 Tax rate (Provision for income tax/Pre-tax Income) 0.30911 Capex-to-sales ratio (PP&E:Net/Total Revenue) 0.90968 Depreciation-to-sales ratio (Depreciation/Total Revenue) 0.06122 NWC-to-sales ratio ([Current Assets-Current Liabilities]/Total Revenue) 0.26335 Forecaste Sales growth rate 5.61% Values in Millions 2018 Total Revenue EBIT (Total Revenue × EBIT-to-sales) EBIT x (1-t) Depreciation (Total Revenue × Depreciation-to-sales) Capital Expenditures Net Working Capital (Total Revenue × NWC-to-sales ) Increase in Net Working Capital
Image of page 1
Image of page 2
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Winter '18
  • Generally Accepted Accounting Principles, Sale of Prop

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes