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

VAL Cash Flow

Annual
Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in other current liabilities62 M5 M
(Increase) Decrease in other working capital-151 M93 M141 M65 M-6 M-52 M-22 M5 M-45 M96 M
(Increase) Decrease in receivables40 M
Acquisitions-872 M
Amortization of intangibles-17 M6 M-18 M-45 M-28 M
AssetImpairmentCharge4,214 M-6 M183 M40 M104 M3,646 M35 M
CapitalExpenditureReported3,527 M1,567 M322 M537 M427 M227 M94 M50 M207 M696 M
Cash at beginning of period487 M166 M121 M1,160 M445 M275 M97 M696 M645 M749 M
Cash at end of period-41 M287 M1,160 M445 M275 M275 M326 M645 M749 M636 M
Cash flow3,733 M859 M1,086 M260 M-56 M-277 M-252 M-26 M167 M268 M
Cash from disc. investing activities16 M6 M
CashFlowFromContinuingInvestingActivities-3,515 M-2,105 M-575 M-403 M-305 M1,052 M-42 M-25 M-57 M-666 M
CashFromDiscontinuedOperatingActivities409 M1,303 M300000.0-2 M3 M
ChangeInWorkingCapital-151 M93 M141 M65 M-6 M-52 M-22 M5 M57 M101 M
CommonStockDividendPaid-1,051 M-703 M-12 M-14 M-18 M-4 M
CommonStockPayments-199 M
Current deferred income taxes10 M-123 M29 M55 M57 M24 M-106 M-21 M8 M-786 M
Deferred income taxes10 M-123 M29 M55 M57 M24 M-106 M-21 M8 M-786 M
Depreciation992 M538 M445 M445 M479 M610 M541 M66 M91 M101 M
Depreciation unreconciled964 M530 M306 M383 M439 M624 M584 M48 M46 M73 M
DepreciationAndAmortization964 M530 M306 M383 M439 M624 M584 M48 M46 M73 M
EarningsLossesFromEquityInvestments13 M8 M-6 M-24 M-13 M
Effect of exchange rate changes-400000.0-1 M600000.0-600000.0-300000.0100000.0-100000.0-500000.0
FinancingCashFlow-1,154 M1,021 M529 M-570 M188 M-952 M522 M-6 M286 M
Free cash flow627 M983 M773 M-275 M-471 M-486 M-294 M-51 M70 M-398 M
GainLossOnSaleOfBusiness-140 M-2 M-637 M
GainLossOnSaleOfPPE-12 M-21 M-141 M-29 M
Issuance of capital stock586 M
Issuance of debt581 M
IssuanceOfCapitalStock586 M
IssuanceOfDebt-95 M1,186 M-14 M-537 M229 M-928 M571 M-610 M
Net cash from financing activities-1,154 M443 M529 M-570 M188 M-952 M522 M-6 M-817 M
Net cash from investing activities-3,515 M-2,107 M-575 M-403 M-305 M1,052 M-42 M-25 M-17 M-666 M
Net cash from operating activities4,142 M2,380 M1,086 M259 M-56 M-277 M-252 M-26 M127 M268 M
Net change in cash & cash equivalents-528 M241 M1,038 M-714 M-171 M-178 M229 M-51 M104 M-113 M
Net income from continuing operations2,856 M-3,888 M897 M-304 M-637 M-192 M-4,858 M-24 M182 M867 M
NetBusinessPurchaseAndSale-872 M932 M
NetCommonStockIssuance586 M-199 M
NetInvestmentPropertiesPurchaseAndSale6 M-707 M-263 M1,003 M111 M329 M
NetInvestmentPurchaseAndSale6 M-707 M-263 M1,003 M111 M329 M
NetIssuancePaymentsOfDebt-95 M1,186 M-14 M-537 M229 M-928 M571 M-610 M
NetLongTermDebtIssuance-95 M1,186 M-14 M-537 M229 M-928 M-10 M-610 M
NetPPEPurchaseAndSale-3,515 M-1,397 M-312 M-534 M-416 M-209 M-42 M-25 M-57 M-666 M
Operating (gains) losses-288 M-138 M17 M-195 M-34 M-39 M-186 M-20 M
Other financing charges net-43 M-30 M-7 M-8 M-6 M-20 M-49 M-6 M-8 M
Other investing changes net6 M
Other non-cash items54 M4,247 M1 M199 M75 M-486 M4,184 M5 M60 M34 M
Payment of cash dividends1,051 M703 M12 M14 M18 M5 M
PensionAndEmployeeBenefitExpense-13 M-27 M-11 M-20 M-8 M
ProceedsFromStockOptionExercised45 M3 M
Purchase of Float term investments-100 M-791 M-2,475 M-1,040 M-919 M-145 M-220 M
Purchase of property plant & equipment-3,515 M-1,397 M-312 M-534 M-416 M-209 M-42 M-25 M-57 M-666 M
Purchase of short term investments1,246 M850 M1,000 M
PurchaseOfInvestment-100 M-791 M-2,475 M-1,040 M-919 M-145 M-220 M
PurchaseOfPPE-3,527 M-1,567 M-322 M-537 M-427 M-227 M-94 M-50 M-207 M-696 M
Repayment of debt-95 M-60 M-864 M-537 M-771 M-928 M-10 M-610 M
RepaymentOfDebt-95 M-60 M-864 M-537 M-771 M-1,143 M-25 M-610 M
Repurchase of capital stock-199 M
Revenue per share-28 M-8 M-140 M-62 M-40 M15 M43 M-18 M-45 M-28 M
Sale of short term investments100 M83 M2,212 M2,043 M1,030 M474 M220 M
SaleOfBusiness932 M
SaleOfInvestment100 M83 M2,212 M2,043 M1,030 M474 M220 M
SaleOfPPE12 M169 M10 M3 M11 M18 M52 M25 M150 M30 M
ShortTermDebtIssuance215 M596 M
ShortTermDebtPayments-215 M-15 M
StockBasedCompensation50 M45 M40 M41 M30 M37 M21 M4 M17 M27 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