Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
McDonald's Corporation logo

McDonald's Corporation

Sector: 
Consumer Cyclical
   

Industry: 
Restaurants

274.72
 
USD
  
1.72
  
(0.63%)
Optionable: Yes  Market Cap: 197,432 M  90-day average vol: 2,804,401

Previous close: 273.0  Open: 273.0  Bid: 274.71  Ask: 274.71
52 week range    
217.68   
   302.00
Peers   
WEN / 
YUM / 
SBUX / 
JACK / 
CMG / 
GTIM / 
ARCO / 
TAST / 
CBRL / 
Last updated: Friday 27th January 2023
63
MarketXLS Rank marketxls
65
Value marketxls
61
Technical marketxls
63
Quality marketxls

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ARCO

1 B58.66.76

CBRL

0.0433 B24.1120.97

CMG

43 B59.61452.94

EAT

2 B11.538.95

GTIM

0 B3.34.41

JACK

0.0192 B12.392.84

SBUX

0.0206114 B27.895.19

TAST

0 B-2.72.66

WEN

0.02135 B28.122.53

YUM

0.01636 B24.1125.08
News
Financials

MCD Income Statement

Annual
Save
Dec-12Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21
Total revenues27,567 M28,106 M27,441 M25,413 M24,622 M22,820 M21,258 M21,364 M19,208 M23,223 M
Cost of sales15,262 M15,618 M15,341 M14,068 M12,901 M10,836 M7,676 M7,212 M6,254 M7,236 M
Gross operating profit10,816 M10,903 M10,456 M9,789 M10,205 M10,621 M11,867 M12,247 M10,860 M13,769 M
Selling Gen & administrative expense2,455 M2,386 M2,488 M2,434 M2,385 M2,231 M1,985 M1,967 M2,245 M2,378 M
Research & development expense0000000000
Operating income8,361 M8,517 M7,968 M7,355 M7,820 M8,390 M8,632 M8,950 M7,207 M9,873 M
floaterest income0000000000
floaterest expense0000000000
Other income net207 M200 M-40 M-170 M-74 M1,098 M160 M153 M135 M432 M
Pre-tax Income (EBT)8,079 M8,205 M7,372 M6,556 M6,866 M8,574 M7,816 M8,018 M6,141 M9,128 M
Income taxes2,614 M2,619 M2,614 M2,026 M2,180 M3,381 M1,892 M1,993 M1,410 M1,583 M
Net income from total operations5,465 M5,586 M4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M
Minority floaterest0000000000
Total net income5,465 M5,586 M4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common5,465 M5,586 M4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M
Depreciation1,489 M1,585 M1,645 M1,556 M1,517 M1,363 M1,482 M1,618 M1,751 M1,868 M
Amortization0000000000
Operating income before depreciation (EBITDA)10,084 M10,317 M9,593 M8,750 M9,267 M10,858 M10,279 M10,758 M9,110 M12,182 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total5.415.594.854.825.496.437.617.956.3510.11
Diluted EPS total5.365.554.824.85.446.377.547.886.3110.04
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today