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

276.88
 
USD
  
1.30
  
(0.47%)
Optionable: Yes  Market Cap: 191,654 M  90-day average vol: 3,321,246

Previous close: 275.58  Open: 276.82  Bid: 275.9  Ask: 277.0
52 week range    
245.73   
   302.39
Peers   
WEN / 
YUM / 
SBUX / 
JACK / 
CMG / 
GTIM / 
ARCO / 
TAST / 
CBRL / 
Last updated: Wednesday 24th April 2024
62
MarketXLS Rank
80
Value
53
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 Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in payables-71 M-79 M260 M-456 M96 M147 M-181 M-77 M-515 M-170 M
(Increase) Decrease in receivables27 M-181 M-159 M-341 M-479 M27 M-7 M310 M-264 M-161 M
CapitalExpenditureReported2,754 M1,955 M1,931 M1,931 M2,843 M2,935 M1,707 M2,414 M2,706 M2,799 M
Cash at beginning of period2,799 M2,078 M7,686 M1,223 M2,464 M866 M899 M3,449 M4,709 M2,584 M
Cash at end of period2,078 M7,686 M1,223 M2,464 M866 M899 M3,449 M4,709 M2,584 M4,579 M
Cash flow6,730 M6,539 M6,060 M5,551 M6,967 M8,122 M6,265 M9,142 M7,387 M9,612 M
CashFlowFromContinuingInvestingActivities-2,305 M-1,420 M-982 M562 M-2,455 M-3,071 M-1,546 M-2,166 M-2,678 M-3,184 M
ChangeInAccountPayable-75 M-15 M90 M-60 M129 M-27 M-137 M225 M31 M50 M
ChangeInAccruedExpense-14 M383 M38 M-146 M-87 M-4 M44 M284 M129 M206 M
ChangeInIncomeTaxPayable3 M-64 M170 M-396 M-33 M173 M-44 M-302 M-547 M-220 M
ChangeInPayablesAndAccruedExpense-86 M304 M298 M-602 M9 M143 M-137 M207 M-386 M36 M
ChangeInTaxPayable3 M-64 M170 M-396 M-33 M173 M-44 M-302 M-547 M-220 M
ChangeInWorkingCapital-59 M123 M139 M-943 M-471 M170 M-143 M516 M-650 M-125 M
CommonStockDividendPaid-3,216 M-3,230 M-3,058 M-3,089 M-3,256 M-3,582 M-3,753 M-3,919 M-4,168 M-4,533 M
CommonStockPayments-3,199 M-6,099 M-11,171 M-4,686 M-5,208 M-4,976 M-908 M-845 M-3,896 M-3,054 M
Current deferred income taxes-91 M-1 M-539 M-36 M103 M150 M6 M-428 M-346 M-686 M
Deferred income taxes-91 M-1 M-539 M-36 M103 M150 M6 M-428 M-346 M-686 M
Depreciation1,645 M1,556 M1,517 M1,363 M1,482 M1,618 M1,751 M1,868 M1,871 M1,978 M
Depreciation unreconciled1,645 M1,556 M1,517 M1,363 M1,482 M1,618 M1,751 M1,868 M1,871 M1,978 M
DepreciationAndAmortization1,645 M1,556 M1,517 M1,363 M1,482 M1,618 M1,751 M1,868 M1,871 M1,978 M
Effect of exchange rate changes-528 M-247 M-104 M264 M-160 M-24 M80 M-120 M-254 M-58 M
FinancingCashFlow-4,618 M735 M-11,262 M-5,311 M-5,950 M-4,995 M-2,249 M-5,596 M-6,580 M-4,374 M
Free cash flow4,466 M5,139 M5,188 M4,762 M4,815 M5,680 M4,662 M7,030 M5,165 M7,104 M
GainLossOnSaleOfBusiness-311 M-1,156 M-309 M-128 M-28 M-98 M733 M-103 M
IncomeTaxPaidSupplementalData2,388 M1,985 M2,388 M2,786 M1,734 M1,590 M1,442 M2,404 M3,024 M2,993 M
InterestPaidSupplementalData573 M641 M874 M885 M960 M1,067 M1,136 M1,197 M1,184 M1,287 M
Issuance of debt510 M590 M-286 M-1,050 M96 M799 M-893 M15 M26 M213 M
IssuanceOfDebt1,503 M9,755 M2,670 M2,028 M2,131 M3,236 M2,238 M-1,070 M1,198 M2,993 M
Net cash from financing activities-4,618 M735 M-11,262 M-5,311 M-5,950 M-4,995 M-2,249 M-5,596 M-6,580 M-4,374 M
Net cash from investing activities-2,305 M-1,420 M-982 M562 M-2,455 M-3,071 M-1,546 M-2,166 M-2,678 M-3,184 M
Net cash from operating activities6,730 M6,539 M6,060 M5,551 M6,967 M8,122 M6,265 M9,142 M7,387 M9,612 M
Net change in cash & cash equivalents-721 M5,608 M-6,392 M1,330 M-1,598 M33 M2,551 M1,380 M-1,872 M2,053 M
Net income from continuing operations4,758 M4,529 M4,687 M5,192 M5,924 M6,025 M4,731 M7,545 M6,177 M8,469 M
NetBusinessPurchaseAndSale1,597 M
NetCommonStockIssuance-3,199 M-6,099 M-11,171 M-4,686 M-5,208 M-4,976 M-908 M-845 M-3,896 M-3,054 M
NetInvestmentPropertiesPurchaseAndSale-41 M-20 M-109 M-246 M-303 M-628 M57 M-54 M-457 M-676 M
NetInvestmentPurchaseAndSale-41 M-20 M-109 M-246 M-303 M-628 M57 M-54 M-457 M-676 M
NetIssuancePaymentsOfDebt1,503 M9,755 M2,670 M2,028 M2,131 M3,236 M2,238 M-1,070 M1,198 M2,993 M
NetLongTermDebtIssuance993 M9,166 M2,957 M3,078 M2,035 M2,437 M3,131 M-1,086 M1,172 M2,780 M
NetPPEPurchaseAndSale-2,264 M-1,400 M-872 M-789 M-2,152 M-2,443 M-1,603 M-2,112 M-2,221 M-2,508 M
Operating (gains) losses-311 M-1,156 M-309 M-128 M-28 M-98 M733 M-103 M
Other financing charges net58 M-8 M-3 M-20 M-20 M-23 M-122 M-47 M38 M-40 M
Other investing changes net-41 M-20 M-109 M-246 M-303 M-628 M57 M-54 M-457 M-676 M
Other non-cash items477 M333 M567 M1,131 M237 M288 M-51 M-262 M-398 M79 M
Payment of cash dividends3,216 M3,230 M3,058 M3,089 M3,256 M3,582 M3,753 M3,919 M4,168 M4,533 M
ProceedsFromStockOptionExercised235 M317 M299 M457 M403 M351 M296 M286 M248 M260 M
Purchase of property plant & equipment-2,264 M-1,400 M-872 M-789 M-2,152 M-2,443 M-1,603 M-2,112 M-2,221 M-2,508 M
Purchase of short term investments1,541 M10,220 M3,780 M4,728 M3,795 M4,499 M5,543 M1,154 M3,375 M5,221 M
PurchaseOfPPE-2,754 M-1,954 M-1,931 M-1,931 M-2,843 M-2,935 M-1,707 M-2,414 M-2,706 M-2,799 M
Repayment of debt-548 M-1,054 M-823 M-1,649 M-1,760 M-2,062 M-2,412 M-2,240 M-2,202 M-2,441 M
RepaymentOfDebt-38 M-465 M-1,109 M-2,700 M-1,664 M-1,263 M-3,305 M-2,240 M-2,202 M-2,441 M
Repurchase of capital stock-3,199 M-6,099 M-11,171 M-4,686 M-5,208 M-4,976 M-908 M-845 M-3,896 M-3,054 M
SaleOfBusiness1,597 M
SaleOfPPE490 M554 M1,059 M1,142 M691 M492 M104 M302 M485 M290 M
ShortTermDebtIssuance15 M26 M213 M
ShortTermDebtPayments510 M590 M-286 M-1,050 M96 M799 M-893 M
StockBasedCompensation113 M110 M131 M118 M125 M110 M92 M139 M167 M175 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