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

BEST Cash Flow

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories-21 M10 M12 M-5 M415000.01 M
(Increase) Decrease in other current assets-27 M-9 M-70 M17 M2 M-7 M
(Increase) Decrease in other current liabilities14 M11 M-493000.0-3 M
(Increase) Decrease in payables162000.05 M992000.07 M-2 M142000.0
(Increase) Decrease in receivables-350 M-448 M-389 M3,052 M-432 M22 M
Acquisitions-314 M-45 M-30 M-13 M-274000.0
AssetImpairmentCharge2 M
CapitalExpenditureReported1,499 M2,635 M1,502 M347 M28 M25 M
Cash at beginning of period3,381 M2,983 M2,999 M3,957 M4,209 M5,316 M
Cash at end of period2,941 M2,999 M568 M645 M834 M359 M
Cash flow26 M-591 M-527 M-952 M91 M-1,443 M
Cash from disc. financing activities-365 M-11 M-53 M
Cash from disc. investing activities6 M-1,141 M-70 M
CashFlowFromContinuingInvestingActivities-4,106 M-1,231 M-1,068 M268 M783 M22 M
CashFlowFromDiscontinuedOperation1,229 M237 M-2,476 M-192 M-15 M
CashFromDiscontinuedOperatingActivities1,229 M596 M-1,325 M-69 M-15 M
ChangeInIncomeTaxPayable162000.05 M992000.07 M-2 M142000.0
ChangeInPayablesAndAccruedExpense162000.05 M992000.07 M-2 M142000.0
ChangeInPrepaidAssets-466 M-231 M-410 M394 M-218 M3 M
ChangeInTaxPayable162000.05 M992000.07 M-2 M142000.0
ChangeInWorkingCapital-850 M-662 M-856 M3,462 M-650 M19 M
ChangesInAccountReceivables-268 M-415 M-275 M3,107 M-439 M14 M
CommonStockPayments-10 M-211 M
Current deferred income taxes-2 M-6 M2 M-828000.0
Deferred income taxes-2 M-6 M2 M-828000.0
Depreciation364 M462 M476 M157 M30 M27 M
Depreciation unreconciled364 M462 M476 M758 M151 M131 M
DepreciationAndAmortization364 M462 M476 M758 M151 M131 M
EarningsLossesFromEquityInvestments816000.0456000.0-4 M-5 M-39 M-3 M
Effect of exchange rate changes-48 M53 M6 M-192 M-9 M11 M
FinancingCashFlow3,689 M557 M2,235 M1,559 M-37 M-282 M
Free cash flow26 M637 M21 M71 M-140 M-152 M
GainLossOnSaleOfPPE-3 M12 M8 M22 M2 M-1 M
IncomeTaxPaidSupplementalData368000.05 M16 M16 M3 M-216000.0
InterestPaidSupplementalData47 M75 M69 M47 M24 M13 M
Issuance of capital stock3,130 M
Issuance of debt712 M567 M1,043 M643 M-210 M-61 M
IssuanceOfCapitalStock3,130 M
IssuanceOfDebt699 M561 M1,834 M642 M-211 M-61 M
Net cash from financing activities3,689 M557 M1,690 M1,559 M-37 M-282 M
Net cash from investing activities-4,106 M-1,231 M-606 M268 M783 M22 M
Net cash from operating activities26 M637 M21 M71 M-140 M-152 M
Net change in cash & cash equivalents-439 M17 M963 M60 M165 M-400 M
Net income from continuing operations199 M-448 M-233 M-2,051 M33 M-1,503 M
NetBusinessPurchaseAndSale-314 M-45 M-29 M14 M612 M
NetCommonStockIssuance3,130 M-10 M-211 M
NetForeignCurrencyExchangeGainLoss6 M7 M4 M8 M-7 M19 M
NetIntangiblesPurchaseAndSale-27 M-1 M-5 M-36 M-3 M-5 M
NetInvestmentPropertiesPurchaseAndSale-2,338 M1,405 M444 M597 M196 M44 M
NetInvestmentPurchaseAndSale-2,338 M1,405 M444 M597 M196 M44 M
NetIssuancePaymentsOfDebt699 M561 M1,834 M642 M-211 M-61 M
NetLongTermDebtIssuance-14 M-5 M791 M-1 M-671000.0-392000.0
NetPreferredStockIssuance-140 M30 M
Operating (gains) losses4 M19 M9 M24 M-44 M16 M
Other financing charges net2 M-150 M1,126 M143 M-221 M
Other investing changes net55 M120 M492 M-74 M192 M106 M
Other non-cash items311 M44 M76 M-3,145 M602 M-106 M
PreferredStockIssuance30 M
PreferredStockPayments-140 M
ProceedsFromStockOptionExercised48000.03 M5 M2 M408000.01000.0
Purchase of Float term investments-2,380 M1,399 M-45 M671 M12 M-62 M
Purchase of short term investments950 M193 M
PurchaseOfIntangibles-27 M-1 M-5 M-36 M-3 M-5 M
PurchaseOfInvestment-2,394 M1,286 M-48 M671 M4 M-62 M
PurchaseOfLongTermInvestments-14 M-113 M-3 M-8 M
PurchaseOfPPE-1,472 M-2,634 M-1,498 M-311 M-25 M-21 M
Repayment of debt-14 M-5 M-159 M-1 M-671000.0-392000.0
RepaymentOfDebt-1,203 M-2,857 M-2,208 M-1,403 M-353 M-77 M
Repurchase of capital stock-10 M-211 M
Revenue per share601 M121 M103 M
SaleOfBusiness550000.027 M613 M
SaleOfPPE45 M44 M19 M4 M3 M4 M
ShortTermDebtIssuance1,902 M3,418 M3,092 M2,044 M142 M16 M
ShortTermDebtPayments-1,189 M-2,851 M-2,049 M-1,401 M-352 M-77 M
StockBasedCompensation299 M109 M92 M115 M17 M10 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