Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

MCD Stock Forecast, Price Targets, Chart, Dividends & Analysis

McDonald's Corporation logo

McDonald's Corporation

Sector: Consumer Cyclical   

Industry: Restaurants

290.91
 
USD
  
0.18
  
(0.06%)
Previous close: 290.73  Open: 290.62  Bid: 290.0  Ask: 290.91
52 week range    
243.53   
   317.90
Mkt Cap: 208,343 M  Avg Vol (90 Days): 3,322,570
Peers   
WEN / 
YUM / 
SBUX / 
JACK / 
CMG / 
GTIM / 
ARCO / 
TAST / 
CBRL / 
Last updated: Thursday 21st November 2024

Stock Rankings

53
MarketXLS Rank
80
Value
23
Technical
57
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ARCO

0.02732 B108.52

CBRL

0.02051 B26.6746.37

CMG

80 B54.4958.88

EAT

5 B28.79124.74

GTIM

0 B24.732.6284

JACK

0.03931 B45.6

SBUX

0.0248111 B27.5898.26

TAST

189.54

WEN

0.05544 B19.0717.92

YUM

0.020137 B24.97132.88
Financials

MCD Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles2,677 M2,773 M2,783 M2,900 M3,040 M
Basic EPS from continuing operations7.956.3510.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 M-9,961 M-9,189 M-10,382 M9,975 M10,931 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/share7.886.3110.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
GeneralAndAdministrativeExpense2,229 M
Gross operating profit10,456 M9,789 M10,205 M10,621 M10,786 M31,326 M28,397 M33,605 M13,207 M14,563 M
ImpairmentOfCapitalAssets-80 M-40 M1 M-99 M72 M
Income before tax7,372 M6,556 M6,866 M8,574 M7,816 M27,941 M24,518 M29,893 M7,825 M10,522 M
Income restructuring and M&A-39 M-235 M-342 M703 M-232 M74 M-267 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 M186 M
InterestExpenseNonOperating576 M638 M885 M921 M981 M1,122 M1,218 M1,186 M1,207 M1,361 M
MiscOtherSpecialCharges-37 M70 M35 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 M25,948 M23,108 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,122 M-1,218 M-1,186 M1,163 M1,175 M
Normalized income22,147 M19,102 M25,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 M30,680 M27,488 M32,946 M10,903 M13,861 M
OperatingExpense2,507 M2,644 M2,460 M1,068 M1,963 M2,333 M2,695 M2,485 M2,863 M2,817 M
Other income net9 M147 M-55 M-184 M-151 M-70 M-35 M42 M-1,357 M-49 M
OtherGandA2,229 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 M74 M-267 M-285 M1,010 M362 M
Revenue per share2,677 M2,773 M2,783 M2,900 M3,040 M
SalariesAndWages-113 M-110 M-131 M-117 M-125 M110 M92 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 M1,967 M2,245 M2,378 M2,492 M2,435 M
SellingExpense2,488 M2,434 M2,385 M2,231 M2,200 M
Special income/charges39 M235 M342 M-703 M232 M-74 M268 M285 M-1,010 M-434 M
Total Income available for interest expense (EBIT)7,948 M7,194 M7,751 M9,495 M8,797 M29,062 M25,736 M31,078 M9,032 M11,883 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 shares717 M717 M717 M717 M717 M717 M717 M717 M717 M717 M
Total revenues27,441 M25,413 M24,622 M22,820 M21,025 M21,364 M19,208 M23,223 M23,183 M25,178 M
TotalExpenses19,492 M18,268 M16,877 M13,268 M12,203 M-7,628 M-6,494 M-7,898 M12,838 M13,748 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