COM:CONSTELLATION
Constellation
- Stock
Last Close
253.49
25/09 14:39
Market Cap
69.21B
Beta: -
Volume Today
1.87M
Avg: -
Preview
Full access to financials is available to subscribers only. Please support our work and get full access to all features. You can cancel anytime. If you'd like a demo, free trial or have any questions, please checkout the help page
Dec '13 | Dec '14 | Dec '15 | Dec '16 | Dec '17 | Dec '18 | Dec '19 | Dec '20 | Dec '21 | Dec '22 | Dec '23 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
average inventory | 795.50M - | 1.07B 34.95% | 1.29B 19.98% | 1.25B 3.30% | 1.21B 2.53% | 1.24B - | 1.25B 1.05% | 1.40B 11.76% | 752.50M 46.12% | |||
average payables | 1.48B - | 1.60B 8.22% | 1.68B 4.85% | 1.60B 4.80% | 1.70B 6.70% | 1.47B - | 1.50B 2.21% | 2.29B 52.33% | 1.42B 38.08% | |||
average receivables | 1.71B - | 2.10B 22.95% | 2.29B 9.06% | 2.38B 3.95% | 2.71B 13.82% | 2.79B - | 2.13B 23.76% | 2.87B 34.61% | 1.66B 42.20% | |||
book value per share | 41.32 - | 38.00 8.05% | 34.41 9.43% | 33.59 2.39% | 7.85 76.64% | |||||||
capex per share | -6.87 - | -5.65 17.71% | -5.35 5.31% | -4.08 23.86% | -5.15 26.31% | -7.48 45.17% | ||||||
capex to depreciation | -1.08 - | -1.20 11.19% | -1.48 24.08% | -1.12 24.47% | -0.81 27.84% | -0.66 18.80% | -0.60 8.25% | -0.48 20.23% | -0.29 39.07% | -0.70 137.73% | -0.96 38.44% | |
capex to operating cash flow | -0.71 - | -1.65 132.98% | -0.91 44.54% | -0.69 24.25% | -0.68 1.18% | -0.58 15.20% | -0.64 10.59% | -2.99 365.82% | 0.99 133.20% | 0.72 27.73% | 0.46 36.35% | |
capex to revenue | -0.18 - | -0.17 1.65% | -0.20 15.91% | -0.17 13.65% | -0.12 29.56% | -0.11 10.16% | -0.10 11.13% | -0.10 1.79% | -0.07 31.85% | -0.07 2.17% | -0.10 40.65% | |
cash per share | 0.93 - | 0.69 25.41% | 1.55 123.21% | -41.74 2,800.10% | 0.29 100.70% | |||||||
days of inventory on hand | 23.94 - | 32.30 34.90% | 30.12 6.73% | 31.16 3.46% | 28.47 8.62% | 29.58 - | 29.96 1.30% | 28.12 6.14% | 24.63 12.41% | |||
days payables outstanding | 40.94 - | 43.59 6.48% | 37.72 13.47% | 40.89 8.39% | 42.61 4.20% | 39.65 - | 31.00 21.82% | 38.36 23.74% | 46.28 20.65% | 0.19 99.60% | ||
days sales outstanding | 41.96 - | 50.53 20.42% | 41.55 17.79% | 53.22 28.10% | 55.97 5.18% | 72.31 - | 38.17 47.21% | 44.97 17.81% | 49.52 10.12% | |||
debt to assets | 0.17 - | 0.17 2.98% | 0.19 13.01% | 0.17 9.27% | 0.18 3.14% | 0.17 - | 0.15 11.42% | 0.17 13.66% | 0.12 27.86% | 0.22 76.61% | ||
debt to equity | 0.56 - | 0.60 5.83% | 0.76 27.86% | 0.71 7.18% | 0.63 10.62% | 0.62 - | 0.58 5.44% | 0.73 25.60% | 0.52 28.34% | 0.30 42.36% | ||
dividend yield | 0.07 - | 0.07 10.19% | 0.13 92.88% | 0.13 5.75% | 0.01 95.11% | 0.01 47.71% | ||||||
earnings yield | 0.03 - | 0.08 204.05% | 0.04 47.64% | -0.01 112.41% | -0.01 2.15% | 0.04 886.88% | ||||||
enterprise value | -1.26B - | -780M 38.00% | -431M 44.74% | -290M 32.71% | -416M 43.45% | 21.70B - | 20.69B 4.63% | 21.38B 3.35% | 33.62B 57.23% | 38.54B 14.64% | ||
enterprise value over ebitda | -0.30 - | -0.21 28.47% | -0.09 58.51% | -0.06 27.58% | -0.10 56.24% | 4.03 - | 4.29 6.53% | 4.90 14.13% | 15.75 221.32% | 12.25 22.23% | ||
ev to operating cash flow | -0.32 - | -0.43 31.99% | -0.10 75.97% | -0.07 36.40% | -0.13 93.15% | 7.55 - | 35.43 369.16% | -15.98 145.11% | -14.29 10.59% | -7.27 49.11% | ||
ev to sales | -0.08 - | -0.04 44.28% | -0.02 49.77% | -0.02 27.49% | -0.02 37.69% | 1.15 - | 1.18 2.52% | 1.09 7.41% | 1.38 26.41% | 1.55 12.44% | ||
free cash flow per share | 4.96 - | 3.15 36.50% | -3.56 213.13% | -8.18 129.53% | -12.32 50.63% | -23.84 93.43% | ||||||
free cash flow yield | 0.12 - | 0.08 36.50% | -0.08 213.13% | -0.19 129.53% | -0.14 26.61% | -0.20 42.66% | ||||||
graham net net | -90.16 - | -95.64 6.07% | -102.79 7.48% | -140.21 36.41% | -2.76 98.03% | |||||||
graham number | 56.62 - | 39.28 30.62% | 13.17 66.48% | 18.84 43.06% | 29.74 57.86% | |||||||
income quality | 3.63 - | 2.19 39.80% | 3.06 39.95% | 9.20 200.50% | 1.22 86.76% | 8.72 615.95% | 2.36 72.91% | 1.01 57.27% | 16.12 1,498.25% | 14.09 12.60% | -3.36 123.86% | |
intangibles to total assets | 0.02 - | 0.01 23.00% | 0.01 13.93% | 0.01 7.85% | 0.01 13.26% | 0 100% | 0.00 Infinity% | 0.00 1.87% | 0.05 5,500.93% | 0 100% | 0 | |
interest coverage | 2.26 - | 5.41 139.51% | 3.31 38.75% | -0.60 118.00% | -1.16 95.21% | -3.74 221.10% | ||||||
interest debt per share | 26.73 - | 23.20 13.23% | 26.05 12.31% | 18.35 29.56% | 1.04 94.35% | |||||||
inventory turnover | 15.25 - | 11.30 25.87% | 12.12 7.22% | 11.71 3.34% | 12.82 9.44% | 12.34 - | 12.18 1.28% | 12.98 6.54% | 14.82 14.17% | |||
invested capital | 0.56 - | 0.60 5.83% | 0.76 27.86% | 0.71 7.18% | 0.63 10.62% | 0.62 - | 0.58 5.44% | 0.73 25.60% | 0.52 28.34% | 0.30 42.36% | ||
market cap | 13.70B - | 13.70B 0% | 13.70B 0% | 13.69B 0.09% | 28.28B 106.52% | 37.87B 33.93% | ||||||
net current asset value | -22.05B - | -23.59B 6.97% | -27.22B 15.38% | -27.19B 0.10% | -25.62B 5.79% | -26.09B - | -26.47B 1.46% | -28.49B 7.63% | -26.18B 8.12% | 397M 101.52% | ||
net debt to ebitda | -0.30 - | -0.21 28.47% | -0.09 58.51% | -0.06 27.58% | -0.10 56.24% | 1.48 - | 1.45 2.34% | 1.76 21.59% | 2.50 42.03% | 0.21 91.47% | ||
net income per share | 1.13 - | 3.45 204.05% | 1.81 47.64% | -0.22 112.41% | -0.47 109.67% | 5.01 1,166.91% | ||||||
operating cash flow per share | 11.83 - | 8.80 25.59% | 1.79 79.67% | -4.10 329.32% | -7.17 74.79% | -16.36 128.07% | ||||||
payables turnover | 8.92 - | 8.37 6.09% | 9.68 15.57% | 8.93 7.74% | 8.57 4.03% | 9.20 - | 11.77 27.92% | 9.52 19.19% | 7.89 17.12% | 1.97K 24,897.86% | ||
receivables turnover | 8.70 - | 7.22 16.96% | 8.79 21.63% | 6.86 21.93% | 6.52 4.92% | 5.05 - | 9.56 89.42% | 8.12 15.12% | 7.37 9.19% | |||
research and ddevelopement to revenue | ||||||||||||
return on tangible assets | 0.03 - | 0.02 28.71% | 0.03 58.44% | 0.01 65.16% | 0.06 443.14% | 0.02 - | 0.01 46.66% | -0.00 113.10% | -0.00 104.42% | 0.46 14,096.95% | ||
revenue per share | 62.63 - | 58.00 7.40% | 53.95 6.98% | 60.27 11.73% | 74.51 23.62% | 76.91 3.21% | ||||||
roe | 0.08 - | 0.07 21.92% | 0.12 79.61% | 0.04 64.33% | 0.20 371.31% | 0.08 - | 0.05 43.06% | -0.01 113.70% | -0.01 114.81% | 0.64 4,667.99% | ||
roic | 0.05 - | 0.04 10.32% | 0.08 85.72% | 0.05 33.28% | 0.00 96.40% | 0.08 - | 0.04 45.62% | 0.00 89.65% | -0.00 212.89% | 0.32 6,488.35% | ||
sales general and administrative to revenue | ||||||||||||
shareholders equity per share | 41.32 - | 38.00 8.05% | 34.41 9.43% | 33.59 2.39% | 7.85 76.64% | |||||||
stock based compensation to revenue | 0.00 - | 0.00 2.65% | 0.00 11.87% | 0.00 31.33% | 0.00 8.29% | 0.03 529.54% | -0.01 146.06% | -0.02 50.34% | -0.03 59.54% | |||
tangible asset value | 12.03B - | 13.46B 11.83% | 12.44B 7.55% | 12.76B 2.60% | 15.52B 21.59% | 15.78B - | 14.63B 7.31% | 8.98B 38.60% | 11.37B 26.61% | 2.54B 77.65% | ||
tangible book value per share | 48.37 - | 44.83 7.31% | 35.63 20.54% | 34.67 2.68% | 7.85 77.37% | |||||||
working capital | 2.57B - | 2.85B 10.89% | 1.41B 50.60% | 845M 40.03% | 2.69B 218.46% | -213M - | 1.73B 911.27% | -15M 100.87% | 1.52B 10,240% | 1.29B 14.99% |
All numbers in (except ratios and percentages)