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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

STM Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-39 M63 M-94 M-254 M-142 M-84 M-188 M-125 M-72 M
(Increase) Decrease in other working capital-125 M124 M199 M324 M120 M160 M16 M255 M511 M
(Increase) Decrease in payables-70 M-46 M68 M141 M4 M-14 M161 M95 M240 M-238 M
(Increase) Decrease in receivables119 M81 M-121 M-206 M-155 M-103 M-72 M-307 M-231 M229 M
Acquisitions-14 M-78 M-127 M-113 M
Amortization of intangibles103 M
AssetImpairmentCharge4 M20 M34 M-6 M-12 M-16 M-3 M2 M
CapitalExpenditureReported58 M36 M42 M71 M50 M69 M75 M97 M87 M4,536 M
Cash at beginning of period1,836 M2,017 M1,771 M1,629 M1,759 M2,266 M2,607 M3,006 M3,225 M3,258 M
Cash at end of period2,017 M1,771 M1,629 M1,759 M2,267 M2,607 M3,006 M3,225 M3,258 M3,222 M
Cash flow715 M842 M1,043 M1,677 M1,846 M1,869 M2,093 M3,060 M5,202 M5,992 M
CashFlowFromContinuingInvestingActivities-784 M-516 M-727 M-1,468 M-1,212 M-1,172 M-2,043 M-1,518 M-4,591 M-5,766 M
ChangeInAccountPayable-70 M-46 M68 M141 M4 M-14 M161 M95 M240 M-238 M
ChangeInPayablesAndAccruedExpense-70 M-46 M68 M141 M4 M-14 M161 M95 M240 M-238 M
ChangeInWorkingCapital-76 M120 M209 M165 M-285 M-99 M21 M-145 M-130 M-81 M
ChangesInAccountReceivables119 M81 M-121 M-206 M-155 M-103 M-72 M-307 M229 M
CommonStockDividendPaid-354 M-350 M-251 M-214 M-216 M-214 M-168 M-211 M-218 M-6 M
CommonStockPayments-156 M-297 M-62 M-250 M-125 M-485 M-346 M-223 M
Current deferred income taxes-143 M-93 M-34 M60 M20 M25 M-8 M45 M3 M19 M
Deferred income taxes-143 M-93 M-34 M60 M20 M25 M-8 M45 M3 M19 M
Depreciation811 M736 M696 M650 M791 M854 M923 M1,045 M1,113 M1,561 M
Depreciation unreconciled821 M757 M718 M684 M828 M892 M967 M1,081 M1,217 M1,562 M
DepreciationAndAmortization821 M757 M718 M684 M828 M892 M967 M1,081 M1,113 M1,562 M
EarningsLossesFromEquityInvestments43 M-2 M27 M-4 M-8 M-1000000.0-2 M
Effect of exchange rate changes-12 M-16 M-19 M27 M-4 M-13 M1000000.0-9 M-11 M5 M
FinancingCashFlow262 M-556 M-439 M-106 M-122 M-343 M348 M-1,314 M-185 M-267 M
Free cash flow666 M868 M1,005 M1,609 M1,796 M1,807 M2,022 M2,965 M5,119 M1,464 M
GainLossOnInvestmentSecurities1000000.0-40 M105 M16 M-405 M26 M43 M
GainLossOnSaleOfBusiness-22 M
IncomeTaxPaidSupplementalData30 M41 M42 M52 M60 M130 M138 M279 M416 M489 M
InterestPaidSupplementalData11 M15 M13 M12 M12 M13 M7 M2 M2 M31 M
Issuance of capital stock1000000.0-346 M
IssuanceOfCapitalStock1000000.0-346 M
IssuanceOfDebt774 M-200 M-178 M1,390 M-103 M-144 M1,383 M-134 M-134 M160 M
Net cash from financing activities262 M-556 M-439 M-106 M-122 M-343 M348 M-1,314 M-567 M-267 M
Net cash from investing activities-784 M-516 M-727 M-1,468 M-1,212 M-1,172 M-2,043 M-1,518 M-924 M-5,766 M
Net cash from operating activities715 M842 M1,043 M1,677 M1,845 M1,869 M2,093 M3,060 M1,550 M5,992 M
Net change in cash & cash equivalents193 M-230 M-142 M130 M511 M354 M399 M228 M22 M-41 M
Net income from continuing operations129 M110 M170 M810 M1,293 M1,033 M1,108 M2,006 M3,966 M4,222 M
NetBusinessPurchaseAndSale53 M-14 M-78 M-126 M-113 M
NetCapitalExpenditureDisposals-4,528 M
NetCommonStockIssuance-156 M-297 M-62 M-250 M-125 M-485 M-346 M-569 M
NetIntangiblesPurchaseAndSale-554 M-503 M-42 M-71 M-50 M-69 M-75 M-97 M-87 M-97 M
NetInvestmentPropertiesPurchaseAndSale-283 M1000000.0-611 M-99 M100 M197 M-576 M407 M-4,508 M-655 M
NetInvestmentPurchaseAndSale-283 M1000000.0-611 M-99 M100 M197 M-576 M407 M-4,508 M-655 M
NetIssuancePaymentsOfDebt774 M-200 M-178 M1,390 M-103 M-144 M1,383 M-134 M-134 M160 M
NetLongTermDebtIssuance774 M-200 M-178 M420 M178 M137 M678 M-569 M-134 M160 M
NetPPEPurchaseAndSale9 M62 M-607 M-1,298 M-1,262 M-1,174 M-1,279 M-1,828 M4 M-4,431 M
Operating (gains) losses22 M-2 M27 M12 M-8 M-1000000.024 M43 M
Other financing charges net-4 M-979 M263 M267 M-736 M-484 M131 M150 M
Other investing changes net-496 M-543 M-611 M-1,301 M-5 M-78 M69 M40 M-4 M-583 M
Other non-cash items-68 M-87 M-63 M-51 M-79 M-72 M-86 M-117 M146 M270 M
Payment of cash dividends354 M350 M251 M214 M216 M214 M168 M205 M218 M6 M
Purchase of Float term investments-9 M-26 M-3 M-577 M273 M-293 M-645 M
Purchase of property plant & equipment-563 M-565 M-653 M-1,372 M-1,313 M-1,250 M-1,358 M-1,906 M-920 M
Purchase of short term investments997 M13 M1,509 M281 M281 M1,567 M788 M329 M
PurchaseOfIntangibles-563 M-565 M-42 M-71 M-50 M-69 M-75 M-97 M-87 M-97 M
PurchaseOfInvestment-342 M-99 M-26 M-3 M-577 M-17 M-980 M-655 M
PurchaseOfLongTermInvestments-333 M-99 M-687 M-10 M
PurchaseOfPPE-611 M-1,301 M-1,263 M-1,181 M-1,283 M-1,830 M-4,439 M
Repayment of debt-223 M-200 M-191 M-1,089 M-103 M-144 M-893 M-1,357 M-134 M-169 M
RepaymentOfDebt-223 M-200 M-191 M-119 M-103 M-144 M-184 M-134 M-134 M-169 M
Repurchase of capital stock-156 M-297 M-62 M-250 M-125 M-485 M-346 M-223 M
Revenue per share10 M21 M22 M34 M37 M38 M44 M36 M111 M1000000.0
Sale of short term investments59 M1000000.0126 M200 M132 M
SaleOfBusiness53 M1000000.01000000.0
SaleOfIntangibles9 M62 M
SaleOfInvestment59 M1000000.0100 M200 M1000000.0424 M
SaleOfPPE9 M62 M4 M3 M1000000.07 M4 M2 M4 M8 M
StockBasedCompensation36 M38 M38 M61 M125 M145 M155 M221 M215 M236 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