Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Canadian Solar Inc. logo

Canadian Solar Inc.

Sector: Technology   

Industry: Solar

Optionable: Yes  Market Cap: 987 M  90-day average vol: 1,451,207

Previous close: 14.53  Open: 14.48  Bid: 14.3  Ask: 14.66
52 week range    
JKS / 
Last updated: Monday 22nd April 2024

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



StockDividendMarket Cap (B)PEPrice ($)


8 B18.569.74



3 B9.615.62

CSIQ Income Statement

AcquiredInProcessRnD50 M
Amortization of intangibles-1 M-2 M-2 M-7 M-5 M-5 M-5 M0.0-5 M-4 M
Basic EPS from continuing operations0.684.
Basic EPS total0.684.
Basic weighted shares outstanding46 M54 M56 M58 M58 M59 M60 M60 M62 M64 M
Cost of sales1,379 M2,380 M2,891 M2,436 M2,753 M2,969 M2,482 M2,787 M4,368 M6,205 M
Depreciation-81 M-83 M-94 M-96 M-99 M-129 M-160 M0.0-283 M-235 M
DepreciationAndAmortization-81 M-83 M-94 M-96 M-99 M-129 M-160 M-209 M-283 M-235 M
Diluted EPS total0.634.112.931.121.693.882.832.381.463.44
Diluted normalized net income/share0.634.112.931.121.693.882.832.381.463.44
Diluted weighted shares outstanding50 M59 M60 M58 M62 M62 M61 M62 M69 M71 M
Earnings from equity interest-643000.0-4 M9 M6 M29 M11 M7 M15 M
EarningsFromEquityInterestNetOfTax-643000.0-4 M9 M6 M29 M11 M7 M15 M
GainOnSaleOfPPE-4 M-1 M-12 M0.0-83000.04 M
GainOnSaleOfSecurity11 M20 M-25 M27 M1 M41 M-20 M-9 M19 M858000.0
GeneralAndAdministrativeExpense45 M77 M168 M204 M231 M245 M243 M226 M309 M342 M
Gross operating profit276 M581 M582 M417 M638 M775 M718 M690 M909 M1,263 M
ImpairmentOfCapitalAssets-4 M-2 M-7 M-23 M-12 M-31 M-22 M0.0-6 M-60 M
Income before tax56 M321 M223 M83 M144 M304 M209 M145 M146 M372 M
Income restructuring and M&A-432 M-159 M-15 M0.0-1 M-1 M
Income taxes8 M77 M50 M18 M41 M62 M42 M-2 M36 M73 M
Interest income12 M14 M17 M10 M10 M11 M12 M9 M35 M41 M
InterestExpenseNonOperating46 M49 M54 M70 M118 M106 M81 M72 M58 M74 M
InterestExpenseOperating-64 M-59 M-78 M-122 M-132 M-123 M-95 M0.0-75 M-119 M
InterestIncomeOperating20 M27 M-19 M
MinorityInterests-14 M-4 M-1 M-26000.0-3 M-5 M5 M-543000.0-15 M-59 M
MiscOtherSpecialCharges427560.02 M389000.03 M-272000.013 M28 M0.0-52 M220 M
Net income from total operations32 M240 M172 M65 M100 M237 M172 M147 M95 M240 M
NetIncomeCommonStockholders32 M240 M172 M65 M100 M237 M172 M147 M95 M240 M
NetIncomeContinuousOperations32 M240 M172 M65 M100 M237 M172 M147 M95 M240 M
NetIncomeFromOtherGainsLosses-3 M487000.0-643000.0
NetNonOperatingInterestIncomeExpense-34 M-35 M-35 M-61 M-111 M-95 M-69 M-63 M-23 M-34 M
Operating income131 M366 M247 M93 M269 M365 M259 M220 M190 M356 M
Operating income before depreciation (EBITDA)119 M393 M293 M127 M229 M417 M355 M0.0411 M561 M
OperatingExpense145 M215 M335 M324 M368 M410 M460 M469 M719 M907 M
Other income net-427560.0-2 M12 M2 M-9 M-47 M-9 M-2 M-26 M28 M
OtherGandA45 M77 M168 M204 M231 M245 M243 M226 M309 M342 M
OtherImpairmentOfCapitalAssets0.0-4 M-6 M0.0-357000.0
OtherOperatingExpenses-145 M-215 M-329 M-43 M-48 M-45 M-11 M-26 M-47 M-64 M
PromotionAndAdvertising-5 M-7 M0.0
RealizedCapitalGain27 M-272000.0-44 M
RentAndLandingFees-10 M-12 M-15 M-17 M-20 M0.0
Research & development expense12 M12 M17 M17 M29 M44 M47 M45 M58 M70 M
ResearchExpense12 M12 M17 M17 M29 M44 M47 M45 M58 M70 M
RestructringAndMnAIncome-432 M-159 M-15 M0.0-1 M-1 M
Revenue per share-1 M-2 M-2 M-7 M-5 M-5 M-24 M-13 M-5 M-4 M
SalariesAndWages-6 M-5 M-6 M-8 M-9 M-10 M-11 M0.0-9 M-9 M
Selling Gen & administrative expense133 M203 M318 M349 M387 M411 M423 M450 M708 M901 M
SellingAndMarketingExpense88 M126 M150 M145 M156 M165 M180 M224 M399 M559 M
SellingExpense88 M126 M150 M145 M156 M165 M0.0
Special income/charges4 M433 M166 M23 M27 M31 M22 M50 M8 M62 M
Total Income available for interest expense (EBIT)39 M310 M198 M31 M130 M288 M195 M0.0128 M327 M
Total common shares outstanding51 M55 M56 M58 M58 M59 M59 M60 M64 M65 M
Total net income32 M240 M172 M65 M100 M237 M172 M147 M95 M240 M
Total ordinary shares65 M65 M65 M65 M65 M65 M65 M65 M65 M65 M
Total revenues1,654 M2,961 M3,473 M2,853 M3,390 M3,745 M3,201 M3,476 M5,277 M7,469 M
TotalExpenses1,524 M2,594 M3,226 M2,760 M3,121 M3,380 M2,942 M3,256 M5,087 M7,113 M
TotalRevenue1,654 M2,961 M3,473 M2,853 M3,390 M3,745 M3,201 M3,476 M5,277 M7,469 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


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.


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