| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Xpel Inc | ||||||||||||||||||||||||||
2 | Fisacal Year (End of December) (in million) | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | |||||||||||
3 | Revenue | ||||||||||||||||||||||||||
4 | Paint protection film | 49.489 | 85.495 | 97.342 | 110.786 | 169.879 | 192.374 | 229.880 | |||||||||||||||||||
5 | % of revenue | 73.54% | 77.78% | 74.92% | 69.71% | 65.52% | 59.38% | 58.01% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
6 | Window film | 5.103 | 7.310 | 11.384 | 20.951 | 38.363 | 54.370 | 67.951 | |||||||||||||||||||
7 | % of revenue | 7.58% | 6.65% | 8.76% | 13.18% | 14.80% | 16.78% | 17.15% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
8 | Film of other functions & tools | 1.756 | 2.721 | 3.478 | 4.525 | 9.040 | 11.430 | 13.575 | |||||||||||||||||||
9 | % of revenue | 2.61% | 2.48% | 2.68% | 2.85% | 3.49% | 3.53% | 3.43% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
10 | Software services | 2.821 | 2.567 | 3.263 | 3.489 | 4.373 | 5.213 | 6.518 | |||||||||||||||||||
11 | % of revenue | 4.19% | 2.34% | 2.51% | 2.20% | 1.69% | 1.61% | 1.64% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
12 | Cutbank credit 3 | 4.146 | 6.197 | 7.254 | 7.785 | 12.372 | 16.317 | 17.626 | |||||||||||||||||||
13 | % of revenue | 6.16% | 5.64% | 5.58% | 4.90% | 4.77% | 5.04% | 4.45% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
14 | Installation labor | 3.710 | 5.212 | 6.621 | 10.926 | 24.253 | 42.828 | 58.477 | |||||||||||||||||||
15 | % of revenue | 5.51% | 4.74% | 5.10% | 6.87% | 9.35% | 13.22% | 14.76% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
16 | Trainiing | 0.273 | 0.418 | 0.591 | 0.463 | 0.982 | 1.461 | 2.266 | |||||||||||||||||||
17 | % of revenue | 0.41% | 0.38% | 0.45% | 0.29% | 0.38% | 0.45% | 0.57% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||
18 | Total Revenue | 3.83 | 4.13 | 6.04 | 10.67 | 17.90 | 29.63 | 41.47 | 51.76 | 67.30 | 109.92 | 129.93 | 158.92 | 259.26 | 323.99 | 396.29 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
19 | Revenue growth | 7.70% | 46.29% | 76.62% | 67.74% | 65.54% | 39.96% | 24.81% | 30.02% | 63.34% | 18.21% | 22.31% | 63.14% | 24.97% | 22.32% | -100.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||
20 | Revenue growth (5-year CAGR) | 50.52% | 58.62% | 53.66% | 44.53% | 43.76% | 34.40% | 30.83% | 38.02% | 36.93% | 29.24% | -100.00% | -100.00% | -100.00% | -100.00% | -100.00% | |||||||||||
21 | Cost of revenue | 1.63 | 1.90 | 3.53 | 7.04 | 12.15 | 20.37 | 29.15 | 37.74 | 50.61 | 76.48 | 86.43 | 104.90 | 166.59 | 196.48 | 233.88 | |||||||||||
22 | Gross profit | 2.21 | 2.23 | 2.52 | 3.63 | 5.75 | 9.26 | 12.32 | 14.02 | 16.68 | 33.44 | 43.51 | 54.03 | 92.68 | 127.51 | 162.41 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
23 | Gross margin | 57.51% | 53.98% | 41.63% | 34.06% | 32.10% | 31.24% | 29.70% | 27.08% | 24.79% | 30.42% | 33.48% | 33.99% | 35.75% | 39.36% | 40.98% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
24 | |||||||||||||||||||||||||||
25 | Sale and marketing | 4.95 | 6.80 | 7.58 | 9.75 | 18.27 | 25.37 | 31.79 | |||||||||||||||||||
26 | General and adminstrative | 9.53 | 14.83 | 18.83 | 20.91 | 34.29 | 48.21 | 63.65 | |||||||||||||||||||
27 | |||||||||||||||||||||||||||
28 | Operating expense | 1.68 | 1.57 | 1.90 | 2.56 | 3.70 | 6.46 | 9.71 | 10.76 | 14.47 | 21.63 | 26.42 | 30.66 | 52.56 | 73.58 | 95.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
29 | % to Revenue | 43.79% | 38.03% | 31.49% | 24.00% | 20.69% | 21.82% | 23.41% | 20.79% | 21.51% | 19.68% | 20.33% | 19.29% | 20.27% | 22.71% | 24.08% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
30 | Operating income | 0.53 | 0.66 | 0.61 | 1.07 | 2.04 | 2.79 | 2.61 | 3.25 | 2.21 | 11.81 | 17.09 | 23.37 | 40.11 | 53.94 | 66.97 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
31 | % to Revenue | 13.73% | 15.95% | 10.15% | 10.06% | 11.41% | 9.42% | 6.29% | 6.29% | 3.29% | 10.74% | 13.15% | 14.71% | 15.47% | 16.65% | 16.90% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
32 | Interest expense | -0.03 | -0.02 | 0.00 | 0.00 | -0.01 | -0.04 | -0.22 | -0.22 | -0.33 | -0.17 | -0.10 | -0.25 | -0.30 | -1.41 | -1.25 | |||||||||||
33 | Gain/(loss) on sale of properties, plants, equipment | 0.00 | 0.02 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | |||||||||||||||||
34 | Foreign exchange loss | 0.05 | 0.00 | 0.25 | -0.16 | -0.04 | -0.32 | -0.37 | -0.56 | 0.31 | |||||||||||||||||
35 | Amortization | -0.35 | -0.33 | ||||||||||||||||||||||||
36 | Loss on discontinue operation | -0.71 | |||||||||||||||||||||||||
37 | Equity investment (loss) | -0.11 | |||||||||||||||||||||||||
38 | Total other income | -1.09 | -0.43 | 0.00 | 0.00 | -0.01 | -0.04 | -0.17 | -0.22 | -0.06 | -0.32 | -0.14 | -0.57 | -0.68 | -1.97 | -0.94 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
39 | Income before tax | -0.57 | 0.22 | 0.61 | 1.08 | 2.03 | 2.75 | 2.43 | 3.03 | 2.15 | 11.48 | 16.95 | 22.80 | 39.44 | 51.97 | 66.03 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
40 | Income tax | -0.2 | 0.2 | -0.1 | 0.71 | -0.32 | 0.96 | 0.87 | 1.15 | 2.76 | 2.96 | 4.52 | 7.87 | 10.58 | 13.2 | ||||||||||||
41 | Net income | -0.57 | 0.43 | 0.40 | 1.16 | 1.32 | 3.07 | 1.47 | 2.16 | 0.99 | 8.72 | 14.00 | 18.28 | 31.57 | 41.38 | 52.80 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
42 | Net margin | -14.77% | 10.31% | 6.65% | 10.89% | 7.38% | 10.36% | 3.55% | 4.18% | 1.48% | 7.93% | 10.77% | 11.50% | 12.18% | 12.77% | 13.32% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
43 | Earning per share | #DIV/0! | #DIV/0! | 0.02 | 0.05 | 0.05 | 0.12 | 0.06 | 0.08 | 0.04 | 0.32 | 0.51 | 0.66 | 1.14 | 1.50 | 1.91 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
44 | Common stock (diluted) | 25.72 | 25.78 | 25.78 | 25.78 | 25.78 | 25.78 | 27.33 | 27.61 | 27.61 | 27.61 | 27.61 | 27.62 | 27.63 | |||||||||||||
45 | |||||||||||||||||||||||||||
46 | Price at yearend (approximate) | 0.04 | 0.01 | 0.09 | 0.15 | 1.37 | 3.17 | 1.01 | 1.40 | 1.40 | 5.51 | 15.52 | 51.56 | 68.28 | 60.06 | 53.85 | |||||||||||
47 | P/E (never assume price will back to previous high) | 26.62 | 17.71 | 16.68 | 38.47 | 17.45 | 30.62 | 77.88 | 59.73 | 40.08 | 28.18 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||||||
48 | |||||||||||||||||||||||||||
49 | |||||||||||||||||||||||||||
50 | Assets (excluding right-to-use beginning 2020) | 1.57 | 1.68 | 3.24 | 5.40 | 6.45 | 12.61 | 19.53 | 21.80 | 27.81 | 30.54 | 46.52 | 77.53 | 147.79 | 177.82 | 236.43 | |||||||||||
51 | Cash and cash equivalents | 0.12 | 0.16 | 0.42 | 1.40 | 1.41 | 1.47 | 2.84 | 1.86 | 3.50 | 3.97 | 11.50 | 29.03 | 9.64 | 8.06 | 11.61 | |||||||||||
52 | Account receivables | 0.26 | 0.37 | 0.59 | 0.90 | 1.02 | 2.29 | 3.45 | 4.75 | 5.45 | 5.55 | 7.15 | 9.94 | 13.16 | 14.73 | 24.11 | |||||||||||
53 | |||||||||||||||||||||||||||
54 | Debt | 0.13 | 0.00 | 0.00 | 0.00 | 0.07 | 0.99 | 4.83 | 3.93 | 2.93 | 1.82 | 0.77 | 6.14 | 25.45 | 26.08 | 19.38 | |||||||||||
55 | Equity | 0.58 | 1.00 | 1.83 | 2.99 | 4.32 | 7.40 | 8.34 | 10.35 | 12.50 | 20.61 | 34.89 | 53.38 | 84.46 | 124.72 | 179.99 | |||||||||||
56 | Liabilities (excluding lease operating liability beginning 2020) | 1.00 | 0.68 | 1.40 | 2.40 | 2.13 | 5.12 | 11.18 | 11.50 | 15.32 | 9.93 | 11.57 | 24.83 | 63.42 | 52.39 | 55.21 | |||||||||||
57 | Invested Capital | 0.71 | 1.00 | 1.83 | 2.99 | 4.38 | 8.39 | 13.17 | 14.28 | 15.42 | 22.43 | 35.66 | 59.52 | 109.91 | 150.80 | 199.37 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
58 | |||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||
60 | Cash flow from operation 1 | 0.50 | 0.64 | 0.95 | 1.43 | 2.42 | 3.15 | 2.58 | 3.74 | 2.28 | 10.27 | 16.17 | 20.41 | 37.43 | 49.73 | 63.34 | |||||||||||
61 | CapEx | 0.00 | 0.01 | 0.07 | 0.11 | 0.32 | 0.37 | 0.45 | 0.38 | 1.46 | 1.88 | 1.50 | 1.72 | 6.66 | 7.86 | 6.33 | |||||||||||
62 | Acquisition | 0.00 | 0.49 | 1.85 | 0.82 | 0.66 | 0.83 | 0.13 | 2.57 | 49.18 | 4.67 | 18.74 | |||||||||||||||
63 | Intellecture properties | 0.26 | 0.28 | 0.30 | 0.24 | 0.50 | 0.56 | 0.76 | 0.98 | 0.21 | 0.39 | 0.67 | 0.37 | 0.96 | 1.62 | 1.29 | |||||||||||
64 | Equity investment | 0.11 | |||||||||||||||||||||||||
65 | Total of CapEx + Acquisition + investment 2 | 0.26 | 0.39 | 0.38 | 0.35 | 0.82 | 1.42 | 3.07 | 2.18 | 2.33 | 3.09 | 2.30 | 4.66 | 56.81 | 14.16 | 26.35 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
66 | Free Cash Flow | 0.24 | 0.25 | 0.57 | 1.07 | 1.60 | 1.73 | -0.49 | 1.56 | -0.05 | 7.18 | 13.86 | 15.75 | -19.38 | 35.58 | 36.99 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
67 | Free cash flow/cash flow from operation | 48.53% | 39.43% | 60.18% | 75.32% | 66.04% | 54.97% | -19.02% | 41.64% | -2.11% | 69.88% | 85.75% | 77.16% | -51.79% | 71.54% | 58.40% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
68 | |||||||||||||||||||||||||||
69 | Stock compensation | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.17 | 0.52 | 1.64 | |||||||||||
70 | % to Cash flow from operation | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.45% | 1.05% | 2.59% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
71 | |||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||
73 | CEO Pay | na | 0.123 | 0.130 | 0.150 | 0.218 | 0.251 | 0.238 | na | 0.373 | 0.537 | 0.632 | 0.718 | 1.303 | 1.533 | 2.045 | |||||||||||
74 | % to Revenue | #VALUE! | 2.97% | 2.16% | 1.41% | 1.22% | 0.85% | 0.57% | #VALUE! | 0.55% | 0.49% | 0.49% | 0.45% | 0.50% | 0.47% | 0.52% | #DIV/0! | ||||||||||
75 | % to OP Income | #VALUE! | 18.59% | 21.26% | 13.97% | 10.69% | 9.00% | 9.12% | #VALUE! | 16.85% | 4.54% | 3.70% | 3.07% | 3.25% | 2.84% | 3.05% | #DIV/0! | ||||||||||
76 | % to Net | #VALUE! | 28.77% | 32.41% | 12.91% | 16.54% | 8.19% | 16.17% | #VALUE! | 37.48% | 6.15% | 4.51% | 3.93% | 4.13% | 3.70% | 3.87% | #DIV/0! | ||||||||||
77 | |||||||||||||||||||||||||||
78 | Executive Pay 4 | na | 0.569 | 0.601 | 0.652 | 0.865 | 0.984 | 0.962 | na | 1.616 | 2.248 | 2.667 | 2.383 | 4.173 | 5.009 | 4.765 | |||||||||||
79 | % to Revenue | #VALUE! | 13.79% | 9.95% | 6.11% | 4.83% | 3.32% | 2.32% | #VALUE! | 2.40% | 2.05% | 2.05% | 1.50% | 1.61% | 1.55% | 1.20% | #DIV/0! | ||||||||||
80 | % to OP Income | #VALUE! | 86.42% | 98.03% | 60.74% | 42.34% | 35.23% | 36.87% | #VALUE! | 73.06% | 19.04% | 15.61% | 10.20% | 10.40% | 9.29% | 7.11% | #DIV/0! | ||||||||||
81 | % to Net | #VALUE! | 133.71% | 149.48% | 56.12% | 65.52% | 32.05% | 65.39% | #VALUE! | 162.49% | 25.78% | 19.05% | 13.04% | 13.22% | 12.10% | 9.02% | #DIV/0! | ||||||||||
82 | |||||||||||||||||||||||||||
83 | Director Pay | na | 0.036 | 0.090 | 0.109 | 0.135 | na | 0.254 | 0.332 | 0.408 | 0.400 | 0.425 | 0.674 | ||||||||||||||
84 | % to OP Income | #VALUE! | 0.00% | 0.00% | 3.35% | 4.41% | 3.89% | 5.18% | #VALUE! | 0.00% | 2.15% | 1.95% | 1.75% | 1.00% | 0.79% | 1.01% | #DIV/0! | ||||||||||
85 | % to Net | #VALUE! | 0.00% | 0.00% | 3.10% | 6.82% | 3.54% | 9.18% | #VALUE! | 0.00% | 2.91% | 2.38% | 2.23% | 1.27% | 1.03% | 1.28% | #DIV/0! | ||||||||||
86 | |||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||
91 | Ratio | ||||||||||||||||||||||||||
92 | Revenue to assets | #REF! | 2.54 | 2.46 | 2.47 | 3.02 | 3.11 | 2.58 | 2.51 | 2.71 | 3.77 | 3.37 | 2.56 | 2.30 | 1.99 | 1.91 | 0.00 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
93 | Revenue to invested capital | #REF! | 4.84 | 4.26 | 4.42 | 4.85 | 4.64 | 3.85 | 3.77 | 4.53 | 5.81 | 4.47 | 3.34 | 3.06 | 2.49 | 2.26 | 0.00 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
94 | |||||||||||||||||||||||||||
95 | Net income to assets | #REF! | 26.2% | 16.4% | 26.9% | 22.3% | 32.2% | 9.2% | 10.5% | 4.0% | 29.9% | 36.3% | 29.5% | 28.0% | 25.4% | 25.5% | 0.0% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
96 | Net income to invested capital | #REF! | 49.9% | 28.4% | 48.1% | 35.8% | 48.1% | 13.6% | 15.8% | 6.7% | 46.1% | 48.2% | 38.4% | 37.3% | 31.7% | 30.2% | 0.0% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
97 | |||||||||||||||||||||||||||
98 | Cash to liabilities | 0.12 | 0.23 | 0.30 | 0.58 | 0.66 | 0.29 | 0.25 | 0.16 | 0.23 | 0.40 | 0.99 | 1.17 | 0.15 | 0.15 | 0.21 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||
99 | |||||||||||||||||||||||||||
100 | Free cash flow to liabilities | 0.25 | 0.37 | 0.41 | 0.45 | 0.75 | 0.34 | -0.04 | 0.14 | 0.00 | 0.72 | 1.20 | 0.63 | -0.31 | 0.68 | 0.67 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||