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 Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""4,224 M5,126 M6,032 M10,709 M12,426 M6,697 M7,786 M11,487 M2,152 M3,224 M
Accounts payable1,768 M3,149 M3,785 M4,290 M4,664 M5,329 M4,990 M6,902 M1,998 M2,842 M
Accounts receivable1,649 M3,118 M2,691 M4,754 M4,498 M5,436 M5,266 M4,535 M7,471 M16,675 M
Accrued expenses2,856 M4,937 M5,248 M6,136 M7,230 M8,512 M9,056 M11,451 M7,070 M12,459 M
Accumulated depreciation & depletion-1,024 M-1,354 M-1,731 M-2,029 M-2,368 M-3,087 M-3,497 M0.0-6,462 M
Additional paid in capital1,969 M2,794 M2,924 M3,145 M3,314 M4,011 M4,583 M5,251 M882 M1,437 M
Cash and equivalents472 M2,294 M2,948 M2,820 M2,761 M3,482 M6,230 M8,075 M8,923 M11,271 M
CashCashEquivalentsAndShortTermInvestments502 M2,427 M2,978 M2,892 M2,764 M3,482 M6,230 M8,645 M8,947 M11,375 M
CashEquivalents472 M2,294 M2,948 M2,820 M833 M377 M577 M593 M8,923 M1,027 M
CommercialPaper1,975 M2,607 M2,590 M5,489 M6,204 M7,103 M
Common par15574.017560.017711.017881.018604.021727.024767.026052.04157.04000.0
Common stock equity2,010 M3,507 M4,322 M6,461 M6,689 M7,840 M9,303 M9,988 M1,734 M2,369 M
CommonStock15574.017560.017711.017881.018604.021727.024767.026052.04157.04000.0
Construction in progress648 M1,246 M806 M0.01,551 M
CurrentAccruedExpenses239 M312 M454 M582 M721 M811 M879 M995 M195 M295 M
CurrentCapitalLeaseObligation8 M40 M58 M60 M538 M626 M268 M321 M257 M234 M
CurrentDeferredRevenue749 M2,395 M4,350 M376 M200 M
CurrentDeferredTaxesLiabilities84 M88 M148 M152 M506 M0.052 M
CurrentProvisions0.00.0
Deferred revenues84 M88 M148 M749 M2,395 M4,350 M376 M200 M
Deposits132 M
DerivativeProductLiabilities68 M
FinancialAssets1 M21 M
Finished goods370 M928 M2,081 M2,720 M2,170 M2,853 M3,676 M0.08,713 M
Float term debt1,162 M1,753 M1,309 M489 M380 M7,103 M9,047 M8,239 M11,990 M14,823 M
GoodwillAndOtherIntangibleAssets6 M10 M20 M20 M26 M35 M36 M36 M55 M80 M
Gross fixed assets (Plant Property & Equipment)4,211 M4,456 M5,498 M6,768 M9,048 M11,363 M15,283 M0.020,408 M6,859 M
IncomeTaxPayable16 M76 M106 M168 M28 M70 M117 M74 M34 M107 M
Intangibles6 M10 M20 M20 M26 M35 M36 M36 M55 M80 M
InterestPayable788908.03 M3 M410 M322 M429 M606 M0.0
Inventories712 M1,891 M3,203 M4,474 M4,274 M5,743 M5,819 M8,377 M13,252 M17,450 M
InventoriesAdjustmentsAllowances-164 M-76 M-99 M-439 M-314 M-220 M-136 M0.0-1,819 M
Invested capital3,204 M6,867 M6,600 M6,993 M7,492 M16,898 M20,665 M0.013,985 M17,435 M
Leases160 M825 M0.01,260 M829 M
LongTermCapitalLeaseObligation44 M0.00.0863 M590 M622 M410 M
LongTermDebtAndCapitalLeaseObligation1,194 M3,360 M2,165 M533 M380 M9,058 M12,225 M16,130 M12,873 M15,476 M
LongTermProvisions62 M0.0
Minority interest11 M1,461 M1,638 M-495889.0-10213.0614 M3,138 M3,003 M508 M1,547 M
Net fixed assets (net PP&E)3,187 M3,102 M3,766 M4,739 M6,680 M8,276 M11,786 M13,601 M20,408 M397 M
NetUnrealizedGainLossInvestments9 M20 M
Non-current deferred income taxes3 M25220.051 M70 M26 M251 M329 M183 M195 M
NonCurrentAccountsReceivable0.026 M28 M
NonCurrentAccruedExpenses159 M229 M329 M511 M578 M574 M652 M769 M135 M206 M
NonCurrentDeferredAssets102 M118 M135 M275 M338 M271 M255 M372 M704 M
NonCurrentDeferredLiabilities3 M25220.051 M70 M26 M251 M329 M183 M195 M
NonCurrentDeferredTaxesAssets242 M102 M118 M135 M275 M338 M271 M255 M372 M704 M
NonCurrentPensionAndOtherPostretirementBenefitPlans26 M
Notes payable1,412 M2,452 M1,924 M4,797 M5,672 M6,072 M7,519 M9,335 M1,894 M2,990 M
NotesReceivable298 M73 M515 M1,526 M571 M1,010 M1,548 M1,085 M1,689 M6,738 M
Number of employees31030.031030.031030.031030.031030.031030.031030.031030.031030.031030.0
Other current assets170 M373 M11,165 M661788.0397 M1,240 M1,465 M0.01,494 M1,431 M
Other equity adjustments13 M12 M13 M105 M23 M-24 M32 M
Other fixed assets8,276 M10,526 M12,772 M397 M
Other non-current assets302 M5,051 M640 M1,647 M1,879 M3,604 M5,916 M6,333 M3,813 M5,770 M
Other non-current liabilities23871.053 M28 M46 M72 M40 M392381.09 M
Other receivable284 M175 M61 M1,667 M2,306 M890 M724 M725 M19 M49 M
OtherCurrentBorrowings1,804 M2,566 M2,562 M5,246 M6,204 M7,103 M9,047 M0.012,419 M
OtherCurrentLiabilities148 M423 M7,333 M1,611 M460 M365 M4 M35 M2 M13,591 M
OtherInventories5,743 M5,819 M8,377 M
OtherPayable834 M1,400 M903 M1,095 M1,817 M2,302 M3,069 M3,480 M4,844 M9,215 M
Payables2,617 M4,625 M4,794 M5,554 M6,508 M7,701 M8,176 M10,456 M6,876 M12,164 M
Prepaid expenses1,951 M913 M715 M767 M1,707 M1,713 M1,573 M3,021 M382 M477 M
Raw materials239 M639 M530 M944 M856 M1,337 M1,351 M0.05,500 M
RecievablesAdjustmentsAllowances-446 M-429 M-336 M-377 M-265 M-257 M-318 M0.0-584 M
Restricted cash734 M1,599 M1,161 M3,333 M3,238 M4,058 M6,931 M6,401 M1,453 M1,297 M
Retained earnings42 M715 M1,399 M3,225 M3,366 M3,843 M4,734 M4,780 M883 M906 M
Short term debt4,224 M5,126 M6,032 M10,709 M11,887 M6,072 M7,519 M11,166 M1,894 M2,990 M
TaxesReceivable464 M686 M444 M286 M0.030 M
Total assets10,611 M19,084 M27,145 M26,091 M28,636 M35,853 M47,845 M53,232 M11,453 M15,755 M
Total current assets5,343 M10,404 M22,495 M19,695 M19,608 M23,574 M29,557 M32,787 M7,144 M9,907 M
Total current liabilities7,237 M10,523 M18,622 M18,363 M19,962 M17,982 M21,196 M22,973 M7,134 M9,415 M
Total equity2,010 M3,507 M4,322 M6,461 M6,689 M7,840 M9,303 M9,988 M1,734 M2,369 M
Total liabilities8,591 M14,115 M21,185 M19,630 M21,947 M27,687 M35,404 M40,242 M9,211 M11,839 M
Total non-current assets3,949 M8,680 M4,650 M6,395 M9,029 M12,279 M18,288 M20,446 M4,309 M5,848 M
Total non-current liabilities1,353 M3,592 M2,562 M1,268 M1,985 M9,704 M14,208 M17,269 M2,077 M2,424 M
TotalEquityGrossMinority2,021 M3,533 M4,352 M6,460 M6,689 M8,454 M12,441 M12,991 M14,287 M27,004 M
TotalEquityGrossMinorityInterest2,021 M3,533 M4,352 M6,460 M6,689 M8,454 M12,441 M12,991 M14,287 M27,004 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest10,611 M19,084 M27,145 M26,091 M28,636 M36,141 M47,845 M53,232 M11,453 M15,755 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,353 M3,592 M2,562 M1,268 M1,985 M9,704 M14,208 M17,269 M2,077 M2,424 M
TotalTaxPayable16 M76 M106 M168 M28 M70 M117 M74 M34 M107 M
Treasury stock-14 M-14 M-14 M-14 M-14 M-14 M-14 M-43 M-7 M-6 M
UnearnedIncome359 M60 M
Work in progress103 M325 M592 M810 M1,247 M1,553 M792 M0.03,237 M
Working capital-1,894 M-120 M3,872 M1,333 M-355 M5,592 M8,361 M9,814 M10 M492 M
ltinv94 M103 M7 M7 M22 M26 M278 M194 M85 M1,711 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