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 Balance Sheet

Annual
Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""48 M35 M332 M125 M
Accounts payable341 M373 M146 M433 M211 M288 M176 M226 M257 M400 M
Accounts receivable884 M895 M383 M369 M348 M527 M465 M464 M475 M
Accrued expenses341 M373 M146 M433 M211 M288 M176 M226 M257 M400 M
Accumulated depreciation & depletion-3,187 M-2,441 M-2,073 M-2,458 M-2,901 M-3,297 M-2,249 M-66 M-157 M-255 M
Additional paid in capital5,467 M5,518 M6,402 M7,195 M7,225 M8,628 M8,640 M1,083 M1,098 M1,120 M
Cash and equivalents166 M665 M1,160 M445 M275 M97 M326 M609 M724 M621 M
CashCashEquivalentsAndShortTermInvestments216 M1,422 M2,602 M885 M604 M97 M326 M609 M724 M621 M
Common par24 M24 M31 M45 M46 M82 M83 M17 M17 M17 M
Common stock equity12,792 M8,215 M8,251 M8,732 M8,091 M9,311 M4,375 M1,075 M1,290 M1,988 M
CommonStock24 M24 M31 M45 M46 M82 M83 M800000.0800000.0800000.0
Cost in excess3,274 M276 M
CurrentCapitalLeaseObligation37 M77 M33 M23 M32 M21 M16 M10 M9 M27 M
CurrentDeferredRevenue170 M241 M117 M72 M57 M30 M58 M46 M78 M116 M
CurrentDeferredTaxesAssets223 M290 M227 M136 M60 M226 M81 M83 M89 M
CurrentDeferredTaxesLiabilities518 M372 M157 M28 M35 M50 M29 M68 M69 M855 M
DefinedPensionBenefit849 M903 M844 M623 M618 M
Float term debt4,719 M5,886 M4,943 M4,751 M5,010 M5,924 M220 M545 M542 M1,079 M
GoodwillAndOtherIntangibleAssets3,274 M276 M
Gross fixed assets (Plant Property & Equipment)17,499 M14,976 M12,993 M15,332 M15,517 M18,394 M13,209 M957 M1,135 M1,889 M
IncomeTaxPayable84 M95 M41 M46 M37 M61 M51 M46 M41 M53 M
Intangibles209 M209 M300000.016 M3 M12 M2 M
InterestPayable159 M161 M229 M224 M283 M428 M291 M31 M8 M15 M
Inventories256 M240 M225 M279 M268 M340 M279 M
Invested capital17,558 M14,161 M14,057 M14,020 M13,873 M16,163 M4,595 M1,603 M2,375 M4,146 M
LineOfCredit232 M264 M56 M76 M126 M100 M115 M37 M141 M129 M
LongTermCapitalLeaseObligation4,766 M5,920 M73 M37 M27 M23 M88 M
LongTermDebtAndCapitalLeaseObligation4,719 M5,886 M4,943 M4,751 M5,010 M5,924 M545 M542 M1,079 M
LongTermProvisions-5 M-6 M
Minority interest7 M8 M4 M-2 M-3 M-1 M-4 M3 M8 M9 M
Net fixed assets (net PP&E)14,311 M12,535 M10,919 M12,874 M12,616 M15,097 M10,961 M891 M977 M1,634 M
Non-current deferred income taxes362 M163 M103 M52 M71 M156 M41 M15 M16 M30 M
NonCurrentAccountsReceivable52 M19 M
NonCurrentAccruedExpenses10 M20 M
NonCurrentDeferredAssets55 M855 M
NonCurrentDeferredLiabilities362 M163 M16 M30 M
NonCurrentDeferredRevenue218 M373 M121 M51 M21 M34 M45 M41 M38 M
NonCurrentDeferredTaxesAssets456 M562 M466 M415 M376 M2,815 M2,869 M3,912 M55 M855 M
NonCurrentPensionAndOtherPostretirementBenefitPlans37 M26 M14 M18 M25 M250 M300 M209 M-165 M-146 M
NonCurrentPrepaidAssets50 M40 M33 M
NotesReceivable453 M
Number of employees3400.03400.03400.03400.03400.03400.03400.03400.03400.03400.0
Other current assets464 M586 M316 M381 M361 M447 M387 M118 M403 M460 M
Other equity adjustments18 M12 M19 M29 M18 M6 M-88 M-9 M
Other fixed assets58 M10,961 M891 M1,135 M1,889 M
Other non-current assets353 M339 M176 M140 M98 M188 M176 M170 M117 M154 M
Other non-current liabilities546 M667 M323 M387 M396 M867 M8,076 M558 M500 M472 M
Other receivable856 M883 M361 M345 M345 M521 M449 M444 M449 M459 M
OtherCapitalStock16 M16 M16 M
OtherCurrentBorrowings48 M35 M
OtherCurrentLiabilities659 M694 M377 M326 M318 M418 M250 M196 M248 M344 M
OtherDeferredCosts59 M82 M36 M37 M14 M7 M
OtherEquityAdjustments6 M
OtherEquityInterest21 M8 M14 M23 M13 M23 M98 M
OtherPayable1,764 M1,567 M523 M872 M529 M227 M94 M207 M
Payables341 M373 M146 M433 M211 M288 M176 M226 M257 M400 M
Prepaid expenses88 M91 M31 M44 M35 M36 M43 M45 M49 M
RecievablesAdjustmentsAllowances-28 M-11 M-22 M-24 M-3 M-6 M-16 M-15 M-15 M
Restricted cash11 M36 M24 M15 M
Retained earnings7,327 M2,720 M1,864 M1,533 M874 M672 M-4,184 M-16 M175 M1,051 M
Short term debt48 M35 M332 M125 M
TaxesReceivable8 M39 M191 M94 M83 M
Total assets19,473 M16,060 M14,375 M14,626 M14,024 M16,931 M12,873 M2,603 M2,860 M4,322 M
Total current assets1,535 M2,935 M3,279 M1,612 M1,310 M1,064 M1,173 M1,207 M1,346 M1,272 M
Total current liabilities1,047 M1,105 M854 M759 M529 M831 M427 M422 M504 M744 M
Total equity12,792 M8,215 M8,251 M8,732 M8,091 M9,311 M4,375 M1,075 M1,290 M1,988 M
Total liabilities6,674 M7,818 M6,120 M5,896 M5,935 M7,622 M8,503 M1,526 M1,562 M2,325 M
Total non-current assets17,938 M13,150 M11,095 M13,014 M12,714 M15,867 M11,700 M1,397 M1,260 M2,768 M
Total non-current liabilities5,627 M6,716 M5,265 M5,137 M5,406 M6,791 M8,076 M1,104 M1,058 M1,581 M
TotalEquityGrossMinority12,799 M8,223 M8,255 M8,730 M8,089 M9,310 M4,370 M1,077 M1,298 M1,997 M
TotalEquityGrossMinorityInterest12,799 M8,223 M8,255 M8,730 M8,089 M9,310 M4,370 M1,077 M1,298 M1,997 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest19,473 M16,060 M14,375 M14,626 M14,024 M16,931 M12,873 M2,603 M2,860 M4,322 M
TotalNonCurrentLiabilitiesNetMinorityInteres5,627 M6,716 M5,265 M5,137 M5,406 M6,791 M8,076 M1,104 M1,058 M1,581 M
Treasury stock-45 M-59 M-66 M-69 M-72 M-77 M-76 M-200 M
UnearnedPremiums284 M248 M-120 M132 M
Working capital488 M1,830 M2,425 M854 M781 M234 M746 M785 M842 M528 M
ltinv129 M121 M87 M111 M124 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