Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

CSIQ Stock Forecast, Price Targets, Chart, Dividends & Analysis

Canadian Solar Inc. logo

Canadian Solar Inc.

Sector: Technology   

Industry: Solar

10.76
 
USD
  
-0.56
  
(-4.95%)
Previous close: 11.32  Open: 11.38  Bid: 10.8  Ask: 10.87
52 week range    
10.74   
   26.85
Mkt Cap: 772 M  Avg Vol (90 Days): 2,293,423
Peers   
SPWR / 
JKS / 
Last updated: Friday 20th December 2024

Stock Rankings

49
MarketXLS Rank
80
Value
38
Technical
31
Quality
How are these ranks calculated?
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

FSLR

20 B16.41175.88

JKS

SPWR

0 B00.1228
Financials

CSIQ Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquiredInProcessRnD50 M
Amortization of intangibles-2 M-2 M-7 M-5 M-5 M-5 M-5 M-5 M-4 M
Basic EPS from continuing operations4.43.081.131.714.022.882.461.553.734.19
Basic EPS total4.43.081.131.714.022.882.461.553.734.19
Basic weighted shares outstanding54 M56 M58 M58 M59 M60 M60 M62 M64 M65 M
Cost of sales2,380 M2,891 M2,436 M2,753 M2,969 M2,482 M2,787 M4,368 M6,205 M6,334 M
Depreciation-83 M-94 M-96 M-99 M-129 M-160 M-209 M-283 M-235 M
DepreciationAndAmortization-83 M-94 M-96 M-99 M-129 M-160 M-209 M-283 M-235 M
Diluted EPS total4.112.931.121.693.882.832.381.463.443.87
Diluted normalized net income/share4.112.931.121.693.882.832.381.463.443.87
Diluted weighted shares outstanding59 M60 M58 M62 M62 M61 M62 M69 M71 M72 M
Earnings from equity interest-643000.0-4 M9 M6 M29 M11 M7 M15 M15 M
EarningsFromEquityInterestNetOfTax-643000.0-4 M9 M6 M29 M11 M7 M15 M15 M
GainOnSaleOfPPE-1 M-12 M0.0-83000.04 M
GainOnSaleOfSecurity20 M-25 M27 M1 M41 M-20 M-9 M19 M858000.015 M
GeneralAndAdministrativeExpense77 M168 M204 M231 M245 M243 M226 M309 M342 M440 M
Gross operating profit581 M582 M417 M638 M775 M718 M690 M909 M1,263 M1,364 M
ImpairmentOfCapitalAssets-2 M-7 M-23 M-12 M-31 M-22 M-12 M-6 M-60 M
Income before tax321 M223 M83 M144 M304 M209 M145 M146 M356 M423 M
Income restructuring and M&A-432 M-159 M-15 M-1 M-1 M-1 M
Income taxes77 M50 M18 M41 M62 M42 M-2 M36 M73 M60 M
Interest income14 M17 M10 M10 M11 M12 M9 M35 M41 M52 M
InterestExpenseNonOperating49 M54 M70 M118 M106 M81 M72 M58 M74 M114 M
InterestExpenseOperating-59 M-78 M-122 M-132 M-123 M-95 M-82 M-75 M-119 M
InterestIncomeOperating20 M27 M-19 M
MinorityInterests-4 M-1 M-26000.0-3 M-5 M5 M-543000.0-15 M-59 M-89 M
MiscOtherSpecialCharges2 M389000.03 M-272000.013 M28 M139 M-52 M220 M
Net income from total operations240 M172 M65 M100 M237 M172 M147 M95 M240 M274 M
NetIncomeCommonStockholders240 M172 M65 M100 M237 M172 M147 M95 M240 M274 M
NetIncomeContinuousOperations240 M172 M65 M100 M237 M172 M147 M95 M299 M364 M
NetIncomeFromOtherGainsLosses487000.0-643000.0
NetNonOperatingInterestIncomeExpense-35 M-35 M-61 M-111 M-95 M-69 M-63 M-23 M-34 M-62 M
Normalized income311 M
Operating income366 M247 M93 M269 M365 M259 M220 M190 M356 M453 M
Operating income before depreciation (EBITDA)393 M293 M127 M229 M417 M355 M415 M479 M665 M844 M
OperatingExpense215 M335 M324 M368 M410 M460 M469 M719 M911 M911 M
Other income net-2 M12 M2 M-9 M-47 M-9 M-2 M-26 M38 M-2 M
OtherCostofRevenue6,334 M
OtherGandA77 M168 M204 M231 M245 M243 M226 M309 M342 M440 M
OtherImpairmentOfCapitalAssets0.0-4 M-6 M-24 M-357000.0
OtherOperatingExpenses-215 M-329 M-43 M-48 M-45 M-11 M-26 M-47 M-64 M
PromotionAndAdvertising-7 M0.0
RealizedCapitalGain27 M-272000.0-44 M
RentAndLandingFees-12 M-15 M-17 M-20 M0.0
Research & development expense12 M17 M17 M29 M44 M47 M45 M58 M70 M101 M
ResearchExpense12 M17 M17 M29 M44 M47 M45 M58 M70 M101 M
RestructringAndMnAIncome-432 M-159 M-15 M-1 M-1 M-1 M
Revenue per share-2 M-2 M-7 M-5 M-5 M-24 M-13 M-5 M-4 M
SalariesAndWages-5 M-6 M-8 M-9 M-10 M-11 M-12 M-9 M-9 M
Selling Gen & administrative expense203 M318 M349 M387 M411 M423 M450 M708 M901 M810 M
SellingAndMarketingExpense126 M150 M145 M156 M165 M180 M224 M399 M559 M370 M
SellingExpense126 M150 M145 M156 M165 M180 M
Special income/charges433 M166 M23 M27 M31 M22 M50 M8 M62 M
Total Income available for interest expense (EBIT)310 M198 M31 M130 M288 M195 M206 M197 M431 M537 M
Total common shares outstanding55 M56 M58 M58 M59 M59 M60 M64 M65 M
Total net income240 M172 M65 M100 M237 M172 M147 M95 M240 M274 M
Total ordinary shares66 M66 M66 M66 M66 M66 M66 M66 M66 M66 M
Total revenues2,961 M3,473 M2,853 M3,390 M3,745 M3,201 M3,476 M5,277 M7,469 M7,614 M
TotalExpenses2,594 M3,226 M2,760 M3,121 M3,380 M2,942 M3,256 M5,087 M7,117 M7,245 M
TotalRevenue2,961 M3,473 M2,853 M3,390 M3,745 M3,201 M3,476 M5,277 M7,469 M7,698 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