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

JKS Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories-348 M-1,255 M-1,411 M-2,001 M-114 M-1,690 M-210 M-2,823 M-5,699 M-6,053 M
(Increase) Decrease in other current assets-16 M-262 M-304 M-182 M-1 M23 M49 M104 M3 M
(Increase) Decrease in other current liabilities59 M349 M1,037 M313 M-483 M1,723 M1,724 M-25 M446 M795 M
(Increase) Decrease in other working capital3,533 M3,289 M
(Increase) Decrease in payables581 M1,681 M823 M848 M486 M1,403 M2,046 M2,092 M6,122 M5,684 M
(Increase) Decrease in receivables-308 M-1,293 M-390 M-3,330 M-236 M-1,439 M-356 M-937 M-4,265 M-13,907 M
Acquisitions-89 M-129 M-75 M70 M-17 M-295 M-19 M-410 M-933 M
Amortization of intangibles8 M8 M9 M1 M-39 M24 M179 M182 M173 M175 M
AssetImpairmentCharge185 M82 M99 M565 M202 M227 M266 M399 M1,097 M2,478 M
CapitalExpenditureReported465 M495 M874 M1,983 M2,189 M2,435 M3,305 M4,070 M8,686 M12,294 M
Cash at beginning of period279 M456 M1,777 M2,393 M2,820 M2,761 M3,482 M6,274 M8,075 M9,097 M
Cash at end of period456 M1,777 M3,684 M2,501 M2,472 M2,669 M6,043 M8,681 M8,075 M11,257 M
Cash flow438 M209 M1,279 M-900 M-466 M201 M2,813 M3,014 M2,927 M-5,815 M
CashFlowFromContinuingInvestingActivities-1,286 M-4,159 M-3,315 M-6,909 M-2,434 M-3,935 M-6,025 M-4,919 M-11,309 M-12,272 M
CashFromDiscontinuedOperatingActivities-1,008 M
ChangeInAccountPayable565 M1,621 M793 M786 M626 M962 M346 M320 M5,981 M5,161 M
ChangeInIncomeTaxPayable16 M60 M30 M63 M-140 M42 M48 M-45 M141 M523 M
ChangeInPayablesAndAccruedExpense581 M1,681 M823 M848 M486 M1,403 M2,046 M2,092 M6,122 M5,684 M
ChangeInPrepaidAssets-168 M-310 M-53 M-8 M-696 M-294 M58 M-1,112 M-208 M-277 M
ChangeInTaxPayable16 M60 M30 M63 M-140 M42 M48 M-45 M141 M523 M
ChangeInWorkingCapital-200 M-1,089 M-298 M-4,359 M-1,045 M-273 M3,310 M-2,804 M33 M-10,465 M
ChangesInAccountReceivables179 M-1,628 M-64 M-2,859 M226 M-905 M168 M362 M-3,666 M-8,611 M
CommonStockDividendPaid-95 M
CommonStockPayments-29 M
Current deferred income taxes910065.0-171 M-7 M22 M-8 M
Deferred income taxes910065.0-171 M-7 M22 M-8 M
Depreciation356 M434 M622 M777 M604 M802 M815 M1,214 M1,636 M2,585 M
Depreciation unreconciled363 M442 M631 M779 M565 M826 M994 M1,396 M1,809 M2,760 M
DepreciationAndAmortization363 M442 M631 M779 M565 M826 M994 M1,396 M1,809 M2,760 M
EarningsLossesFromEquityInvestments26 M-10 M-14 M-5 M-257070.09 M-20 M-14 M
Effect of exchange rate changes-3 M32 M75 M-73 M68 M25 M-169 M-117 M228 M
FinancingCashFlow841 M5,304 M3,851 M7,455 M2,624 M3,574 M5,749 M4,481 M12,018 M20,019 M
Free cash flow162 M-291 M472 M-3,741 M-2,597 M-2,096 M-292 M-967 M431 M-17,380 M
GainLossOnInvestmentSecurities-5 M114 M
GainLossOnSaleOfPPE10 M19 M13 M34 M-80 M48 M-68 M428 M350 M249 M
IncomeTaxPaidSupplementalData2 M35 M115 M250 M189 M27 M14 M358 M157 M400 M
InterestPaidSupplementalData146 M201 M412 M671 M284 M371 M575 M670 M802 M1,073 M
Issuance of capital stock413 M770 M663 M489 M641 M
Issuance of debt-89 M2,238 M2,981 M9,172 M1,890 M2,423 M2,931 M-1,232 M6,165 M10,591 M
IssuanceOfCapitalStock413 M770 M663 M489 M641 M
IssuanceOfDebt411 M3,179 M2,981 M7,469 M2,188 M2,114 M3,251 M-1,485 M5,879 M10,374 M
Net cash from financing activities841 M5,330 M3,851 M7,455 M2,624 M3,574 M5,749 M4,481 M8,075 M20,019 M
Net cash from investing activities-1,286 M-670 M-3,315 M-6,909 M-2,434 M-3,935 M-6,025 M-4,919 M-11,309 M-12,272 M
Net cash from operating activities625 M187 M1,339 M-1,803 M-466 M201 M2,813 M3,014 M431 M-5,801 M
Net change in cash & cash equivalents177 M1,321 M1,938 M-1,108 M-348 M-92 M2,561 M2,407 M1,022 M2,174 M
Net income from continuing operations189 M726 M860 M1,992 M-150 M-513 M1,216 M429 M693 M1,244 M
NetBusinessPurchaseAndSale-89 M-129 M-75 M-37 M-1 M12 M-97 M29 M-410 M-933 M
NetCommonStockIssuance413 M770 M663 M489 M-29 M641 M
NetForeignCurrencyExchangeGainLoss38 M147 M87 M-209 M10 M330706.04 M
NetIntangiblesPurchaseAndSale-1 M-5 M-13 M29 M-2 M-14 M-8 M-15 M-32 M-42 M
NetInvestmentPropertiesPurchaseAndSale-735 M-3,551 M-2,372 M-4,934 M-301 M-1,649 M-2,824 M-966 M-2,234 M241 M
NetInvestmentPurchaseAndSale-735 M-3,551 M-2,372 M-4,934 M-301 M-1,649 M-2,824 M-966 M-2,234 M241 M
NetIssuancePaymentsOfDebt411 M3,179 M2,981 M7,469 M2,188 M2,114 M3,251 M-1,485 M5,879 M10,374 M
NetLongTermDebtIssuance500 M941 M-1,703 M298 M-310 M320 M-252 M-286 M-217 M
NetPPEPurchaseAndSale-462 M-474 M-853 M-1,966 M-2,129 M-2,283 M-3,096 M-3,966 M-8,633 M-11,537 M
NetPreferredStockIssuance1,383 M
Operating (gains) losses73 M157 M86 M24 M-81 M67 M-88 M432 M350 M234 M
Other financing charges net9 M862 M367 M752 M1,989 M5,880 M8,075 M9,735 M
Other investing changes net-725 M-2,574 M-2,291 M-2,478 M-465 M-831 M48 M-919 M208 M-65 M
Other non-cash items11 M144 M6 M642 M245 M94 M-2,620 M3,561 M42 M412 M
Payment of cash dividends95 M
PreferredStockIssuance1,383 M
ProceedsFromIssuanceOfWarrants-36 M
ProceedsFromStockOptionExercised18 M15 M8 M22 M70 M44 M38 M115 M10 M5 M
Purchase of Float term investments-1,739 M-244 M-32 M-167 M-192 M-600 M-123 M
Purchase of property plant & equipment-463 M-478 M-867 M-1,938 M-2,131 M-2,297 M-3,104 M-3,981 M-8,666 M-11,580 M
Purchase of short term investments800 M941 M298 M604 M
PurchaseOfIntangibles-1 M-5 M-13 M-7 M-11 M-14 M-8 M-15 M-32 M-42 M
PurchaseOfInvestment-1,739 M-2,398 M-2,676 M-4,791 M-5,997 M-7,257 M-10,749 M-9,553 M-13,362 M-8,339 M
PurchaseOfLongTermInvestments-1,739 M-2,154 M-2,644 M-4,624 M-5,806 M-7,257 M-10,749 M-9,553 M-13,362 M-8,215 M
PurchaseOfPPE-463 M-490 M-861 M-1,975 M-2,178 M-2,422 M-3,298 M-4,055 M-8,654 M-12,251 M
Repayment of debt-300 M-1,703 M-310 M-284 M-252 M-286 M-217 M
RepaymentOfDebt-3,853 M-4,023 M-7,221 M-16,192 M-17,274 M-12,489 M-15,230 M-25,590 M-24,567 M-27,841 M
Repurchase of capital stock-29 M
Revenue per share8 M8 M9 M1 M-39 M24 M179 M182 M173 M175 M
Sale of Float term investments1,730 M1,289 M2,480 M2,289 M5,901 M6,437 M7,877 M10,075 M10,501 M8,494 M
Sale of short term investments1,728 M133 M114 M45 M260 M3 M-570 M420 M150 M
SaleOfBusiness-107 M15 M12 M198 M48 M
SaleOfIntangibles391541.036 M9 M
SaleOfInvestment1,730 M1,421 M2,595 M2,335 M6,162 M6,439 M7,877 M9,505 M10,921 M8,644 M
SaleOfPPE2 M16 M7 M9 M49 M138 M201 M89 M20 M714 M
ShortTermDebtIssuance3,463 M6,261 M10,202 M23,661 M19,164 M14,602 M17,877 M24,105 M30,446 M38,215 M
ShortTermDebtPayments-3,553 M-4,023 M-7,221 M-14,489 M-17,274 M-12,179 M-14,946 M-25,337 M-24,280 M-27,624 M
StockBasedCompensation18 M43 M113 M203 M65 M29 M5 M922868.010 M1,001 M
UnrealizedGainLossOnInvestmentSecurities10 M16 M-10 M70 M79 M-19 M4 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