25 XP   0   0   10

Celestica Inc.
Buy, Hold or Sell?

Let's analyse Celestica together

PenkeI guess you are interested in Celestica Inc.. Buy, hold or sell? I don't know! However, I do recommend doing research before doing anything. I will help you with that.

I'm going to help you getting a better view of Celestica Inc.. At the end you don't have to ask anyone for trading advice. You can make your own decision, with more confidence, the odds in your favor, backed by data.

You can find me behind Let's Analyse Together in the top-right of each section.

Get notifications about Celestica Inc.

I send you an email if I find something interesting about Celestica Inc..

Quick analysis of Celestica (30 sec.)










What can you expect buying and holding a share of Celestica? (30 sec.)

How much money do you get?

How much money do you get?
$0.45
When do you have the money?
1 year
How often do you get paid?
20.0%

What is your share worth?

Current worth
$14.72
Expected worth in 1 year
$15.74
How sure are you?
85.0%

+ What do you gain per year?

Total Gains per Share
$1.46
Return On Investment
3.3%

For what price can you sell your share?

Current Price per Share
$44.94
Expected price per share
$30.36 - $49.36
How sure are you?
50%

1. Valuation of Celestica (5 min.)




Live pricePrice per Share (EOD)

$44.94

Intrinsic Value Per Share

$18.02 - $47.36

Total Value Per Share

$32.75 - $62.09

2. Growth of Celestica (5 min.)




Is Celestica growing?

Current yearPrevious yearGrowGrow %
How rich?$1.7b$1.5b$136.3m8.0%

How much money is Celestica making?

Current yearPrevious yearGrowGrow %
Making money$61.1m$36.3m$24.7m40.5%
Net Profit Margin3.0%2.0%--

How much money comes from the company's main activities?

3. Financial Health of Celestica (5 min.)




4. Comparing to competitors in the Electronic Components industry (5 min.)




  Industry Rankings (Electronic Components)  


Richest
#50 / 524

Most Revenue
#26 / 524

Most Profit
#40 / 524

Most Efficient
#294 / 524

What can you expect buying and holding a share of Celestica? (5 min.)

Welcome investor! Celestica's management wants to use your money to grow the business. In return you get a share of Celestica.

What can you expect buying and holding a share of Celestica?

First you should know what it really means to hold a share of Celestica. And how you can make/lose money.

Speculation

The Price per Share of Celestica is $44.94. The market price reflects what other people think it is worth; not what it's really worth. Your job is to find out if the market price is fair, overpriced, or underpriced. I will help you with that.

If you buy blind, there is a 50% chance of making or losing money by selling the stock in the future. However, we can look at a few things to determine the odds in our favor:

  • The fundamentals: the financial health trends of Celestica.
  • The technials: based on market psychology, we can make a calculated estimate of what the price will do in the future. We can do this through technical analysis. We can calculate the probabilities and the expected value (millionaire math). That's called speculation.
  • The book value: what is the market price compared to it's book value.

Investing

If you really want to invest in Celestica, you will have to let go of the thought of selling in the future. If you have to sell the share for less than you bought it, it can still be a good investment. Focus on what it means to hold the stock forever:

  • You own a part of the company. The equity of this part can grow or shrink. The current Book Value per Share is $14.72. Based on the TTM, the Book Value Change Per Share is $0.25 per quarter. Based on the YOY, the Book Value Change Per Share is $0.50 per quarter.
  • You may receive quarterly/yearly dividend in the form of additional shares.
  • You may receive quarterly/yearly dividend in the form of cash. Based on the TTM the Dividend per Share is $0.11 per quarter.
Based on historical numbers we can estimate the returns while holding a share of Celestica.

How much money are you going to get?

 MRQTTMYOY5Y10Y
 $% of Price per Share$% of Price per Share$% of Price per Share$% of Price per Share$% of Price per Share
Usd Eps0.701.6%0.511.1%0.290.7%0.250.6%0.230.5%
Usd Book Value Change Per Share0.210.5%0.250.6%0.501.1%0.250.6%0.180.4%
Usd Dividend Per Share0.100.2%0.110.2%0.000.0%0.030.1%0.180.4%
Usd Total Gains Per Share0.300.7%0.370.8%0.501.1%0.280.6%0.350.8%
Usd Price Per Share29.28-20.30-10.33-10.74-11.06-
Price to Earnings Ratio10.39-10.82-9.82-1.67-10.50-
Price-to-Total Gains Ratio96.42-6.23-26.42-38.37-61.70-
Price to Book Ratio1.99-1.42-0.81-0.87-1.12-
Price-to-Total Gains Ratio96.42-6.23-26.42-38.37-61.70-

When do you get the money?

Usd Investment
$.00
Usd Price Per Share44.94
Number of shares22
Gains per QuarterTrailing 12 Months5 Year
Usd Dividend Per Share0.110.03
Usd Book Value Change Per Share0.250.25
Usd Total Gains Per Share0.370.28
Gains per Quarter (22 shares)8.046.25
Gains per Year (22 shares)32.1825.01
YearsReturn on Investment (TTM)Return on Investment (5Y)
 DividendBook Value gainTotal gainsDividendBook Value gainTotal gains
Broker costs---10---10
110222232215
220455454540
329678686765
43989118118990
54911215014112115
65913418216134140
76915721419156165
87817924622178190
98820127824201215
109822431027223240

How sure are you?

Based on the past periods, how sure are you to get value out of your investment.

Linear %
 Trailing 12 Months3Y5 Year10 YearALLTIME
  % % % % %
Earnings Per Share4.00.00.0100.0%12.00.00.0100.0%16.04.00.080.0%36.04.00.090.0%74.030.00.071.2%
Book Value Change Per Share3.01.00.075.0%11.01.00.091.7%17.03.00.085.0%33.07.00.082.5%68.032.04.065.4%
Dividend per Share2.00.02.050.0%4.00.08.033.3%5.00.015.025.0%8.00.032.020.0%9.00.095.08.7%
Total Gains per Share3.01.00.075.0%11.01.00.091.7%17.03.00.085.0%34.06.00.085.0%69.031.04.066.3%

Fundamentals of Celestica

About Celestica Inc.

Celestica Inc. provides supply chain solutions in North America, Europe, and Asia. It operates through two segments: Advanced Technology Solutions, and Connectivity & Cloud Solutions. The company offers a range of product manufacturing and related supply chain services, including design and development, new product introduction, engineering services, component sourcing, electronics manufacturing and assembly, testing, complex mechanical assembly, systems integration, precision machining, order fulfillment, logistics, asset management, product licensing, and after-market repair and return services. It also provides hardware platform solutions, which includes development of infrastructure platforms, and hardware and software design solutions and services which is used as-is or customized for specific applications; and management of program including design and supply chain, manufacturing, and after-market support, including IT asset disposition and asset management services. The company offers its products and services to original equipment manufacturers, cloud-based, and other service providers, including hyperscalers, and other companies in aerospace and defense, industrial, HealthTech, capital equipment, and communication and enterprise markets. Celestica Inc. was incorporated in 1994 and is headquartered in Toronto, Canada.

Fundamental data was last updated by Penke on 2024-03-22 19:15:07.

Financial Health

Profitability Details
 Compared to previous yearCompared to industry
The company is making a profit.
Using its assets, the company is less efficient in making profit.
Using its investors money, the company is inefficient in making profit.
Operating Efficiency Details
 Compared to previous yearCompared to industry
The company is operating less efficient.
The company is less efficient in keeping operating costs low.
Liquidity Details
 Compared to previous yearCompared to industry
The company is just able to pay all its short-term debts.
The company is just not able to pay all its short-term debts with the most liquid assets.
Solvency Details
 Compared to previous yearCompared to industry
The company is able to pay all its debts by selling its assets.
The company is just not able to pay all its debts with equity.

Valuation

Valuation Details
 Compared to previous yearCompared to industry
Based on the equity, the company is underpriced.
Based on the earnings, the company is underpriced.
Based on how much money comes from the company's main activities, the company is cheap.

1.1. Profitability of Celestica Inc..

1.1. Profitability
1.1.1. Net Profit Margin

Measures how much net profit Celestica earns for each $1 of revenue.

  • Above 10% is considered healthy but always compare Celestica to the Electronic Components industry mean.
  • A Net Profit Margin of 3.8% means that $0.04 for each $1 in revenue is generated as profit.

Let's take a look of the Net Profit Margin trends of Celestica Inc.:

  • The MRQ is 3.8%. The company is making a profit. +1
  • The TTM is 3.0%. The company is making a profit. +1
Trends
Current periodCompared to+/- 
MRQ3.8%TTM3.0%+0.8%
TTM3.0%YOY2.0%+1.0%
TTM3.0%5Y1.8%+1.2%
5Y1.8%10Y1.8%+0.0%
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ3.8%3.6%+0.2%
TTM3.0%4.1%-1.1%
YOY2.0%5.4%-3.4%
5Y1.8%4.4%-2.6%
10Y1.8%4.8%-3.0%
1.1.2. Return on Assets

Shows how efficient Celestica is using its assets to generate profit.

  • Above 5% is considered healthy but always compare Celestica to the Electronic Components industry mean.
  • 1.4% Return on Assets means that Celestica generated $0.01 profit for each $1 in assets.

Let's take a look of the Return on Assets trends of Celestica Inc.:

  • The MRQ is 1.4%. Using its assets, the company is less efficient in making profit.
  • The TTM is 1.1%. Using its assets, the company is less efficient in making profit.
Trends
Current periodCompared to+/- 
MRQ1.4%TTM1.1%+0.4%
TTM1.1%YOY0.7%+0.4%
TTM1.1%5Y0.7%+0.4%
5Y0.7%10Y0.8%-0.1%
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ1.4%0.8%+0.6%
TTM1.1%0.9%+0.2%
YOY0.7%1.3%-0.6%
5Y0.7%1.1%-0.4%
10Y0.8%1.1%-0.3%
1.1.3. Return on Equity

Shows how efficient Celestica is using its investors money to generate profit.

  • Above 15%-20% is considered healthy but always compare Celestica to the Electronic Components industry mean.
  • 4.8% Return on Equity means Celestica generated $0.05 for each $1 the owners (shareholders) invested.

Let's take a look of the Return on Equity trends of Celestica Inc.:

  • The MRQ is 4.8%. Using its investors money, the company is inefficient in making profit. -1
  • The TTM is 3.5%. Using its investors money, the company is inefficient in making profit. -1
Trends
Current periodCompared to+/- 
MRQ4.8%TTM3.5%+1.2%
TTM3.5%YOY2.3%+1.2%
TTM3.5%5Y2.0%+1.6%
5Y2.0%10Y2.0%0.0%
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ4.8%1.5%+3.3%
TTM3.5%1.5%+2.0%
YOY2.3%2.5%-0.2%
5Y2.0%2.1%-0.1%
10Y2.0%2.1%-0.1%

1.2. Operating Efficiency of Celestica Inc..

1.2. Operating Efficiency
1.2.1. Operating Margin

Measures how efficient Celestica is operating .

  • Measures how much profit Celestica makes for each $1 of sales after paying variable costs (production costs, wages, etc) but before taxes.
  • Above 15% is considered healthy but always compare Celestica to the Electronic Components industry mean.
  • An Operating Margin of 5.6% means the company generated $0.06  for each $1 in revenue (before taxes).

Let's take a look of the Operating Margin trends of Celestica Inc.:

  • The MRQ is 5.6%. The company is operating less efficient.
  • The TTM is 4.9%. The company is operating less efficient.
Trends
Current periodCompared to+/- 
MRQ5.6%TTM4.9%+0.7%
TTM4.9%YOY3.6%+1.3%
TTM4.9%5Y3.1%+1.7%
5Y3.1%10Y3.0%+0.1%
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ5.6%5.6%+0.0%
TTM4.9%2.1%+2.8%
YOY3.6%5.3%-1.7%
5Y3.1%5.3%-2.2%
10Y3.0%4.3%-1.3%
1.2.2. Operating Ratio

Measures how efficient Celestica is keeping operating costs low.

  • Below 1 is considered healthy (always compare to Electronic Components industry mean).
  • An Operation Ratio of 0.94 means that the operating costs are $0.94 for each $1 in net sales.

Let's take a look of the Operating Ratio trends of Celestica Inc.:

  • The MRQ is 0.944. The company is less efficient in keeping operating costs low.
  • The TTM is 0.950. The company is less efficient in keeping operating costs low.
Trends
Current periodCompared to+/- 
MRQ0.944TTM0.950-0.007
TTM0.950YOY0.963-0.013
TTM0.9505Y0.968-0.017
5Y0.96810Y0.970-0.002
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ0.9441.732-0.788
TTM0.9501.729-0.779
YOY0.9631.714-0.751
5Y0.9681.690-0.722
10Y0.9701.487-0.517

1.3. Liquidity of Celestica Inc..

1.3. Liquidity
1.3.1. Current Ratio

Measures if Celestica is able to pay off Short-term Debt.

  • Above 1.5 is considered healthy (always compare to Electronic Components industry mean).
  • A Current Ratio of 1.40 means the company has $1.40 in assets for each $1 in short-term debts.

Let's take a look of the Current Ratio trends of Celestica Inc.:

  • The MRQ is 1.402. The company is just able to pay all its short-term debts.
  • The TTM is 1.422. The company is just able to pay all its short-term debts.
Trends
Current periodCompared to+/- 
MRQ1.402TTM1.422-0.020
TTM1.422YOY1.452-0.030
TTM1.4225Y1.583-0.161
5Y1.58310Y1.747-0.164
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ1.4021.861-0.459
TTM1.4221.846-0.424
YOY1.4521.849-0.397
5Y1.5831.890-0.307
10Y1.7471.689+0.058
1.3.2. Quick Ratio

Measures if Celestica is able to pay off Short-term Debt but only using the most liquid assets.

  • Above 1 is considered healthy but always compare Celestica to the Electronic Components industry mean.
  • A Quick Ratio of 0.68 means the company can pay off $0.68 for each $1 in debt (using most liquid assets).

Let's take a look of the Quick Ratio trends of Celestica Inc.:

  • The MRQ is 0.677. The company is just not able to pay all its short-term debts with the most liquid assets. -1
  • The TTM is 0.605. The company is just not able to pay all its short-term debts with the most liquid assets. -1
Trends
Current periodCompared to+/- 
MRQ0.677TTM0.605+0.071
TTM0.605YOY0.594+0.012
TTM0.6055Y0.797-0.191
5Y0.79710Y0.939-0.142
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ0.6770.773-0.096
TTM0.6050.759-0.154
YOY0.5940.809-0.215
5Y0.7970.847-0.050
10Y0.9390.882+0.057

1.4. Solvency of Celestica Inc..

1.3. Liquidity
1.4.1. Debt to Asset Ratio

Measures how much % of Celestica assets are financed with debt.

  • Below 1 (100%) is considered healthy but always compare Celestica to Electronic Components industry mean.
  • A Debt to Asset Ratio of 0.70 means that Celestica assets are financed with 70.0% credit (debt) and the remaining percentage (100% - 70.0%) is financed by its owners/shareholders. 

Let's take a look of the Debt to Asset Ratio trends of Celestica Inc.:

  • The MRQ is 0.700. The company is able to pay all its debts by selling its assets. +1
  • The TTM is 0.697. The company is able to pay all its debts by selling its assets. +1
Trends
Current periodCompared to+/- 
MRQ0.700TTM0.697+0.002
TTM0.697YOY0.700-0.003
TTM0.6975Y0.656+0.041
5Y0.65610Y0.599+0.057
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ0.7000.422+0.278
TTM0.6970.424+0.273
YOY0.7000.445+0.255
5Y0.6560.442+0.214
10Y0.5990.426+0.173
1.4.2. Debt to Equity Ratio

Measures if Celestica is able to pay off its debts by using shareholders equity.

  • Below 2 is considered healthy but always compare Celestica to the Electronic Components industry mean.
  • A Debt to Equity ratio of 233.1% means that company has $2.33 debt for each $1 in shareholders equity.

Let's take a look of the Debt to Equity Ratio trends of Celestica Inc.:

  • The MRQ is 2.331. The company is just not able to pay all its debts with equity.
  • The TTM is 2.304. The company is just not able to pay all its debts with equity.
Trends
Current periodCompared to+/- 
MRQ2.331TTM2.304+0.027
TTM2.304YOY2.334-0.030
TTM2.3045Y1.944+0.360
5Y1.94410Y1.581+0.363
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
MRQ2.3310.748+1.583
TTM2.3040.757+1.547
YOY2.3340.824+1.510
5Y1.9440.822+1.122
10Y1.5810.804+0.777

2. Market Valuation of Celestica Inc.

2.1. Earnings Per Share
2.1. Price to Earnings Ratio

Measures how much money you pay for each share for every $1 in earnings Celestica generates.

  • Above 15 is considered overpriced but always compare Celestica to the Electronic Components industry mean.
  • A PE ratio of 10.39 means the investor is paying $10.39 for every $1 in earnings.

Let's take a look of the Price to Earnings Ratio trends of Celestica Inc.:

  • The EOD is 15.945. Based on the earnings, the company is fair priced.
  • The MRQ is 10.389. Based on the earnings, the company is underpriced. +1
  • The TTM is 10.816. Based on the earnings, the company is underpriced. +1
Trends
Current periodCompared to+/- 
EOD15.945MRQ10.389+5.556
MRQ10.389TTM10.816-0.427
TTM10.816YOY9.824+0.992
TTM10.8165Y1.667+9.149
5Y1.66710Y10.497-8.830
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
EOD15.94514.767+1.178
MRQ10.38914.696-4.307
TTM10.81614.600-3.784
YOY9.82412.909-3.085
5Y1.66718.612-16.945
10Y10.49723.001-12.504
2.2. Price To Free Cash Flow Ratio

Let's take a look of the Price To Free Cash Flow Ratio trends of Celestica Inc.:

  • The EOD is 13.951. Based on how much money comes from the company's main activities, the company is cheap. +2
  • The MRQ is 9.090. Based on how much money comes from the company's main activities, the company is cheap. +2
  • The TTM is 8.870. Based on how much money comes from the company's main activities, the company is cheap. +2
Trends
Current periodCompared to+/- 
EOD13.951MRQ9.090+4.862
MRQ9.090TTM8.870+0.220
TTM8.870YOY9.128-0.258
TTM8.8705Y6.788+2.082
5Y6.78810Y6.355+0.433
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
EOD13.9515.304+8.647
MRQ9.0905.406+3.684
TTM8.8702.989+5.881
YOY9.1281.824+7.304
5Y6.7881.629+5.159
10Y6.3551.916+4.439
2. Book Value per Share
2.3. Price to Book Ratio

Measures if the stock price of Celestica is to cheap or to expensive compared to its book value.

  • At or below 1 is considered healthy (always compare to Electronic Components industry mean).
  • A PB ratio of 1.99 means the investor is paying $1.99 for each $1 in book value.

Let's take a look of the Price to Book Ratio trends of Celestica Inc.:

  • The EOD is 3.052. Based on the equity, the company is fair priced.
  • The MRQ is 1.989. Based on the equity, the company is underpriced. +1
  • The TTM is 1.416. Based on the equity, the company is underpriced. +1
Trends
Current periodCompared to+/- 
EOD3.052MRQ1.989+1.064
MRQ1.989TTM1.416+0.573
TTM1.416YOY0.814+0.602
TTM1.4165Y0.870+0.546
5Y0.87010Y1.118-0.248
Compared to industry (Electronic Components)
PeriodCompanyIndustry (mean)+/- 
EOD3.0521.807+1.245
MRQ1.9891.910+0.079
TTM1.4161.949-0.533
YOY0.8141.921-1.107
5Y0.8702.147-1.277
10Y1.1182.257-1.139
2. Total Gains per Share

3. Holders & Insider Transactions

Let's take a look at which institutions, funds and insiders are holding shares of Celestica Inc..

3.1. Institutions holding Celestica Inc.

Institutions are holding 76.021% of the shares of Celestica Inc..

DateNameTotal SharesTotal AssetsCurrent SharesChange%
2023-12-31Connor Clark & Lunn Inv Mgmt Ltd5.15410.83756135452404580.6638
2023-12-31Letko, Brosseau & Associates Inc.3.92142.50244668101-1189560-20.3078
2023-12-31Whale Rock Capital Management LLC3.512.186941782982794009201.8371
2023-12-31Arrowstreet Capital Limited Partnership3.14650.1153745617942152.5802
2023-09-30Acadian Asset Management LLC3.1210.3827371532134607981359.7192
2023-09-30Vanguard Group Inc3.11180.00223704369476191.3022
2023-09-30Donald Smith & Co Inc2.7072.71693222449-1840906-36.3574
2023-09-30CIBC World Markets Inc.2.48790.23942961578-396621-11.8105
2023-12-31WCM Investment Management1.92570.1876229240922924090
2023-12-31Amvescap Plc.1.870.01552226059103042586.1823
2023-09-30Morgan Stanley - Brokerage Accounts1.6620.00491978488-633180-24.2443
2023-09-30Point72 Asset Management, L.P.1.64530.1401195863818477381666.1298
2023-12-31Guardian Capital Inc1.62142.03571930139-170345-8.1098
2023-12-31American Century Companies Inc1.5680.037618666111491918398.1708
2023-09-30Shannon River Fund Management LLC1.4248.2613169513916951390
2023-12-31Hillsdale Investment Management Inc.1.42074.04511691186-439540-20.6286
2023-09-30Millennium Management LLC1.34660.01981602991-1228274-43.3825
2023-12-31Grantham, Mayo, Van Otterloo & Co., LLC1.20360.18571432782202011.4301
2023-12-31Dimensional Fund Advisors, Inc.1.10430.0112131460014741712.6302
2023-12-31Portolan Capital Management, LLC1.03663.15911234024-176352-12.5039
Total 44.987927.086653554251+8887568+16.6%

3.2. Funds holding Celestica Inc.

DateNameTotal SharesTotal AssetsCurrent SharesChange%
2024-01-31DFA International Small Cap Value I1.91180.7214227996000
2024-02-29Vanguard Total Intl Stock Index Inv1.33980.0163159778550100.3145
2023-12-31Victory Trivalent International Sm-Cp I1.13631.16411355082-31270-2.2556
2023-12-31Donald Smith & Co. All Eq Accounts Comp1.05780.92511261457-1930870-60.4847
2024-01-31Invesco Discovery A0.95631.0091140430310072.7949
2023-12-31Invesco OFI Small Cap Growth0.93030.8418110942311094230
2024-01-31Guardian Canadian Targeted Exposure Eq0.90593.8976108033887470.8163
2024-02-29Vanguard Developed Markets Index Admiral0.80830.0221963902143511.5113
2023-12-31Neumeier Poma Small Cap Value0.78722.594993881527615541.6737
2023-12-31WCM Focused Emerging Markets Instl0.762.22659063909063900
2023-12-31WCM Inv Mgt Emerging Markets0.762.22499063909063900
2024-02-29Vanguard Instl Ttl Intl Stk Mkt Idx TrII0.64570.016577001200
2023-12-31Donald Smith & Co. Md-Cap Val Eq0.59891.4317714186-962600-57.4074
2023-12-31Vanguard Selected Value Inv0.59890.3044714186-962600-57.4074
2024-01-31DFA International Small Company I0.57050.2068680353700.0103
2024-01-31DFA International Core Equity I0.51270.068761146700
2023-07-31Dimensional Canadian Small Company0.50980.971660799800
2023-12-31Strategic Advisers Small-Mid Cap0.50070.1901597175-32235-5.1215
2023-12-31American Century U.S. Small Cap Growth0.45320.49395405215405210
2023-12-31American Century Small Cap Growth Inv0.45320.49385405215405210
Total 16.197319.821219316391+419010+2.2%

4. Summary

4.1. Key Performance Indicators

The key performance indicators of Celestica Inc. compared to the Most Recent Quarter (MRQ).

 End of day+/-Most Recent QuarterTrailing 12 Months+/-Year-Over-Year+/-5 Year+/-10 Year+/-
Book Value Change Per Share--0.2060.254-19%0.496-58%0.253-19%0.178+16%
Book Value Per Share--14.72314.206+4%12.722+16%11.890+24%10.158+45%
Current Ratio--1.4021.422-1%1.452-3%1.583-11%1.747-20%
Debt To Asset Ratio--0.7000.697+0%0.7000%0.656+7%0.599+17%
Debt To Equity Ratio--2.3312.304+1%2.3340%1.944+20%1.581+47%
Dividend Per Share--0.0980.111-12%0.000+5930003%0.031+219%0.175-44%
Eps--0.7050.510+38%0.295+139%0.251+181%0.227+210%
Free Cash Flow Per Share--0.8050.614+31%0.383+110%0.442+82%0.283+185%
Free Cash Flow To Equity Per Share--0.138-0.012+109%-0.039+128%0.058+139%0.091+51%
Gross Profit Margin--1.0001.0000%1.0000%1.0000%1.0000%
Intrinsic Value_10Y_max--47.365--------
Intrinsic Value_10Y_min--18.023--------
Intrinsic Value_1Y_max--2.220--------
Intrinsic Value_1Y_min--1.254--------
Intrinsic Value_3Y_max--8.596--------
Intrinsic Value_3Y_min--4.269--------
Intrinsic Value_5Y_max--17.293--------
Intrinsic Value_5Y_min--7.808--------
Market Cap5359409580.000+35%3498960000.0002436135500.000+44%1276504250.000+174%1336750800.000+162%1542327832.308+127%
Net Profit Margin--0.0380.030+28%0.020+93%0.018+112%0.018+117%
Operating Margin--0.0560.049+15%0.036+57%0.031+78%0.030+87%
Operating Ratio--0.9440.950-1%0.963-2%0.968-2%0.970-3%
Pb Ratio3.052+35%1.9891.416+40%0.814+144%0.870+129%1.118+78%
Pe Ratio15.945+35%10.38910.816-4%9.824+6%1.667+523%10.497-1%
Price Per Share44.940+35%29.28020.300+44%10.328+184%10.738+173%11.065+165%
Price To Free Cash Flow Ratio13.951+35%9.0908.870+2%9.1280%6.788+34%6.355+43%
Price To Total Gains Ratio147.983+35%96.4166.232+1447%26.415+265%38.375+151%61.701+56%
Quick Ratio--0.6770.605+12%0.594+14%0.797-15%0.939-28%
Return On Assets--0.0140.011+34%0.007+109%0.007+119%0.008+84%
Return On Equity--0.0480.035+35%0.023+108%0.020+140%0.020+139%
Total Gains Per Share--0.3040.366-17%0.496-39%0.284+7%0.353-14%
Usd Book Value--1759451823.0001707962955.750+3%1571600000.000+12%1494282591.150+18%1390041295.575+27%
Usd Book Value Change Per Share--0.2060.254-19%0.496-58%0.253-19%0.178+16%
Usd Book Value Per Share--14.72314.206+4%12.722+16%11.890+24%10.158+45%
Usd Dividend Per Share--0.0980.111-12%0.000+5930003%0.031+219%0.175-44%
Usd Eps--0.7050.510+38%0.295+139%0.251+181%0.227+210%
Usd Free Cash Flow--96232156.00073733039.000+31%47225000.000+104%55486607.800+73%37698303.900+155%
Usd Free Cash Flow Per Share--0.8050.614+31%0.383+110%0.442+82%0.283+185%
Usd Free Cash Flow To Equity Per Share--0.138-0.012+109%-0.039+128%0.058+139%0.091+51%
Usd Market Cap5359409580.000+35%3498960000.0002436135500.000+44%1276504250.000+174%1336750800.000+162%1542327832.308+127%
Usd Price Per Share44.940+35%29.28020.300+44%10.328+184%10.738+173%11.065+165%
Usd Profit--84200000.00061150000.000+38%36375000.000+131%31245000.000+169%28505000.000+195%
Usd Revenue--2199660062.0002005040015.500+10%1812500000.000+21%1627063003.100+35%1564299001.550+41%
Usd Total Gains Per Share--0.3040.366-17%0.496-39%0.284+7%0.353-14%
 EOD+4 -4MRQTTM+23 -12YOY+27 -85Y+25 -1010Y+24 -11

4.2. Fundamental Score

Let's check the fundamental score of Celestica Inc. based on Penke's default stock scanner.

Penke's Stock Scanner

  
  
IndicatorConditionValue
Price to Earnings Ratio (EOD)Between0-1515.945
Price to Book Ratio (EOD)Between0-13.052
Net Profit Margin (MRQ)Greater than00.038
Operating Margin (MRQ)Greater than00.056
Quick Ratio (MRQ)Greater than10.677
Current Ratio (MRQ)Greater than11.402
Debt to Asset Ratio (MRQ)Less than10.700
Debt to Equity Ratio (MRQ)Less than12.331
Return on Equity (MRQ)Greater than0.150.048
Return on Assets (MRQ)Greater than0.050.014
Total4/10 (40.0%)

4.3. Technical Score

Let's check the technical score of Celestica Inc. based on Penke's default Symbol scanner.

Penke's Symbol Scanner

  
  
IndicatorConditionValue
RsiGreater than5054.942
Ma 20Greater thanMa 5045.512
Ma 50Greater thanMa 10040.051
Ma 100Greater thanMa 20033.858
OpenGreater thanClose45.250
Total5/5 (100.0%)



Latest Balance Sheet

Balance Sheet of 2023-12-31. Currency in USD. All numbers in thousands.

Summary
Total Assets5,860,561
Total Liabilities4,101,110
Total Stockholder Equity1,759,452
 As reported
Total Liabilities 4,101,110
Total Stockholder Equity+ 1,759,452
Total Assets = 5,860,561

Assets

Total Assets5,860,561
Total Current Assets4,489,512
Long-term Assets1,371,049
Total Current Assets
Cash And Cash Equivalents 368,505
Net Receivables 1,798,352
Inventory 2,095,325
Other Current Assets 227,331
Total Current Assets  (as reported)4,489,512
Total Current Assets  (calculated)4,489,512
+/- 0
Long-term Assets
Property Plant Equipment 623,494
Goodwill 320,054
Intangible Assets 325,200
Long-term Assets Other 27,532
Long-term Assets  (as reported)1,371,049
Long-term Assets  (calculated)1,296,279
+/- 74,770

Liabilities & Shareholders' Equity

Total Current Liabilities3,203,028
Long-term Liabilities898,082
Total Stockholder Equity1,759,452
Total Current Liabilities
Short-term Debt 51,336
Short Long Term Debt 17,000
Accounts payable 1,291,558
Other Current Liabilities 1,795,666
Total Current Liabilities  (as reported)3,203,028
Total Current Liabilities  (calculated)3,155,560
+/- 47,468
Long-term Liabilities
Long term Debt 589,300
Capital Lease Obligations 176,500
Long-term Liabilities Other 41,200
Long-term Liabilities  (as reported)898,082
Long-term Liabilities  (calculated)807,000
+/- 91,082
Total Stockholder Equity
Common Stock1,663,943
Retained Earnings -835,304
Accumulated Other Comprehensive Income -14,824
Other Stockholders Equity 945,637
Total Stockholder Equity (as reported)1,759,452
Total Stockholder Equity (calculated)1,759,452
+/-0
Other
Capital Stock1,672,500
Cash and Short Term Investments 368,505
Common Stock Shares Outstanding 119,500
Current Deferred Revenue64,468
Liabilities and Stockholders Equity 5,860,561
Net Debt 410,290
Net Invested Capital 2,374,800
Net Working Capital 1,293,100
Property Plant and Equipment Gross 1,529,600
Short Long Term Debt Total 778,795



Balance Sheet

Currency in USD. All numbers in thousands.

 Trend2023-12-312023-09-302023-06-302023-03-312022-12-312022-09-302022-06-302022-03-312021-12-312021-09-302021-06-302021-03-312020-12-312020-09-302020-06-302020-03-312019-12-312019-09-302019-06-302019-03-312018-12-312018-09-302018-06-302018-03-312017-12-312017-09-302017-06-302017-03-312016-12-312016-09-302016-06-302016-03-312015-12-312015-09-302015-06-302015-03-312014-12-312014-09-302014-06-302014-03-312013-12-312013-09-302013-06-302013-03-312012-12-312012-09-302012-06-302012-03-312011-12-312011-09-302011-06-302011-03-312010-12-312010-09-302010-06-302010-03-312009-12-312009-09-302009-06-302009-03-312008-12-312008-09-302008-06-302008-03-312007-12-312007-09-302007-06-302007-03-312006-12-312006-09-302006-06-302006-03-312005-12-312005-09-302005-06-302005-03-312004-12-312004-09-302004-06-302004-03-312003-12-312003-09-302003-06-302003-03-312002-12-312002-09-302002-06-302002-03-312001-12-312001-09-302001-06-302001-03-312000-12-312000-09-302000-06-302000-03-311999-12-311999-09-301999-06-301999-03-311998-12-311998-09-301998-06-301998-03-311997-12-311997-09-301997-06-301997-03-31
> Total Assets 
0
0
0
1,346,400
1,392,500
1,408,600
1,395,900
1,636,400
1,981,300
1,420,800
2,273,100
2,655,600
3,636,014
3,997,304
5,473,597
5,937,985
5,937,985
6,001,580
5,937,592
6,632,900
6,632,900
6,821,600
6,491,700
5,806,800
5,806,800
5,335,100
5,168,900
5,134,700
5,134,700
5,702,800
5,674,600
4,939,800
4,898,600
5,188,400
4,692,700
4,857,800
4,786,500
4,872,800
4,897,300
4,686,300
4,281,800
4,291,100
4,509,300
4,470,500
4,400,000
4,505,600
4,715,000
3,786,200
3,185,600
3,245,400
3,469,800
3,106,100
2,891,600
2,784,800
2,918,200
3,103,600
2,997,300
3,020,600
2,914,800
2,969,600
2,955,400
2,951,200
2,885,500
2,658,800
2,643,400
2,705,500
2,714,400
2,638,900
2,590,700
2,673,300
2,666,300
2,583,600
2,579,300
2,624,700
2,603,600
2,612,000
2,621,900
2,720,100
2,813,700
2,822,300
2,814,600
2,857,700
2,871,700
2,944,700
2,976,000
3,212,200
3,316,100
3,737,700
3,688,100
3,633,700
3,557,600
3,560,700
3,537,800
3,788,100
3,789,300
3,664,100
3,553,400
3,745,400
4,026,100
4,666,900
4,848,000
5,140,500
5,347,900
5,628,000
5,468,100
5,500,500
5,745,300
5,860,561
5,860,5615,745,3005,500,5005,468,1005,628,0005,347,9005,140,5004,848,0004,666,9004,026,1003,745,4003,553,4003,664,1003,789,3003,788,1003,537,8003,560,7003,557,6003,633,7003,688,1003,737,7003,316,1003,212,2002,976,0002,944,7002,871,7002,857,7002,814,6002,822,3002,813,7002,720,1002,621,9002,612,0002,603,6002,624,7002,579,3002,583,6002,666,3002,673,3002,590,7002,638,9002,714,4002,705,5002,643,4002,658,8002,885,5002,951,2002,955,4002,969,6002,914,8003,020,6002,997,3003,103,6002,918,2002,784,8002,891,6003,106,1003,469,8003,245,4003,185,6003,786,2004,715,0004,505,6004,400,0004,470,5004,509,3004,291,1004,281,8004,686,3004,897,3004,872,8004,786,5004,857,8004,692,7005,188,4004,898,6004,939,8005,674,6005,702,8005,134,7005,134,7005,168,9005,335,1005,806,8005,806,8006,491,7006,821,6006,632,9006,632,9005,937,5926,001,5805,937,9855,937,9855,473,5973,997,3043,636,0142,655,6002,273,1001,420,8001,981,3001,636,4001,395,9001,408,6001,392,5001,346,400000
   > Total Current Assets 
0
0
0
830,800
886,300
878,700
855,800
982,900
1,300,600
890,900
1,512,200
1,851,300
2,717,876
2,802,014
4,237,367
4,520,964
4,520,964
4,539,362
4,114,545
3,996,600
3,996,600
4,113,500
3,917,400
3,564,500
3,564,500
3,120,100
2,951,100
3,030,100
3,030,100
3,284,400
3,306,400
3,273,300
3,256,400
3,559,200
3,079,200
3,258,400
3,153,300
3,239,900
3,308,100
3,120,800
2,760,000
2,776,000
3,013,900
2,999,600
2,924,300
3,044,600
3,264,200
3,171,800
2,596,500
2,654,400
2,894,400
2,542,800
2,335,800
2,236,600
2,350,600
2,531,400
2,542,700
2,521,800
2,423,000
2,462,600
2,429,400
2,441,500
2,305,100
2,110,700
2,111,500
2,178,900
2,189,900
2,120,500
2,066,800
2,147,200
2,149,000
2,104,200
2,099,400
2,128,400
2,091,800
2,124,000
2,137,900
2,246,800
2,345,400
2,346,500
2,356,400
2,387,000
2,392,600
2,455,500
2,486,700
2,652,500
2,751,300
2,823,500
2,675,400
2,629,500
2,579,100
2,592,000
2,590,600
2,850,100
2,860,100
2,737,200
2,640,800
2,840,700
3,103,200
3,435,300
3,630,400
3,897,500
4,071,700
4,327,000
4,175,900
4,196,600
4,425,700
4,489,512
4,489,5124,425,7004,196,6004,175,9004,327,0004,071,7003,897,5003,630,4003,435,3003,103,2002,840,7002,640,8002,737,2002,860,1002,850,1002,590,6002,592,0002,579,1002,629,5002,675,4002,823,5002,751,3002,652,5002,486,7002,455,5002,392,6002,387,0002,356,4002,346,5002,345,4002,246,8002,137,9002,124,0002,091,8002,128,4002,099,4002,104,2002,149,0002,147,2002,066,8002,120,5002,189,9002,178,9002,111,5002,110,7002,305,1002,441,5002,429,4002,462,6002,423,0002,521,8002,542,7002,531,4002,350,6002,236,6002,335,8002,542,8002,894,4002,654,4002,596,5003,171,8003,264,2003,044,6002,924,3002,999,6003,013,9002,776,0002,760,0003,120,8003,308,1003,239,9003,153,3003,258,4003,079,2003,559,2003,256,4003,273,3003,306,4003,284,4003,030,1003,030,1002,951,1003,120,1003,564,5003,564,5003,917,4004,113,5003,996,6003,996,6004,114,5454,539,3624,520,9644,520,9644,237,3672,802,0142,717,8761,851,3001,512,200890,9001,300,600982,900855,800878,700886,300830,800000
       Cash And Cash Equivalents 
0
0
0
105,200
98,400
101,100
70,300
31,700
208,700
113,200
73,400
371,500
930,389
283,648
942,494
883,757
883,757
1,261,259
965,899
1,342,800
1,342,800
1,683,700
1,848,300
1,851,000
1,851,000
1,454,800
1,209,500
1,028,800
1,028,800
802,800
974,500
968,800
951,400
1,298,500
895,500
969,000
776,000
748,100
778,800
803,700
704,100
747,000
953,100
1,116,700
1,149,300
1,203,000
1,258,200
1,201,000
1,081,300
1,119,300
1,261,400
937,700
712,200
683,900
705,600
632,800
584,000
552,600
586,100
658,900
646,700
630,600
598,200
550,500
531,300
553,500
546,800
544,300
489,200
519,100
578,200
565,000
569,200
496,800
495,700
545,300
511,500
472,900
542,000
557,200
558,000
582,700
527,000
515,200
435,700
401,400
457,700
422,000
457,800
436,500
448,900
479,500
472,100
435,900
451,400
463,800
449,400
467,200
477,200
394,000
346,600
365,500
363,300
374,500
318,700
360,700
353,100
368,505
368,505353,100360,700318,700374,500363,300365,500346,600394,000477,200467,200449,400463,800451,400435,900472,100479,500448,900436,500457,800422,000457,700401,400435,700515,200527,000582,700558,000557,200542,000472,900511,500545,300495,700496,800569,200565,000578,200519,100489,200544,300546,800553,500531,300550,500598,200630,600646,700658,900586,100552,600584,000632,800705,600683,900712,200937,7001,261,4001,119,3001,081,3001,201,0001,258,2001,203,0001,149,3001,116,700953,100747,000704,100803,700778,800748,100776,000969,000895,5001,298,500951,400968,800974,500802,8001,028,8001,028,8001,209,5001,454,8001,851,0001,851,0001,848,3001,683,7001,342,8001,342,800965,8991,261,259883,757883,757942,494283,648930,389371,50073,400113,200208,70031,70070,300101,10098,400105,200000
       Short-term Investments 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
794,800
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
000000000000000000000000000000000000000000000000000000000000794,80000000000000000000000000000000000000000000000000
       Net Receivables 
0
0
0
372,100
382,500
342,300
371,300
463,000
491,600
342,300
595,300
700,800
797,666
1,110,079
1,501,027
1,785,716
1,785,716
1,615,967
1,313,473
1,054,100
1,054,100
1,101,500
924,000
785,900
785,900
632,200
658,700
771,500
771,500
1,034,800
929,200
1,023,300
946,100
910,300
856,600
982,600
985,400
1,131,100
1,093,100
973,200
874,600
972,200
1,001,500
941,200
855,500
893,300
1,040,100
1,088,100
748,500
827,600
874,500
849,300
821,100
805,800
797,000
960,700
858,500
840,100
791,600
819,900
769,800
832,500
788,800
714,300
700,800
693,500
667,000
667,700
662,400
753,300
702,700
704,900
656,700
682,500
656,000
691,400
666,000
754,600
763,000
795,900
726,100
732,800
733,400
766,400
1,006,500
1,127,100
1,135,700
1,211,600
1,042,900
1,030,400
1,020,400
1,060,400
988,300
1,139,900
1,130,100
1,100,200
971,600
1,092,600
1,156,600
1,268,900
1,252,000
1,220,400
1,169,500
1,399,400
1,265,400
1,310,900
1,608,600
1,798,352
1,798,3521,608,6001,310,9001,265,4001,399,4001,169,5001,220,4001,252,0001,268,9001,156,6001,092,600971,6001,100,2001,130,1001,139,900988,3001,060,4001,020,4001,030,4001,042,9001,211,6001,135,7001,127,1001,006,500766,400733,400732,800726,100795,900763,000754,600666,000691,400656,000682,500656,700704,900702,700753,300662,400667,700667,000693,500700,800714,300788,800832,500769,800819,900791,600840,100858,500960,700797,000805,800821,100849,300874,500827,600748,5001,088,1001,040,100893,300855,500941,2001,001,500972,200874,600973,2001,093,1001,131,100985,400982,600856,600910,300946,1001,023,300929,2001,034,800771,500771,500658,700632,200785,900785,900924,0001,101,5001,054,1001,054,1001,313,4731,615,9671,785,7161,785,7161,501,0271,110,079797,666700,800595,300342,300491,600463,000371,300342,300382,500372,100000
       Other Current Assets 
0
0
0
40,600
57,800
56,600
63,700
57,300
63,100
56,700
58,100
56,700
78,873
117,622
172,578
187,187
187,187
145,047
164,036
227,000
227,000
211,400
199,300
152,000
152,000
198,200
192,800
199,200
199,200
237,700
230,600
89,100
88,600
85,600
84,400
113,500
91,800
120,400
123,200
31,200
100,600
101,900
132,400
19,800
113,600
32,900
34,400
95,300
71,600
73,200
61,000
79,700
78,200
70,100
83,700
92,200
118,900
84,400
66,200
71,000
69,200
64,200
76,800
69,400
61,300
60,600
63,700
61,100
59,500
63,000
64,000
87,000
91,300
101,900
63,800
65,300
77,100
86,300
83,400
73,900
82,400
67,000
79,900
82,000
85,600
89,700
68,100
72,600
83,600
63,800
63,300
59,200
56,700
68,200
73,400
81,700
66,200
56,000
63,500
75,400
88,000
203,800
213,100
202,800
188,500
179,400
202,900
227,331
227,331202,900179,400188,500202,800213,100203,80088,00075,40063,50056,00066,20081,70073,40068,20056,70059,20063,30063,80083,60072,60068,10089,70085,60082,00079,90067,00082,40073,90083,40086,30077,10065,30063,800101,90091,30087,00064,00063,00059,50061,10063,70060,60061,30069,40076,80064,20069,20071,00066,20084,400118,90092,20083,70070,10078,20079,70061,00073,20071,60095,30034,40032,900113,60019,800132,400101,900100,60031,200123,200120,40091,800113,50084,40085,60088,60089,100230,600237,700199,200199,200192,800198,200152,000152,000199,300211,400227,000227,000164,036145,047187,187187,187172,578117,62278,87356,70058,10056,70063,10057,30063,70056,60057,80040,600000
   > Long-term Assets 
0
0
0
515,600
506,200
529,900
540,100
653,500
680,700
529,900
760,900
804,300
918,138
1,195,290
1,236,230
1,417,021
1,417,021
1,462,218
1,823,047
2,636,300
2,636,300
2,708,100
2,574,300
2,242,300
2,242,300
2,215,000
2,217,800
2,104,600
2,104,600
2,418,400
2,368,200
1,666,500
1,642,200
1,629,200
1,613,500
1,599,400
1,633,200
1,632,900
1,589,200
1,565,500
1,521,800
1,515,100
1,495,400
1,470,900
1,475,700
1,461,000
1,450,800
614,400
589,100
591,000
575,400
563,300
555,800
548,200
567,600
572,200
454,600
498,800
491,800
507,000
526,000
509,700
580,400
548,100
531,900
526,600
524,500
518,400
523,900
526,100
517,300
479,400
479,900
496,300
511,800
488,000
484,000
473,300
468,300
475,800
458,200
470,700
479,100
489,200
489,300
559,700
564,800
914,200
1,012,700
1,004,200
978,500
968,700
947,200
938,000
929,200
926,900
912,600
904,700
922,900
1,231,600
1,217,600
1,243,000
1,276,200
1,301,000
1,292,200
1,303,900
1,319,600
1,371,049
1,371,0491,319,6001,303,9001,292,2001,301,0001,276,2001,243,0001,217,6001,231,600922,900904,700912,600926,900929,200938,000947,200968,700978,5001,004,2001,012,700914,200564,800559,700489,300489,200479,100470,700458,200475,800468,300473,300484,000488,000511,800496,300479,900479,400517,300526,100523,900518,400524,500526,600531,900548,100580,400509,700526,000507,000491,800498,800454,600572,200567,600548,200555,800563,300575,400591,000589,100614,4001,450,8001,461,0001,475,7001,470,9001,495,4001,515,1001,521,8001,565,5001,589,2001,632,9001,633,2001,599,4001,613,5001,629,2001,642,2001,666,5002,368,2002,418,4002,104,6002,104,6002,217,8002,215,0002,242,3002,242,3002,574,3002,708,1002,636,3002,636,3001,823,0471,462,2181,417,0211,417,0211,236,2301,195,290918,138804,300760,900529,900680,700653,500540,100529,900506,200515,600000
       Property Plant Equipment 
0
0
0
124,200
148,900
175,400
180,500
214,900
242,700
175,400
326,200
365,400
417,598
508,057
544,377
633,438
633,438
752,667
890,824
915,100
915,100
929,400
831,400
727,800
727,800
692,200
688,100
679,600
679,600
708,300
669,700
569,300
554,800
534,800
545,300
544,800
582,000
609,100
576,700
567,100
541,000
530,300
513,000
466,000
462,500
465,100
462,900
467,500
432,700
422,400
410,000
393,800
380,300
372,700
368,200
368,700
333,100
330,900
328,600
322,700
338,900
327,000
346,800
337,000
327,600
322,900
319,500
313,600
316,700
318,100
314,600
312,400
310,100
314,700
324,600
314,600
313,800
310,200
314,600
302,700
301,700
309,100
318,200
323,900
319,500
340,400
344,300
365,300
473,300
474,200
462,800
459,100
444,000
436,900
435,300
433,500
423,500
419,400
435,100
452,500
436,000
463,900
483,500
510,300
509,200
531,300
552,300
623,494
623,494552,300531,300509,200510,300483,500463,900436,000452,500435,100419,400423,500433,500435,300436,900444,000459,100462,800474,200473,300365,300344,300340,400319,500323,900318,200309,100301,700302,700314,600310,200313,800314,600324,600314,700310,100312,400314,600318,100316,700313,600319,500322,900327,600337,000346,800327,000338,900322,700328,600330,900333,100368,700368,200372,700380,300393,800410,000422,400432,700467,500462,900465,100462,500466,000513,000530,300541,000567,100576,700609,100582,000544,800545,300534,800554,800569,300669,700708,300679,600679,600688,100692,200727,800727,800831,400929,400915,100915,100890,824752,667633,438633,438544,377508,057417,598365,400326,200175,400242,700214,900180,500175,400148,900124,200000
       Goodwill 
0
0
0
352,300
307,100
308,300
300,100
374,500
360,500
308,300
349,000
367,600
417,078
592,288
589,554
578,272
555,287
566,662
794,630
1,556,000
1,580,100
1,558,400
1,510,600
1,159,900
1,149,400
1,135,300
1,123,300
1,085,900
1,341,200
1,335,500
1,316,900
977,400
970,200
963,200
959,200
874,500
874,800
854,800
854,800
854,800
854,800
854,800
854,800
850,500
850,500
850,500
850,500
20,100
49,000
44,900
40,700
43,200
3,000
3,000
10,600
11,000
15,300
46,500
48,700
48,000
48,400
47,500
73,300
60,300
60,300
60,300
60,300
60,300
60,300
60,300
60,300
19,500
19,500
19,500
19,500
19,500
19,500
19,500
19,500
23,200
23,200
23,200
23,200
23,200
23,200
87,200
87,200
198,400
202,800
202,600
198,100
198,300
198,100
198,200
198,300
198,600
198,400
198,400
198,200
324,200
321,900
321,700
321,300
321,800
321,600
321,600
321,500
320,054
320,054321,500321,600321,600321,800321,300321,700321,900324,200198,200198,400198,400198,600198,300198,200198,100198,300198,100202,600202,800198,40087,20087,20023,20023,20023,20023,20023,20023,20019,50019,50019,50019,50019,50019,50019,50019,50060,30060,30060,30060,30060,30060,30060,30060,30073,30047,50048,40048,00048,70046,50015,30011,00010,6003,0003,00043,20040,70044,90049,00020,100850,500850,500850,500850,500854,800854,800854,800854,800854,800854,800874,800874,500959,200963,200970,200977,4001,316,9001,335,5001,341,2001,085,9001,123,3001,135,3001,149,4001,159,9001,510,6001,558,4001,580,1001,556,000794,630566,662555,287578,272589,554592,288417,078367,600349,000308,300360,500374,500300,100308,300307,100352,300000
       Long Term Investments 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
00000000000000000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
       Intangible Assets 
0
0
0
352,300
307,100
308,300
300,100
374,500
360,500
308,300
349,000
367,600
417,078
592,288
589,554
578,272
578,272
566,662
794,630
1,556,000
1,556,000
1,558,400
1,510,600
1,159,900
1,159,900
1,135,300
1,123,300
1,085,900
1,085,900
1,335,500
1,316,900
977,400
970,200
963,200
959,200
79,000
80,100
74,200
67,400
60,100
54,100
49,000
43,900
35,200
31,000
26,800
23,400
20,100
49,000
44,900
40,700
43,200
33,500
30,000
39,500
33,000
31,500
41,200
37,700
35,500
34,900
32,800
56,000
53,000
50,200
47,600
45,900
44,200
42,000
39,900
37,400
35,200
33,500
32,300
31,700
30,400
28,800
27,300
26,300
25,500
25,200
23,200
22,600
21,600
20,900
68,800
65,600
283,600
273,100
266,300
257,900
251,300
245,000
240,200
234,600
229,400
224,600
220,100
216,400
382,000
375,300
365,500
356,100
346,500
336,600
327,000
317,600
325,200
325,200317,600327,000336,600346,500356,100365,500375,300382,000216,400220,100224,600229,400234,600240,200245,000251,300257,900266,300273,100283,60065,60068,80020,90021,60022,60023,20025,20025,50026,30027,30028,80030,40031,70032,30033,50035,20037,40039,90042,00044,20045,90047,60050,20053,00056,00032,80034,90035,50037,70041,20031,50033,00039,50030,00033,50043,20040,70044,90049,00020,10023,40026,80031,00035,20043,90049,00054,10060,10067,40074,20080,10079,000959,200963,200970,200977,4001,316,9001,335,5001,085,9001,085,9001,123,3001,135,3001,159,9001,159,9001,510,6001,558,4001,556,0001,556,000794,630566,662578,272578,272589,554592,288417,078367,600349,000308,300360,500374,500300,100308,300307,100352,300000
       Other Assets 
0
0
0
0
0
0
0
0
0
0
0
0
500,540
687,233
691,853
783,583
759,277
709,551
932,223
1,721,200
1,783,800
1,778,700
1,742,900
1,514,500
1,505,800
1,522,800
1,529,700
1,425,000
1,691,100
1,710,100
1,698,500
1,097,200
1,087,400
1,094,400
1,068,200
1,054,600
1,051,200
1,023,800
1,012,500
998,400
980,800
984,800
982,400
1,004,900
1,013,200
995,900
987,900
146,900
156,400
168,600
165,400
169,500
175,500
175,500
199,400
203,500
121,500
167,900
163,200
184,300
187,100
182,700
233,600
211,100
204,300
203,700
205,000
204,800
207,200
208,000
202,700
167,000
169,800
181,600
187,200
173,400
170,200
163,100
153,700
113,400
156,500
161,600
160,900
165,300
169,800
63,300
67,200
56,800
63,500
61,100
59,700
50,300
60,100
62,700
61,000
56,100
65,800
66,600
73,100
72,900
78,900
91,900
95,700
122,400
124,800
124,000
128,200
0
0128,200124,000124,800122,40095,70091,90078,90072,90073,10066,60065,80056,10061,00062,70060,10050,30059,70061,10063,50056,80067,20063,300169,800165,300160,900161,600156,500113,400153,700163,100170,200173,400187,200181,600169,800167,000202,700208,000207,200204,800205,000203,700204,300211,100233,600182,700187,100184,300163,200167,900121,500203,500199,400175,500175,500169,500165,400168,600156,400146,900987,900995,9001,013,2001,004,900982,400984,800980,800998,4001,012,5001,023,8001,051,2001,054,6001,068,2001,094,4001,087,4001,097,2001,698,5001,710,1001,691,1001,425,0001,529,7001,522,8001,505,8001,514,5001,742,9001,778,7001,783,8001,721,200932,223709,551759,277783,583691,853687,233500,540000000000000
> Total Liabilities 
0
0
0
983,200
1,061,200
1,085,700
667,000
777,100
854,400
1,097,900
1,106,600
997,500
1,205,649
1,534,512
2,100,204
2,468,716
2,468,716
1,738,453
1,527,961
1,887,300
1,887,300
1,966,400
1,790,500
1,603,200
1,603,200
1,497,200
1,522,700
1,666,400
1,666,400
2,288,100
2,276,100
2,451,000
2,421,400
2,700,200
2,454,500
2,643,400
2,580,500
2,686,800
2,750,700
2,591,700
2,224,400
2,191,000
2,385,300
2,352,300
2,247,600
2,315,300
2,506,600
2,420,700
1,792,600
1,808,800
2,012,600
1,630,300
1,379,400
1,293,100
1,416,000
1,682,300
1,664,000
1,636,100
1,516,600
1,505,800
1,480,300
1,490,800
1,376,600
1,342,100
1,299,000
1,345,600
1,313,200
1,236,900
1,165,600
1,204,700
1,206,700
1,188,700
1,178,000
1,536,200
1,517,300
1,521,000
1,504,000
1,558,000
1,602,400
1,583,500
1,540,900
1,536,000
1,514,200
1,594,000
1,620,300
1,921,800
2,027,500
2,405,400
2,295,900
2,261,700
2,192,500
2,204,500
2,198,900
2,425,800
2,388,800
2,255,100
2,142,800
2,317,100
2,556,800
3,203,900
3,338,600
3,610,900
3,778,200
3,950,300
3,812,600
3,819,900
4,009,000
4,101,110
4,101,1104,009,0003,819,9003,812,6003,950,3003,778,2003,610,9003,338,6003,203,9002,556,8002,317,1002,142,8002,255,1002,388,8002,425,8002,198,9002,204,5002,192,5002,261,7002,295,9002,405,4002,027,5001,921,8001,620,3001,594,0001,514,2001,536,0001,540,9001,583,5001,602,4001,558,0001,504,0001,521,0001,517,3001,536,2001,178,0001,188,7001,206,7001,204,7001,165,6001,236,9001,313,2001,345,6001,299,0001,342,1001,376,6001,490,8001,480,3001,505,8001,516,6001,636,1001,664,0001,682,3001,416,0001,293,1001,379,4001,630,3002,012,6001,808,8001,792,6002,420,7002,506,6002,315,3002,247,6002,352,3002,385,3002,191,0002,224,4002,591,7002,750,7002,686,8002,580,5002,643,4002,454,5002,700,2002,421,4002,451,0002,276,1002,288,1001,666,4001,666,4001,522,7001,497,2001,603,2001,603,2001,790,5001,966,4001,887,3001,887,3001,527,9611,738,4532,468,7162,468,7162,100,2041,534,5121,205,649997,5001,106,6001,097,900854,400777,100667,0001,085,7001,061,200983,200000
   > Total Current Liabilities 
0
0
0
467,600
521,800
513,600
524,000
626,700
702,200
525,800
955,700
851,100
1,051,138
1,339,772
1,913,713
2,258,408
2,258,408
1,550,597
1,335,948
1,656,800
1,656,800
1,708,800
1,652,000
1,471,300
1,471,300
1,347,300
1,370,100
1,516,500
1,516,500
1,604,900
1,594,100
1,815,000
1,785,900
1,815,000
1,575,800
1,770,300
1,712,800
1,820,700
1,915,800
1,725,900
1,355,400
1,344,000
1,488,000
1,446,600
1,335,500
1,409,900
1,606,300
1,568,400
1,098,800
1,114,000
1,673,900
1,519,800
1,269,600
1,182,800
1,300,500
1,562,500
1,483,100
1,462,300
1,348,600
1,346,600
1,317,800
1,332,100
1,209,600
1,198,900
1,165,700
1,214,800
1,177,500
1,109,200
1,035,700
1,077,200
1,071,700
1,054,300
1,044,800
1,173,300
1,138,100
1,133,400
1,122,800
1,206,600
1,248,600
1,245,700
1,206,500
1,208,400
1,191,600
1,266,800
1,304,900
1,422,100
1,534,300
1,620,300
1,477,900
1,439,100
1,971,500
1,474,300
1,473,100
1,760,400
1,713,500
1,578,200
1,490,600
1,656,700
1,856,500
2,253,500
2,407,000
2,681,600
2,848,900
3,055,200
2,925,000
2,936,000
3,096,600
3,203,028
3,203,0283,096,6002,936,0002,925,0003,055,2002,848,9002,681,6002,407,0002,253,5001,856,5001,656,7001,490,6001,578,2001,713,5001,760,4001,473,1001,474,3001,971,5001,439,1001,477,9001,620,3001,534,3001,422,1001,304,9001,266,8001,191,6001,208,4001,206,5001,245,7001,248,6001,206,6001,122,8001,133,4001,138,1001,173,3001,044,8001,054,3001,071,7001,077,2001,035,7001,109,2001,177,5001,214,8001,165,7001,198,9001,209,6001,332,1001,317,8001,346,6001,348,6001,462,3001,483,1001,562,5001,300,5001,182,8001,269,6001,519,8001,673,9001,114,0001,098,8001,568,4001,606,3001,409,9001,335,5001,446,6001,488,0001,344,0001,355,4001,725,9001,915,8001,820,7001,712,8001,770,3001,575,8001,815,0001,785,9001,815,0001,594,1001,604,9001,516,5001,516,5001,370,1001,347,3001,471,3001,471,3001,652,0001,708,8001,656,8001,656,8001,335,9481,550,5972,258,4082,258,4081,913,7131,339,7721,051,138851,100955,700525,800702,200626,700524,000513,600521,800467,600000
       Short-term Debt 
0
0
0
15,000
16,400
15,600
1,900
2,300
2,300
27,800
2,800
2,700
2,569
2,365
1,922
1,364
1,364
413
187
10,000
10,000
3,100
2,700
2,700
2,700
3,200
3,100
2,700
2,700
3,700
3,100
126,700
127,500
130,800
200
500
400
500
500
600
600
500
300
200
200
0
1,200
1,000
400
100
357,400
222,800
0
0
0
0
0
45,000
0
0
0
0
0
55,000
20,000
0
0
0
0
0
0
29,100
0
51,000
52,800
29,100
69,000
84,100
69,200
56,000
41,000
40,000
38,900
37,900
26,800
8,300
61,000
107,700
133,100
89,900
629,200
132,600
75,600
76,300
75,900
99,800
83,600
80,900
55,700
51,500
59,600
69,500
51,400
52,200
51,100
65,400
51,200
51,336
51,33651,20065,40051,10052,20051,40069,50059,60051,50055,70080,90083,60099,80075,90076,30075,600132,600629,20089,900133,100107,70061,0008,30026,80037,90038,90040,00041,00056,00069,20084,10069,00029,10052,80051,000029,10000000020,00055,0000000045,00000000222,800357,4001004001,0001,2000200200300500600600500500400500200130,800127,500126,7003,1003,7002,7002,7003,1003,2002,7002,7002,7003,10010,00010,0001874131,3641,3641,9222,3652,5692,7002,80027,8002,3002,3001,90015,60016,40015,000000
       Short Long Term Debt 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
29,100
0
0
0
29,100
0
0
0
40,700
227,300
219,700
26,700
26,800
26,800
8,300
61,000
104,500
133,100
89,900
629,200
139,600
75,600
76,300
75,900
99,800
83,600
80,900
55,700
51,500
59,600
69,500
51,400
52,200
51,100
65,400
51,200
17,000
17,00051,20065,40051,10052,20051,40069,50059,60051,50055,70080,90083,60099,80075,90076,30075,600139,600629,20089,900133,100104,50061,0008,30026,80026,80026,700219,700227,30040,70000029,10000029,10000000000000000000000000000000000000000000000000000000000000000000000000
       Accounts payable 
0
0
0
445,600
495,600
494,100
519,100
428,500
696,700
494,100
949,600
613,100
1,042,377
1,331,215
1,905,599
2,249,342
2,249,342
1,020,785
886,541
1,198,300
1,198,300
1,167,600
1,137,600
947,200
947,200
911,200
938,800
1,101,900
1,101,900
1,129,200
1,090,200
1,107,900
1,145,800
1,147,200
1,057,800
1,153,300
1,199,300
1,289,400
1,414,200
1,193,600
957,900
937,400
1,097,200
1,029,800
981,000
1,024,100
1,169,000
1,090,600
781,400
790,500
1,001,600
927,100
978,300
856,500
945,800
1,176,200
1,161,200
1,089,900
1,010,900
1,002,600
1,031,200
1,027,300
906,600
831,600
868,200
904,000
856,600
770,700
790,600
806,200
781,400
730,900
751,400
803,900
767,500
801,400
809,000
856,600
888,800
876,900
892,300
888,700
864,000
931,100
988,700
1,118,800
1,147,800
1,126,700
943,200
937,900
937,200
898,000
932,000
1,116,900
1,046,500
854,500
857,900
964,400
1,095,400
1,238,300
1,400,200
1,506,200
1,482,600
1,440,800
1,338,700
1,276,700
1,322,600
1,291,558
1,291,5581,322,6001,276,7001,338,7001,440,8001,482,6001,506,2001,400,2001,238,3001,095,400964,400857,900854,5001,046,5001,116,900932,000898,000937,200937,900943,2001,126,7001,147,8001,118,800988,700931,100864,000888,700892,300876,900888,800856,600809,000801,400767,500803,900751,400730,900781,400806,200790,600770,700856,600904,000868,200831,600906,6001,027,3001,031,2001,002,6001,010,9001,089,9001,161,2001,176,200945,800856,500978,300927,1001,001,600790,500781,4001,090,6001,169,0001,024,100981,0001,029,8001,097,200937,400957,9001,193,6001,414,2001,289,4001,199,3001,153,3001,057,8001,147,2001,145,8001,107,9001,090,2001,129,2001,101,9001,101,900938,800911,200947,200947,2001,137,6001,167,6001,198,3001,198,300886,5411,020,7852,249,3422,249,3421,905,5991,331,2151,042,377613,100949,600494,100696,700428,500519,100494,100495,600445,600000
       Other Current Liabilities 
0
0
0
7,000
9,800
3,900
3,000
195,900
3,200
3,900
3,300
235,300
6,192
6,192
6,192
7,702
7,702
529,399
16,170
21,000
21,000
28,300
18,200
24,500
24,500
42,200
35,300
8,200
8,200
12,200
11,300
93,200
88,800
89,200
92,800
119,900
102,700
101,000
102,100
42,700
44,100
44,700
21,500
14,000
15,900
385,800
20,300
463,300
304,800
312,700
600
331,900
291,300
326,300
354,700
386,300
321,900
279,100
337,700
344,000
286,600
304,800
303,000
274,500
240,200
310,800
320,900
338,500
245,100
271,000
290,300
323,400
293,400
296,800
290,200
277,900
219,200
238,000
263,100
280,400
235,800
239,300
248,500
258,600
250,600
261,500
290,300
348,300
355,700
366,800
354,900
410,100
427,800
519,200
541,500
584,000
504,200
563,400
650,900
916,000
947,200
1,105,900
1,314,900
1,493,300
1,535,200
1,593,900
1,722,800
1,795,666
1,795,6661,722,8001,593,9001,535,2001,493,3001,314,9001,105,900947,200916,000650,900563,400504,200584,000541,500519,200427,800410,100354,900366,800355,700348,300290,300261,500250,600258,600248,500239,300235,800280,400263,100238,000219,200277,900290,200296,800293,400323,400290,300271,000245,100338,500320,900310,800240,200274,500303,000304,800286,600344,000337,700279,100321,900386,300354,700326,300291,300331,900600312,700304,800463,30020,300385,80015,90014,00021,50044,70044,10042,700102,100101,000102,700119,90092,80089,20088,80093,20011,30012,2008,2008,20035,30042,20024,50024,50018,20028,30021,00021,00016,170529,3997,7027,7026,1926,1926,192235,3003,3003,9003,200195,9003,0003,9009,8007,000000
   > Long-term Liabilities 
0
0
0
515,600
539,400
572,100
143,000
150,400
152,200
572,100
150,900
146,400
154,511
194,740
186,491
210,308
210,308
187,856
192,013
230,500
230,500
257,600
138,500
131,900
131,900
149,900
152,600
149,900
149,900
683,200
682,000
636,000
635,500
885,200
878,700
873,100
867,700
866,100
834,900
865,800
869,000
847,000
897,300
905,700
912,100
905,400
900,300
852,300
693,800
694,800
338,700
110,500
109,800
110,300
115,500
119,800
180,900
173,800
168,000
159,200
162,500
158,700
167,000
143,200
133,300
130,800
135,700
127,700
129,900
127,500
135,000
134,400
133,200
362,900
379,200
387,600
381,200
351,400
353,800
337,800
334,400
327,600
322,600
327,200
315,400
499,700
493,200
785,100
818,000
822,600
221,000
730,200
725,800
665,400
675,300
676,900
652,200
660,400
700,300
950,400
931,600
929,300
929,300
895,100
887,600
883,900
912,400
898,082
898,082912,400883,900887,600895,100929,300929,300931,600950,400700,300660,400652,200676,900675,300665,400725,800730,200221,000822,600818,000785,100493,200499,700315,400327,200322,600327,600334,400337,800353,800351,400381,200387,600379,200362,900133,200134,400135,000127,500129,900127,700135,700130,800133,300143,200167,000158,700162,500159,200168,000173,800180,900119,800115,500110,300109,800110,500338,700694,800693,800852,300900,300905,400912,100905,700897,300847,000869,000865,800834,900866,100867,700873,100878,700885,200635,500636,000682,000683,200149,900149,900152,600149,900131,900131,900138,500257,600230,500230,500192,013187,856210,308210,308186,491194,740154,511146,400150,900572,100152,200150,400143,000572,100539,400515,600000
       Long term Debt Total 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
650,200
679,800
679,500
91,300
559,100
556,300
495,900
503,400
486,100
469,700
474,100
516,100
742,900
726,100
734,900
741,100
733,900
724,100
718,000
739,100
0
0739,100718,000724,100733,900741,100734,900726,100742,900516,100474,100469,700486,100503,400495,900556,300559,10091,300679,500679,800650,200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
       Other Liabilities 
0
0
0
0
0
0
0
0
0
0
0
0
23,519
64,588
56,418
41,086
43,496
44,675
48,097
51,600
70,400
79,800
80,400
81,500
83,200
90,600
93,600
92,000
119,200
112,500
111,800
111,800
113,500
110,000
108,900
104,400
100,800
105,800
76,200
68,100
75,900
87,300
82,300
84,100
83,400
84,800
84,300
73,000
71,200
76,000
81,300
82,500
85,500
83,600
88,400
89,500
145,100
137,700
129,400
131,600
135,400
131,200
135,100
129,700
122,600
119,900
122,900
109,800
106,500
109,600
110,500
117,300
109,200
111,300
116,500
111,200
117,600
118,100
116,900
149,100
118,900
120,700
125,000
133,200
131,300
152,600
142,600
130,500
130,300
129,800
129,700
152,000
148,500
149,000
153,100
174,300
169,000
174,400
174,000
200,100
203,600
194,400
188,200
161,200
163,500
0
173,300
0
0173,3000163,500161,200188,200194,400203,600200,100174,000174,400169,000174,300153,100149,000148,500152,000129,700129,800130,300130,500142,600152,600131,300133,200125,000120,700118,900149,100116,900118,100117,600111,200116,500111,300109,200117,300110,500109,600106,500109,800122,900119,900122,600129,700135,100131,200135,400131,600129,400137,700145,10089,50088,40083,60085,50082,50081,30076,00071,20073,00084,30084,80083,40084,10082,30087,30075,90068,10076,200105,800100,800104,400108,900110,000113,500111,800111,800112,500119,20092,00093,60090,60083,20081,50080,40079,80070,40051,60048,09744,67543,49641,08656,41864,58823,519000000000000
       Deferred Long Term Liability 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
17,100
0
0
0
25,800
0
0
0
34,800
0
0
0
27,500
0
0
0
5,000
0
0
0
4,100
0
0
0
3,300
0
0
0
4,700
0
0
0
3,200
0
0
0
0
00003,2000004,7000003,3000004,1000005,00000027,50000034,80000025,80000017,10000000000000000000000000000000000000000000000000000000000000000000000000
> Total Stockholder Equity
0
0
0
363,200
331,300
322,900
728,900
859,300
1,126,900
322,900
1,166,500
1,658,100
2,430,365
2,462,792
3,373,393
3,469,269
3,469,269
4,263,127
4,409,631
4,745,600
4,745,600
4,855,200
4,701,200
4,203,600
4,203,600
3,837,900
3,646,200
3,468,300
3,468,300
3,414,700
3,398,500
2,488,800
2,477,200
2,488,200
2,238,200
2,214,400
2,206,000
2,186,000
2,146,600
2,094,600
2,057,400
2,100,100
2,124,000
2,118,200
2,152,400
2,190,300
2,208,400
1,365,500
1,393,000
1,436,600
1,457,200
1,475,800
1,512,200
1,491,700
1,502,200
1,421,300
1,333,300
1,384,500
1,398,200
1,463,800
1,475,100
1,460,400
1,508,900
1,316,700
1,344,400
1,359,900
1,401,200
1,402,000
1,425,100
1,468,600
1,459,600
1,394,900
1,401,300
1,088,500
1,086,300
1,091,000
1,117,900
1,162,100
1,211,300
1,238,800
1,273,700
1,321,700
1,357,500
1,350,700
1,355,700
1,290,400
1,288,600
1,332,300
1,392,200
1,372,000
1,365,100
1,356,200
1,338,900
1,362,300
1,400,500
1,409,000
1,410,600
1,428,300
1,469,300
1,463,000
1,509,400
1,529,600
1,569,700
1,677,700
1,655,500
1,680,600
1,736,300
1,759,452
1,759,4521,736,3001,680,6001,655,5001,677,7001,569,7001,529,6001,509,4001,463,0001,469,3001,428,3001,410,6001,409,0001,400,5001,362,3001,338,9001,356,2001,365,1001,372,0001,392,2001,332,3001,288,6001,290,4001,355,7001,350,7001,357,5001,321,7001,273,7001,238,8001,211,3001,162,1001,117,9001,091,0001,086,3001,088,5001,401,3001,394,9001,459,6001,468,6001,425,1001,402,0001,401,2001,359,9001,344,4001,316,7001,508,9001,460,4001,475,1001,463,8001,398,2001,384,5001,333,3001,421,3001,502,2001,491,7001,512,2001,475,8001,457,2001,436,6001,393,0001,365,5002,208,4002,190,3002,152,4002,118,2002,124,0002,100,1002,057,4002,094,6002,146,6002,186,0002,206,0002,214,4002,238,2002,488,2002,477,2002,488,8003,398,5003,414,7003,468,3003,468,3003,646,2003,837,9004,203,6004,203,6004,701,2004,855,2004,745,6004,745,6004,409,6314,263,1273,469,2693,469,2693,373,3932,462,7922,430,3651,658,1001,166,500322,9001,126,900859,300728,900322,900331,300363,200000
   Common Stock
0
0
0
0
0
0
0
0
0
0
0
0
2,392,843
2,391,935
2,394,610
2,395,414
2,400,994
3,112,886
3,294,216
3,693,100
3,703,200
3,704,600
3,687,400
3,664,700
3,549,400
3,383,000
3,308,100
3,291,900
3,547,300
3,552,500
3,556,000
3,553,200
3,561,400
3,562,500
3,564,600
3,562,300
3,567,900
3,569,300
3,569,500
3,576,600
3,582,500
3,584,700
3,585,000
3,585,200
3,585,200
3,587,600
3,588,500
3,588,500
3,588,500
3,588,700
3,590,500
3,591,200
3,596,300
3,597,000
3,519,000
3,329,400
3,346,300
3,347,400
3,347,400
3,348,000
3,259,600
3,189,500
3,144,900
2,774,700
2,785,300
2,787,700
2,750,100
2,712,000
2,714,800
2,681,100
2,629,100
2,609,500
2,516,900
2,088,700
2,089,400
2,093,900
2,089,900
2,046,600
2,047,100
2,048,200
2,073,000
2,078,000
2,078,500
2,048,300
2,007,700
2,003,900
1,973,200
1,954,100
1,878,900
1,827,000
1,827,000
1,832,100
1,834,300
1,834,300
1,834,300
1,834,200
1,824,100
1,798,000
1,764,500
1,764,500
1,753,900
1,739,600
1,730,900
1,714,900
1,699,500
1,677,800
1,678,100
1,663,943
1,663,9431,678,1001,677,8001,699,5001,714,9001,730,9001,739,6001,753,9001,764,5001,764,5001,798,0001,824,1001,834,2001,834,3001,834,3001,834,3001,832,1001,827,0001,827,0001,878,9001,954,1001,973,2002,003,9002,007,7002,048,3002,078,5002,078,0002,073,0002,048,2002,047,1002,046,6002,089,9002,093,9002,089,4002,088,7002,516,9002,609,5002,629,1002,681,1002,714,8002,712,0002,750,1002,787,7002,785,3002,774,7003,144,9003,189,5003,259,6003,348,0003,347,4003,347,4003,346,3003,329,4003,519,0003,597,0003,596,3003,591,2003,590,5003,588,7003,588,5003,588,5003,588,5003,587,6003,585,2003,585,2003,585,0003,584,7003,582,5003,576,6003,569,5003,569,3003,567,9003,562,3003,564,6003,562,5003,561,4003,553,2003,556,0003,552,5003,547,3003,291,9003,308,1003,383,0003,549,4003,664,7003,687,4003,704,6003,703,2003,693,1003,294,2163,112,8862,400,9942,395,4142,394,6102,391,9352,392,843000000000000
   Retained Earnings Total Equity000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
   Accumulated Other Comprehensive Income 
0
0
0
-21,200
-21,200
-21,200
-21,200
-57,300
-57,300
-1,000
1,500
-4,100
-4,786
-12,878
841,469
856,343
856,343
-210,844
876,847
883,900
883,900
916,400
869,100
827,700
827,700
795,500
748,000
749,300
749,300
499,800
504,500
403,300
401,000
398,300
191,000
27,800
29,000
34,000
33,000
34,900
28,900
41,900
55,700
59,000
58,500
48,500
28,200
9,400
10,800
40,300
54,100
55,800
57,600
46,600
61,300
59,200
15,400
11,800
-9,600
-12,300
1,000
-11,000
3,700
4,100
2,900
-8,400
-6,400
-14,300
-10,800
-3,900
-13,100
-25,000
-32,500
-26,500
-41,000
-32,800
-8,600
-9,400
-11,500
-24,700
-15,600
-6,400
-3,400
-6,700
-6,900
-24,300
-19,300
-26,500
-24,600
-24,500
-31,700
-23,600
-49,400
-34,300
-28,300
-15,200
-26,200
-26,500
-31,500
-26,800
-16,100
-24,700
-30,000
-1,300
-9,700
-14,800
-26,000
-14,824
-14,824-26,000-14,800-9,700-1,300-30,000-24,700-16,100-26,800-31,500-26,500-26,200-15,200-28,300-34,300-49,400-23,600-31,700-24,500-24,600-26,500-19,300-24,300-6,900-6,700-3,400-6,400-15,600-24,700-11,500-9,400-8,600-32,800-41,000-26,500-32,500-25,000-13,100-3,900-10,800-14,300-6,400-8,4002,9004,1003,700-11,0001,000-12,300-9,60011,80015,40059,20061,30046,60057,60055,80054,10040,30010,8009,40028,20048,50058,50059,00055,70041,90028,90034,90033,00034,00029,00027,800191,000398,300401,000403,300504,500499,800749,300749,300748,000795,500827,700827,700869,100916,400883,900883,900876,847-210,844856,343856,343841,469-12,878-4,786-4,1001,500-1,000-57,300-57,300-21,200-21,200-21,200-21,200000
   Capital Surplus 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
906,600
935,900
973,500
980,500
982,600
978,400
986,300
988,200
974,500
973,500
991,100
1,035,400
1,029,800
1,024,400
1,041,700
1,046,300
1,063,600
1,027,900
1,041,800
1,055,200
0
01,055,2001,041,8001,027,9001,063,6001,046,3001,041,7001,024,4001,029,8001,035,400991,100973,500974,500988,200986,300978,400982,600980,500973,500935,900906,600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
   Treasury Stock00000000-48,900-2,300-2,300-2,500-15,700-13,900-14,000-1,100-14,800-6,300-6,500-6,600-20,200-11,900-11,900-6,700-8,700-10,600-4,900-4,900-15,300-9,500-4,300-4,400-31,400-13,600-5,600-5,700-21,400-24,900-1,300-1,500-12,000-11,800-12,000-2,200-18,300-600-800-2,500-37,900-31,900-9,100-7,900-15,900-22,900-13,10000000000000000000000000000000000000000000000000000000
   Other Stockholders Equity 
0
0
0
388,100
388,100
398,900
798,500
968,800
1,226,900
378,700
1,175,000
1,646,000
2,392,843
2,391,935
2,394,610
2,395,414
2,395,414
4,192,857
3,294,216
3,699,000
3,699,000
3,704,600
3,690,200
3,670,600
3,670,600
3,383,000
3,308,100
3,297,800
3,297,800
3,552,500
3,556,000
3,559,100
3,561,400
3,562,500
3,564,600
3,732,200
3,740,000
3,745,300
3,749,000
3,755,900
3,765,400
3,770,200
3,772,900
3,775,500
3,780,400
3,788,500
3,794,800
204,400
3,799,800
219,900
3,816,000
3,801,800
3,810,500
3,807,100
3,767,500
333,700
3,338,400
3,700,800
3,685,700
3,679,600
3,634,400
3,608,100
3,598,200
634,900
636,700
633,100
652,600
669,700
649,200
678,600
694,100
655,700
742,500
827,700
828,400
815,300
796,400
848,500
845,700
847,300
842,500
841,900
840,800
854,300
866,500
869,600
884,900
886,400
929,300
967,000
974,200
967,800
977,300
972,300
974,300
958,800
971,000
988,800
1,033,100
980,900
1,005,400
1,012,900
1,021,300
1,045,100
1,017,600
1,014,000
1,000,400
945,637
945,6371,000,4001,014,0001,017,6001,045,1001,021,3001,012,9001,005,400980,9001,033,100988,800971,000958,800974,300972,300977,300967,800974,200967,000929,300886,400884,900869,600866,500854,300840,800841,900842,500847,300845,700848,500796,400815,300828,400827,700742,500655,700694,100678,600649,200669,700652,600633,100636,700634,9003,598,2003,608,1003,634,4003,679,6003,685,7003,700,8003,338,400333,7003,767,5003,807,1003,810,5003,801,8003,816,000219,9003,799,800204,4003,794,8003,788,5003,780,4003,775,5003,772,9003,770,2003,765,4003,755,9003,749,0003,745,3003,740,0003,732,2003,564,6003,562,5003,561,4003,559,1003,556,0003,552,5003,297,8003,297,8003,308,1003,383,0003,670,6003,670,6003,690,2003,704,6003,699,0003,699,0003,294,2164,192,8572,395,4142,395,4142,394,6102,391,9352,392,8431,646,0001,175,000378,7001,226,900968,800798,500398,900388,100388,100000



Balance Sheet

Currency in USD. All numbers in thousands.




Cash Flow

Currency in USD. All numbers in thousands.




Income Statement

Currency in USD. All numbers in thousands.


Latest Income Statement (annual, 2023-12-31)

Gross Profit (+$)
totalRevenue8,106,995
Cost of Revenue-7,354,545
Gross Profit752,451752,451
 
Operating Income (+$)
Gross Profit752,451
Operating Expense-346,744
Operating Income405,706405,706
 
Operating Expense (+$)
Research Development62,017
Selling General Administrative281,000
Selling And Marketing Expenses0
Operating Expense346,744343,017
 
Net Interest Income (+$)
Interest Income0
Interest Expense-78,005
Other Finance Cost-3,395
Net Interest Income-81,400
 
Pretax Income (+$)
Operating Income405,706
Net Interest Income-81,400
Other Non-Operating Income Expenses0
Income Before Tax (EBT)312,223499,190
EBIT - interestExpense = 327,701
307,737
322,605
Interest Expense78,005
Earnings Before Interest and Taxes (EBIT)405,706390,227
Earnings Before Interest and Taxes (EBITDA)569,048
 
After tax Income (+$)
Income Before Tax312,223
Tax Provision-62,000
Net Income From Continuing Ops202,800250,223
Net Income244,600
Net Income Applicable To Common Shares0
 
Non-recurring Events
Discontinued Operations0
Extraordinary Items0
Effect of Accounting Charges0
Other Items0
Non Recurring0
Other Operating Expenses7,701,289
Total Other Income/Expenses Net-93,48481,400
 

Technical Analysis of Celestica
The psychology behind the price

Technical indicators reflecting market sentiment and the collective psychology of you and other traders. Your emotions and other traders' emotions, such as fear and greed, play a significant role in driving price movements.

General trend

First of all, I'm going to put something in the back of your mind. One of the most stable factors that gives you more confidence as a trader: the general trend of Celestica. The general trend of Celestica is BULLISH with 85.7% confidence. It is very important for your mental being to use each indicator with this in mind. But beware, also the general trend flips once in a while! You can use moving averages to determine Celestica's overall trend. For convenience I use the most commonly used moving averages: 20, 50, 100 & 200. Of course you can use other moving averages or other indicators to determine the trend.

Indicator phases

Some of the indicators I use have 3 zones: overbought, oversold and neutral. Transitions between these zones (market phases) provide valuable trading signals and insights. Expecially with the general trend mind, I use the highlighted phases:

Indicator zone transitionsBullish trend (85.7%) Bearish trend (-85.7%)
Overbought to neutralBullish pullback=Bearish reversal
Upper to lower neutralBullish correction=Bearish continuation
Nuetral to oversoldOversold=Oversold
Oversold to neutralBullish reversal=Bearish correction
Lower to upper neutralBullish continuation=Bearish pullback
Nuetral to overboughtOverbought=Overbought

1. Price Targets

1.1 Support & Resistance

Support and resistance are levels on a price chart that act as barriers or zones where the price of an asset tends to stop, reverse, or experience a significant amount of buying or selling pressure.

Support is a price level at which demand for an asset is strong enough to prevent the price from falling further.
Resistance is a price level at which selling pressure becomes significant enough to prevent the price of an asset from rising further.


Score

Let's take a look at the Support & Resistance of Celestica Inc..

The long score for the Support & Resistance is 0/1.
The longshort score for the Support & Resistance is 0/(-1 +1).

  • Between support/resistance: The price is trading between support and resistance lines.

The bullish price targets are: 49.36.

The bearish price targets are: 42.10 > 41.50 > 30.36.

Tweet this
Celestica Inc. Daily Support & Resistance Chart

2. Trend Indicators

2.1 Moving Averages

Shows the moving average of the selected period.

  • Moving averages are lagging trend indicators.
  • There are many types of moving averages.
  • Moving averages are also used within other indicators.

Score

Let's take a look at the Moving Averages of Celestica Inc.. The current mas is .

The long score for the Moving Averages is 13/14.
The longshort score for the Moving Averages is 12/(-14 +14).

  • MA 20 trending up: The MA 20 is trending up. +1
  • Close < MA 20: The price is below the MA 20. -1
  • MA 20 > MA 50: The MA 20 is higher than the MA 50. +1
  • MA 20 > MA 100: The MA 20 is higher than the MA 100. +1
  • MA 20 > MA 200: The MA 20 is higher than the MA 200. +1
  • MA 50 trending up: The MA 50 is trending up. +1
  • Close > MA 50: The price is above the MA 50. +1
  • MA 50 > MA 100: The MA 50 is higher than the MA 100. +1
  • MA 50 > MA 200: The MA 50 is higher than the MA 200. +1
  • MA 100 trending up: The MA 100 is trending up. +1
  • Close > MA 100: The price is above the MA 100. +1
  • MA 100 > MA 200: The MA 100 is higher than the MA 200. +1
  • MA 200 trending up: The MA 200 is trending up. +1
  • Close > MA 200: The price is above the MA 200. +1

Directionalities and relatives.

Moving AverageAmount of candlesTrendPrice +/-vs. MA 50vs. MA 100vs. MA 200
MA 2020
MA 5050-
MA 100100--
MA 200200---

Explanation: https://www.youtube.com/watch?v=xwW8h0lrQ-I

Celestica Inc. Daily Moving Averages Chart
2.2 Moving Average Convergence/Divergence (MACD)

Shows the momentum of the selected period based on two moving averages.

  • MACD is a lagging momentum indicator.
  • Uses two moving averages.
  • Can show buy or sell signals based on momentum.
  • Can show overbought. and oversold. levels.

Score

Let's take a look at the Moving Average Convergence/Divergence (MACD) of Celestica Inc.. The current macd is 1.5353547.

The long score for the Moving Average Convergence/Divergence (MACD) is 1/4.
The longshort score for the Moving Average Convergence/Divergence (MACD) is -2/(-4 +4).

  • MACD line < signal line: The MACD line is below the signal line, which indicates a bearish signal in the market. This means that the negative momentum is currently stronger than the average momentum, suggesting that sellers are more active than buyers, and there's a higher probability of the Celestica price going down in the near term. -2
  • MACD > 0: The MACD is above the zero line (centerline), it indicates a bullish signal for Celestica. This means that the short-term moving average is higher than the long-term moving average, signaling positive momentum and suggesting a higher likelihood of the Celestica price continuing to rise in the near future. It indicates that buyers are gaining control, and there is optimism in the market, leading to potential price increases. +1
  • Trending down: The MACD line is trending down. This indicates that the short-term moving average is falling faster than the long-term moving average, suggesting negative momentum in the market. This signals that sellers are becoming more active and insecure, leading to potential price decreases as traders anticipate further losses and are willing to sell at lower prices. -1
Celestica Inc. Daily Moving Average Convergence/Divergence (MACD) ChartCelestica Inc. Daily Moving Average Convergence/Divergence (MACD) Chart
2.3 Directional Movement Index (DMI)

The DMI is a collection of 3 indicators: +DI (Plus Direction Indicator), -DI (Minus Direction Indicator) and ADX (Average Directional Index). The ADX helps you determine the strength of a trend.


Score

Let's take a look at the Directional Movement Index (DMI) of Celestica Inc.. The current adx is 21.57.

The long score for the Directional Movement Index (DMI) is 1/7.
The longshort score for the Directional Movement Index (DMI) is 1/(-7 +7).

  • PLUS_ID > MINUS_DI: The +DI line is above the -DI line. This indicates a bullish signal in the market, as the positive directional movement is currently stronger than the negative directional movement, showing that buyers have the upper hand. Market psychology suggests that traders are optimistic, expecting further price increases, and are more willing to buy Celestica shares, leading to potential upward momentum in its price. +1
  • PLUS_ID > MINUS_DI && ADX < 25 && ADX trending down: The ADX is below 25 and indicates a weak or no trend. Also, the ADX is declining so there is no trend indication.
Celestica Inc. Daily Directional Movement Index (DMI) Chart
2.4 Parabolic SAR

Shows the current trend and potential entry and exit signals.

  • Parabolic SAR (stop and reverse) is a lagging trend indicator.
  • Shows the current trend.
  • Shows potential entry signals.
  • Shows  potential exit signals.
  • Can be used to place trailing stoplosses..

Score

Let's take a look at the Parabolic SAR of Celestica Inc.. The current sar is 47.35.

The long score for the Parabolic SAR is 0/1.
The longshort score for the Parabolic SAR is -1/(-1 +1).

  • Close < SAR: The price is below the SAR. It's generally considered a bearish signal. -1
Celestica Inc. Daily Parabolic SAR Chart

3. Momentum Indicators

3.1 Relative Strength Index (RSI)

Measures the speed and change of price movements.

  • Leading momentum indicator, meaning the signals are instant.
  • Ranges between 0 and 100.
  • Above 70 is considered overbought.
  • Below 30 is considered oversold.
  • Above or below 50 can also be used to determine price trend or support and resistance.
  • RSI divergence looks at a deviation between RSI and price movement. Penketrading automatically calculates RSI divergences.
  • Can be used in many different ways

Score

Let's take a look at the Relative Strength Index (RSI) of Celestica Inc.. The current rsi is 54.94. The current phase is Continuation in bull market.

The long score for the Relative Strength Index (RSI) is 3/13.
The longshort score for the Relative Strength Index (RSI) is 2/(-13 +13).

  • Continuation in bull market: Uptrend continues after a consolidation or pullback. Hold or add to existing positions.
  • Trending down: The RSI is trending down. -1
Celestica Inc. Daily Relative Strength Index (RSI) ChartCelestica Inc. Daily Relative Strength Index (RSI) Chart
3.2 Stochastic Oscillator

Compares a certain price to multiple prices ranging over time.

  • Leading momentum indicator, meaning the signals are instant.
  • Used to determine overbought and oversold areas much like the RSI.
  • Ranges between 0 and 100.
  • Above 80 is considered overbought.
  • Below 20 is considered oversold.
  • Consists of two lines named K and D.
  • K compares the highest high and lowest low on the selected price range.
  • The D line is a moving average of the K line.
  • Can be used to spot divergences

Score

Let's take a look at the Stochastic Oscillator of Celestica Inc.. The current phase is Continuation in bull market.

The long score for the Stochastic Oscillator is 4/6.
The longshort score for the Stochastic Oscillator is 4/(-6 +6).

  • STOCH > 50: The STOCH %K is above 50. There are more buyers than sellers. +1
  • STOCH %K line > STOCH %D line: The STOCH %K line is above the STOCH %D line, which indicates a bullish signal in the market. This means that the positive momentum is currently stronger than the average momentum, suggesting that buyers are more active than sellers, and there's a higher probability of the Celestica price going up in the near term. +2
  • Trending up: The STOCH %K is trending up. +1
Celestica Inc. Daily Stochastic Oscillator ChartCelestica Inc. Daily Stochastic Oscillator Chart
3.3 Commodity Channel Index (CCI)

Measures the difference between the current price and the historical average price.

  • Lagging or leading Momentum indicator
  • When the CCI is above zero, the price is above the historical average
  • When the CCI is below zero, the price is below the historical average
  • Used for spotting trends
    • If the CCI moves from negative or near zero to positive 100 that might indicate an uptrend
    • If the CCI moves from positive or near zero to negative -100 that might indicate a downtrend

Score

Let's take a look at the Commodity Channel Index (CCI) of Celestica Inc.. The current cci is -22.48171162.

Celestica Inc. Daily Commodity Channel Index (CCI) ChartCelestica Inc. Daily Commodity Channel Index (CCI) Chart
3.4 Chande Momentum Oscillator (CMO)

Measures the difference between the sum of recent gains and the sum of recent losses. Then divides the result by the sum of all price movements in that period.

  • Lagging momentum indicator
  • Ranges between +100 and -100
  • Considered overbought above +50
  • Considered oversold below -50
  • It's possible to add a moving average that acts as a signal line

Score

Let's take a look at the Chande Momentum Oscillator (CMO) of Celestica Inc.. The current cmo is 0.68510951.

The long score for the Chande Momentum Oscillator (CMO) is 1/1.
The longshort score for the Chande Momentum Oscillator (CMO) is 1/(-1 +1).

  • CMO > 0: The CMO is above 0, the momentum of the price is positive, indicating a potential uptrend in the price. +1
Celestica Inc. Daily Chande Momentum Oscillator (CMO) ChartCelestica Inc. Daily Chande Momentum Oscillator (CMO) Chart
3.5 Williams %R

 Shows the current price relative to the highest high over the last 14 days.
 

  • Lagging momentum indicator
  • Ranging between 0 and -100
  • Above -20 is considered overbought
  • Below -80 is considered oversold
  • Is prone to give false signals

Score

Let's take a look at the Williams %R of Celestica Inc.. The current willr is -41.98890369.

The long score for the Williams %R is 0/1.
The longshort score for the Williams %R is 0/(-1 +1).

  • WILLR between -80 and -20: The Williams %R is between -80 and -20. This indicates that Celestica is trading in a neutral price range, neither oversold nor overbought, suggesting a balanced market condition without any extreme price signals.
Celestica Inc. Daily Williams %R ChartCelestica Inc. Daily Williams %R Chart

4. Volatility Indicators

4.1 Bollinger Bands

Shows if the price is to high or to low relative to an average.

  • Lagging volatility indicator
  • Uses 3 bands: one upper, one lower and one in the middle
  • Works best when the middle band reflects an intermediate trend (MA20).
  • When the price is moving closer to the upper band, the market might be overbought
  • When the price is moving closer to the lower band, the market might be oversold 

Score

Let's take a look at the Bollinger Bands of Celestica Inc..

Celestica Inc. Daily Bollinger Bands Chart
4.2 Average True Range (ATR)
Measures market volatility
  • Leading volatility indicator
  • Can be used to determine stop-loss positions
  • Calculated by:
    • Current high minus the current low
    • Current high minus the previous close
    • Current low minus the previous close
  • The larger the range of the candles, the greater the ATR value

Score

Let's take a look at the Average True Range (ATR) of Celestica Inc.. The current atr is 1.8761018.

Celestica Inc. Daily Average True Range (ATR) ChartCelestica Inc. Daily Average True Range (ATR) Chart

5. Volume Indicators

5.1 On-Balance Volume (OBV)

 Measures market volatility

  • Leading momentum indicator
  • Calculation:
    • If the closing price is above the previous closing price: OBV = previous OBV + current volume
    • If the closing price is below the previous closing price: OBV = previous OBV - current volume
    • If the closing price is the same as the previous closing price than the OBV is the same.
  • Can be used to confirm price trends
  • Can be used with divergences

Score

Let's take a look at the On-Balance Volume (OBV) of Celestica Inc.. The current obv is 70,952,132.

Celestica Inc. Daily On-Balance Volume (OBV) ChartCelestica Inc. Daily On-Balance Volume (OBV) Chart
5.2 Money Flow Index (MFI)

Measures the flow of money in and out of a security

  • Lagging momentum indicator
  • Looks like RSI but uses volume as an extra metric (RSI only considers price)
  • Above 80 is considered overbought
  • Below 20 is considered oversold
  • Can be used with divergences

Score

Let's take a look at the Money Flow Index (MFI) of Celestica Inc.. The current mfi is 40.95.

The long score for the Money Flow Index (MFI) is 0/2.
The longshort score for the Money Flow Index (MFI) is -1/(-2 +2).

  • MFI < 50: -1
Celestica Inc. Daily Money Flow Index (MFI) ChartCelestica Inc. Daily Money Flow Index (MFI) Chart

6. Summary

6.1. Notifications

TypeNotificationDate
PenkeCurrently no notifications for Celestica Inc..

6.2. Trading Signals

Below you will find trading signals as the indicator is commonly used. This doesn't mean you should use it that way. Learn from these, but don't use them blindly. I recommend using at least 4 indicators, 1 from each category: trend, momentum, volatility and volume.

DateIndicatorSignal
2023-11-06DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
STOCH LONG EXITThe %K line crosses below the %D line.
2023-11-07DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
2023-11-08STOCH SHORT EXITThe %K line crosses above the %D line.
2023-11-09STOCH LONG EXITThe %K line crosses below the %D line.
CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2023-11-10MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
STOCH SHORT EXITThe %K line crosses above the %D line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2023-11-13DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
2023-11-14CCI LONG ENTRY SHORT CLOSE100 crossover to upside
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2023-11-15STOCH LONG EXITThe %K line crosses below the %D line.
2023-11-17STOCH SHORT EXITThe %K line crosses above the %D line.
MFI LONG ENTRY SHORT CLOSE80 crossover to upside
2023-11-21STOCH LONG EXITThe %K line crosses below the %D line.
ATR SHORT ENTRY LONG CLOSEPrice closed below (close - ATR).
MFI SHORT ENTRY LONG CLOSE80 crossover to downside
2023-11-24STOCH SHORT EXITThe %K line crosses above the %D line.
2023-11-28STOCH LONG EXITThe %K line crosses below the %D line.
2023-11-29SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
STOCH SHORT EXITThe %K line crosses above the %D line.
2023-11-30MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
STOCH LONG EXITThe %K line crosses below the %D line.
2023-12-01DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
2023-12-06CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
ATR SHORT ENTRY LONG CLOSEPrice closed below (close - ATR).
2023-12-07STOCH SHORT EXITThe %K line crosses above the %D line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2023-12-11DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
2023-12-13MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2023-12-14BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
2023-12-18STOCH LONG EXITThe %K line crosses below the %D line.
2023-12-21STOCH SHORT EXITThe %K line crosses above the %D line.
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2023-12-22MFI LONG ENTRY SHORT CLOSE80 crossover to upside
2023-12-26STOCH LONG EXITThe %K line crosses below the %D line.
2023-12-28MFI SHORT ENTRY LONG CLOSE80 crossover to downside
2024-01-02MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
ATR SHORT ENTRY LONG CLOSEPrice closed below (close - ATR).
2024-01-04WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-01-08STOCH SHORT EXITThe %K line crosses above the %D line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-01-10DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
2024-01-11DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
STOCH LONG EXITThe %K line crosses below the %D line.
2024-01-16CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
2024-01-17SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
CCI SHORT ENTRY LONG CLOSE-100 crossover to downside
2024-01-18STOCH SHORT EXITThe %K line crosses above the %D line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-01-19MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-01-23STOCH LONG EXITThe %K line crosses below the %D line.
2024-01-25STOCH SHORT EXITThe %K line crosses above the %D line.
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
2024-01-30STOCH LONG EXITThe %K line crosses below the %D line.
2024-01-31STOCH SHORT EXITThe %K line crosses above the %D line.
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
2024-02-01ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-02-02MFI LONG ENTRY SHORT CLOSE80 crossover to upside
2024-02-05STOCH LONG EXITThe %K line crosses below the %D line.
2024-02-08STOCH SHORT EXITThe %K line crosses above the %D line.
2024-02-12STOCH LONG EXITThe %K line crosses below the %D line.
2024-02-13SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
2024-02-14SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
STOCH SHORT EXITThe %K line crosses above the %D line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-02-16STOCH LONG EXITThe %K line crosses below the %D line.
2024-02-20RSI SHORT ENTRY LONG CLOSE70 crossover to downside
ATR SHORT ENTRY LONG CLOSEPrice closed below (close - ATR).
MFI SHORT ENTRY LONG CLOSE80 crossover to downside
2024-02-21MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
2024-02-22MACD LONG ENTRY SHORT CLOSEThe MACD line crosses above the signal line.
SAR LONG ENTRY SHORT CLOSEThe price broke the SAR to the upside.
STOCH SHORT EXITThe %K line crosses above the %D line.
CCI LONG ENTRY SHORT CLOSE100 crossover to upside
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-02-23RSI SHORT ENTRY LONG CLOSE70 crossover to downside
2024-02-26WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2024-02-28STOCH LONG EXITThe %K line crosses below the %D line.
2024-02-29STOCH SHORT EXITThe %K line crosses above the %D line.
WILLR LONG ENTRY SHORT CLOSE-20 crossover to upside
2024-03-01BB SHORT ENTRY LONG CLOSEPrice closed above the lower band.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-03-04ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-03-05STOCH LONG EXITThe %K line crosses below the %D line.
2024-03-06STOCH SHORT EXITThe %K line crosses above the %D line.
2024-03-08RSI SHORT ENTRY LONG CLOSE70 crossover to downside
STOCH LONG EXITThe %K line crosses below the %D line.
2024-03-11SAR SHORT ENTRY LONG CLOSEThe price broke the SAR to the downside
ATR SHORT ENTRY LONG CLOSEPrice closed below (close - ATR).
2024-03-12MACD SHORT ENTRY LONG CLOSEThe MACD line crosses below the signal line.
2024-03-18STOCH SHORT EXITThe %K line crosses above the %D line.
2024-03-19DMI SHORT ENTRY LONG CLOSEThe +DI crossed the -DI to the downside. The trend is reversing to a down trend.
STOCH LONG EXITThe %K line crosses below the %D line.
CMO SHORT ENTRY LONG CLOSEZero line crossover to downside
WILLR SHORT ENTRY LONG CLOSE-80 crossover to downside
2024-03-20STOCH SHORT EXITThe %K line crosses above the %D line.
CMO LONG ENTRY SHORT CLOSEZero line crossover to upside
2024-03-21DMI LONG ENTRY SHORT CLOSEThe +DI crossed the -DI to the upside. The trend is reversing to an up trend.
ATR LONG ENTRY SHORT CLOSEPrice closed above (close + ATR).
2024-03-25STOCH LONG EXITThe %K line crosses below the %D line.
2024-03-28STOCH SHORT EXITThe %K line crosses above the %D line.

6.3. Candlestick Patterns

Celestica Inc. Daily Candlestick Chart
DateCandlestick Pattern

6.4. Technical Score

Let's check the technical score of Celestica Inc. based on Penke's default Symbol scanner.

Penke's Symbol Scanner

  
  
IndicatorConditionValue
RsiGreater than5054.942
Ma 20Greater thanMa 5045.512
Ma 50Greater thanMa 10040.051
Ma 100Greater thanMa 20033.858
OpenGreater thanClose45.250
Total5/5 (100.0%)
Penke

Good job! You gained 25 XP and 0   0   10 . What's next:

  • Share my analysis of Celestica with someone you think should read this too:
  • Are you bullish or bearish on Celestica? Let me know what you think in the comments.
  • Do you want an email if I find something interesting about Celestica? Add an email alert using the form below.
  • Join the community if you want to keep your earnings and track your progress: Join the community
  • Is this analysis useful to you? Support me via But Me a Coffee. I'll analyze the stock market faster for you!

Get notifications about Celestica Inc.

I send you an email if I find something interesting about Celestica Inc..


Comments

How you think about this?

Leave a comment

Stay informed about Celestica Inc..

Receive notifications about Celestica Inc. in your mailbox!