A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | MSFT PE | Microsoft | AAPL PE | Apple | ||
2 | 21.2 | 0.69202 | 85.2 | 1.47736 | ||
3 | 22 | 0.71673 | 78.9 | 1.36893 | ||
4 | 22.3 | 0.72909 | 80.9 | 1.40281 | ||
5 | 21.8 | 0.71056 | 83.2 | 1.44347 | ||
6 | 21.4 | 0.6982 | 88.3 | 1.53157 | ||
7 | 20.8 | 0.67966 | 92.6 | 1.60612 | ||
8 | 20.3 | 0.66113 | 96.5 | 1.67389 | ||
9 | 19.7 | 0.64259 | 101.6 | 1.76199 | ||
10 | 20.1 | 0.65495 | 101.6 | 1.76199 | ||
11 | 20.6 | 0.67348 | 110.9 | 1.92463 | ||
12 | 21 | 0.68584 | 112.5 | 1.95174 | ||
13 | 21 | 0.68584 | 109.8 | 1.9043 | ||
14 | 19.9 | 0.67966 | 106.6 | 1.85009 | ||
15 | 19.7 | 0.67348 | 106.6 | 1.85009 | ||
16 | 19.9 | 0.67966 | 107.8 | 1.87042 | ||
17 | 20.1 | 0.68584 | 105.5 | 1.82976 | ||
18 | 20.1 | 0.68584 | 100.8 | 1.74843 | ||
19 | 19.7 | 0.67348 | 96.5 | 1.67389 | ||
20 | 19.9 | 0.67966 | 94.5 | 1.64 | ||
21 | 20.3 | 0.69202 | 99.6 | 1.7281 | ||
22 | 20.5 | 0.6982 | 98.8 | 1.71455 | ||
23 | 20.8 | 0.71056 | 95.3 | 1.65356 | ||
24 | 21 | 0.71673 | 95.7 | 1.66033 | ||
25 | 21 | 0.71673 | 97.7 | 1.69422 | ||
26 | 21.7 | 0.74145 | 96.9 | 1.68066 | ||
27 | 21.9 | 0.74763 | 102.7 | 1.78232 | ||
28 | 21.2 | 0.72291 | 99.6 | 1.7281 | ||
29 | 21.2 | 0.72291 | 101.6 | 1.76199 | ||
30 | 20.8 | 0.71056 | 102.7 | 1.78232 | ||
31 | 20.9 | 0.71365 | 102.3 | 1.77554 | ||
32 | 23 | 0.7847 | 100.8 | 1.74843 | ||
33 | 24.5 | 0.83413 | 100 | 1.73488 | ||
34 | 24.6 | 0.84031 | 96.9 | 1.68066 | ||
35 | 23.9 | 0.81559 | 93.4 | 1.61967 | ||
36 | 23.4 | 0.79706 | 88.3 | 1.53157 | ||
37 | 23 | 0.7847 | 83.2 | 1.44347 | ||
38 | 23 | 0.7847 | 86.3 | 1.49769 | ||
39 | 22.8 | 0.77852 | 89.5 | 1.5519 | ||
40 | 23 | 0.7847 | 89.5 | 1.5519 | ||
41 | 23 | 0.7847 | 89.8 | 1.55868 | ||
42 | 23.2 | 0.79088 | 85.2 | 1.47736 | ||
43 | 23 | 0.7847 | 85.2 | 1.47736 | ||
44 | 23.2 | 0.79088 | 82.4 | 1.42992 | ||
45 | 23.4 | 0.79706 | 81.6 | 1.41637 | ||
46 | 23.2 | 0.79088 | 79.7 | 1.38248 | ||
47 | 23.2 | 0.79088 | 79.7 | 1.38248 | ||
48 | 23.4 | 0.79706 | 81.6 | 1.41637 | ||
49 | 22.8 | 0.77852 | 85.2 | 1.47736 | ||
50 | 22.8 | 0.77852 | 80.1 | 1.38926 | ||
51 | 22.5 | 0.76616 | 75.8 | 1.31471 | ||
52 | 22.5 | 0.76616 | 77 | 1.33504 | ||
53 | 22.5 | 0.76616 | 74.2 | 1.28761 | ||
54 | 22.5 | 0.76616 | 78.9 | 1.36893 | ||
55 | 23.2 | 0.79088 | 80.1 | 1.38926 | ||
56 | 23.9 | 0.81559 | 82.8 | 1.4367 | ||
57 | 24.5 | 0.83413 | 83.2 | 1.44347 | ||
58 | 25.2 | 0.85885 | 82 | 1.42314 | ||
59 | 24.6 | 0.84031 | 81.3 | 1.40959 | ||
60 | 24.6 | 0.84031 | 80.9 | 1.40281 | ||
61 | 24.5 | 0.83413 | 80.1 | 1.38926 | ||
62 | 24.8 | 0.84649 | 73.8 | 1.28083 | ||
63 | 24.8 | 0.84649 | 70.3 | 1.21984 | ||
64 | 23.7 | 0.80942 | 67.6 | 1.1724 | ||
65 | 23.7 | 0.80942 | 70.3 | 1.21984 | ||
66 | 23.7 | 0.80942 | 69.5 | 1.20628 | ||
67 | 22.8 | 0.77852 | 72.3 | 1.25372 | ||
68 | 22.8 | 0.77852 | 75.8 | 1.31471 | ||
69 | 22.6 | 0.77234 | 80.5 | 1.39604 | ||
70 | 23 | 0.7847 | 79.7 | 1.38248 | ||
71 | 22.8 | 0.77852 | 80.5 | 1.39604 | ||
72 | 22.6 | 0.77234 | 83.6 | 1.45025 | ||
73 | 22.7 | 0.77543 | 83.2 | 1.44347 | ||
74 | 23 | 0.7847 | 81.6 | 1.41637 | ||
75 | 22.8 | 0.77852 | 80.1 | 1.38926 | ||
76 | 22.5 | 0.76616 | 77.3 | 1.34182 | ||
77 | 21.7 | 0.74145 | 77.3 | 1.34182 | ||
78 | 21.6 | 0.73527 | 58.3 | 1.33824 | ||
79 | 19.7 | 0.75999 | 57.7 | 1.32458 | ||
80 | 19.7 | 0.75999 | 62.8 | 1.44066 | ||
81 | 19.7 | 0.75999 | 63.1 | 1.44748 | ||
82 | 20 | 0.77234 | 61.9 | 1.42017 | ||
83 | 20 | 0.77234 | 61.3 | 1.40652 | ||
84 | 19.2 | 0.74145 | 64.3 | 1.47479 | ||
85 | 18.8 | 0.72291 | 65.5 | 1.5021 | ||
86 | 17.9 | 0.69202 | 66.4 | 1.52259 | ||
87 | 17.5 | 0.67348 | 66.4 | 1.52259 | ||
88 | 17.9 | 0.69202 | 66.4 | 1.52259 | ||
89 | 17.7 | 0.68275 | 63.1 | 1.44748 | ||
90 | 17.9 | 0.69202 | 59.5 | 1.36555 | ||
91 | 18.6 | 0.71673 | 59.5 | 1.36555 | ||
92 | 18.9 | 0.72909 | 61.3 | 1.40652 | ||
93 | 19.1 | 0.73527 | 65.5 | 1.5021 | ||
94 | 19.1 | 0.73527 | 67.9 | 1.55673 | ||
95 | 19.7 | 0.75999 | 69.6 | 1.59769 | ||
96 | 19.2 | 0.74145 | 69 | 1.58404 | ||
97 | 19.9 | 0.76616 | 68.5 | 1.57038 | ||
98 | 20 | 0.77234 | 67.3 | 1.54307 | ||
99 | 19.6 | 0.75381 | 66.4 | 1.52259 | ||
100 | 19.1 | 0.73527 | 67.6 | 1.5499 |