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.23
 
USD
  
-0.65
  
(-0.22%)
Previous close: 290.88  Open: 290.88  Bid: 290.23  Ask: 290.99
52 week range    
243.53   
   317.90
Mkt Cap: 212,177 M  Avg Vol (90 Days): 3,397,193
Peers   
WEN / 
YUM / 
SBUX / 
JACK / 
CMG / 
GTIM / 
ARCO / 
TAST / 
CBRL / 
Last updated: Friday 20th December 2024

Stock Rankings

58
MarketXLS Rank
80
Value
38
Technical
57
Quality
How are these ranks calculated?
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ARCO

0.03032 B97.32

CBRL

0.01881 B29.5652.13

CMG

88 B60.2261.74

EAT

6 B32.44131.33

GTIM

0 B182.45

JACK

0.04071 B38.71

SBUX

0.025104 B28.1588.76

TAST

189.54

WEN

0.05923 B17.9716.57

YUM

0.019838 B25.24130.36
Financials

MCD Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles2,735 M2,516 M2,337 M2,380 M2,332 M2,677 M2,773 M2,783 M2,900 M3,040 M
Basic EPS from continuing operations4.854.825.496.437.617.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 sales-13,591 M-12,330 M-10,980 M-8,620 M-10,239 M-9,961 M-9,189 M-10,382 M9,975 M10,931 M
Depreciation1,645 M1,556 M1,517 M1,363 M1,482 M263 M301 M330 M370 M382 M
Depreciation unreconciled263 M301 M330 M370 M382 M
DepreciationAndAmortization1,645 M1,556 M1,517 M1,363 M1,482 M263 M301 M330 M370 M382 M
Diluted EPS total4.824.85.446.377.547.886.3110.048.3311.56
Diluted normalized net income/share4.824.85.446.377.547.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,488 M2,434 M2,385 M2,231 M2,200 M2,229 M
Gross operating profit41,032 M37,743 M35,602 M31,440 M31,264 M31,326 M28,397 M33,605 M13,207 M14,563 M
ImpairmentOfCapitalAssets80 M40 M-1 M-99 M72 M
Income before tax37,949 M34,510 M32,264 M29,393 M28,295 M27,941 M24,518 M29,893 M7,825 M10,522 M
Income restructuring and M&A39 M235 M342 M-703 M232 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 income186 M
InterestExpenseNonOperating576 M638 M885 M921 M981 M1,122 M1,218 M1,186 M1,207 M1,361 M
MiscOtherSpecialCharges-800000.049 M6 M-58 M-25 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
NetIncomeCommonStockholders35,334 M32,483 M30,084 M26,012 M26,403 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-576 M-638 M-885 M-921 M-981 M-1,122 M-1,218 M-1,186 M1,163 M1,175 M
Normalized income24,705 M22,666 M21,313 M18,402 M22,584 M22,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)40,170 M36,704 M34,665 M31,677 M30,758 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 net800000.0-48 M-6 M58 M25 M-70 M-35 M42 M-1,357 M-49 M
OtherGandA2,488 M2,434 M2,385 M2,231 M2,200 M2,229 M
OtherOperatingExpenses19 M209 M76 M-1,163 M-237 M104 M150 M-223 M1,218 M331 M
RestructringAndMnAIncome39 M235 M342 M-703 M232 M74 M-267 M-285 M1,010 M362 M
Revenue per share2,735 M2,516 M2,337 M2,380 M2,332 M2,677 M2,773 M2,783 M2,900 M3,040 M
SalariesAndWages113 M110 M131 M118 M125 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
SellingAndMarketingExpense1,967 M2,245 M2,378 M2,492 M2,435 M
Special income/charges-39 M-235 M-342 M703 M-232 M-74 M268 M285 M-1,010 M-434 M
Total Income available for interest expense (EBIT)38,525 M35,148 M33,148 M30,314 M29,276 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
TotalExpenses-11,084 M-9,686 M-8,520 M-7,551 M-8,276 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