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

NCTY Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AccretionOnPreferredStock21 M80 M83 M57 M-41 M-13 M
AcquiredInProcessRnD-529 M
AcquiredInProcessRnDIncome21 M
Basic EPS from continuing operations2.42
Basic EPS total2.42-0.83-1.35
Basic weighted shares outstanding2 M2 M2 M2 M3 M6 M11 M164 M495 M720 M
Cost of sales-108 M-86 M-68 M-49 M-24 M16 M1 M814136.0-88 M142 M
Depreciation unreconciled-16 M-12 M-7 M-5 M-4 M
DepreciationAndAmortization-16 M-12 M-7 M-5 M-4 M
Diluted EPS total-227.1-46.5-165.5-283.4-8.1-41.5-17.92.42-0.83-1.35
Diluted normalized net income/share-41.5-17.92.42
Diluted weighted shares outstanding2 M6 M2 M2 M14 M6 M11 M164 M495 M720 M
Earnings from equity interest-2 M162 M-10 M-111 M-3 M6 M-2 M473 M13 M-4 M
EarningsFromEquityInterestNetOfTax-2 M162 M-10 M-111 M-3 M6 M-2 M473 M13 M-4 M
ExciseTaxes60557.01582.0
GainOnSaleOfPPE2 M200000.02 M10000.011 M
GainOnSaleOfSecurity33 M-1 M115349.014 M3 M12 M711914.0
GeneralAndAdministrativeExpense162 M111 M132 M129 M109 M90 M114 M127 M293 M376 M
Gross operating profit-3 M-22 M-21 M8 M49 M-16 M-1 M-188648.048 M-66 M
ImpairmentOfCapitalAssets-77 M-4 M-8 M11 M-1 M
Income before tax-561 M-125 M-341 M-563 M-170 M-209 M-172 M389 M-415 M-979 M
Income restructuring and M&A35 M-14 M-35 M
Income taxes-6 M59610.07 M
InsuranceAndClaims18 M
Interest income3 M775152.0161144.030525.0193928.018576.0429732.0
InterestExpenseNonOperating6 M56 M84 M99 M35 M4 M114 M23 M
InterestExpenseOperating-1 M-892159.0-260073.0-48 M
InterestIncomeOperating-526 M17 M
LossAndLossAdjustmentExpectedIncurred-1 M25 M
MinorityInterests37 M42 M49 M73 M-63 M-19 M6 M3 M6 M5 M
MiscOtherSpecialCharges9 M-963125.0-9 M51 M17 M21 M11 M95 M91 M129 M
Net income from total operations-1,581 M-87 M-305 M-594 M-175 M-227 M-166 M386 M-318 M-979 M
NetIncomeCommonStockholders-1,581 M-108 M-385 M-677 M-175 M-227 M-166 M386 M-318 M-823 M
NetIncomeContinuousOperations-1,581 M-87 M-305 M-594 M-175 M-227 M-166 M386 M-318 M-979 M
NetIncomeFromOtherGainsLosses61 M
NetNonOperatingInterestIncomeExpense3 M-6 M-56 M-12 M-99 M-34 M-4 M-114 M-23 M
NetOperatingInterestIncomeExpense8 M3 M
NonRecurringOperationExpense13 M
Operating income-495 M-326 M-330 M-217 M-126 M-133 M-126 M-163 M-351 M-556 M
Operating income before depreciation (EBITDA)-517 M-79 M-300 M-437 M-2 M-6 M-100 M349 M-275 M-940 M
OperatingExpense-527 M-139 M-304 M-307 M-163 M116 M124 M163 M-365 M896 M
Other income net41 M-194 M19 M376 M-7 M-18 M6 M-564 M-148 M217 M
Other special charges-25 M
OtherGandA162 M111 M132 M129 M109 M90 M114 M127 M293 M376 M
OtherImpairmentOfCapitalAssets48 M316 M9 M9 M43 M8 M19 M353 M
OtherOperatingExpenses-6 M-14 M10 M-4 M-349954.0-229538.0-30240.020 M51 M59 M
OtherWriteOff6 M-2 M-4 M
OtherunderPreferredStockDividend21 M80 M83 M57 M-41 M-13 M
PreferredStockDividends21 M80 M83 M57 M-41 M-13 M
PromotionAndAdvertising-53 M-22 M-3 M-2 M-900000.0-300000.0-200000.0-100000.0-10 M
RealizedCapitalGain62 M
RentAndLandingFees162 M111 M132 M129 M109 M-500000.0-1 M293 M376 M
Research & development expense213 M156 M135 M78 M45 M25 M13 M2 M2 M2 M
ResearchExpense213 M156 M135 M78 M45 M25 M13 M2 M2 M2 M
RestructringAndMnAIncome35 M-14 M-35 M
Revenue per share-3 M-50 M-77 M-98 M-33 M-3 M-121 M-23 M
SalariesAndWages-29 M-19 M-34 M-28 M-38 M-33 M-5 M13 M-150 M-202 M
Selling Gen & administrative expense279 M163 M163 M150 M118 M92 M116 M127 M298 M495 M
SellingAndMarketingExpense117 M52 M32 M21 M9 M2 M2 M646492.05 M119 M
SellingExpense117 M52 M32 M21 M9 M2 M2 M646492.05 M119 M
Special income/charges-564 M4 M8 M-11 M25 M35 M-13 M
Total Income available for interest expense (EBIT)-561 M-125 M-335 M-507 M-87 M-110 M-137 M346 M-302 M-956 M
Total common shares outstanding959464.0959464.01 M2 M3 M15 M12 M137 M852 M1,021 M
Total net income-1,581 M-87 M-305 M-594 M-175 M-227 M-166 M386 M-318 M-979 M
Total ordinary shares4 M4 M4 M4 M4 M4 M4 M4 M4 M4 M
Total revenues105 M64 M46 M56 M61 M17 M341495.0625488.0136 M119 M
TotalExpenses-635 M-225 M-371 M-355 M-187 M133 M126 M-336 M-453 M1,038 M
TotalRevenue107 M65 M47 M56 M73 M-60557.0-1582.0625488.0136 M102 M
WriteDown6 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