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 Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in other current assets11 M8 M-2 M-4 M6220.0-18 M-6 M
(Increase) Decrease in other current liabilities875939.0-2 M940911.04 M11 M-8 M-175012.0-2 M498098.0-179018.0
(Increase) Decrease in payables6 M-15 M60 M-8 M-57 M-2 M15 M-25 M15 M7 M
(Increase) Decrease in receivables-4 M7 M4 M-1 M6 M2 M313044.03955.0-2 M511925.0
Acquisitions-35 M-3 M-2 M
Amortization of intangibles25 M31 M21 M12 M2 M2 M1 M
AssetImpairmentCharge54 M76246.0711908.0329 M9 M9 M44 M8 M3 M51 M
CapitalExpenditureReported500000.07 M3 M915731.0
Cash at beginning of period554 M157 M181 M49 M39 M143 M4 M10 M32 M428 M
Cash at end of period157 M181 M8 M6 M143 M4 M10 M24 M67 M8 M
Cash flow-358 M-269 M-176 M-177 M-87 M-101 M-54 M-106 M-108 M-23 M
CashFlowFromContinuingInvestingActivities-3 M198 M-209 M-10 M162 M-17 M61 M438 M-22 M-36 M
ChangeInAccountPayable9 M-15 M61 M-7 M-59 M-3 M15 M-25 M16 M7 M
ChangeInAccruedExpense4 M5 M6 M1 M-5 M147087.0172962.0
ChangeInInterestPayable4 M5 M6 M1 M-5 M147087.0172962.0
ChangeInPayablesAndAccruedExpense6 M-15 M60 M-4 M-52 M4 M16 M-31 M15 M7 M
ChangeInPrepaidAssets-453785.05 M
ChangeInTaxPayable-3 M-306421.0-405070.0-267451.01 M1 M-491112.089779.0-444585.020699.0
ChangeInWorkingCapital14 M3 M63 M-5 M-36 M-2 M16 M-32 M-4 M2 M
ChangesInAccountReceivables-4 M7 M4 M-1 M6 M2 M313044.03955.0-2 M511925.0
CommonStockPayments-29 M
Depreciation19 M16 M12 M7 M5 M4 M3 M400000.07 M13 M
Depreciation unreconciled44 M46 M35 M70 M84 M104 M37 M3 M26 M17 M
DepreciationAndAmortization44 M46 M35 M70 M84 M104 M37 M3 M26 M17 M
EarningsLossesFromEquityInvestments2 M-162 M10 M111 M3 M-6 M945707.02 M270714.0-103218.0
Effect of exchange rate changes2 M-4 M-6 M-9 M5 M-1 M-42 M259337.0-178862.021020.0
FinancingCashFlow-39 M100 M258 M190 M44 M-18 M41 M-319 M192 M5 M
Free cash flow-358 M-268 M-175 M-188 M-86 M-101 M-52 M-106 M-109 M-23 M
GainLossOnInvestmentSecurities-1 M-13 M-3 M
IncomeTaxPaidSupplementalData7 M
InterestPaidSupplementalData1 M892159.0260073.048 M
Issuance of capital stock47 M159 M
Issuance of debt32 M129 M24 M-18 M41 M-319 M-98412.0
IssuanceOfCapitalStock47 M159 M
IssuanceOfDebt292 M129 M24 M-18 M41 M-358 M24 M5 M
Net cash from financing activities-39 M100 M258 M190 M44 M-18 M41 M-319 M192 M5 M
Net cash from investing activities-3 M198 M-209 M-10 M162 M-17 M61 M438 M-22 M-36 M
Net cash from operating activities-358 M-269 M-176 M-181 M-87 M-101 M-54 M-106 M-108 M-22 M
Net change in cash & cash equivalents-397 M24 M-138 M-19 M108 M-138 M6 M14 M62 M-54 M
Net income from continuing operations-563 M-129 M-354 M-667 M-112 M-239 M-196 M393 M-65 M-142 M
NetBusinessPurchaseAndSale5 M189 M12 M737894.0115349.0-34 M441 M-2 M
NetCommonStockIssuance-29 M47 M159 M
NetForeignCurrencyExchangeGainLoss-2 M3 M7 M13 M-19 M20 M5 M8 M1 M913598.0
NetIntangiblesPurchaseAndSale-500000.0-7 M-3 M-915731.0
NetInvestmentPropertiesPurchaseAndSale-8 M8 M-222 M-5 M162 M-17 M92 M-3 M-19 M-35 M
NetInvestmentPurchaseAndSale-8 M8 M-222 M-5 M162 M-17 M92 M-3 M-19 M-35 M
NetIssuancePaymentsOfDebt292 M129 M24 M-18 M41 M-358 M24 M5 M
NetLongTermDebtIssuance260 M-39 M24 M5 M
NetPPEPurchaseAndSale146500.01 M340962.0292074.081848.03 M183003.02 M59043.0
Operating (gains) losses868669.0-192 M17 M125 M-16 M14 M-7 M-49 M2 M2 M
Other financing charges net-14 M99 M-13 M58 M20 M-8 M9 M
Other investing changes net-4 M7 M-212 M-2 M168 M-11 M55 M5 M-12 M-34 M
Other non-cash items147 M2 M64 M300 M-7 M22 M95 M-422 M-66 M100 M
ProceedsFromStockOptionExercised4 M1 M84059.03 M
Purchase of Float term investments-4 M-5 M-10 M-3 M-4 M-600000.0
Purchase of property plant & equipment-353500.01 M340962.0-7 M292074.081848.03 M183003.0-734036.0-856688.0
Purchase of short term investments260 M3 M25 M5 M
PurchaseOfIntangibles-500000.0-7 M-3 M-915731.0
PurchaseOfInvestment-4 M-5 M-10 M-3 M-8 M-6 M-8 M-7 M-3 M
PurchaseOfLongTermInvestments-4 M-5 M-8 M-7 M-3 M
Repayment of debt-43 M-1 M
RepaymentOfDebt-30 M44 M-70 M-29 M-10 M-361 M-1 M-456018.0
Repurchase of capital stock-29 M
Revenue per share25 M31 M24 M62 M79 M100 M35 M3 M19 M3 M
Sale of Float term investments1 M37 M2 M
Sale of short term investments877350.06 M
SaleOfBusiness5 M189 M12 M737894.0115349.0694628.0444 M-37533.0
SaleOfInvestment877350.06 M1 M37 M2 M
SaleOfPPE146500.01 M340962.0292074.081848.03 M183003.02 M59043.0
ShortTermDebtIssuance62 M85 M94 M11 M51 M357606.0
ShortTermDebtPayments-30 M44 M-70 M-29 M-10 M-319 M-456018.0
StockBasedCompensation29 M4 M34 M28 M38 M4 M22 M55 M24 M29 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