| 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 | Candence Design Systems (CDNS) | Market Price as 00/00/0000: $ | ||||||||||||||||||||||||||||||
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 | Product and Maintenance | 830.49 | 806.79 | 663.51 | 729.78 | 851.50 | 982.67 | 1,103.97 | 516.60 | 400.77 | 471.60 | 1,033.14 | 1,212.43 | 1,357.93 | 1,479.15 | 1,578.94 | 1,683.77 | 1,813.99 | 1,997.89 | 2,204.62 | 2,536.62 | 2,812.95 | 3,340.20 | 3,834.36 | 4,213.51 | |||||||
4 | Services | 263.35 | 149.81 | 131.15 | 137.05 | 126.17 | 134.90 | 125.84 | 133.50 | 106.56 | 100.89 | 116.69 | 114.00 | 102.18 | 101.78 | 123.15 | 132.31 | 129.05 | 140.14 | 131.70 | 146.27 | 175.30 | 221.52 | 255.63 | 427.8 | |||||||
5 | Maintenance | 336.59 | 331.35 | 324.82 | 330.65 | 351.53 | 366.33 | 385.21 | 388.51 | 345.30 | 363.47 | |||||||||||||||||||||
6 | ||||||||||||||||||||||||||||||||
7 | Revenue | 1430.43 | 1287.94 | 1119.48 | 1197.48 | 1329.19 | 1483.90 | 1615.01 | 1038.61 | 852.63 | 935.95 | 1149.84 | 1326.42 | 1460.12 | 1580.93 | 1702.09 | 1816.08 | 1943.03 | 2138.02 | 2336.32 | 2682.89 | 2988.24 | 3561.72 | 4089.99 | 4641.26 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
8 | Revenue growth | -9.96% | -13.08% | 6.97% | 11.00% | 11.64% | 8.84% | -35.69% | -17.91% | 9.77% | 22.85% | 15.36% | 10.08% | 8.27% | 7.66% | 6.70% | 6.99% | 10.04% | 9.27% | 14.83% | 11.38% | 19.19% | 14.83% | 13.48% | -100.00% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
9 | Contracted backlog | 1400.00 | 1600.00 | 1800.00 | 1900.00 | 2000.00 | 1800.00 | 1600.00 | 1700.00 | 1700.00 | 1700.00 | 1900.00 | 2100.00 | 2300.00 | 2500.00 | 2700.00 | 2900.00 | 3600.00 | 3900.00 | 4400.00 | 5800.00 | 6000.00 | n/a | |||||||||
10 | ||||||||||||||||||||||||||||||||
11 | Cost of product and maintenance | 118.46 | 98.29 | 67.04 | 82.01 | 79.72 | 66.77 | 60.07 | 50.30 | 32.11 | 31.42 | 113.66 | 118.52 | 132.25 | 156.33 | 155.66 | 183.29 | 156.68 | 173.01 | 189.15 | 231.03 | 222.65 | 273.57 | 331.76 | 436.60 | |||||||
12 | Cost of services | 192.65 | 114.69 | 93.15 | 90.99 | 91.89 | 96.50 | 93.36 | 103.34 | 90.54 | 82.97 | 81.50 | 72.61 | 67.96 | 67.37 | 82.79 | 73.20 | 80.71 | 85.74 | 77.21 | 74.47 | 84.36 | 98.06 | 103.28 | 210.90 | |||||||
13 | cost of maintenance | 65.30 | 65.09 | 56.46 | 53.05 | 59.79 | 63.83 | 61.08 | 55.84 | 46.59 | 42.05 | |||||||||||||||||||||
14 | Cost of revenue | 376.41 | 278.07 | 216.65 | 226.05 | 231.41 | 227.10 | 214.51 | 209.48 | 169.24 | 156.44 | 195.16 | 191.12 | 200.20 | 223.71 | 238.45 | 256.49 | 237.39 | 258.75 | 266.36 | 305.50 | 307.01 | 371.62 | 435.04 | 647.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
15 | Gross | 1054.03 | 1009.88 | 902.84 | 971.43 | 1097.78 | 1256.80 | 1400.51 | 829.13 | 683.39 | 779.51 | 954.68 | 1135.30 | 1259.92 | 1357.23 | 1463.64 | 1559.59 | 1705.64 | 1879.28 | 2069.96 | 2377.39 | 2681.24 | 3190.10 | 3654.95 | 3993.76 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
16 | Gross margin | 73.69% | 78.41% | 80.65% | 81.12% | 82.59% | 84.70% | 86.72% | 79.83% | 80.15% | 83.29% | 83.03% | 85.59% | 86.29% | 85.85% | 85.99% | 85.88% | 87.78% | 87.90% | 88.60% | 88.61% | 89.73% | 89.57% | 89.36% | 86.05% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
17 | Marketing and sales | 393.61 | 402.15 | 326.58 | 325.94 | 366.16 | 405.58 | 407.15 | 358.41 | 286.83 | 305.56 | 323.80 | 342.28 | 378.16 | 399.69 | 402.43 | 395.19 | 419.16 | 439.67 | 481.67 | 516.46 | 560.26 | 604.22 | 690.32 | 757.48 | |||||||
18 | Research and development | 297.33 | 326.41 | 340.12 | 351.25 | 390.74 | 460.06 | 494.03 | 457.91 | 354.70 | 376.41 | 400.75 | 454.09 | 534.02 | 603.01 | 637.57 | 735.34 | 804.22 | 884.82 | 935.94 | 1033.73 | 1134.28 | 1251.54 | 1441.80 | 1549.09 | |||||||
19 | General and administrative | 119.35 | 115.77 | 82.57 | 85.41 | 129.55 | 143.32 | 169.00 | 152.03 | 122.65 | 86.39 | 92.86 | 112.08 | 121.31 | 113.62 | 109.98 | 125.11 | 134.18 | 133.41 | 139.81 | 154.43 | 189.02 | 242.12 | 242.43 | 282.28 | |||||||
20 | Amortization of intangible assets | 70.79 | 53.75 | 62.57 | 55.70 | 47.76 | 23.14 | 19.42 | 22.73 | 11.42 | 14.16 | 16.54 | 15.08 | 19.42 | 24.02 | 23.72 | 18.10 | 14.72 | 14.09 | 12.13 | 18.01 | 19.64 | 18.47 | 18.16 | 30.38 | |||||||
21 | Restructuring | 61.62 | 134.30 | 66.84 | 13.54 | 35.33 | -0.80 | -9.69 | 46.45 | 31.38 | 10.15 | 0.36 | 0.11 | 18.00 | 10.25 | 4.51 | 40.96 | 9.41 | 11.09 | 8.62 | 9.22 | -1.05 | 0.06 | 11.01 | 23.77 | |||||||
22 | Impairment of goodwill | 25.83 | 1317.20 | |||||||||||||||||||||||||||||
23 | Impairment of intangible and tangible assets | 47.07 | ||||||||||||||||||||||||||||||
24 | Write-off | 21.70 | 34.00 | 7.50 | 9.00 | 9.40 | 0.90 | 2.68 | 0.60 | |||||||||||||||||||||||
25 | Deferred compensation | 17.91 | 44.01 | 41.12 | 26.43 | |||||||||||||||||||||||||||
26 | Litigation charge | -194.56 | -261.09 | -14.50 | 15.80 | |||||||||||||||||||||||||||
27 | Operating expense | 813.58 | 849.30 | 912.80 | 867.28 | 978.95 | 1032.20 | 1082.59 | 2402.40 | 806.98 | 808.48 | 834.30 | 923.63 | 1070.91 | 1150.58 | 1178.21 | 1314.69 | 1381.69 | 1483.07 | 1578.17 | 1731.84 | 1902.15 | 2116.41 | 2403.72 | 2643.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
28 | % to Revenue | 56.88% | 65.94% | 81.54% | 72.43% | 73.65% | 69.56% | 67.03% | 231.31% | 94.65% | 86.38% | 72.56% | 69.63% | 73.34% | 72.78% | 69.22% | 72.39% | 71.11% | 69.37% | 67.55% | 64.55% | 63.65% | 59.42% | 58.77% | 56.95% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
29 | Operating income | 240.44 | 160.58 | -9.96 | 104.15 | 118.83 | 224.59 | 317.92 | -1573.27 | -123.59 | -28.97 | 120.38 | 211.67 | 189.01 | 206.64 | 285.43 | 244.90 | 323.96 | 396.21 | 491.80 | 645.55 | 779.09 | 1073.69 | 1251.23 | 1350.76 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
30 | Operating margin | -83.19% | 12.47% | -0.89% | 8.70% | 8.94% | 15.14% | 19.68% | -151.48% | -14.50% | -3.09% | 10.47% | 15.96% | 12.94% | 13.07% | 16.77% | 13.49% | 16.67% | 18.53% | 21.05% | 24.06% | 26.07% | 30.15% | 30.59% | 29.10% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
31 | ||||||||||||||||||||||||||||||||
32 | Interest expense | -2.63 | -2.80 | -5.00 | -6.20 | -5.45 | -12.35 | -28.26 | -27.40 | -28.87 | -36.34 | -43.03 | -34.74 | -37.58 | -34.12 | -28.31 | -23.67 | -25.66 | -23.14 | -18.83 | -20.75 | -16.98 | -22.93 | -36.19 | -76.00 | |||||||
33 | Other income (expense) | 4.33 | -13.76 | -15.60 | -11.51 | 15.10 | 70.40 | 58.53 | -16.84 | -1.04 | 2.54 | 18.07 | 11.34 | 7.57 | 8.48 | 10.48 | 15.92 | 16.76 | 3.32 | 6.00 | 7.95 | 6.33 | -5.39 | 66.89 | 121.06 | |||||||
34 | Extinguishment of debt | -40.77 | ||||||||||||||||||||||||||||||
35 | Other income | 1.70 | -16.56 | -20.60 | -17.71 | 9.65 | 17.29 | 30.27 | -44.25 | -29.91 | -33.80 | -24.95 | -23.40 | -30.01 | -25.64 | -17.83 | -7.75 | -8.91 | -19.82 | -12.83 | -12.80 | -10.65 | -28.32 | 30.70 | 45.06 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
36 | Income before tax | 242.14 | 144.02 | -30.57 | 86.44 | 128.48 | 241.88 | 348.19 | -1617.51 | -153.51 | -62.77 | 95.43 | 188.27 | 159.00 | 181.00 | 267.60 | 237.15 | 315.05 | 376.39 | 478.97 | 632.75 | 768.44 | 1045.36 | 1281.93 | 1395.82 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
37 | ||||||||||||||||||||||||||||||||
38 | Income tax | 100.86 | 83.68 | -13.00 | 11.96 | 79.14 | 99.70 | 61.40 | 239.20 | -3.63 | -189.31 | 23.20 | -251.68 | -5.25 | 22.10 | 15.18 | 34.07 | 110.95 | 30.61 | -510.01 | 42.10 | 72.48 | 196.41 | 240.78 | 340.3 | |||||||
39 | Net income | 141.28 | 60.34 | -17.57 | 74.47 | 49.34 | 142.17 | 286.79 | -1856.72 | -149.87 | 126.54 | 72.23 | 439.95 | 164.24 | 158.90 | 252.42 | 203.09 | 204.10 | 345.78 | 988.98 | 590.64 | 695.96 | 848.95 | 1041.14 | 1055.48 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
40 | Net margin | 9.88% | 4.68% | -1.57% | 6.22% | 3.71% | 9.58% | 17.76% | -178.77% | -17.58% | 13.52% | 6.28% | 33.17% | 11.25% | 10.05% | 14.83% | 11.18% | 10.50% | 16.17% | 42.33% | 22.02% | 23.29% | 23.84% | 25.46% | 22.74% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
41 | Earning per share (diluted) | 0.55 | 0.23 | -0.07 | 0.24 | 0.16 | 0.46 | 0.97 | -7.30 | -0.58 | 0.48 | 0.27 | 1.57 | 0.56 | 0.52 | 0.81 | 0.70 | 0.73 | 1.23 | 3.53 | 2.11 | 2.50 | 3.09 | 3.82 | 3.85 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
42 | EPS Growth | -58.86% | 129.19% | -469.92% | -35.56% | 189.91% | 113.23% | -852.47% | 92.04% | 181.86% | -43.96% | 487.72% | -64.43% | -7.11% | 56.04% | -13.73% | 4.46% | 68.86% | 186.66% | -40.09% | 18.16% | 23.69% | 23.66% | 0.98% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
43 | EPS Growth (5 year average) | -3.66% | -226.98% | 156.43% | -219.01% | -215.24% | -10.13% | 10.07% | -159.78% | -197.72% | 11.17% | 21.19% | -14.21% | 17.14% | 46.75% | 21.18% | 29.05% | 33.49% | 25.42% | 1.80% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||
44 | ||||||||||||||||||||||||||||||||
45 | Common stock (Diluted) | 257.66 | 267.50 | 266.79 | 305.77 | 314.38 | 312.46 | 295.59 | 254.32 | 257.78 | 265.87 | 270.82 | 280.67 | 294.56 | 306.78 | 312.30 | 291.26 | 280.22 | 281.14 | 280.52 | 279.64 | 278.86 | 275.01 | 272.75 | 273.83 | |||||||
46 | ||||||||||||||||||||||||||||||||
47 | Price at yearend | 21.77 | 11.79 | 17.98 | 13.81 | 16.92 | 17.91 | 17.01 | 3.66 | 5.88 | 8.26 | 10.40 | 13.51 | 14.02 | 18.83 | 20.81 | 25.22 | 41.82 | 43.48 | 69.36 | 136.43 | 186.35 | 160.64 | 272.37 | 300.46 | |||||||
48 | P/E | 39.70 | 52.27 | -273.08 | 56.70 | 107.80 | 39.36 | 17.53 | -0.50 | -10.11 | 17.36 | 38.99 | 8.62 | 25.14 | 36.35 | 25.75 | 36.17 | 57.42 | 35.35 | 19.67 | 64.59 | 74.67 | 52.04 | 71.35 | 77.95 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
49 | (never assume price will back to previous high) | |||||||||||||||||||||||||||||||
50 | ||||||||||||||||||||||||||||||||
51 | Total Assets | 1730.03 | 2426.62 | 2817.90 | 2989.84 | 3401.31 | 3442.82 | 3871.75 | 1679.85 | 1410.59 | 1732.12 | 1761.28 | 2287.00 | 2428.60 | 3209.56 | 2351.02 | 2096.91 | 2418.71 | 2468.65 | 3256.88 | 3817.43 | 4256.17 | 4966.69 | 5518.69 | 8828.29 | |||||||
52 | Cash and equivalents+short term investment | 274.79 | 395.61 | 418.42 | 593.01 | 894.59 | 934.34 | 1062.92 | 568.26 | 569.12 | 557.41 | 601.60 | 726.36 | 536.26 | 932.16 | 616.69 | 465.23 | 688.09 | 533.30 | 705.21 | 928.43 | 1088.94 | 882.33 | 1008.15 | 2644.03 | |||||||
53 | Other financial assets (current) | 24.09 | 15.19 | 3.84 | 2.18 | 12.72 | 3.04 | 100.70 | 96.79 | 90.45 | 94.50 | 3.06 | 4.46 | |||||||||||||||||||
54 | Account receivables | 258.40 | 313.97 | 348.68 | 384.11 | 282.07 | 238.44 | 326.21 | 298.67 | 200.63 | 191.89 | 136.77 | 97.82 | 107.62 | 122.49 | 164.85 | 157.17 | 190.43 | 297.08 | 304.55 | 338.49 | 337.60 | 486.71 | 489.22 | 680.46 | |||||||
55 | Debt | 0.00 | 52.00 | 420.00 | 420.00 | 580.00 | 758.39 | 730.39 | 416.57 | 436.01 | 679.87 | 641.09 | 447.01 | 324.83 | 691.18 | 348.79 | 693.49 | 729.37 | 445.29 | 346.02 | 346.79 | 347.59 | 748.08 | 649.06 | 2476.18 | |||||||
56 | Equity | 1121.35 | 1644.03 | 1572.28 | 1699.97 | 1844.70 | 1699.29 | 2080.07 | 186.71 | 108.37 | 276.65 | 411.13 | 915.17 | 1156.11 | 1333.57 | 1376.12 | 741.77 | 989.20 | 1288.41 | 2102.89 | 2350.33 | 3046.29 | 2745.11 | 3404.27 | 4673.58 | |||||||
57 | Total Liabilities | 608.68 | 782.59 | 1245.62 | 1289.87 | 1556.61 | 1743.53 | 1791.68 | 1493.14 | 1302.21 | 1455.46 | 1350.15 | 1371.83 | 1272.50 | 1875.98 | 974.90 | 1355.14 | 1429.51 | 1180.24 | 1254.33 | 1343.85 | 1538.50 | 2252.62 | 2149.86 | 4192.01 | |||||||
58 | Invested Capital | 1121.35 | 1696.03 | 1992.28 | 2119.97 | 2424.70 | 2457.68 | 2810.45 | 603.29 | 544.39 | 956.53 | 1052.22 | 1362.18 | 1480.93 | 2024.75 | 1724.90 | 1435.26 | 1718.57 | 1733.70 | 2448.91 | 2697.13 | 3393.88 | 3493.19 | 4053.33 | 7149.76 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
59 | Goodwill | 311.00 | 664.03 | 992.80 | 1267.58 | 1310.21 | 1267.58 | 1310.21 | 0.00 | 0.00 | 158.89 | 192.13 | 233.27 | 456.91 | 553.77 | 551.77 | 572.76 | 666.01 | 662.27 | 661.86 | 782.09 | 928.36 | 1374.27 | 1535.85 | 2378.67 | |||||||
60 | % to Assets | 18.0% | 27.4% | 35.2% | 42.4% | 38.5% | 36.8% | 33.8% | 0.0% | 0.0% | 9.2% | 10.9% | 10.2% | 18.8% | 17.3% | 23.5% | 27.3% | 27.5% | 26.8% | 20.3% | 20.5% | 21.8% | 27.7% | 27.8% | 26.9% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
61 | Goodwill Impairment | 25.80 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1317.20 | 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.00 | 0.00 | 0.00 | 0.00 | |||||||
62 | Goodwill acquired of the year | 156.20 | 306.92 | 208.66 | 44.35 | 221.67 | 17.39 | 45.70 | 0.00 | 0.00 | 156.10 | 32.25 | 39.68 | 227.96 | 102.03 | 0.00 | 23.58 | 90.22 | 0.00 | 0.00 | 120.56 | 154.36 | 456.32 | 160.08 | 889.59 | |||||||
63 | ||||||||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||||||||
66 | Cash flow from operation 1 | 477.02 | 404.46 | 226.70 | 306.11 | 285.17 | 430.12 | 522.39 | -20.61 | 46.40 | 207.73 | 218.51 | 357.03 | 350.47 | 393.48 | 457.70 | 426.47 | 543.52 | 526.71 | 723.29 | 920.34 | 1018.37 | 1154.35 | 1447.95 | 1730.84 | |||||||
67 | CapEx | 154.31 | 125.16 | 73.73 | 58.15 | 38.03 | 67.32 | 35.30 | 97.29 | 37.44 | 33.88 | 31.42 | 35.97 | 44.93 | 39.81 | 44.81 | 52.79 | 57.90 | 61.50 | 74.61 | 94.81 | 65.30 | 123.22 | 102.34 | 142.54 | |||||||
68 | Purchase of intangible assets | 1.75 | 8.75 | 33.51 | 4.16 | 2.60 | 8.41 | 2.00 | 2.39 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.58 | 1.00 | 0.17 | 0.00 | |||||||||||||
69 | Business combination | -6.91 | 34.68 | 182.25 | 115.12 | 297.13 | 65.78 | 80.73 | 20.93 | 14.90 | 258.82 | 44.05 | 66.43 | 392.83 | 167.12 | 0.00 | 41.63 | 143.25 | 0.00 | 0.34 | 197.56 | 226.20 | 613.79 | 198.35 | 737.57 | |||||||
70 | Equity investment | 20.49 | 6.82 | 39.76 | 22.77 | 14.18 | 3.80 | 3.21 | 4.39 | 2.30 | 3.00 | 0.61 | 0.25 | |||||||||||||||||||
71 | Total of CapEx + Acquisition + investment 2 | 169.64 | 175.41 | 329.25 | 200.20 | 351.94 | 145.31 | 121.23 | 125.00 | 54.64 | 295.71 | 76.08 | 102.65 | 437.75 | 206.93 | 44.81 | 94.42 | 201.15 | 61.50 | 74.94 | 292.38 | 293.08 | 738.00 | 300.85 | 880.12 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
72 | Free Cash Flow | 307.38 | 229.05 | -102.55 | 105.91 | -66.78 | 284.81 | 401.16 | -145.60 | -8.24 | -87.97 | 142.43 | 254.38 | -87.29 | 186.55 | 412.89 | 332.05 | 342.37 | 465.21 | 648.35 | 627.96 | 725.29 | 416.35 | 1147.10 | 850.72 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
73 | Free Cash Flow/Cash flow from operation | 64.44% | 56.63% | -45.24% | 34.60% | -23.42% | 66.22% | 76.79% | 706.51% | -17.76% | -42.35% | 65.18% | 71.25% | -24.91% | 47.41% | 90.21% | 77.86% | 62.99% | 88.32% | 89.64% | 68.23% | 71.22% | 36.07% | 79.22% | 49.15% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
74 | Free Cash Flow/Cash flow from operation 5yrs avg | 27.83% | 27.26% | 35.16% | 38.05% | 36.83% | 37.45% | 30.97% | 19.16% | 18.07% | 26.72% | 51.15% | 55.34% | 54.64% | 74.07% | 82.19% | 76.93% | 75.27% | 66.39% | 67.72% | 60.07% | 58.66% | 55.71% | 62.85% | 49.15% | #DIV/0! | ||||||
75 | ||||||||||||||||||||||||||||||||
76 | Free cash flow per share | 1.19 | 0.86 | -0.38 | 0.35 | -0.21 | 0.91 | 1.36 | -0.57 | -0.03 | -0.33 | 0.53 | 0.91 | -0.30 | 0.61 | 1.32 | 1.14 | 1.22 | 1.65 | 2.31 | 2.25 | 2.60 | 1.51 | 4.21 | 3.11 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
77 | Price to Free cash flow per share ratio | 18.25 | 13.77 | -46.78 | 39.87 | -79.66 | 19.65 | 12.53 | -6.39 | -183.95 | -24.96 | 19.77 | 14.91 | -47.31 | 30.97 | 15.74 | 22.12 | 34.23 | 26.28 | 30.01 | 60.75 | 71.65 | 106.11 | 64.76 | 96.71 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
78 | Free Cash Flow to Market Cap | 5.48% | 7.26% | -2.14% | 2.51% | -1.26% | 5.09% | 7.98% | -15.64% | -0.54% | -4.01% | 5.06% | 6.71% | -2.11% | 3.23% | 6.35% | 4.52% | 2.92% | 3.81% | 3.33% | 1.65% | 1.40% | 0.94% | 1.54% | 1.03% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
79 | ||||||||||||||||||||||||||||||||
80 | stock repurchase | 299.04 | 181.80 | 213.38 | 94.11 | 101.07 | 494.09 | 399.49 | 273.95 | 0.00 | 31.00 | 0.00 | 0.00 | 0.00 | 100.12 | 333.19 | 960.29 | 100.03 | 250.06 | 306.15 | 380.06 | 612.28 | 1050.09 | 700.13 | 550.03 | |||||||
81 | % to Cash flow from operation | 63% | 45% | 94% | 31% | 35% | 115% | 76% | -1329% | 0% | 15% | 0% | 0% | 0% | 25% | 73% | 225% | 18% | 47% | 42% | 41% | 60% | 91% | 48% | 32% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
82 | Stock compensation | na | na | na | 31.41 | 39.90 | 103.99 | 101.42 | 81.27 | 54.71 | 43.46 | 43.59 | 47.56 | 66.29 | 83.79 | 92.34 | 109.22 | 130.02 | 167.72 | 181.55 | 197.27 | 210.09 | 270.44 | 325.61 | 391.22 | |||||||
83 | % to Cash flow from operation | #VALUE! | #VALUE! | #VALUE! | 10.26% | 13.99% | 24.18% | 19.41% | -394.36% | 117.89% | 20.92% | 19.95% | 13.32% | 18.91% | 21.30% | 20.18% | 25.61% | 23.92% | 31.84% | 25.10% | 21.43% | 20.63% | 23.43% | 22.49% | 22.60% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
84 | option/restric shares granted | 14.83 | 17.18 | 16.32 | 14.02 | 11.36 | 8.74 | 4.35 | 9.29 | 9.36 | 7.30 | 7.47 | 7.78 | 6.35 | 7.15 | 7.15 | 8.47 | 6.73 | 4.70 | 4.62 | 2.71 | 2.30 | 4.14 | 0.26 | 1.785 | |||||||
85 | price per granted share from repurchase | $ 20.16 | $ 10.58 | $ 13.08 | $ 6.71 | $ 8.90 | $ 56.56 | $ 91.77 | $ 29.48 | $ - | $ 4.25 | $ - | $ - | $ - | $ 14.00 | $ 46.57 | $ 113.38 | $ 14.86 | $ 53.17 | $ 66.22 | $ 140.04 | $ 266.21 | $ 253.89 | $ 2,672.27 | $ 308.14 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
86 | percentage above market price yearend | -7.39% | -10.23% | -27.27% | -51.40% | -47.42% | 215.79% | 439.53% | 705.44% | -100.00% | -48.59% | -100.00% | -100.00% | -100.00% | -25.66% | 123.80% | 349.55% | -64.46% | 22.29% | -4.52% | 2.64% | 42.85% | 58.05% | 881.12% | 2.56% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
87 | Cash wasted if granted shares purchased from market | -23.85 | -20.71 | -80.00 | -99.51 | -91.15 | 337.63 | 325.45 | 239.94 | -55.01 | -29.30 | -77.68 | -105.08 | -89.00 | -34.56 | 184.31 | 746.68 | -181.38 | 45.57 | -14.50 | 9.79 | 183.67 | 385.68 | 628.77 | 13.70 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
88 | Accumulated cash wasted for shareholders | -23.85 | -44.56 | -124.56 | -224.07 | -315.22 | 22.41 | 347.85 | 587.79 | 532.78 | 503.48 | 425.80 | 320.72 | 231.72 | 197.17 | 381.48 | 1128.16 | 946.78 | 992.35 | 977.85 | 987.64 | 1171.31 | 1557.00 | 2185.77 | 2199.48 | 2199.48 | 2199.48 | 2199.48 | 2199.48 | 2199.48 | ||
89 | ||||||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||||||
91 | CEO Pay | 13.510 | 0.320 | 6.282 | 3.228 | 5.337 | 5.407 | 5.191 | 5.011 | 5.929 | 7.611 | 7.965 | 7.556 | 19.147 | 9.605 | 21.736 | 32.216 | 17.342 | 19.293 | |||||||||||||
92 | % to Revenue | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.84% | 0.03% | 0.74% | 0.34% | 0.46% | 0.41% | 0.36% | 0.32% | 0.35% | 0.42% | 0.41% | 0.35% | 0.82% | 0.36% | 0.73% | 0.90% | 0.42% | 0.42% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
93 | % to OP Income | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 4.25% | -0.02% | -5.08% | -11.15% | 4.43% | 2.55% | 2.75% | 2.42% | 2.08% | 3.11% | 2.46% | 1.91% | 3.89% | 1.49% | 2.79% | 3.00% | 1.39% | 1.43% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
94 | % to Net | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 4.71% | -0.02% | -4.19% | 2.55% | 7.39% | 1.23% | 3.16% | 3.15% | 2.35% | 3.75% | 3.90% | 2.19% | 1.94% | 1.63% | 3.12% | 3.79% | 1.67% | 1.83% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
95 | ||||||||||||||||||||||||||||||||
96 | Executive Pay | 25.432 | 10.280 | 11.529 | 8.923 | 10.681 | 12.483 | 11.542 | 11.656 | 12.884 | 22.66 | 21.581 | 19.110 | 41.922 | 26.610 | 44.713 | 73.392 | 38.506 | 38.898 | |||||||||||||
97 | % to Revenue | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1.57% | 0.99% | 1.35% | 0.95% | 0.93% | 0.94% | 0.79% | 0.74% | 0.76% | 1.25% | 1.11% | 0.89% | 1.79% | 0.99% | 1.50% | 2.06% | 0.94% | 0.84% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
98 | % to OP Income | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 8.00% | -0.65% | -9.33% | -30.81% | 8.87% | 5.90% | 6.11% | 5.64% | 4.51% | 9.25% | 6.66% | 4.82% | 8.52% | 4.12% | 5.74% | 6.84% | 3.08% | 2.88% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
99 | % to Net | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 8.87% | -0.55% | -7.69% | 7.05% | 14.79% | 2.84% | 7.03% | 7.34% | 5.10% | 11.16% | 10.57% | 5.53% | 4.24% | 4.51% | 6.42% | 8.64% | 3.70% | 3.69% | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
100 | ||||||||||||||||||||||||||||||||