| 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 | AA | AB | AC | AD | AE | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Synopsys Inc (SNPS) | |||||||||||||||||||||||||||||||
2 | Fisacal Year (End of Oct 31) (in million) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | |||||||
3 | Time-based products/ratable license | 174.59 | 373.59 | 618.02 | 663.24 | 743.72 | 874.86 | 1004.03 | 1125.85 | 1150.47 | 1158.42 | 1260.34 | 1449.30 | 1599.46 | 1699.14 | 1792.21 | 1910.90 | 2021.81 | 2303.42 | 2197.97 | 2365.20 | 2633.76 | 2993.79 | 3383.63 | 3224.30 | |||||||
4 | Upfront products/product | 163.92 | 245.19 | 298.28 | 215.96 | 60.47 | 63.05 | 67.52 | 71.38 | 57.55 | 68.62 | 90.53 | 105.14 | 132.02 | 135.76 | 197.33 | 248.14 | 338.20 | 357.70 | 619.79 | 735.57 | 861.06 | 1226.77 | 1429.33 | 1802.22 | |||||||
5 | Maintence and service/services | 341.83 | 287.75 | 260.68 | 212.91 | 187.74 | 157.65 | 140.92 | 139.72 | 152.02 | 153.63 | 184.77 | 201.58 | 230.73 | 222.58 | 252.67 | 263.49 | 364.86 | 460.04 | 542.94 | 584.51 | 709.37 | 861.03 | 1029.66 | 1100.92 | |||||||
6 | ||||||||||||||||||||||||||||||||
7 | Revenue | 680.35 | 906.53 | 1176.98 | 1092.10 | 991.93 | 1095.56 | 1212.47 | 1336.95 | 1360.05 | 1380.66 | 1535.64 | 1756.02 | 1962.21 | 2057.47 | 2242.21 | 2422.53 | 2724.88 | 3121.16 | 3360.69 | 3685.28 | 4204.19 | 5081.58 | 5842.62 | 6127.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
8 | Revenue growth | 33.25% | 29.83% | -7.21% | -9.17% | 10.45% | 10.67% | 10.27% | 1.73% | 1.52% | 11.23% | 14.35% | 11.74% | 4.85% | 8.98% | 8.04% | 12.48% | 14.54% | 7.67% | 9.66% | 14.08% | 20.87% | 14.98% | 4.87% | -100.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
9 | Revenue CAGR Chan vs Ghazi | 10.29% | 14.83% | 12.76% | ||||||||||||||||||||||||||||
10 | Contracted backlog | 7100.00 | 8600.00 | |||||||||||||||||||||||||||||
11 | ||||||||||||||||||||||||||||||||
12 | Cost of revenue | |||||||||||||||||||||||||||||||
13 | License/time-based products | 29.90 | 45.74 | 53.52 | 51.32 | 102.33 | 129.05 | 146.42 | 171.97 | 175.62 | 180.25 | 205.39 | 232.81 | 268.91 | 268.35 | 303.63 | 346.83 | 413.20 | 448.43 | 459.13 | 487.31 | 542.11 | 653.78 | 763.49 | 770.24 | |||||||
14 | Maintenance and service | 79.75 | 78.17 | 78.00 | 83.76 | 70.78 | 65.97 | 64.36 | 63.60 | 65.37 | 64.75 | 80.24 | 78.61 | 80.34 | 87.23 | 105.24 | 94.02 | 164.87 | 203.43 | 234.20 | 254.93 | 271.20 | 342.98 | 383.84 | 367.06 | |||||||
15 | Amortization of intangible assets & stock compensation | 33.94 | 92.86 | 102.57 | 81.53 | 28.51 | 23.49 | 23.33 | 32.66 | 36.10 | 54.82 | 81.26 | 104.30 | 101.31 | 110.05 | 102.12 | 76.11 | 84.03 | 59.62 | 52.45 | 48.46 | 66.94 | 74.86 | 108.00 | ||||||||
16 | Product/upfront license | 20.48 | 15.32 | 15.95 | 19.41 | |||||||||||||||||||||||||||
17 | ||||||||||||||||||||||||||||||||
18 | Cost of Revenue | 130.12 | 173.16 | 240.32 | 257.06 | 254.64 | 223.53 | 234.27 | 258.90 | 273.65 | 281.09 | 340.45 | 392.67 | 453.55 | 456.89 | 518.92 | 542.96 | 654.18 | 735.90 | 752.95 | 794.69 | 861.78 | 1063.70 | 1222.19 | 1245.29 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
19 | Gross | 550.23 | 733.38 | 936.67 | 835.05 | 737.30 | 872.03 | 978.20 | 1078.06 | 1086.40 | 1099.57 | 1195.19 | 1363.34 | 1508.66 | 1600.59 | 1723.29 | 1879.57 | 2070.70 | 2385.26 | 2607.75 | 2890.59 | 3342.42 | 4017.89 | 4620.43 | 4882.15 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
20 | Gross margin | 80.87% | 80.90% | 79.58% | 76.46% | 74.33% | 79.60% | 80.68% | 80.64% | 79.88% | 79.64% | 77.83% | 77.64% | 76.89% | 77.79% | 76.86% | 77.59% | 75.99% | 76.42% | 77.60% | 78.44% | 79.50% | 79.07% | 79.08% | 79.68% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
21 | Research and development | 189.83 | 225.55 | 285.88 | 285.28 | 320.94 | 370.63 | 379.22 | 394.75 | 419.91 | 449.23 | 491.87 | 581.63 | 669.20 | 718.77 | 776.23 | 856.71 | 908.84 | 1084.82 | 1136.93 | 1279.02 | 1504.82 | 1680.38 | 1946.81 | 2082.36 | |||||||
22 | Sale and marketing | 273.95 | 264.81 | 310.69 | 302.37 | 333.64 | 330.36 | 349.40 | 334.78 | 324.12 | 339.76 | 363.12 | 415.63 | 425.98 | 453.08 | 474.41 | 502.37 | 549.25 | 622.98 | 632.89 | 632.01 | 712.49 | 779.78 | 889.02 | 859.34 | |||||||
23 | General and administrative | 69.68 | 78.46 | 90.02 | 121.55 | 104.99 | 112.87 | 101.74 | 103.85 | 119.10 | 114.89 | 112.76 | 157.46 | 143.79 | 155.22 | 165.10 | 165.96 | 196.84 | 262.56 | 229.22 | 284.53 | 322.99 | 353.84 | 410.31 | 568.50 | |||||||
24 | Amortization of intangible assets | 17.01 | 28.65 | 35.32 | 34.89 | 31.87 | 27.94 | 26.61 | 20.77 | 12.81 | 11.58 | 14.60 | 18.60 | 23.20 | 24.81 | 26.00 | 27.51 | 31.61 | 41.63 | 41.29 | 38.83 | 33.92 | 29.75 | 28.03 | 16.24 | |||||||
25 | In-process research and development | 0.00 | 87.70 | 19.85 | 1.64 | 5.70 | 0.80 | 3.20 | 4.80 | 2.20 | 0.00 | |||||||||||||||||||||
26 | Integration | 128.53 | 0.00 | 0.00 | ||||||||||||||||||||||||||||
27 | Restructuring charge | 15.09 | 9.63 | 36.59 | 12.95 | 47.19 | 36.06 | 33.41 | 12.06 | 77.00 | ||||||||||||||||||||||
28 | ||||||||||||||||||||||||||||||||
29 | Operating expense | 550.48 | 813.69 | 741.76 | 745.73 | 797.14 | 842.60 | 860.16 | 858.94 | 878.14 | 915.46 | 982.35 | 1173.32 | 1262.17 | 1351.87 | 1456.83 | 1562.18 | 1723.13 | 2024.94 | 2087.52 | 2270.45 | 2607.63 | 2855.81 | 3351.17 | 3526.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
30 | % to Revenue | 80.91% | 89.76% | 63.02% | 68.28% | 80.36% | 76.91% | 70.94% | 64.25% | 64.57% | 66.31% | 63.97% | 66.82% | 64.32% | 65.71% | 64.97% | 64.49% | 63.24% | 64.88% | 62.12% | 61.61% | 62.02% | 56.20% | 57.36% | 57.55% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
31 | Operating income | -0.25 | -80.32 | 194.91 | 89.32 | -59.85 | 29.43 | 118.04 | 219.11 | 208.25 | 184.11 | 212.84 | 190.02 | 246.49 | 248.72 | 266.47 | 317.40 | 347.56 | 360.33 | 520.23 | 620.14 | 734.79 | 1162.08 | 1269.26 | 1355.71 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
32 | Operating margin | -100.04% | -8.86% | 16.56% | 8.18% | -6.03% | 2.69% | 9.74% | 16.39% | 15.31% | 13.33% | 13.86% | 10.82% | 12.56% | 12.09% | 11.88% | 13.10% | 12.76% | 11.54% | 15.48% | 16.83% | 17.48% | 22.87% | 21.72% | 22.13% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
33 | Other income | 83.78 | -208.62 | 24.08 | 2.28 | 52.06 | 14.29 | 47.76 | -0.16 | 24.82 | 14.55 | 6.27 | 11.11 | 29.17 | 23.43 | 15.14 | 12.15 | 35.54 | 3.32 | 25.28 | 18.02 | 70.72 | -46.52 | 32.52 | 158.15 | |||||||
34 | ||||||||||||||||||||||||||||||||
35 | Other income | 83.78 | -208.62 | 24.08 | 2.28 | 52.06 | 14.29 | 47.76 | -0.16 | 24.82 | 14.55 | 6.27 | 11.11 | 29.17 | 23.43 | 15.14 | 12.15 | 35.54 | 3.32 | 25.28 | 18.02 | 70.72 | -46.52 | 32.52 | 158.15 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
36 | Income before tax | 83.53 | -288.94 | 218.99 | 91.59 | -7.79 | 43.72 | 165.80 | 218.96 | 233.07 | 198.66 | 219.11 | 201.14 | 275.67 | 272.14 | 281.61 | 329.55 | 383.10 | 363.64 | 545.51 | 638.16 | 805.51 | 1115.55 | 1301.78 | 1513.86 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
37 | Income tax | 26.73 | -88.95 | 69.27 | 17.26 | 9.33 | 18.98 | 35.31 | 28.98 | 65.39 | -38.41 | -2.25 | 18.73 | 27.87 | 13.02 | 55.68 | 62.72 | 246.54 | -68.98 | 13.14 | -25.29 | 49.16 | 137.08 | 83.66 | 99.72 | |||||||
38 | Net income | 56.80 | -199.99 | 149.72 | 74.34 | -17.11 | 24.74 | 130.49 | 189.98 | 167.68 | 237.06 | 221.36 | 182.40 | 247.80 | 259.12 | 225.93 | 266.83 | 136.56 | 432.62 | 532.37 | 663.45 | 756.36 | 978.48 | 1218.13 | 1414.14 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
39 | Net margin | 8.35% | -22.06% | 12.72% | 6.81% | -1.73% | 2.26% | 10.76% | 14.21% | 12.33% | 17.17% | 14.42% | 10.39% | 12.63% | 12.59% | 10.08% | 11.01% | 5.01% | 13.86% | 15.84% | 18.00% | 17.99% | 19.26% | 20.85% | 23.08% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
40 | Average Net Margin Chan vs Ghazi | 11.43% | 19.02% | 19.84% | ||||||||||||||||||||||||||||
41 | Earning per share | 0.44 | -1.50 | 0.95 | 0.46 | -0.12 | 0.17 | 0.87 | 1.29 | 1.15 | 1.56 | 1.47 | 1.21 | 1.58 | 1.64 | 1.43 | 1.72 | 0.88 | 2.82 | 3.45 | 4.26 | 4.81 | 6.25 | 7.85 | 9.07 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
42 | EPS Growth | -440.76% | 163.18% | -50.87% | -125.41% | 244.81% | 409.84% | 47.60% | -10.64% | 35.74% | -5.66% | -17.55% | 30.37% | 3.83% | -13.00% | 20.65% | -48.87% | 219.85% | 22.42% | 23.41% | 12.82% | 30.07% | 25.53% | 15.53% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
43 | EPS Growth (5 year average) | -17.20% | 9.61% | 6.35% | 19.86% | 70.05% | 53.82% | 6.85% | 4.23% | 7.40% | -1.74% | 3.22% | -6.19% | 12.25% | 16.01% | 24.41% | 22.76% | 47.96% | 22.72% | 21.30% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||
44 | EPS CAGR Chan vs Ghazi | 11.24% | 22.79% | 21.30% | ||||||||||||||||||||||||||||
45 | ||||||||||||||||||||||||||||||||
46 | ||||||||||||||||||||||||||||||||
47 | ||||||||||||||||||||||||||||||||
48 | Common stock (Diluted) | 129.32 | 133.62 | 158.33 | 159.99 | 144.97 | 144.73 | 149.72 | 147.67 | 145.86 | 151.91 | 150.37 | 150.28 | 156.60 | 157.71 | 158.07 | 154.72 | 154.87 | 153.39 | 154.19 | 155.71 | 157.34 | 156.49 | 155.20 | 155.94 | |||||||
49 | ||||||||||||||||||||||||||||||||
50 | Price at yearend | 23.93 | 23.12 | 33.67 | 18.55 | 20.65 | 26.73 | 25.88 | 18.93 | 22.20 | 27.24 | 27.32 | 31.63 | 40.62 | 43.96 | 45.77 | 58.86 | 85.24 | 83.90 | 140.62 | 259.24 | 370.81 | 319.27 | 514.91 | 485.36 | |||||||
51 | P/E | 54.48 | -15.45 | 35.60 | 39.92 | -174.92 | 156.36 | 29.69 | 14.71 | 19.31 | 17.46 | 18.56 | 26.06 | 25.67 | 26.76 | 32.02 | 34.13 | 96.67 | 29.75 | 40.73 | 60.84 | 77.14 | 51.06 | 65.60 | 53.52 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
52 | (never assume price will back to previous high) | |||||||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||||||||
54 | Total Assets | 1128.91 | 1978.71 | 2307.35 | 2092.19 | 2133.42 | 2157.82 | 2617.34 | 2742.48 | 2938.85 | 3286.55 | 3368.84 | 4147.66 | 4358.94 | 4775.50 | 5045.74 | 5240.37 | 5396.41 | 6145.97 | 6405.16 | 7564.24 | 8259.01 | 8859.00 | 9764.30 | 12507.334 | |||||||
55 | Cash and equivalents+short term investment | 271.70 | 312.58 | 524.31 | 346.71 | 404.44 | 330.76 | 579.33 | 577.63 | 701.61 | 775.41 | 855.08 | 700.38 | 1022.44 | 985.76 | 836.19 | 976.62 | 1048.36 | 723.12 | 728.60 | 1235.65 | 1432.84 | 1417.61 | 1438.91 | 4050.401 | |||||||
56 | Other financial assets (current) | 204.74 | 102.15 | 174.05 | 232.32 | 182.07 | 241.96 | 405.13 | 373.67 | 466.71 | 163.15 | 149.00 | 128.75 | 140.70 | 147.95 | 147.91 | 151.64 | |||||||||||||||
57 | Account receivables | 146.29 | 207.21 | 201.00 | 132.26 | 100.18 | 122.58 | 123.90 | 147.37 | 127.01 | 181.10 | 203.12 | 292.69 | 256.03 | 326.73 | 385.69 | 438.87 | 451.14 | 554.22 | 553.90 | 780.71 | 568.50 | 796.09 | 946.97 | 934.47 | |||||||
58 | Debt | 0.61 | 1.42 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 135.00 | 105.00 | 75.00 | 205.00 | 205.00 | 143.99 | 469.30 | 137.71 | 127.91 | 100.09 | 20.82 | 18.08 | 15.601 | |||||||
59 | Equity | 485.66 | 1113.48 | 1433.41 | 1265.05 | 1210.64 | 1163.17 | 1436.39 | 1528.37 | 1844.17 | 2100.18 | 2101.30 | 2543.97 | 2788.28 | 3056.17 | 3133.99 | 3195.15 | 3279.72 | 3485.02 | 4088.88 | 4912.37 | 5298.94 | 5520.53 | 6153.26 | 8993.206 | |||||||
60 | Total Liabilities | 643.25 | 865.23 | 873.94 | 827.18 | 922.79 | 994.66 | 1180.94 | 1214.11 | 1094.69 | 1186.36 | 1267.54 | 1603.69 | 1570.66 | 1719.33 | 1911.75 | 2045.22 | 2116.69 | 2660.96 | 2316.28 | 2582.11 | 2886.64 | 3223.35 | 3479.11 | 3380.959 | |||||||
61 | Invested Capital | 486.26 | 1114.90 | 1433.41 | 1265.05 | 1210.64 | 1163.17 | 1436.39 | 1528.37 | 1844.17 | 2100.18 | 2101.30 | 2678.97 | 2893.28 | 3131.17 | 3338.99 | 3400.15 | 3423.71 | 3954.32 | 4226.58 | 5040.28 | 5399.03 | 5541.35 | 6171.34 | 9008.81 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
62 | Goodwill Impairment | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||||||||
63 | Acquisition | 331.30 | 569.50 | 355.00 | ||||||||||||||||||||||||||||
64 | Goodwill | 205.80 | 321.80 | 229.40 | 96.14 | |||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||||||||
66 | Cash flow from operation 1 | 20.17 | -94.77 | 388.62 | 236.31 | 145.84 | 179.79 | 304.46 | 330.08 | 363.11 | 432.18 | 429.73 | 428.36 | 501.27 | 506.04 | 562.23 | 557.39 | 560.81 | 574.72 | 875.80 | 1179.77 | 1362.44 | 1798.24 | 2030.61 | 2983.43 | |||||||
67 | CapEx | 82.49 | 48.76 | 50.15 | 45.01 | 43.56 | 48.46 | 70.99 | 38.87 | 39.20 | 39.22 | 57.35 | 54.19 | 63.46 | 103.28 | 86.97 | 66.91 | 70.33 | 97.31 | 198.13 | 154.72 | 93.76 | 136.59 | 189.62 | 123.16 | |||||||
68 | Acquisition | -4.12 | -168.31 | 167.74 | 60.14 | 174.50 | 41.14 | 57.47 | 184.65 | 53.36 | 500.83 | 41.02 | 970.09 | 0.00 | 394.62 | 340.15 | 60.06 | 259.20 | 652.64 | 36.61 | 201.05 | 296.02 | 422.37 | 297.69 | -1289.63 | |||||||
69 | Intellecture properties | 1.31 | 1.59 | 2.62 | 2.74 | 2.95 | 2.95 | 2.60 | 2.87 | 2.85 | 2.85 | 2.89 | 3.30 | 3.61 | 3.64 | 3.68 | 4.13 | 3.23 | 2.95 | 4.26 | 4.05 | 1.98 | 2.49 | 2.20 | 0.00 | |||||||
70 | Equity investment | |||||||||||||||||||||||||||||||
71 | Total of CapEx + Acquisition + investment 2 | 79.68 | -117.96 | 220.51 | 107.88 | 221.01 | 92.55 | 131.06 | 226.39 | 95.41 | 542.90 | 101.25 | 1027.58 | 67.07 | 501.54 | 430.80 | 131.10 | 332.76 | 752.91 | 238.99 | 359.81 | 391.76 | 561.46 | 489.51 | -1166.47 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
72 | Free Cash Flow | -59.52 | 23.20 | 168.12 | 128.42 | -75.18 | 87.24 | 173.40 | 103.68 | 267.70 | -110.72 | 328.48 | -599.22 | 434.21 | 4.51 | 131.43 | 426.29 | 228.05 | -178.19 | 636.81 | 819.96 | 970.68 | 1236.78 | 1541.10 | 4149.90 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
73 | Free Cash Flow/Cash flow from operation | -295.13% | -24.48% | 43.26% | 54.35% | -51.55% | 48.52% | 56.95% | 31.41% | 73.72% | -25.62% | 76.44% | -139.89% | 86.62% | 0.89% | 23.38% | 76.48% | 40.66% | -31.00% | 72.71% | 69.50% | 71.25% | 68.78% | 75.89% | 139.10% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
74 | Free Cash Flow/Cash flow from operation 5yrs avg | 26.58% | 38.77% | 38.41% | 34.90% | 42.08% | 32.39% | 41.01% | -0.51% | 14.87% | 2.49% | 12.33% | 15.54% | 45.56% | 22.17% | 39.74% | 51.57% | 54.40% | 60.20% | 71.83% | 93.20% | 96.62% | 101.70% | 113.50% | 139.10% | #DIV/0! | ||||||
75 | ||||||||||||||||||||||||||||||||
76 | Free cash flow per share | -0.46 | 0.17 | 1.06 | 0.80 | -0.52 | 0.60 | 1.16 | 0.70 | 1.84 | -0.73 | 2.18 | -3.99 | 2.77 | 0.03 | 0.83 | 2.76 | 1.47 | -1.16 | 4.13 | 5.27 | 6.17 | 7.90 | 9.93 | 26.61 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
77 | Price to Free cash flow per share ratio | -52.00 | 133.18 | 31.71 | 23.11 | -39.82 | 44.34 | 22.34 | 26.96 | 12.10 | -37.37 | 12.51 | -7.93 | 14.65 | 1538.94 | 55.05 | 21.36 | 57.89 | -72.23 | 34.05 | 49.23 | 60.11 | 40.40 | 51.85 | 18.24 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
78 | Free Cash Flow to Market Cap | -1.92% | 0.75% | 3.15% | 4.33% | -2.51% | 2.26% | 4.48% | 3.71% | 8.27% | -2.68% | 8.00% | -12.61% | 6.83% | 0.06% | 1.82% | 4.68% | 1.73% | -1.38% | 2.94% | 2.03% | 1.66% | 2.48% | 1.93% | 5.48% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
79 | ||||||||||||||||||||||||||||||||
80 | stock repurchase | 331.88 | 171.68 | 260.75 | 423.30 | 88.39 | 199.99 | 151.62 | 220.05 | 0.00 | 184.70 | 401.84 | 40.00 | 145.02 | 119.75 | 260.00 | 400.00 | 380.00 | 400.00 | 329.19 | 242.08 | 753.08 | 1100.00 | 1160.72 | 0.00 | |||||||
81 | Stock compensation | na | na | na | 3.36 | 6.18 | 63.04 | 62.01 | 65.47 | 56.93 | 59.99 | 56.41 | 71.41 | 67.51 | 79.44 | 86.40 | 97.58 | 108.29 | 140.03 | 155.00 | 248.58 | 345.27 | 459.03 | 563.29 | 692.316 | |||||||
82 | % to Cash flow from operation | #VALUE! | #VALUE! | #VALUE! | 1.42% | 4.23% | 35.06% | 20.37% | 19.84% | 15.68% | 13.88% | 13.13% | 16.67% | 13.47% | 15.70% | 15.37% | 17.51% | 19.31% | 24.37% | 17.70% | 21.07% | 25.34% | 25.53% | 27.74% | 23.21% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
83 | Option share granted | 5.97 | 8.16 | 4.52 | 5.14 | 8.28 | 5.34 | 4.05 | 4.09 | 3.87 | 4.67 | 4.41 | 4.45 | 4.22 | 4.15 | 4.62 | 4.65 | 4.20 | 3.68 | 3.92 | 3.82 | 3.53 | 4.38 | 3.83 | 2.99 | |||||||
84 | price per granted share from repurchase | 55.62 | 21.03 | 57.71 | 82.31 | 10.68 | 37.44 | 37.45 | 53.82 | 0.00 | 39.53 | 91.12 | 8.99 | 34.34 | 28.83 | 56.34 | 85.98 | 90.50 | 108.84 | 83.89 | 63.34 | 213.64 | 251.37 | 302.74 | 0.00 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
85 | percentage above market price yearend | 132.4% | -9.0% | 71.4% | 343.7% | -48.3% | 40.1% | 44.7% | 184.3% | -100.0% | 45.1% | 233.5% | -71.6% | -15.5% | -34.4% | 23.1% | 46.1% | 6.2% | 29.7% | -40.3% | -75.6% | -42.4% | -21.3% | -41.2% | -100.0% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
86 | Cash wasted if granted shares purchased from market | 189.09 | -17.03 | 108.62 | 327.90 | -82.58 | 57.23 | 46.83 | 142.65 | 0.00 | 57.43 | 281.35 | -100.79 | -26.52 | -62.86 | 48.77 | 126.18 | 22.08 | 91.67 | -222.59 | -748.74 | -554.02 | -297.13 | -813.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
87 | Accumulated cash wasted for shareholders | 189.09 | 172.06 | 280.69 | 608.59 | 526.01 | 583.24 | 630.07 | 772.72 | 772.72 | 830.15 | 1111.51 | 1010.72 | 984.20 | 921.34 | 970.11 | 1096.29 | 1118.37 | 1210.04 | 987.44 | 238.71 | -315.32 | -612.44 | -1425.88 | -1425.88 | -1425.88 | -1425.88 | -1425.88 | -1425.88 | -1425.88 | ||
88 | ||||||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||||||
91 | CEO Pay | 0.963 | 1.663 | 2.000 | 4.240 | 4.493 | 4.537 | 4.366 | 5.210 | 5.362 | 4.918 | 4.491 | 4.919 | 5.715 | 6.652 | 7.433 | 9.628 | 6.769 | 9.975 | 10.058 | 11.37 | |||||||||||
92 | % to Revenue | 0.00% | 0.00% | 0.00% | 0.09% | 0.17% | 0.18% | 0.35% | 0.34% | 0.33% | 0.32% | 0.34% | 0.31% | 0.25% | 0.22% | 0.22% | 0.24% | 0.24% | 0.24% | 0.29% | 0.18% | 0.24% | 0.20% | 0.19% | 0.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
93 | % to OP Income | 0.00% | 0.00% | 0.00% | 1.08% | -2.78% | 6.79% | 3.59% | 2.05% | 2.18% | 2.37% | 2.45% | 2.82% | 2.00% | 1.81% | 1.85% | 1.80% | 1.91% | 2.06% | 1.85% | 1.09% | 1.36% | 0.87% | 0.90% | 0.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
94 | % to Net | 0.00% | 0.00% | 0.00% | 1.30% | -9.72% | 8.08% | 3.25% | 2.36% | 2.71% | 1.84% | 2.35% | 2.94% | 1.98% | 1.73% | 2.18% | 2.14% | 4.87% | 1.72% | 1.81% | 1.02% | 1.32% | 1.03% | 0.93% | 0.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
95 | ||||||||||||||||||||||||||||||||
96 | Executive Pay 3 | 3.671 | 5.565 | 6.030 | 13.011 | 12.615 | 11.896 | 12.799 | 14.527 | 15.648 | 16.337 | 14.896 | 15.304 | 16.710 | 21.923 | 23.612 | 31.051 | 25.184 | 35.801 | 28.186 | 42.88 | |||||||||||
97 | % to Revenue | 0.00% | 0.00% | 0.00% | 0.34% | 0.56% | 0.55% | 1.07% | 0.94% | 0.87% | 0.93% | 0.95% | 0.89% | 0.83% | 0.72% | 0.68% | 0.69% | 0.80% | 0.76% | 0.92% | 0.68% | 0.85% | 0.55% | 0.73% | 0.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
98 | % to OP Income | 0.00% | 0.00% | 0.00% | 4.11% | -9.30% | 20.49% | 11.02% | 5.76% | 5.71% | 6.95% | 6.83% | 8.23% | 6.63% | 5.99% | 5.74% | 5.26% | 6.31% | 6.55% | 5.97% | 4.06% | 4.87% | 2.43% | 3.38% | 0.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
99 | % to Net | 0.00% | 0.00% | 0.00% | 4.94% | -32.52% | 24.37% | 9.97% | 6.64% | 7.09% | 5.40% | 6.56% | 8.58% | 6.59% | 5.75% | 6.77% | 6.26% | 16.05% | 5.46% | 5.83% | 3.80% | 4.73% | 2.88% | 3.52% | 0.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
100 | ||||||||||||||||||||||||||||||||