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

NCTY Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""108 M369 M488 M535 M4 M97 M67 M
Accounts payable69 M40 M41 M37 M37 M38 M38 M36 M40 M166 M
Accounts receivable19 M12 M7 M9 M3 M592897.0110437.02981.04 M151432.0
Accrued expenses71 M83 M78 M130 M132 M138 M138 M120 M183 M237 M
AccruedInterestReceivable186593.0740586.0
Accumulated depreciation & depletion-228 M-207 M-205 M-200 M-176 M-176 M-90 M-3 M-121 M-138 M
Additional paid in capital2,152 M2,076 M2,080 M2,526 M2,527 M2,496 M2,540 M2,696 M4,139 M4,371 M
Cash and equivalents158 M181 M49 M39 M143 M4 M10 M5 M428 M58 M
CashCashEquivalentsAndShortTermInvestments158 M181 M49 M39 M143 M4 M10 M5 M429 M58 M
CashEquivalents700000.05 M100000.04 M21 M80000.0350000.05 M428 M
Common par2 M2 M2 M2 M3 M7 M7 M17 M45 M57 M
Common stock equity261 M98 M-197 M-340 M-474 M-712 M-840 M-289 M776 M45 M
CommonStock2 M2 M2 M2 M3 M7 M7 M17 M45 M57 M
Cost in excess10 M10 M10 M11 M
CurrentAccruedExpenses42 M36 M93 M93 M97 M99 M84 M141 M69 M
CurrentCapitalLeaseObligation12 M6 M8 M3 M3 M4 M4 M6 M
CurrentDeferredAssets68217.09745.0
CurrentDeferredRevenue20 M20 M19 M16 M6 M159125.0200000.022099.0
CurrentDeferredTaxesAssets20 M9 M
CurrentDeferredTaxesLiabilities5 M5 M6 M
Deferred revenues20 M20 M19 M16 M6 M40 M40 M38 M19 M18 M
Float term debt32 M35 M194169.03 M
GoodwillAndOtherIntangibleAssets138 M107 M89 M
Gross fixed assets (Plant Property & Equipment)278 M243 M239 M227 M197 M193 M100 M9 M300 M150 M
Intangibles129 M98 M79 M86 M
InterestPayable412626.010 M15 M5 M937328.02 M
Invested capital261 M98 M-30 M-107 M-158 M-657 M30 M777 M49 M
LongTermCapitalLeaseObligation6 M2 M3 M7 M
LongTermDebtAndCapitalLeaseObligation167 M232 M6 M2 M3 M7 M
LongTermProvisions76246.0711908.047948.0109939.0169416.0103501.0
Minority interest-71 M98 M135 M-116 M-23 M-32 M-44 M-31 M-13 M-18 M
Net fixed assets (net PP&E)50 M36 M34 M27 M21 M17 M10 M6 M179 M12 M
NetUnrealizedGainLossInvestments711914.0
Non-current deferred income taxes5 M5 M6 M
NonCurrentAccruedExpenses21 M19 M
NonCurrentDeferredLiabilities5 M5 M6 M
NonCurrentDeferredTaxesAssets583 M562 M580 M610 M402 M342 M321 M46 M13 M
Notes payable261 M375 M414 M93 M61 M
Number of employees74.074.074.074.074.074.074.074.074.074.0
Other current assets5 M733339.064 M16 M8 M214146.011 M27725.086 M66 M
Other equity adjustments-9 M-9 M-3 M3 M-16 M-9 M-4 M-17 M-13 M-13 M
Other fixed assets17 M10 M6 M12 M
Other non-current assets16 M8 M3 M16 M92 M22 M130 M27725.09 M11 M
Other non-current liabilities1000000.056 M52 M
Other receivable5 M11 M20 M2 M6 M758761.0732705.0599574.0599574.0
OtherCapitalStock20 M16 M29 M8 M200000.012 M81 M
OtherCurrentBorrowings108 M109 M112 M118 M
OtherCurrentLiabilities239 M193 M267 M304 M306 M242 M301 M200 M246 M191 M
OtherEquityInterest28 M28 M7 M7 M7 M
Payables71 M41 M42 M37 M39 M41 M39 M37 M41 M168 M
Prepaid expenses37 M57 M9 M12 M7 M6 M9 M10 M528 M272 M
RecievablesAdjustmentsAllowances-404711.0-480926.0-1 M-1 M-1 M-234794.0
Retained earnings-1,884 M-1,971 M-2,276 M-2,870 M-2,988 M-3,233 M-3,411 M-2,992 M-3,403 M-4,378 M
Short term debt108 M369 M488 M532 M93 M61 M
TaxesReceivable2 M1 M1 M272871.0381647.0
Total assets547 M517 M538 M351 M323 M165 M181 M22 M1,310 M599 M
Total current assets218 M256 M77 M88 M183 M17 M31 M16 M1,051 M398 M
Total current liabilities330 M297 M428 M574 M819 M908 M1,013 M364 M544 M564 M
Total equity261 M98 M-197 M-340 M-474 M-712 M-840 M-289 M776 M45 M
Total liabilities357 M321 M601 M806 M819 M908 M1,064 M367 M547 M572 M
Total non-current assets328 M261 M462 M272 M161 M147 M150 M6 M263 M59 M
Total non-current liabilities26 M24 M173 M232 M2 M51 M2 M3 M59 M
TotalEquityGrossMinority190 M65 M-241 M-101 M-802 M-744 M-884 M-319 M763 M28 M
TotalEquityGrossMinorityInterest190 M65 M-241 M-101 M-802 M-744 M-884 M-319 M763 M28 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest547 M517 M538 M351 M323 M165 M181 M48 M1,310 M599 M
TotalNonCurrentLiabilitiesNetMinorityInteres26 M24 M173 M232 M2 M51 M2 M3 M59 M
TotalTaxPayable1 M932431.0551445.0283994.02 M3 M1 M1 M2 M2 M
UnearnedIncome72 M70 M68 M66 M65 M63 M
Working capital-112 M-41 M-351 M-486 M-636 M-891 M-982 M-349 M506 M-166 M
ltinv51 M39 M268 M163 M48 M45 M10 M74 M35 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