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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

VAL Income Statement

Annual
Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends-1,403 M3,911 M-874 M304 M
Amortization of intangibles-42 M-33 M
Basic EPS from continuing operations24.4-46.8-1.14-0.372.3511.68
Basic EPS total24.32-67.52-1.14-0.372.3511.68
Basic weighted shares outstanding58 M58 M70 M83 M109 M173 M199 M75 M75 M74 M
BasicDiscontinuousOperations-0.08-20.72
CommissionExpenses1,459 M
Cost of sales2,443 M2,615 M1,746 M-1,189 M-1,319 M2,709 M1,470 M740 M1,383 M1,544 M
Depreciation-496 M-538 M-445 M445 M479 M610 M541 M66 M91 M101 M
Depreciation unreconciled445 M479 M541 M66 M91 M101 M
DepreciationAndAmortization-496 M-538 M-445 M445 M479 M610 M541 M66 M91 M101 M
Diluted EPS total24.28-67.5212.52-3.64-5.88-1.14-24.42-0.372.3311.51
Diluted normalized net income/share24.36-46.8-0.372.3311.51
Diluted weighted shares outstanding58 M58 M71 M83 M109 M173 M199 M75 M76 M75 M
DilutedDiscontinuousOperations-0.08-20.720.12-0.08
Earnings from equity interest-13 M-8 M6 M25 M13 M
EarningsFromEquityInterestNetOfTax-13 M-8 M6 M25 M13 M
Fees67 M
GainOnSaleOfBusiness300000.0
GainOnSaleOfPPE141 M29 M
GainOnSaleOfSecurity19 M
GainsLossOnDisposalOfDiscontinuedOperations-2 M-1,199 M8 M1000000.0-8 M
GeneralAndAdministrativeExpense147 M132 M101 M158 M103 M189 M215 M58 M81 M99 M
Gross operating profit1,880 M1,950 M1,030 M654 M386 M-655 M75 M95 M219 M241 M
ImpairmentOfCapitalAssets4,219 M183 M40 M104 M3,646 M35 M
Income before tax1,633 M-2,549 M998 M-196 M-539 M-64 M-5,117 M13 M225 M84 M
Income restructuring and M&A-25 M
Income taxes203 M141 M109 M109 M90 M128 M-259 M36 M43 M-783 M
Interest income-100 M-148 M68 M87 M-303 M-794 M
InterestExpenseNonOperating159 M161 M229 M224 M283 M428 M291 M31 M45 M69 M
InterestExpenseOperating-182 M-170 M-265 M-200 M-233 M-410 M-190 M-44 M-32 M
InterestIncomeOperating17 M13 M14 M26 M15 M28 M20 M29 M66 M101 M
LossAndLossAdjustmentExpectedIncurred91 M
MarketingExpense610 M
MinorityInterests-10 M-14 M-7 M500000.0-3 M-6 M2 M-4 M-5 M-1 M
MiscOtherSpecialCharges42 M500000.0283 M134 M-35 M1,004 M16 M38 M170 M-2 M
Net income from total operations1,418 M-3,903 M890 M-304 M-640 M-198 M-9,713 M-51 M177 M865 M
NetIncomeCommonStockholders2,821 M-7,813 M1,764 M-304 M-640 M-1,101 M-9,713 M-51 M177 M865 M
NetIncomeContinuousOperations1,418 M-3,903 M890 M-304 M-640 M-198 M-9,713 M-51 M177 M865 M
NetIncomeDiscontinuousOperations-2 M-1,199 M8 M1000000.0-8 M
NetIncomeExtraordinary-4,858 M-24 M182 M867 M
NetNonOperatingInterestIncomeExpense-159 M-161 M-229 M-224 M-283 M-428 M-291 M-31 M-45 M-69 M
NonRecurringOperationExpense-10 M-10 M-20 M
Normalized income-727 M
Operating income1,733 M1,818 M929 M51 M-196 M-668 M-1,208 M-29 M37 M54 M
Operating income before depreciation (EBITDA)2,574 M-2,027 M1,267 M212 M-50 M579 M-4,433 M92 M272 M194 M
OperatingExpense147 M132 M101 M603 M582 M799 M1,283 M124 M175 M200 M
Other income net-42 M-500000.0-283 M-134 M35 M-992 M-8 M-44 M-194 M-11 M
Other special charges-11 M-38 M-25 M7 M
OtherGandA147 M132 M101 M158 M103 M189 M215 M58 M81 M99 M
OtherImpairmentOfCapitalAssets-1,242 M6 M-6 M
OtherOperatingExpenses-10 M-5 M-8 M-5 M-1,319 M-18 M-23 M-195 M-13 M
OtherWriteDown-448 M
OtherunderPreferredStockDividend-1,403 M3,911 M-874 M304 M
PreferredStockDividends-1,403 M3,911 M-874 M304 M
PromotionAndAdvertising610 M
RentAndLandingFees147 M132 M101 M158 M103 M
RestructringAndMnAIncome-25 M
Revenue per share-46 M-35 M-4 M32 M-37 M-100000.0-700000.0
SalariesAndWages-37 M-45 M-40 M-28 M-31 M-2 M-18 M16 M-16 M-2 M
SecuritiesAmortization528 M
Selling Gen & administrative expense147 M132 M101 M158 M103 M799 M215 M58 M83 M99 M
SellingAndMarketingExpense610 M1,459 M2 M
Special income/charges10 M-4,219 M38 M-183 M-40 M-104 M-3,646 M-34 M
Total Income available for interest expense (EBIT)1,610 M-2,557 M962 M-172 M-489 M-45 M-5,016 M44 M226 M121 M
Total common shares outstanding58 M59 M76 M109 M109 M197 M200 M75 M75 M72 M
Total net income1,418 M-3,903 M890 M-304 M-640 M-198 M-9,713 M-51 M177 M865 M
Total ordinary shares72 M72 M72 M72 M72 M72 M72 M72 M72 M72 M
Total revenues4,323 M4,565 M2,776 M1,843 M1,705 M2,053 M1,545 M835 M1,603 M1,784 M
TotalExpenses2,590 M2,747 M1,847 M-587 M-738 M3,507 M2,753 M864 M1,558 M1,744 M
TotalRevenue4,323 M4,565 M2,776 M1,843 M1,705 M2,053 M1,545 M835 M1,603 M1,784 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