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

271.99
 
USD
  
1.01
  
(0.37%)
Optionable: Yes  Market Cap: 191,654 M  90-day average vol: 3,301,535

Previous close: 270.98  Open: 272.01  Bid: 271.61  Ask: 272.13
52 week range    
245.73   
   302.39
Peers   
WEN / 
YUM / 
SBUX / 
JACK / 
CMG / 
GTIM / 
ARCO / 
TAST / 
CBRL / 
Last updated: Monday 22nd April 2024
52
MarketXLS Rank
80
Value
23
Technical
55
Quality

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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

MCD Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles2,783 M2,900 M3,040 M
Basic EPS from continuing operations10.118.3911.63
Basic EPS total4.854.825.496.437.617.956.3510.118.3911.63
Basic weighted shares outstanding981 M939 M854 M807 M778 M758 M745 M746 M737 M727.0
Cost of sales16,986 M15,624 M14,417 M12,200 M10,239 M9,961 M9,189 M-10,382 M-9,731 M-10,699 M
Depreciation-1,539 M-1,438 M-1,391 M-1,227 M-1,303 M263 M301 M330 M370 M382 M
Depreciation unreconciled-1,644 M-1,556 M-1,516 M-1,363 M-1,482 M263 M301 M330 M370 M382 M
DepreciationAndAmortization-1,644 M-1,556 M-1,516 M-1,363 M-1,482 M263 M301 M330 M370 M382 M
Diluted EPS total4.824.85.446.377.547.886.3110.048.3311.56
Diluted normalized net income/share10.048.3311.56
Diluted weighted shares outstanding986 M945 M861 M816 M786 M765 M750 M752 M741 M732.0
Dividends paid per share3.283.443.613.834.194.735.045.255.666.23
Earnings from equity interest-9 M-147 M55 M184 M152 M154 M117 M177 M113 M537 M
EarningsFromEquityInterestNetOfTax-9 M-147 M55 M184 M152 M154 M117 M177 M113 M537 M
Fees80 M83 M89 M87 M44 M
GainOnSaleOfBusiness98 M-733 M
GainOnSaleOfSecurity97 M31 M
GeneralAndAdministrativeExpense1,967 M2,245 M
Gross operating profit10,456 M9,789 M10,205 M10,621 M10,786 M11,403 M10,019 M33,605 M32,913 M36,192 M
ImpairmentOfCapitalAssets-80 M-40 M1 M99 M-26.072 M
Income before tax7,372 M6,556 M6,866 M8,574 M7,816 M8,018 M6,141 M29,893 M27,287 M31,920 M
Income restructuring and M&A-39 M-235 M-342 M703 M-232 M-74 M268 M-285 M1,010 M362 M
Income taxes2,614 M2,026 M2,180 M3,381 M1,892 M1,993 M1,410 M1,583 M1,648 M2,053 M
Interest income-800000.049 M6 M-58 M-25 M70 M35 M
InterestExpenseNonOperating576 M638 M885 M921 M981 M1,122 M1,218 M1,186 M1,207 M1,361 M
MiscOtherSpecialCharges-37 M-42 M-339 M236 M
Net income from total operations4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M6,177 M8,469 M
NetIncomeCommonStockholders4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M6,177 M8,469 M
NetIncomeContinuousOperations4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M6,177 M8,469 M
NetNonOperatingInterestIncomeExpense-577 M-590 M-878 M-979 M-1,006 M-1,052 M-1,183 M-1,186 M-1,207 M-1,361 M
Normalized income25,651 M
Operating income7,949 M7,146 M7,745 M9,553 M8,823 M9,070 M7,324 M10,356 M9,371 M11,647 M
Operating income before depreciation (EBITDA)9,593 M8,750 M9,267 M10,858 M10,279 M10,758 M9,110 M32,946 M30,364 M35,259 M
OperatingExpense2,507 M2,644 M2,460 M1,068 M1,963 M2,333 M2,695 M2,485 M4,081 M3,148 M
Other income net9 M147 M-55 M-184 M-151 M-154 M-117 M42 M339 M-236 M
OtherGandA1,967 M2,245 M
OtherOperatingExpenses19 M209 M76 M-1,163 M-237 M104 M150 M-223 M1,218 M331 M
RestructringAndMnAIncome-39 M-235 M-342 M703 M-232 M-74 M268 M-285 M1,010 M362 M
Revenue per share2,783 M2,900 M3,040 M
SalariesAndWages-113 M-110 M-131 M-117 M-125 M-110 M-92 M139 M167 M175 M
Selling Gen & administrative expense2,488 M2,434 M2,385 M2,231 M2,200 M1,967 M2,245 M2,378 M2,492 M2,435 M
SellingAndMarketingExpense2,488 M2,434 M2,385 M2,231 M2,200 M2,229 M2,378 M2,492 M2,435 M
SellingExpense2,488 M2,434 M2,385 M2,231 M2,200 M2,229 M
Special income/charges39 M235 M342 M-703 M232 M74 M-267 M285 M-1,010 M-434 M
Total Income available for interest expense (EBIT)7,948 M7,194 M7,751 M9,495 M8,797 M9,140 M7,359 M31,078 M28,494 M33,280 M
Total common shares outstanding961 M902 M819 M794 M765 M745 M746 M744 M731 M722 M
Total net income4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M6,177 M8,469 M
Total ordinary shares722 M722 M722 M722 M722 M722 M722 M722 M722 M722 M
Total revenues27,441 M25,413 M24,622 M22,820 M21,025 M21,364 M19,208 M23,223 M23,183 M25,494 M
TotalExpenses19,492 M18,268 M16,877 M13,268 M12,203 M12,295 M11,884 M-7,898 M-5,650 M-7,550 M
TotalRevenue27,441 M25,413 M24,622 M22,820 M21,025 M21,364 M19,208 M23,223 M23,183 M25,494 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University