I need help with Data analysis accounting ASAP !!!
GENERAL DATA
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | Y = Projected stock price | Projected returns | Projected ROI | 2 | |||||
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | PROJECTED RETURNS (Projected stock price - stock price) | (projected stock price-current stock price) | Projected returns/stock price | 6.8344x + 5.0262 | ||||||||||
| 1 | 32.0428669757 | 3.1965317919 | 0.9015370468 | 4.0980688387 | 4.2578954283 | 4.0980688387 | 7.8190162823 | 0.7800092965 | 0.8450930805 | no | 34.126360515 | $ 2.08 | 7% | |||||
| 2 | 19.9929366571 | 1.8582036941 | 0.461789726 | 2.3199934201 | 2.5058137895 | 2.3199934201 | 8.6176695519 | 0.8009521398 | 0.8450930805 | no | 22.1519337632 | $ 2.16 | 11% | |||||
| 3 | 18.930716101 | 1.4795201956 | 0.3248344277 | 1.8043546232 | 1.9523066428 | 1.8043546232 | 10.4916826533 | 0.8199719592 | 0.8450930805 | no | 18.3690445195 | $ (0.56) | -3% | |||||
| 4 | 16.9924923636 | 1.4010723861 | 0.3630233038 | 1.7640956898 | 1.9042029284 | 1.7640956898 | 9.6324096598 | 0.7942156393 | 0.8450930805 | no | 18.0402844941 | $ 1.05 | 6% | |||||
| 5 | 23.3001521692 | 2.0581456116 | 0.607008279 | 2.6651538906 | 2.5416651539 | 2.6651538906 | 8.7425166147 | 0.7722426907 | 0.8450930805 | no | 22.3969563277 | $ (0.90) | -4% | |||||
| 6 | 20.1045520364 | 1.7903381643 | 0.7787439614 | 2.5690821256 | 2.497468599 | 2.5690821256 | 7.8255777953 | 0.6968785258 | 0.8450930805 | no | 22.0948993932 | $ 1.99 | 10% | |||||
| 7 | 15.7656377786 | 1.2188594559 | 0.4834203737 | 1.7022798297 | 1.6900912351 | 1.7022798297 | 9.2614842188 | 0.7160159186 | 0.8450930805 | no | 16.5769595374 | $ 0.81 | 5% | |||||
| 8 | 35.7370104637 | 3.5500367531 | 0.6335713536 | 4.1836081067 | 4.538611782 | 4.1836081067 | 8.5421505916 | 0.8485586275 | 0.8450930805 | yes | 36.0448883629 | $ 0.31 | 1% | |||||
| 9 | 16.2248198788 | 1.3961752267 | 0.5430752454 | 1.9392504721 | 1.7996329494 | 1.9392504721 | 8.3665416676 | 0.7199561103 | 0.8450930805 | no | 17.3256114296 | $ 1.10 | 7% | |||||
| 10 | 18.2951804739 | 1.6904878847 | 0.742018664 | 2.4325065488 | 2.3141723969 | 2.4325065488 | 7.5211228036 | 0.6949571772 | 0.8450930805 | no | 20.8421798291 | $ 2.55 | 14% | |||||
| 11 | 15.944499818 | 1.3110740526 | 0.1908594354 | 1.501933488 | 1.6330408933 | 1.501933488 | 10.6159826286 | 0.8729241761 | 0.8450930805 | yes | 16.187054681 | $ 0.24 | 2% | |||||
| 12 | 21.5180343473 | 1.9034415754 | 0.4431822428 | 2.3466238182 | 2.5369679758 | 2.3466238182 | 9.169784343 | 0.8111404822 | 0.8450930805 | no | 22.3648539337 | $ 0.85 | 4% | |||||
| 13 | 17.1821728433 | 1.4775795695 | 0.2691264979 | 1.7467060673 | 1.8944640243 | 1.7467060673 | 9.8368999596 | 0.8459234196 | 0.8450930805 | yes | 17.9737249276 | $ 0.79 | 5% | |||||
| 14 | 19.4758303817 | 1.7539579896 | 0.3543905811 | 2.1083485707 | 2.2837443696 | 2.1083485707 | 9.2374812461 | 0.8319108206 | 0.8450930805 | no | 20.6342225197 | $ 1.16 | 6% | |||||
| 15 | 38.3086599587 | 3.6310411311 | 0.4862467866 | 4.1172879177 | 4.4803920308 | 4.1172879177 | 9.3043432289 | 0.8819011941 | 0.8450930805 | yes | 35.6469912956 | $ (2.66) | -7% | |||||
| 16 | 45.1878317502 | 4.113573701 | 0.2984623542 | 4.4120360551 | 4.8233934252 | 4.4120360551 | 10.2419452573 | 0.9323526938 | 0.8450930805 | yes | 37.9912000255 | $ (7.20) | -16% | |||||
| 17 | 18.9733046764 | 1.6948452227 | 0.3385223567 | 2.0333675794 | 2.2028521017 | 2.0333675794 | 9.330976292 | 0.833516399 | 0.8450930805 | no | 20.0813724036 | $ 1.11 | 6% | |||||
| 18 | 22.4555261805 | 1.974841609 | 0.6175040519 | 2.5923456608 | 2.5725972447 | 2.5923456608 | 8.6622422773 | 0.7617971781 | 0.8450930805 | no | 22.6083586094 | $ 0.15 | 1% | |||||
| 19 | 32.8838979302 | 3.3135375494 | 1.2225790514 | 4.5361166008 | 4.2047628458 | 4.5361166008 | 7.2493502315 | 0.7304789186 | 0.8450930805 | no | 33.7632311937 | $ 0.88 | 3% | |||||
| 20 | 32.1327478162 | 3.2479042496 | 0.7676503368 | 4.0155545864 | 4.3403450114 | 4.0155545864 | 8.0020697327 | 0.8088308052 | 0.8450930805 | no | 34.6898539458 | $ 2.56 | 8% | |||||
| 21 | 28.5957550442 | 2.4664621612 | 0.335789507 | 2.8022516682 | 3.0488978843 | 2.8022516682 | 10.2045634833 | 0.8801715382 | 0.8450930805 | yes | 25.8635877006 | $ (2.73) | -10% | |||||
| 22 | 25.4923933382 | 2.5640112263 | 0.7706174439 | 3.3346286701 | 3.4628292314 | 3.3346286701 | 7.6447472448 | 0.7689045708 | 0.8450930805 | no | 28.6925600993 | $ 3.20 | 13% | |||||
| 23 | 14.4281390697 | 1.0562749111 | 0.1914682753 | 1.2477431865 | 1.3533706776 | 1.2477431865 | 11.5633883849 | 0.8465483303 | 0.8450930805 | yes | 14.2756765589 | $ (0.15) | -1% | |||||
| 24 | 26.4814162464 | 2.5911212856 | 0.837328306 | 3.4284495915 | 3.4284495915 | 3.4284495915 | 7.7240208845 | 0.7557705652 | 0.8450930805 | no | 28.4575958883 | $ 1.98 | 7% | 3. A. It a positif relationship | ||||
| 25 | 27.8152691728 | 2.3643989455 | 0.2936967165 | 2.658095662 | 2.8945355565 | 2.658095662 | 10.4643597183 | 0.8895085979 | 0.8450930805 | yes | 24.8086138076 | $ (3.01) | -11% | B. As the stock price goes up, the Earnings per Share will go up too. | ||||
| 26 | 21.3121409817 | 1.8083403538 | 0.5068600313 | 2.3152003851 | 2.2066999639 | 2.3152003851 | 9.2053116087 | 0.7810729324 | 0.8450930805 | no | 20.1076702332 | $ (1.20) | -6% | For every time EPS changes 1 unit, it will increase the stock price as well. Furthermore, when the stock price goes down, Earnings per share will go down as well. | ||||
| 27 | 16.9031205449 | 1.1980071483 | 0.1765190079 | 1.3745261562 | 1.494326871 | 1.3745261562 | 12.2974164361 | 0.8715782838 | 0.8450930805 | yes | 15.2390275672 | $ (1.66) | -10% | |||||
| 28 | 15.2468587331 | 1.2817067557 | 0.5145874094 | 1.796294165 | 1.8219283001 | 1.796294165 | 8.4879520458 | 0.7135283188 | 0.8450930805 | no | 17.4779867745 | $ 2.23 | 15% | |||||
| 29 | 23.8433525884 | 2.0118296743 | 0.2002652879 | 2.2120949622 | 2.4132779297 | 2.2120949622 | 10.7786297584 | 0.9094680421 | 0.8450930805 | yes | 21.5195066825 | $ (2.32) | -10% | |||||
| 30 | 27.3426146254 | 2.4725256939 | 0.3947155458 | 2.8672412398 | 3.1144938092 | 2.8672412398 | 9.5362100147 | 0.8623361228 | 0.8450930805 | yes | 26.3118964894 | $ (1.03) | -4% | 4 | In order to calculate the median of a group of values, use the formula “=MEDIAN(startcell,endcell”. For example, to calculate the median of cells A1 to A10, use the formula “=MEDIAN(A1:A10)” | |||
| 31 | 38.0023282738 | 3.8768768769 | 1.046046046 | 4.9229229229 | 4.9616916917 | 4.9229229229 | 7.7194644053 | 0.7875152501 | 0.8450930805 | no | 38.9363856977 | $ 0.93 | 2% | |||||
| 32 | 24.3495221067 | 2.3150731541 | 0.4838002344 | 2.7988733885 | 3.0303807039 | 2.7988733885 | 8.6997583408 | 0.8271446517 | 0.8450930805 | no | 25.737033883 | $ 1.39 | 6% | |||||
| 33 | 19.0408676849 | 1.4845846935 | 0.3120541652 | 1.7966388587 | 1.945097328 | 1.7966388587 | 10.5980495708 | 0.8263122476 | 0.8450930805 | no | 18.3197731786 | $ (0.72) | -4% | |||||
| 34 | 38.1380085248 | 4.0982133189 | 1.2840822956 | 5.3822956145 | 5.2183670818 | 5.3822956145 | 7.0858256878 | 0.761424792 | 0.8450930805 | no | 40.6906079835 | $ 2.55 | 7% | Median (Permanent Earnings Ratio) | 0.8450930805 | |||
| 35 | 16.7856503916 | 1.4456115731 | 0.2858204181 | 1.7314319912 | 1.8759931486 | 1.7314319912 | 9.694663421 | 0.8349225268 | 0.8450930805 | no | 17.8474875746 | $ 1.06 | 6% | |||||
| 36 | 39.5186407574 | 4.1047607163 | 1.2069632495 | 5.3117239658 | 5.0243907157 | 5.3117239658 | 7.439889763 | 0.7727737252 | 0.8450930805 | no | 39.3648959072 | $ (0.15) | -0% | |||||
| 37 | 45.0907059238 | 4.3221038369 | 0.4987990392 | 4.8209028761 | 5.2531132598 | 4.8209028761 | 9.3531662185 | 0.8965341032 | 0.8450930805 | yes | 40.928077263 | $ (4.16) | -9% | The “=IF()” function can be used for checking whether particular conditions are fulfilled. For example, if we wanted to check if cell A1 has the value of 10, and if true, assign the value of 1, and if untrue, assign the value of 0, we can use the formula “=IF(A1=10,1,0)”. The first value in the brackets is the condition to check for, the second is the value to assign if true, and the third is the value to assign if untrue. This function can be used when determining whether a firm has above median or below median permanent earnings ratio. | ||||
| 38 | 17.0872414628 | 1.566189792 | 0.4806959455 | 2.0468857375 | 1.9059286562 | 2.0468857375 | 8.3479215033 | 0.7651574112 | 0.8450930805 | no | 18.052078808 | $ 0.96 | 6% | |||||
| 39 | 15.6643448293 | 1.3609695082 | 0.3492164637 | 1.7101859719 | 1.8462829227 | 1.7101859719 | 9.1594394335 | 0.7958020534 | 0.8450930805 | no | 17.6444360068 | $ 1.98 | 13% | |||||
| 40 | 32.1714189178 | 3.0532428821 | 0.5697399527 | 3.6229828348 | 3.928307123 | 3.6229828348 | 8.8798154406 | 0.8427428507 | 0.8450930805 | no | 31.8738222017 | $ (0.30) | -1% | |||||
| 41 | 13.4294172161 | 0.9508497425 | 0.1839819665 | 1.134831709 | 1.2299166832 | 1.134831709 | 11.833840304 | 0.8378773126 | 0.8450930805 | no | 13.4319425799 | $ 0.00 | 0% | |||||
| 42 | 20.6085870155 | 1.7123043153 | 0.4545673831 | 2.1668716984 | 2.3381021299 | 2.1668716984 | 9.5107555426 | 0.7902195209 | 0.8450930805 | no | 21.0057251967 | $ 0.40 | 2% | no | ||||
| 43 | 12.3970754865 | 0.8638854553 | 0.2232385661 | 1.0871240214 | 1.173512567 | 1.0871240214 | 11.4035521635 | 0.7946521632 | 0.8450930805 | no | 13.0464542876 | $ 0.65 | 5% | |||||
| 44 | 17.5754111464 | 1.5775379402 | 0.6436569913 | 2.2211949315 | 2.1896441727 | 2.2211949315 | 7.9125928559 | 0.7102203944 | 0.8450930805 | no | 19.9911041338 | $ 2.42 | 14% | y=6.8344x + 5.0262 | ||||
| 45 | 28.4030823374 | 2.6389516958 | 0.7262076053 | 3.3651593011 | 3.417938335 | 3.3651593011 | 8.4403381224 | 0.7841981492 | 0.8450930805 | no | 28.385757757 | $ (0.02) | -0% | |||||
| 46 | 26.2446132751 | 2.3150021849 | 0.5057312851 | 2.82073347 | 3.0522336885 | 2.82073347 | 9.3041804743 | 0.8207092976 | 0.8450930805 | no | 25.8863859209 | $ (0.36) | -1% | |||||
| 47 | 22.7037822551 | 1.9664788144 | 0.5389271551 | 2.5054059695 | 2.4070820288 | 2.5054059695 | 9.061917522 | 0.78489428 | 0.8450930805 | no | 21.4771614177 | $ (1.23) | -5% | |||||
| 48 | 13.5217125396 | 1.2029669413 | 0.5102461153 | 1.7132130566 | 1.6169757013 | 1.7132130566 | 7.8926041845 | 0.7021700755 | 0.8450930805 | no | 16.0772587331 | $ 2.56 | 19% | |||||
| 49 | 14.5414780053 | 1.0481779958 | 0.3768395235 | 1.4250175193 | 1.3411632796 | 1.4250175193 | 10.2044205132 | 0.7355544627 | 0.8450930805 | no | 14.1922463181 | $ (0.35) | -2% | |||||
| 50 | 15.4847138722 | 1.4422788606 | 0.5920083437 | 2.0342872042 | 2.0487099928 | 2.0342872042 | 7.6118621992 | 0.7089848757 | 0.8450930805 | no | 19.027903575 | $ 3.54 | 23% | |||||
| 51 | 20.9095264484 | 2.0442079765 | 0.6700694985 | 2.714277475 | 2.5711829166 | 2.714277475 | 7.7035331285 | 0.7531315406 | 0.8450930805 | no | 22.5986925254 | $ 1.69 | 8% | |||||
| 52 | 19.5338876676 | 1.8512449457 | 0.8201745052 | 2.6714194509 | 2.5973696531 | 2.6714194509 | 7.3121754282 | 0.6929817573 | 0.8450930805 | no | 22.7776631573 | $ 3.24 | 17% | |||||
| 53 | 25.3650782162 | 2.2419879097 | 0.5418755126 | 2.7838634223 | 3.0080622133 | 2.7838634223 | 9.1114664651 | 0.8053512582 | 0.8450930805 | no | 25.5845003907 | $ 0.22 | 1% | |||||
| 54 | 12.8649438924 | 1.064529635 | 0.633599372 | 1.6981290069 | 1.6236119325 | 1.6981290069 | 7.5759520271 | 0.6268838413 | 0.8450930805 | no | 16.1226133914 | $ 3.26 | 25% | |||||
| 55 | 14.6283267086 | 1.1688379469 | 0.1739767549 | 1.3428147018 | 1.4596984965 | 1.3428147018 | 10.8937790813 | 0.8704387473 | 0.8450930805 | yes | 15.0023634045 | $ 0.37 | 3% | |||||
| 56 | 19.4234674356 | 1.7360973103 | 0.8321055337 | 2.5682028439 | 2.6029247901 | 2.5682028439 | 7.5630581446 | 0.6759969581 | 0.8450930805 | no | 22.8156291857 | $ 3.39 | 17% | |||||
| 57 | 16.7735975458 | 1.3796846112 | 0.3656334965 | 1.7453181077 | 1.8832865688 | 1.7453181077 | 9.6106248323 | 0.7905061004 | 0.8450930805 | no | 17.8973337257 | $ 1.12 | 7% | |||||
| 58 | 18.9083290525 | 1.5438292964 | 0.47189892 | 2.0157282164 | 1.8767835797 | 2.0157282164 | 9.3803960764 | 0.7658915938 | 0.8450930805 | no | 17.8528896974 | $ (1.06) | -6% | |||||
| 59 | 30.1093256213 | 2.7911429738 | 0.67439539 | 3.4655383638 | 3.7446526612 | 3.4655383638 | 8.6882101597 | 0.8053995313 | 0.8450930805 | no | 30.6186541476 | $ 0.51 | 2% | |||||
| 60 | 30.2615260785 | 3.1288708512 | 0.9321176405 | 4.0609884917 | 4.1548546172 | 4.0609884917 | 7.4517635646 | 0.7704702581 | 0.8450930805 | no | 33.422138396 | $ 3.16 | 10% | |||||
| 61 | 17.5471501025 | 1.5219110762 | 0.509494315 | 2.0314053913 | 1.9400907267 | 2.0314053913 | 8.6379361687 | 0.7491912165 | 0.8450930805 | no | 18.2855560625 | $ 0.74 | 4% | |||||
| 62 | 32.7762826087 | 3.0634475268 | 0.4711046748 | 3.5345522017 | 3.8408969543 | 3.5345522017 | 9.2731075222 | 0.8667144668 | 0.8450930805 | yes | 31.2764261447 | $ (1.50) | -5% | |||||
| 63 | 14.1267759917 | 1.2394714442 | 0.4386526691 | 1.6781241133 | 1.6161505411 | 1.6781241133 | 8.418194983 | 0.7386053477 | 0.8450930805 | no | 16.0716192582 | $ 1.94 | 14% | |||||
| 64 | 45.5201412487 | 4.6486686847 | 1.2663248286 | 5.9149935133 | 5.7290467659 | 5.9149935133 | 7.6957212457 | 0.7859127274 | 0.8450930805 | no | 44.180797217 | $ (1.34) | -3% | |||||
| 65 | 22.1462931992 | 2.0668295184 | 0.6650381495 | 2.7318676679 | 2.7938725535 | 2.7318676679 | 8.1066493298 | 0.7565628243 | 0.8450930805 | no | 24.1206425793 | $ 1.97 | 9% | |||||
| 66 | 21.9749100932 | 1.7343599258 | 0.2203710575 | 1.9547309833 | 2.1281669759 | 1.9547309833 | 11.2419101559 | 0.8872627183 | 0.8450930805 | yes | 19.57094438 | $ (2.40) | -11% | |||||
| 67 | 35.5159529079 | 3.5212165808 | 0.8287956831 | 4.3500122639 | 4.702133922 | 4.3500122639 | 8.1645638571 | 0.8094727939 | 0.8450930805 | no | 37.1624640765 | $ 1.65 | 5% | |||||
| 68 | 17.8264362883 | 1.4316631887 | 0.250069918 | 1.6817331067 | 1.8248994256 | 1.6817331067 | 10.6000388629 | 0.8513022566 | 0.8450930805 | yes | 17.4982926343 | $ (0.33) | -2% | |||||
| 69 | 25.4954040325 | 2.438362954 | 0.71932309 | 3.157686044 | 3.2552205622 | 3.157686044 | 8.0740781943 | 0.7721993004 | 0.8450930805 | no | 27.2736794103 | $ 1.78 | 7% | |||||
| 70 | 22.5508224942 | 2.2011266614 | 0.6375319074 | 2.8386585688 | 2.6185459026 | 2.8386585688 | 7.9441827707 | 0.7754108527 | 0.8450930805 | no | 22.9223901171 | $ 0.37 | 2% | |||||
| 71 | 29.4852469338 | 2.9128923423 | 0.6337797771 | 3.5466721194 | 3.8379613536 | 3.5466721194 | 8.3134966924 | 0.8213029692 | 0.8450930805 | no | 31.2563630754 | $ 1.77 | 6% | |||||
| 72 | 33.3418396626 | 2.9724994801 | 0.3844874194 | 3.3569868996 | 3.6542368476 | 3.3569868996 | 9.9320732133 | 0.8854665118 | 0.8450930805 | yes | 30.0007163111 | $ (3.34) | -10% | |||||
| 73 | 26.5028429896 | 2.3990917488 | 0.6289254926 | 3.0280172414 | 3.2679264163 | 3.0280172414 | 8.7525403183 | 0.7922979156 | 0.8450930805 | no | 27.3605162993 | $ 0.86 | 3% | |||||
| 74 | 16.1246526708 | 1.319777732 | 0.3818481169 | 1.7016258489 | 1.7544169582 | 1.7016258489 | 9.4760271072 | 0.7755980746 | 0.8450930805 | no | 17.0165872593 | $ 0.89 | 6% | |||||
| 75 | 21.561094137 | 1.6370420298 | 0.1244042174 | 1.7614462472 | 1.9251504501 | 1.7614462472 | 12.2405632143 | 0.9293738213 | 0.8450930805 | yes | 18.1834482365 | $ (3.38) | -16% | |||||
| 76 | 33.7617494183 | 3.1496581284 | 0.4460148995 | 3.5956730279 | 3.9106388407 | 3.5956730279 | 9.3895493713 | 0.8759578816 | 0.8450930805 | yes | 31.7530700929 | $ (2.01) | -6% | |||||
| 77 | 19.7635895825 | 1.7969360803 | 0.3821183307 | 2.179054411 | 2.358748019 | 2.179054411 | 9.0698008654 | 0.8246402987 | 0.8450930805 | no | 21.1468274612 | $ 1.38 | 7% | |||||
| 78 | 33.2731866654 | 3.0831213556 | 0.2398935546 | 3.3230149102 | 3.6313270457 | 3.3230149102 | 10.0129513604 | 0.9278084628 | 0.8450930805 | yes | 29.8441415615 | $ (3.43) | -10% | |||||
| 79 | 18.0659509551 | 1.6957203597 | 0.5460374991 | 2.2417578588 | 2.3095866732 | 2.2417578588 | 8.05883244 | 0.7564244073 | 0.8450930805 | no | 20.8108391591 | $ 2.74 | 15% | |||||
| 80 | 24.6686299114 | 2.5164226572 | 1.1410868016 | 3.6575094588 | 3.4310314196 | 3.6575094588 | 6.7446523896 | 0.6880153519 | 0.8450930805 | no | 28.4752411344 | $ 3.81 | 15% | |||||
| 81 | 13.7036693822 | 1.1398060885 | 0.3073202703 | 1.4471263588 | 1.4699224806 | 1.4471263588 | 9.4695734747 | 0.7876341147 | 0.8450930805 | no | 15.0722382016 | $ 1.37 | 10% | |||||
| 82 | 18.8831321592 | 1.7845191893 | 0.5546787408 | 2.3391979301 | 2.3927335058 | 2.3391979301 | 8.0724815612 | 0.7628765255 | 0.8450930805 | no | 21.3790978722 | $ 2.50 | 13% | |||||
| 83 | 28.2047028873 | 2.5218865192 | 0.5192535545 | 3.0411400737 | 3.2933287256 | 3.0411400737 | 9.2743846727 | 0.8292569425 | 0.8450930805 | no | 27.5341258425 | $ (0.67) | -2% | |||||
| 84 | 39.0944408386 | 4.0652073581 | 1.4700995583 | 5.5353069163 | 5.6572631371 | 5.5353069163 | 7.0627413131 | 0.7344140839 | 0.8450930805 | no | 43.690199184 | $ 4.60 | 12% | |||||
| 85 | 20.0535890811 | 1.8071336346 | 0.5661717237 | 2.3733053583 | 2.4275193673 | 2.3733053583 | 8.4496455591 | 0.7614416865 | 0.8450930805 | no | 21.6168383641 | $ 1.56 | 8% | |||||
| 86 | 23.1689674538 | 2.2966621031 | 0.7103135798 | 3.0069756829 | 2.9151091988 | 3.0069756829 | 7.7050731024 | 0.7637780765 | 0.8450930805 | no | 24.9492223081 | $ 1.78 | 8% | |||||
| 87 | 18.7006656156 | 1.6621393697 | 0.5570942447 | 2.2192336144 | 2.185990827 | 2.2192336144 | 8.4266322815 | 0.7489699863 | 0.8450930805 | no | 19.9661357084 | $ 1.27 | 7% | |||||
| 88 | 24.1934832955 | 2.2874397082 | 0.9449433356 | 3.2323830438 | 3.2552574409 | 3.2323830438 | 7.484720396 | 0.707663565 | 0.8450930805 | no | 27.273931454 | $ 3.08 | 13% | |||||
| 89 | 12.8488485268 | 0.9315722256 | 0.270372611 | 1.2019448365 | 1.2392077256 | 1.2019448365 | 10.6900484415 | 0.7750540601 | 0.8450930805 | no | 13.4954412796 | $ 0.65 | 5% | |||||
| 90 | 17.4488716824 | 1.6452180872 | 0.8766306523 | 2.5218487395 | 2.456040016 | 2.5218487395 | 6.9190794076 | 0.6523857127 | 0.8450930805 | no | 21.8117598854 | $ 4.36 | 25% | |||||
| 91 | 21.9169483259 | 2.046891261 | 0.6746751509 | 2.7215664119 | 2.5987529363 | 2.7215664119 | 8.0530639377 | 0.7521004272 | 0.8450930805 | no | 22.7871170677 | $ 0.87 | 4% | |||||
| 92 | 19.1606211934 | 1.4621534753 | 0.2434511852 | 1.7056046605 | 1.851820008 | 1.7056046605 | 11.2339170014 | 0.8572640009 | 0.8450930805 | yes | 17.6822786629 | $ (1.48) | -8% | |||||
| 93 | 43.5117438586 | 4.7530327166 | 1.5092513172 | 6.2622840338 | 6.4048750153 | 6.2622840338 | 6.948222665 | 0.7589934744 | 0.8450930805 | no | 48.7996778047 | $ 5.29 | 12% | |||||
| 94 | 21.1561516244 | 1.8604005505 | 0.4306392672 | 2.2910398178 | 2.4770798728 | 2.2910398178 | 9.2343011503 | 0.8120332681 | 0.8450930805 | no | 21.9555546827 | $ 0.80 | 4% | |||||
| 95 | 31.3851120319 | 2.9520898642 | 0.3402821317 | 3.2923719958 | 3.5875809822 | 3.2923719958 | 9.5326749443 | 0.8966452964 | 0.8450930805 | yes | 29.545163465 | $ (1.84) | -6% | |||||
| 96 | 18.3255663134 | 1.660436767 | 0.4049338494 | 2.0653706164 | 2.2314142931 | 2.0653706164 | 8.8727738099 | 0.8039413139 | 0.8450930805 | no | 20.2765778451 | $ 1.95 | 11% | |||||
| 97 | 18.9658862673 | 1.5555249127 | 0.2658576944 | 1.8213826071 | 1.9769350984 | 1.8213826071 | 10.4129062139 | 0.8540352294 | 0.8450930805 | yes | 18.5373652363 | $ (0.43) | -2% | |||||
| 98 | 32.2048296757 | 3.337340186 | 0.9481374506 | 4.2854776367 | 4.4189712441 | 4.2854776367 | 7.5148752149 | 0.7787557115 | 0.8450930805 | no | 35.2272170707 | $ 3.02 | 9% | |||||
| 99 | 30.7334787233 | 3.0311551872 | 0.8339446633 | 3.8650998506 | 3.6226074356 | 3.8650998506 | 7.9515355131 | 0.7842372266 | 0.8450930805 | no | 29.7845482578 | $ (0.95) | -3% | |||||
| 100 | 20.9032990506 | 1.6970328748 | 0.1674760367 | 1.8645089115 | 2.034212199 | 1.8645089115 | 11.2111553456 | 0.9101768644 | 0.8450930805 | yes | 18.928819853 | $ (1.97) | -9% |
Stock Price x EPS
Earnings per share
4.0980688386757755 2.3199934201250176 1.8043546232341319 1.7640956898329554 2.6651538905850316 2.569082125603865 1.702279829694 4148 4.1836081066890687 1.9392504721121364 2.4325065487884743 1.5019334880123743 2.3466238182429655 1.7467060673426231 2.1083485706640506 4.117287917737789 4.4120360551431599 2.0333675793987585 2.59234566082216 4.536116600790514 4.0155545864224456 2.8022516681951868 3.3346286701208983 1.2477431864698914 3.4284495915252715 2.6580956619988361 2.3152003851245637 1.3745261561789235 1.7962941650362527 2.2120949622370807 2.8672412397831186 4.9229229229229237 2.7988733885297341 1.7966388586627977 5.3822956145100154 1.7314319912499743 5.3117239658077002 4.8209028761470716 2.0468857374898484 1.7101859718682149 3.622982834823723 1.134831708988044 2.1668716983862799 1.0871240214256284 2.2211949314866657 3.3651593011305243 2.8207334700326063 2.505405969526195 1.7132130566273855 1.4250175192711985 2.034287204223975 2.7142774749834184 2.6714194509470102 2.7838634223396821 1.6981290069344497 1.3428147018086196 2.5682028439266746 1.7453181076672104 2.0157282164202579 3.4655383638096104 4.060988491688442 2.0314053912588328 3.5345522016563335 1.678124113331442 5.9149935133131519 2.7318676679031335 1.9547309833024118 4.3500122639195489 1.6817331067271906 3.1576860440416343 2.8386585687879586 3.5466721194151929 3.356986899563319 3.0280172413793105 1.701625848940111 1.7614462471715373 3.5956730278599855 2.1790544109878498 3.3230149101866706 2.2417578587858089 3.6575094587925649 1.4471263588491874 2.3391979301423027 3.0411400737230121 5.5353069163315087 2.3733053582956747 3.0069756828997978 2.219233614440006 3.2323830438022041 1.2019448365485874 2.5218487394957982 2.7215664119413638 1.7056046605062274 6.2622840338193848 2.2910398177590054 3.2923719958202717 2.0653706164423133 1.8213826070968926 4.285477636664826 3.8650998505637824 1.8645089115456002 32.042866975679445 19.992936657140966 18.930716101003043 16.992492363616741 23.30015216915038 20.104552036379957 15.765637778644008 35.737010463687888 16.224819878796975 18.295180473882105 15.944499817985674 21.518034347346383 17.182172843272099 19.475830381655534 38.308659958746105 45.187831750158757 18.973304676372141 22.455526180549693 32.88389793015665 32.132747816201849 28.595755044168893 25.492393338220829 14.428139069728218 26.481416246355465 27.81526917 2764197 21.312140981738935 16.903120544912255 15.246858733066912 23.843352588437117 27.342614625411315 38.00232827378008 24.349522106707727 19.040867684899467 38.138008524785974 16.785650391584905 39.518640757354483 45.090705923786437 17.087241462824927 15.664344829307534 32.171418917834458 13.429417216082477 20.608587015526034 12.397075486543283 17.575411146430191 28.403082337424987 26.244613275127165 22.703782255084779 13.521712539611666 14.541478005323928 15.48471387223589 20.909526448401909 19.533887667640556 25.365078216197347 12.864943892378065 14.62832670856597 19.423467435629771 16.773597545821705 18.908329052472375 30.109325621256751 30.261526078476152 17.547150102471345 32.776282608713046 14.126775991673135 45.520141248702501 22.146293199228889 21.974910093215172 35.515952907931954 17.826436288278003 25.495404032547818 22.550822494198499 29.485246933794173 33.341839662646997 26.502842989608716 16.12465267078629 21.561094137031326 33.761749418259619 19.763589582513436 33.273186665445522 18.0659509550511 24.66862991139125 13.703669382234308 18.883132159173236 28.204702887318991 39.094440838563301 20.053589081064683 23.168967453762527 18.700665615621435 24.193483295482785 12.848848526750913 17.448871682406164 21.91694832594591 19.160621193412371 43.511743858563165 21.15615162441269 31.385112031888138 18.325566313355168 18.965886267340579 32.204829675735937 30.733478723341307 20.903299050558658
Earnings per share
Stock Price
32.042866975679445 19.992936657140966 18.930716101003043 16.992492363616741 23.30015216915038 20.104552036379957 15.765637778644008 35.737010463687888 16.224819878796975 18.295180473882105 15.944499817985674 21.518034347346383 17.182172843272099 19.475830381655534 38.308659958746105 45.187831750158757 18.973304676372141 22.455526180549693 32.88389793015665 32.132747816201849 28.595755044168893 25.492393338220829 14.428139069728218 26.481416246355465 27.815269172764197 21.312140981738935 16.903120544912255 15.246858733066912 23.843352588437117 27.342614625411315 38.00232827378008 24.349522106707727 19.040867684899467 38.138008524785974 16.785650391584905 39.518640757354483 45.090705923786437 17.087241462824927 15.664344829307534 32.171418917834458 13.429417216082477 20.608587015526034 12.397075486543283 17.575411146430191 28.403082337424987 26.244613275127165 22.703782255084779 13.521712539611666 14.541478005323928 15.48471387223589 20.909526448401909 19.533887667640556 25.365078216197347 12.864943892378065 14.62832670856597 19.423467435629771 16.773597545821705 18.908329052472375 30.109325621256751 30.261526078476152 17.547150102471345 32.776282608713046 14.126775991673135 45.520141248702501 22.146293199228889 21.974910093215172 35.515952907931954 17.826436288278003 25.495404032547818 22.550822494198499 29.485246933794173 33.341839662646997 26.502842989608716 16.12465267078629 21.561094137031326 33.761749418259619 19.763589582513436 33.273186665445522 18.0659509550511 24.66862991139125 13.703669382234308 18.883132159173236 28.204702887318991 39.094440838563301 20.053589081064683 23.168967453762527 18.700665615621435 24.193483295482785 12.848848526750913 17.448871682406164 21.91694832594591 19.160621193412371 43.511743858563165 21.15615162441269 31.385112031888138 18.325566313355168 18.965886267340579 32.204829675735937 30.733478723341307 20.903299050558658 4.0980688386757755 2.3199934201250176 1.8043546232341319 1.7640956898329554 2.6651538905850316 2.569082125603865 1.7022798296944148 4.1836081066890687 1.9392504721121364 2.4325065487884743 1.5019334880123743 2.3466238182429655 1.7467060673426231 2.1083485706640506 4.117287917737789 4.4120360551431599 2.0333675793987585 2.59234566082216 4.536116600790514 4.0155545864224456 2.8022516681951868 3.3346286701208 983 1.2477431864698914 3.4284495915252715 2.6580956619988361 2.3152003851245637 1.3745261561789235 1.7962941650362527 2.2120949622370807 2.8672412397831186 4.9229229229229237 2.7988733885297341 1.7966388586627977 5.3822956145100154 1.7314319912499743 5.3117239658077002 4.8209028761470716 2.0468857374898484 1.7101859718682149 3.622982834823723 1.134831708988044 2.1668716983862799 1.0871240214256284 2.2211949314866657 3.3651593011305243 2.8207334700326063 2.505405969526195 1.7132130566273855 1.4250175192711985 2.034287204223975 2.7142774749834184 2.6714194509470102 2.7838634223396821 1.6981290069344497 1.3428147018086196 2.5682028439266746 1.7453181076672104 2.0157282164202579 3.4655383638096104 4.060988491688442 2.0314053912588328 3.5345522016563335 1.678124113331442 5.9149935133131519 2.7318676679031335 1.9547309833024118 4.3500122639195489 1.6817331067271906 3.1576860440416343 2.8386585687879586 3.5466721194151929 3.356986899563319 3.0280172413793105 1.701625848940111 1.7614462471715373 3.5956730278599855 2.1790544109878498 3.3230149101866706 2.2417578587858089 3.6575094587925649 1.4471263588491874 2.3391979301423027 3.0411400737230121 5.5353069163315087 2.3733053582956747 3.0069756828997978 2.219233614440006 3.2323830438022041 1.2019448365485874 2.5218487394957982 2.7215664119413638 1.7056046605062274 6.2622840338193848 2.2910398177590054 3.2923719958202717 2.0653706164423133 1.8213826070968926 4.285477636664826 3.8650998505637824 1.8645089115456002
TOP 10 (PROJECTED RETURNS)
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | Y = Projected Returns | Projected ROI | |
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | PROJECTED RETURNS (Projected stock price - stock price) | Projected returns/stock price | ||||||
| 8 | 35.7370104637 | 3.5500367531 | 0.6335713536 | 4.1836081067 | 4.538611782 | 4.1836081067 | 8.5421505916 | 0.8485586275 | 0.8450930805 | yes | 36.0448883629 | 1.0086150995 |
| 16 | 45.1878317502 | 4.113573701 | 0.2984623542 | 4.4120360551 | 4.8233934252 | 4.4120360551 | 10.2419452573 | 0.9323526938 | 0.8450930805 | yes | 37.9912000255 | 0.8407396096 |
| 31 | 38.0023282738 | 3.8768768769 | 1.046046046 | 4.9229229229 | 4.9616916917 | 4.9229229229 | 7.7194644053 | 0.7875152501 | 0.8450930805 | no | 38.9363856977 | 1.0245789526 |
| 34 | 38.1380085248 | 4.0982133189 | 1.2840822956 | 5.3822956145 | 5.2183670818 | 5.3822956145 | 7.0858256878 | 0.761424792 | 0.8450930805 | no | 40.6906079835 | 1.0669305912 |
| 36 | 39.5186407574 | 4.1047607163 | 1.2069632495 | 5.3117239658 | 5.0243907157 | 5.3117239658 | 7.439889763 | 0.7727737252 | 0.8450930805 | no | 39.3648959072 | 0.9961095613 |
| 37 | 45.0907059238 | 4.3221038369 | 0.4987990392 | 4.8209028761 | 5.2531132598 | 4.8209028761 | 9.3531662185 | 0.8965341032 | 0.8450930805 | yes | 40.928077263 | 0.9076832226 |
| 64 | 45.5201412487 | 4.6486686847 | 1.2663248286 | 5.9149935133 | 5.7290467659 | 5.9149935133 | 7.6957212457 | 0.7859127274 | 0.8450930805 | no | 44.180797217 | 0.970576892 |
| 67 | 35.5159529079 | 3.5212165808 | 0.8287956831 | 4.3500122639 | 4.702133922 | 4.3500122639 | 8.1645638571 | 0.8094727939 | 0.8450930805 | no | 37.1624640765 | 1.0463597633 |
| 84 | 39.0944408386 | 4.0652073581 | 1.4700995583 | 5.5353069163 | 5.6572631371 | 5.5353069163 | 7.0627413131 | 0.7344140839 | 0.8450930805 | no | 43.690199184 | 1.1175552904 |
| 93 | 43.5117438586 | 4.7530327166 | 1.5092513172 | 6.2622840338 | 6.4048750153 | 6.2622840338 | 6.948222665 | 0.7589934744 | 0.8450930805 | no | 48.7996778047 | 1.1215288903 |
TOP 10 (GENERAL PROJECTED ROI)
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | Y = Projected Returns | Projected ROI | |
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | PROJECTED RETURNS (Projected stock price - stock price) | Projected returns/stock price | ||||||
| 10 | 18.2951804739 | 1.6904878847 | 0.742018664 | 2.4325065488 | 2.3141723969 | 2.4325065488 | 7.5211228036 | 0.6949571772 | 0.8450930805 | no | 20.8421798291 | 1.1392169571 |
| 28 | 15.2468587331 | 1.2817067557 | 0.5145874094 | 1.796294165 | 1.8219283001 | 1.796294165 | 8.4879520458 | 0.7135283188 | 0.8450930805 | no | 17.4779867745 | 1.1463336206 |
| 48 | 13.5217125396 | 1.2029669413 | 0.5102461153 | 1.7132130566 | 1.6169757013 | 1.7132130566 | 7.8926041845 | 0.7021700755 | 0.8450930805 | no | 16.0772587331 | 1.1889957493 |
| 50 | 15.4847138722 | 1.4422788606 | 0.5920083437 | 2.0342872042 | 2.0487099928 | 2.0342872042 | 7.6118621992 | 0.7089848757 | 0.8450930805 | no | 19.027903575 | 1.2288185453 |
| 52 | 19.5338876676 | 1.8512449457 | 0.8201745052 | 2.6714194509 | 2.5973696531 | 2.6714194509 | 7.3121754282 | 0.6929817573 | 0.8450930805 | no | 22.7776631573 | 1.1660588791 |
| 54 | 12.8649438924 | 1.064529635 | 0.633599372 | 1.6981290069 | 1.6236119325 | 1.6981290069 | 7.5759520271 | 0.6268838413 | 0.8450930805 | no | 16.1226133914 | 1.2532206534 |
| 56 | 19.4234674356 | 1.7360973103 | 0.8321055337 | 2.5682028439 | 2.6029247901 | 2.5682028439 | 7.5630581446 | 0.6759969581 | 0.8450930805 | no | 22.8156291857 | 1.1746424402 |
| 79 | 18.0659509551 | 1.6957203597 | 0.5460374991 | 2.2417578588 | 2.3095866732 | 2.2417578588 | 8.05883244 | 0.7564244073 | 0.8450930805 | no | 20.8108391591 | 1.1519371004 |
| 80 | 24.6686299114 | 2.5164226572 | 1.1410868016 | 3.6575094588 | 3.4310314196 | 3.6575094588 | 6.7446523896 | 0.6880153519 | 0.8450930805 | no | 28.4752411344 | 1.1543097949 |
| 90 | 17.4488716824 | 1.6452180872 | 0.8766306523 | 2.5218487395 | 2.456040016 | 2.5218487395 | 6.9190794076 | 0.6523857127 | 0.8450930805 | no | 21.8117598854 | 1.2500384141 |
NUMBER 4 and 5
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | Projected Returns | Projected ROI | |
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | Projected Stock price - Stock price | Projected profits for holding 1 share / stock price | ||||||
| 54 | 12.8649438924 | 1.064529635 | 0.633599372 | 1.6981290069 | 1.6236119325 | 1.6981290069 | 7.5759520271 | 0.6268838413 | 0.7889268178 | no | ||
| 90 | 17.4488716824 | 1.6452180872 | 0.8766306523 | 2.5218487395 | 2.456040016 | 2.5218487395 | 6.9190794076 | 0.6523857127 | 0.7889268178 | no | ||
| 56 | 19.4234674356 | 1.7360973103 | 0.8321055337 | 2.5682028439 | 2.6029247901 | 2.5682028439 | 7.5630581446 | 0.6759969581 | 0.7889268178 | no | ||
| 80 | 24.6686299114 | 2.5164226572 | 1.1410868016 | 3.6575094588 | 3.4310314196 | 3.6575094588 | 6.7446523896 | 0.6880153519 | 0.7889268178 | no | ||
| 52 | 19.5338876676 | 1.8512449457 | 0.8201745052 | 2.6714194509 | 2.5973696531 | 2.6714194509 | 7.3121754282 | 0.6929817573 | 0.7889268178 | no | ||
| 10 | 18.2951804739 | 1.6904878847 | 0.742018664 | 2.4325065488 | 2.3141723969 | 2.4325065488 | 7.5211228036 | 0.6949571772 | 0.7889268178 | no | ||
| 6 | 20.1045520364 | 1.7903381643 | 0.7787439614 | 2.5690821256 | 2.497468599 | 2.5690821256 | 7.8255777953 | 0.6968785258 | 0.7889268178 | no | ||
| 48 | 13.5217125396 | 1.2029669413 | 0.5102461153 | 1.7132130566 | 1.6169757013 | 1.7132130566 | 7.8926041845 | 0.7021700755 | 0.7889268178 | no | ||
| 88 | 24.1934832955 | 2.2874397082 | 0.9449433356 | 3.2323830438 | 3.2552574409 | 3.2323830438 | 7.484720396 | 0.707663565 | 0.7889268178 | no | ||
| 50 | 15.4847138722 | 1.4422788606 | 0.5920083437 | 2.0342872042 | 2.0487099928 | 2.0342872042 | 7.6118621992 | 0.7089848757 | 0.7889268178 | no | ||
| 44 | 17.5754111464 | 1.5775379402 | 0.6436569913 | 2.2211949315 | 2.1896441727 | 2.2211949315 | 7.9125928559 | 0.7102203944 | 0.7889268178 | no | ||
| 28 | 15.2468587331 | 1.2817067557 | 0.5145874094 | 1.796294165 | 1.8219283001 | 1.796294165 | 8.4879520458 | 0.7135283188 | 0.7889268178 | no | ||
| 7 | 15.7656377786 | 1.2188594559 | 0.4834203737 | 1.7022798297 | 1.6900912351 | 1.7022798297 | 9.2614842188 | 0.7160159186 | 0.7889268178 | no | ||
| 9 | 16.2248198788 | 1.3961752267 | 0.5430752454 | 1.9392504721 | 1.7996329494 | 1.9392504721 | 8.3665416676 | 0.7199561103 | 0.7889268178 | no | ||
| 19 | 32.8838979302 | 3.3135375494 | 1.2225790514 | 4.5361166008 | 4.2047628458 | 4.5361166008 | 7.2493502315 | 0.7304789186 | 0.7889268178 | no | ||
| 84 | 39.0944408386 | 4.0652073581 | 1.4700995583 | 5.5353069163 | 5.6572631371 | 5.5353069163 | 7.0627413131 | 0.7344140839 | 0.7889268178 | no | ||
| 49 | 14.5414780053 | 1.0481779958 | 0.3768395235 | 1.4250175193 | 1.3411632796 | 1.4250175193 | 10.2044205132 | 0.7355544627 | 0.7889268178 | no | ||
| 63 | 14.1267759917 | 1.2394714442 | 0.4386526691 | 1.6781241133 | 1.6161505411 | 1.6781241133 | 8.418194983 | 0.7386053477 | 0.7889268178 | no | ||
| 87 | 18.7006656156 | 1.6621393697 | 0.5570942447 | 2.2192336144 | 2.185990827 | 2.2192336144 | 8.4266322815 | 0.7489699863 | 0.7889268178 | no | ||
| 61 | 17.5471501025 | 1.5219110762 | 0.509494315 | 2.0314053913 | 1.9400907267 | 2.0314053913 | 8.6379361687 | 0.7491912165 | 0.7889268178 | no | ||
| 91 | 21.9169483259 | 2.046891261 | 0.6746751509 | 2.7215664119 | 2.5987529363 | 2.7215664119 | 8.0530639377 | 0.7521004272 | 0.7889268178 | no | ||
| 51 | 20.9095264484 | 2.0442079765 | 0.6700694985 | 2.714277475 | 2.5711829166 | 2.714277475 | 7.7035331285 | 0.7531315406 | 0.7889268178 | no | ||
| 24 | 26.4814162464 | 2.5911212856 | 0.837328306 | 3.4284495915 | 3.4284495915 | 3.4284495915 | 7.7240208845 | 0.7557705652 | 0.7889268178 | no | ||
| 79 | 18.0659509551 | 1.6957203597 | 0.5460374991 | 2.2417578588 | 2.3095866732 | 2.2417578588 | 8.05883244 | 0.7564244073 | 0.7889268178 | no | ||
| 65 | 22.1462931992 | 2.0668295184 | 0.6650381495 | 2.7318676679 | 2.7938725535 | 2.7318676679 | 8.1066493298 | 0.7565628243 | 0.7889268178 | no | ||
| 93 | 43.5117438586 | 4.7530327166 | 1.5092513172 | 6.2622840338 | 6.4048750153 | 6.2622840338 | 6.948222665 | 0.7589934744 | 0.7889268178 | no | ||
| 34 | 38.1380085248 | 4.0982133189 | 1.2840822956 | 5.3822956145 | 5.2183670818 | 5.3822956145 | 7.0858256878 | 0.761424792 | 0.7889268178 | no | ||
| 85 | 20.0535890811 | 1.8071336346 | 0.5661717237 | 2.3733053583 | 2.4275193673 | 2.3733053583 | 8.4496455591 | 0.7614416865 | 0.7889268178 | no | ||
| 18 | 22.4555261805 | 1.974841609 | 0.6175040519 | 2.5923456608 | 2.5725972447 | 2.5923456608 | 8.6622422773 | 0.7617971781 | 0.7889268178 | no | ||
| 82 | 18.8831321592 | 1.7845191893 | 0.5546787408 | 2.3391979301 | 2.3927335058 | 2.3391979301 | 8.0724815612 | 0.7628765255 | 0.7889268178 | no | ||
| 86 | 23.1689674538 | 2.2966621031 | 0.7103135798 | 3.0069756829 | 2.9151091988 | 3.0069756829 | 7.7050731024 | 0.7637780765 | 0.7889268178 | no | ||
| 38 | 17.0872414628 | 1.566189792 | 0.4806959455 | 2.0468857375 | 1.9059286562 | 2.0468857375 | 8.3479215033 | 0.7651574112 | 0.7889268178 | no | ||
| 58 | 18.9083290525 | 1.5438292964 | 0.47189892 | 2.0157282164 | 1.8767835797 | 2.0157282164 | 9.3803960764 | 0.7658915938 | 0.7889268178 | no | ||
| 22 | 25.4923933382 | 2.5640112263 | 0.7706174439 | 3.3346286701 | 3.4628292314 | 3.3346286701 | 7.6447472448 | 0.7689045708 | 0.7889268178 | no | ||
| 60 | 30.2615260785 | 3.1288708512 | 0.9321176405 | 4.0609884917 | 4.1548546172 | 4.0609884917 | 7.4517635646 | 0.7704702581 | 0.7889268178 | no | ||
| 69 | 25.4954040325 | 2.438362954 | 0.71932309 | 3.157686044 | 3.2552205622 | 3.157686044 | 8.0740781943 | 0.7721993004 | 0.7889268178 | no | ||
| 5 | 23.3001521692 | 2.0581456116 | 0.607008279 | 2.6651538906 | 2.5416651539 | 2.6651538906 | 8.7425166147 | 0.7722426907 | 0.7889268178 | no | ||
| 36 | 39.5186407574 | 4.1047607163 | 1.2069632495 | 5.3117239658 | 5.0243907157 | 5.3117239658 | 7.439889763 | 0.7727737252 | 0.7889268178 | no | ||
| 89 | 12.8488485268 | 0.9315722256 | 0.270372611 | 1.2019448365 | 1.2392077256 | 1.2019448365 | 10.6900484415 | 0.7750540601 | 0.7889268178 | no | ||
| 70 | 22.5508224942 | 2.2011266614 | 0.6375319074 | 2.8386585688 | 2.6185459026 | 2.8386585688 | 7.9441827707 | 0.7754108527 | 0.7889268178 | no | ||
| 74 | 16.1246526708 | 1.319777732 | 0.3818481169 | 1.7016258489 | 1.7544169582 | 1.7016258489 | 9.4760271072 | 0.7755980746 | 0.7889268178 | no | ||
| 98 | 32.2048296757 | 3.337340186 | 0.9481374506 | 4.2854776367 | 4.4189712441 | 4.2854776367 | 7.5148752149 | 0.7787557115 | 0.7889268178 | no | ||
| 1 | 32.0428669757 | 3.1965317919 | 0.9015370468 | 4.0980688387 | 4.2578954283 | 4.0980688387 | 7.8190162823 | 0.7800092965 | 0.7889268178 | no | ||
| 26 | 21.3121409817 | 1.8083403538 | 0.5068600313 | 2.3152003851 | 2.2066999639 | 2.3152003851 | 9.2053116087 | 0.7810729324 | 0.7889268178 | no | ||
| 45 | 28.4030823374 | 2.6389516958 | 0.7262076053 | 3.3651593011 | 3.417938335 | 3.3651593011 | 8.4403381224 | 0.7841981492 | 0.7889268178 | no | ||
| 99 | 30.7334787233 | 3.0311551872 | 0.8339446633 | 3.8650998506 | 3.6226074356 | 3.8650998506 | 7.9515355131 | 0.7842372266 | 0.7889268178 | no | ||
| 47 | 22.7037822551 | 1.9664788144 | 0.5389271551 | 2.5054059695 | 2.4070820288 | 2.5054059695 | 9.061917522 | 0.78489428 | 0.7889268178 | no | ||
| 64 | 45.5201412487 | 4.6486686847 | 1.2663248286 | 5.9149935133 | 5.7290467659 | 5.9149935133 | 7.6957212457 | 0.7859127274 | 0.7889268178 | no | ||
| 31 | 38.0023282738 | 3.8768768769 | 1.046046046 | 4.9229229229 | 4.9616916917 | 4.9229229229 | 7.7194644053 | 0.7875152501 | 0.7889268178 | no | ||
| 81 | 13.7036693822 | 1.1398060885 | 0.3073202703 | 1.4471263588 | 1.4699224806 | 1.4471263588 | 9.4695734747 | 0.7876341147 | 0.7889268178 | no | ||
| 16 | 45.1878317502 | 4.113573701 | 0.2984623542 | 4.4120360551 | 4.8233934252 | 4.4120360551 | 10.2419452573 | 0.9323526938 | 0.7889268178 | yes | ||
| 37 | 45.0907059238 | 4.3221038369 | 0.4987990392 | 4.8209028761 | 5.2531132598 | 4.8209028761 | 9.3531662185 | 0.8965341032 | 0.7889268178 | yes | ||
| 15 | 38.3086599587 | 3.6310411311 | 0.4862467866 | 4.1172879177 | 4.4803920308 | 4.1172879177 | 9.3043432289 | 0.8819011941 | 0.7889268178 | yes | ||
| 8 | 35.7370104637 | 3.5500367531 | 0.6335713536 | 4.1836081067 | 4.538611782 | 4.1836081067 | 8.5421505916 | 0.8485586275 | 0.7889268178 | yes | ||
| 67 | 35.5159529079 | 3.5212165808 | 0.8287956831 | 4.3500122639 | 4.702133922 | 4.3500122639 | 8.1645638571 | 0.8094727939 | 0.7889268178 | yes | ||
| 76 | 33.7617494183 | 3.1496581284 | 0.4460148995 | 3.5956730279 | 3.9106388407 | 3.5956730279 | 9.3895493713 | 0.8759578816 | 0.7889268178 | yes | ||
| 72 | 33.3418396626 | 2.9724994801 | 0.3844874194 | 3.3569868996 | 3.6542368476 | 3.3569868996 | 9.9320732133 | 0.8854665118 | 0.7889268178 | yes | ||
| 78 | 33.2731866654 | 3.0831213556 | 0.2398935546 | 3.3230149102 | 3.6313270457 | 3.3230149102 | 10.0129513604 | 0.9278084628 | 0.7889268178 | yes | ||
| 62 | 32.7762826087 | 3.0634475268 | 0.4711046748 | 3.5345522017 | 3.8408969543 | 3.5345522017 | 9.2731075222 | 0.8667144668 | 0.7889268178 | yes | ||
| 40 | 32.1714189178 | 3.0532428821 | 0.5697399527 | 3.6229828348 | 3.928307123 | 3.6229828348 | 8.8798154406 | 0.8427428507 | 0.7889268178 | yes | ||
| 20 | 32.1327478162 | 3.2479042496 | 0.7676503368 | 4.0155545864 | 4.3403450114 | 4.0155545864 | 8.0020697327 | 0.8088308052 | 0.7889268178 | yes | ||
| 95 | 31.3851120319 | 2.9520898642 | 0.3402821317 | 3.2923719958 | 3.5875809822 | 3.2923719958 | 9.5326749443 | 0.8966452964 | 0.7889268178 | yes | ||
| 59 | 30.1093256213 | 2.7911429738 | 0.67439539 | 3.4655383638 | 3.7446526612 | 3.4655383638 | 8.6882101597 | 0.8053995313 | 0.7889268178 | yes | ||
| 71 | 29.4852469338 | 2.9128923423 | 0.6337797771 | 3.5466721194 | 3.8379613536 | 3.5466721194 | 8.3134966924 | 0.8213029692 | 0.7889268178 | yes | ||
| 21 | 28.5957550442 | 2.4664621612 | 0.335789507 | 2.8022516682 | 3.0488978843 | 2.8022516682 | 10.2045634833 | 0.8801715382 | 0.7889268178 | yes | ||
| 83 | 28.2047028873 | 2.5218865192 | 0.5192535545 | 3.0411400737 | 3.2933287256 | 3.0411400737 | 9.2743846727 | 0.8292569425 | 0.7889268178 | yes | ||
| 25 | 27.8152691728 | 2.3643989455 | 0.2936967165 | 2.658095662 | 2.8945355565 | 2.658095662 | 10.4643597183 | 0.8895085979 | 0.7889268178 | yes | ||
| 30 | 27.3426146254 | 2.4725256939 | 0.3947155458 | 2.8672412398 | 3.1144938092 | 2.8672412398 | 9.5362100147 | 0.8623361228 | 0.7889268178 | yes | ||
| 73 | 26.5028429896 | 2.3990917488 | 0.6289254926 | 3.0280172414 | 3.2679264163 | 3.0280172414 | 8.7525403183 | 0.7922979156 | 0.7889268178 | yes | ||
| 46 | 26.2446132751 | 2.3150021849 | 0.5057312851 | 2.82073347 | 3.0522336885 | 2.82073347 | 9.3041804743 | 0.8207092976 | 0.7889268178 | yes | ||
| 53 | 25.3650782162 | 2.2419879097 | 0.5418755126 | 2.7838634223 | 3.0080622133 | 2.7838634223 | 9.1114664651 | 0.8053512582 | 0.7889268178 | yes | ||
| 32 | 24.3495221067 | 2.3150731541 | 0.4838002344 | 2.7988733885 | 3.0303807039 | 2.7988733885 | 8.6997583408 | 0.8271446517 | 0.7889268178 | yes | ||
| 29 | 23.8433525884 | 2.0118296743 | 0.2002652879 | 2.2120949622 | 2.4132779297 | 2.2120949622 | 10.7786297584 | 0.9094680421 | 0.7889268178 | yes | ||
| 66 | 21.9749100932 | 1.7343599258 | 0.2203710575 | 1.9547309833 | 2.1281669759 | 1.9547309833 | 11.2419101559 | 0.8872627183 | 0.7889268178 | yes | ||
| 75 | 21.561094137 | 1.6370420298 | 0.1244042174 | 1.7614462472 | 1.9251504501 | 1.7614462472 | 12.2405632143 | 0.9293738213 | 0.7889268178 | yes | ||
| 12 | 21.5180343473 | 1.9034415754 | 0.4431822428 | 2.3466238182 | 2.5369679758 | 2.3466238182 | 9.169784343 | 0.8111404822 | 0.7889268178 | yes | ||
| 94 | 21.1561516244 | 1.8604005505 | 0.4306392672 | 2.2910398178 | 2.4770798728 | 2.2910398178 | 9.2343011503 | 0.8120332681 | 0.7889268178 | yes | ||
| 100 | 20.9032990506 | 1.6970328748 | 0.1674760367 | 1.8645089115 | 2.034212199 | 1.8645089115 | 11.2111553456 | 0.9101768644 | 0.7889268178 | yes | ||
| 42 | 20.6085870155 | 1.7123043153 | 0.4545673831 | 2.1668716984 | 2.3381021299 | 2.1668716984 | 9.5107555426 | 0.7902195209 | 0.7889268178 | yes | ||
| 2 | 19.9929366571 | 1.8582036941 | 0.461789726 | 2.3199934201 | 2.5058137895 | 2.3199934201 | 8.6176695519 | 0.8009521398 | 0.7889268178 | yes | ||
| 77 | 19.7635895825 | 1.7969360803 | 0.3821183307 | 2.179054411 | 2.358748019 | 2.179054411 | 9.0698008654 | 0.8246402987 | 0.7889268178 | yes | ||
| 14 | 19.4758303817 | 1.7539579896 | 0.3543905811 | 2.1083485707 | 2.2837443696 | 2.1083485707 | 9.2374812461 | 0.8319108206 | 0.7889268178 | yes | ||
| 92 | 19.1606211934 | 1.4621534753 | 0.2434511852 | 1.7056046605 | 1.851820008 | 1.7056046605 | 11.2339170014 | 0.8572640009 | 0.7889268178 | yes | ||
| 33 | 19.0408676849 | 1.4845846935 | 0.3120541652 | 1.7966388587 | 1.945097328 | 1.7966388587 | 10.5980495708 | 0.8263122476 | 0.7889268178 | yes | ||
| 17 | 18.9733046764 | 1.6948452227 | 0.3385223567 | 2.0333675794 | 2.2028521017 | 2.0333675794 | 9.330976292 | 0.833516399 | 0.7889268178 | yes | ||
| 97 | 18.9658862673 | 1.5555249127 | 0.2658576944 | 1.8213826071 | 1.9769350984 | 1.8213826071 | 10.4129062139 | 0.8540352294 | 0.7889268178 | yes | ||
| 3 | 18.930716101 | 1.4795201956 | 0.3248344277 | 1.8043546232 | 1.9523066428 | 1.8043546232 | 10.4916826533 | 0.8199719592 | 0.7889268178 | yes | ||
| 96 | 18.3255663134 | 1.660436767 | 0.4049338494 | 2.0653706164 | 2.2314142931 | 2.0653706164 | 8.8727738099 | 0.8039413139 | 0.7889268178 | yes | ||
| 68 | 17.8264362883 | 1.4316631887 | 0.250069918 | 1.6817331067 | 1.8248994256 | 1.6817331067 | 10.6000388629 | 0.8513022566 | 0.7889268178 | yes | ||
| 13 | 17.1821728433 | 1.4775795695 | 0.2691264979 | 1.7467060673 | 1.8944640243 | 1.7467060673 | 9.8368999596 | 0.8459234196 | 0.7889268178 | yes | ||
| 4 | 16.9924923636 | 1.4010723861 | 0.3630233038 | 1.7640956898 | 1.9042029284 | 1.7640956898 | 9.6324096598 | 0.7942156393 | 0.7889268178 | yes | ||
| 27 | 16.9031205449 | 1.1980071483 | 0.1765190079 | 1.3745261562 | 1.494326871 | 1.3745261562 | 12.2974164361 | 0.8715782838 | 0.7889268178 | yes | ||
| 35 | 16.7856503916 | 1.4456115731 | 0.2858204181 | 1.7314319912 | 1.8759931486 | 1.7314319912 | 9.694663421 | 0.8349225268 | 0.7889268178 | yes | ||
| 57 | 16.7735975458 | 1.3796846112 | 0.3656334965 | 1.7453181077 | 1.8832865688 | 1.7453181077 | 9.6106248323 | 0.7905061004 | 0.7889268178 | yes | ||
| 11 | 15.944499818 | 1.3110740526 | 0.1908594354 | 1.501933488 | 1.6330408933 | 1.501933488 | 10.6159826286 | 0.8729241761 | 0.7889268178 | yes | ||
| 39 | 15.6643448293 | 1.3609695082 | 0.3492164637 | 1.7101859719 | 1.8462829227 | 1.7101859719 | 9.1594394335 | 0.7958020534 | 0.7889268178 | yes | ||
| 55 | 14.6283267086 | 1.1688379469 | 0.1739767549 | 1.3428147018 | 1.4596984965 | 1.3428147018 | 10.8937790813 | 0.8704387473 | 0.7889268178 | yes | ||
| 23 | 14.4281390697 | 1.0562749111 | 0.1914682753 | 1.2477431865 | 1.3533706776 | 1.2477431865 | 11.5633883849 | 0.8465483303 | 0.7889268178 | yes | ||
| 41 | 13.4294172161 | 0.9508497425 | 0.1839819665 | 1.134831709 | 1.2299166832 | 1.134831709 | 11.833840304 | 0.8378773126 | 0.7889268178 | yes | ||
| 43 | 12.3970754865 | 0.8638854553 | 0.2232385661 | 1.0871240214 | 1.173512567 | 1.0871240214 | 11.4035521635 | 0.7946521632 | 0.7889268178 | yes |
Permanent earnings < Median
1.6981290069344497 2.5218487394957982 2.5682028439266746 3.6575094587925649 2.6714194509470102 2.4325065487884743 2.569082125603865 1.7132130566273855 3.2323830438022041 2.034287204223975 2.2211949314866657 1.7962941650362527 1.7022798296944148 1.9392504721121364 4.536116600790514 5.5353069163315087 1.4250175192711985 1.678124113331442 2.219233614440006 2.0314053912588328 2.7215664119413638 2.7142774749834184 3.4284495915252715 2.2417578587858089 2.7318676679031335 6.2622840338193848 5.3822956145100154 2.3733053582956747 2.59234566082216 2.3391979301423027 3.0069756828997978 2.0468857374898484 2.0157282164202579 3.3346286701208983 4.060988491688442 3.1576860440416343 2.6651538905850316 5.3117239658077002 1.2019448365485874 2.8386585687879586 1.701625848940111 4.285477636664826 4.0980688386757755 2.3152003851245637 3.3651593011305243 3.8650998505637824 2.505405969526195 5.9149935133131519 4.9229229229229237 1.4471263588491874 12.864943892378065 17.448871682406164 19.423467435629771 24.66862991139125 19.533887667640556 18.295180473882105 20.104552036379957 13.521712539611666 24.193483295482785 15.48471387223589 17.575411146430191 15.246858733066912 15.765637778644008 16.224819878796975 32.88389793015665 39.094440838563301 14.541478005323928 14.126775991673135 18.700665615621435 17.547150102471345 21.91694832594591 20.909526448401909 26.481416246355465 18.0659509550511 22.146293199228889 43.511743858563165 38.138008524785974 20.053589081064683 22.455526180549693 18.883132159173236 23.168967453762527 17.087241462824927 18.908329052472375 25.492393338220829 30.261526078476152 25.495404032547818 23.30015216915038 39.518640757354483 12.848848526750913 22.550822494198499 16.12465267078629 32.204829675735937 32.042866975679445 21.312140981738935 28.403082337424987 30.733478723341307 22.703782255084779 45.520141248702501 38.00232827378008 13.703669382234308
Permanent earnings > median
4.4120360551431599 4.8209028761470716 4.117287917737789 4.1836081066890687 4.3500122639195489 3.5956730278599855 3.356986899563319 3.3230149101866706 3.5345522016563335 3.62298283 4823723 4.0155545864224456 3.2923719958202717 3.4655383638096104 3.5466721194151929 2.8022516681951868 3.0411400737230121 2.6580956619988361 2.8672412397831186 3.0280172413793105 2.8207334700326063 2.7838634223396821 2.7988733885297341 2.2120949622370807 1.9547309833024118 1.7614462471715373 2.3466238182429655 2.2910398177590054 1.8645089115456002 2.1668716983862799 2.3199934201250176 2.1790544109878498 2.1083485706640506 1.7056046605062274 1.7966388586627977 2.0333675793987585 1.8213826070968926 1.8043546232341319 2.0653706164423133 1.6817331067271906 1.7467060673426231 1.7640956898329554 1.3745261561789235 1.7314319912499743 1.7453181076672104 1.5019334880123743 1.7101859718682149 1.3428147018086196 1.2477431864698914 1.134831708988044 1.0871240214256284 45.187831750158757 45.090705923786437 38.308659958746105 35.737010463687888 35.515952907931954 33.761749418259619 33.341839662646997 33.273186665445522 32.776282608713046 32.171418917834458 32.132747816201849 31.385112031888138 30.109325621256751 29.485246933794173 28.595755044168893 28.204702887318991 27.815269172764197 27.342614625411315 26.502842989608716 26.244613275127165 25.365078216197347 24.349522106707727 23.843352588437117 21.974910093215172 21.561094137031326 21.518034347346383 21.15615162441269 20.903299050558658 20.608587015526034 19.992936657140966 19.763589582513436 19.475830381655534 19.160621193412371 19.040867684899467 18.973304676372141 18.965886267340579 18.930716101003043 18.325566313355168 17.826436288278003 17.182172843272099 16.992492363616741 16.903120544912255 16.785650391584905 16.773597545821705 15.944499817985674 15.664344829307534 14.62832670856597 14.428139069728218 13.429417216082477 12.397075486543283
Higher than median
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | 8.0542x + 3.8693 | |||
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | y= projected stock price | projected returns | Projected Return on Investment | ||||||
| 20 | 32.1327478162 | 3.2479042496 | 0.7676503368 | 4.0155545864 | 4.3403450114 | 4.0155545864 | 8.0020697327 | 0.8088308052 | 0.7889268178 | yes | 38.8273067907 | 6.6945589745 | 21% |
| 2 | 19.9929366571 | 1.8582036941 | 0.461789726 | 2.3199934201 | 2.5058137895 | 2.3199934201 | 8.6176695519 | 0.8009521398 | 0.7889268178 | yes | 24.0516254237 | 4.0586887666 | 20% |
| 39 | 15.6643448293 | 1.3609695082 | 0.3492164637 | 1.7101859719 | 1.8462829227 | 1.7101859719 | 9.1594394335 | 0.7958020534 | 0.7889268178 | yes | 18.7396319159 | 3.0752870866 | 20% |
| 96 | 18.3255663134 | 1.660436767 | 0.4049338494 | 2.0653706164 | 2.2314142931 | 2.0653706164 | 8.8727738099 | 0.8039413139 | 0.7889268178 | yes | 21.8415569998 | 3.5159906865 | 19% |
| 71 | 29.4852469338 | 2.9128923423 | 0.6337797771 | 3.5466721194 | 3.8379613536 | 3.5466721194 | 8.3134966924 | 0.8213029692 | 0.7889268178 | yes | 34.7810083345 | 5.2957614007 | 18% |
| 67 | 35.5159529079 | 3.5212165808 | 0.8287956831 | 4.3500122639 | 4.702133922 | 4.3500122639 | 8.1645638571 | 0.8094727939 | 0.7889268178 | yes | 41.7412270346 | 6.2252741267 | 18% |
| 32 | 24.3495221067 | 2.3150731541 | 0.4838002344 | 2.7988733885 | 3.0303807039 | 2.7988733885 | 8.6997583408 | 0.8271446517 | 0.7889268178 | yes | 28.2765922657 | 3.927070159 | 16% |
| 77 | 19.7635895825 | 1.7969360803 | 0.3821183307 | 2.179054411 | 2.358748019 | 2.179054411 | 9.0698008654 | 0.8246402987 | 0.7889268178 | yes | 22.8671282948 | 3.1035387123 | 16% |
| 14 | 19.4758303817 | 1.7539579896 | 0.3543905811 | 2.1083485707 | 2.2837443696 | 2.1083485707 | 9.2374812461 | 0.8319108206 | 0.7889268178 | yes | 22.2630339018 | 2.7872035201 | 14% |
| 73 | 26.5028429896 | 2.3990917488 | 0.6289254926 | 3.0280172414 | 3.2679264163 | 3.0280172414 | 8.7525403183 | 0.7922979156 | 0.7889268178 | yes | 30.1898329418 | 3.6869899522 | 14% |
| 17 | 18.9733046764 | 1.6948452227 | 0.3385223567 | 2.0333675794 | 2.2028521017 | 2.0333675794 | 9.330976292 | 0.833516399 | 0.7889268178 | yes | 21.6115113972 | 2.6382067209 | 14% |
| 57 | 16.7735975458 | 1.3796846112 | 0.3656334965 | 1.7453181077 | 1.8832865688 | 1.7453181077 | 9.6106248323 | 0.7905061004 | 0.7889268178 | yes | 19.0376666823 | 2.2640691365 | 13% |
| 8 | 35.7370104637 | 3.5500367531 | 0.6335713536 | 4.1836081067 | 4.538611782 | 4.1836081067 | 8.5421505916 | 0.8485586275 | 0.7889268178 | yes | 40.4241870146 | 4.6871765509 | 13% |
| 35 | 16.7856503916 | 1.4456115731 | 0.2858204181 | 1.7314319912 | 1.8759931486 | 1.7314319912 | 9.694663421 | 0.8349225268 | 0.7889268178 | yes | 18.9789240172 | 2.1932736256 | 13% |
| 4 | 16.9924923636 | 1.4010723861 | 0.3630233038 | 1.7640956898 | 1.9042029284 | 1.7640956898 | 9.6324096598 | 0.7942156393 | 0.7889268178 | yes | 19.2061312262 | 2.2136388626 | 13% |
| 59 | 30.1093256213 | 2.7911429738 | 0.67439539 | 3.4655383638 | 3.7446526612 | 3.4655383638 | 8.6882101597 | 0.8053995313 | 0.7889268178 | yes | 34.0294814638 | 3.9201558425 | 13% |
| 12 | 21.5180343473 | 1.9034415754 | 0.4431822428 | 2.3466238182 | 2.5369679758 | 2.3466238182 | 9.169784343 | 0.8111404822 | 0.7889268178 | yes | 24.3025474706 | 2.7845131232 | 13% |
| 94 | 21.1561516244 | 1.8604005505 | 0.4306392672 | 2.2910398178 | 2.4770798728 | 2.2910398178 | 9.2343011503 | 0.8120332681 | 0.7889268178 | yes | 23.8201967116 | 2.6640450872 | 13% |
| 13 | 17.1821728433 | 1.4775795695 | 0.2691264979 | 1.7467060673 | 1.8944640243 | 1.7467060673 | 9.8368999596 | 0.8459234196 | 0.7889268178 | yes | 19.1276921444 | 1.9455193012 | 11% |
| 53 | 25.3650782162 | 2.2419879097 | 0.5418755126 | 2.7838634223 | 3.0080622133 | 2.7838634223 | 9.1114664651 | 0.8053512582 | 0.7889268178 | yes | 28.0968346785 | 2.7317564623 | 11% |
| 40 | 32.1714189178 | 3.0532428821 | 0.5697399527 | 3.6229828348 | 3.928307123 | 3.6229828348 | 8.8798154406 | 0.8427428507 | 0.7889268178 | yes | 35.5086712303 | 3.3372523125 | 10% |
| 42 | 20.6085870155 | 1.7123043153 | 0.4545673831 | 2.1668716984 | 2.3381021299 | 2.1668716984 | 9.5107555426 | 0.7902195209 | 0.7889268178 | yes | 22.7008421748 | 2.0922551593 | 10% |
| 46 | 26.2446132751 | 2.3150021849 | 0.5057312851 | 2.82073347 | 3.0522336885 | 2.82073347 | 9.3041804743 | 0.8207092976 | 0.7889268178 | yes | 28.4526005741 | 2.207987299 | 8% |
| 83 | 28.2047028873 | 2.5218865192 | 0.5192535545 | 3.0411400737 | 3.2933287256 | 3.0411400737 | 9.2743846727 | 0.8292569425 | 0.7889268178 | yes | 30.3944282221 | 2.1897253348 | 8% |
| 43 | 12.3970754865 | 0.8638854553 | 0.2232385661 | 1.0871240214 | 1.173512567 | 1.0871240214 | 11.4035521635 | 0.7946521632 | 0.7889268178 | yes | 13.3210049168 | 0.9239294302 | 7% |
| 55 | 14.6283267086 | 1.1688379469 | 0.1739767549 | 1.3428147018 | 1.4596984965 | 1.3428147018 | 10.8937790813 | 0.8704387473 | 0.7889268178 | yes | 15.6260036305 | 0.9976769219 | 7% |
| 11 | 15.944499818 | 1.3110740526 | 0.1908594354 | 1.501933488 | 1.6330408933 | 1.501933488 | 10.6159826286 | 0.8729241761 | 0.7889268178 | yes | 17.0221379626 | 1.0776381446 | 7% |
| 62 | 32.7762826087 | 3.0634475268 | 0.4711046748 | 3.5345522017 | 3.8408969543 | 3.5345522017 | 9.2731075222 | 0.8667144668 | 0.7889268178 | yes | 34.8046522496 | 2.0283696409 | 6% |
| 30 | 27.3426146254 | 2.4725256939 | 0.3947155458 | 2.8672412398 | 3.1144938092 | 2.8672412398 | 9.5362100147 | 0.8623361228 | 0.7889268178 | yes | 28.9540560379 | 1.6114414125 | 6% |
| 76 | 33.7617494183 | 3.1496581284 | 0.4460148995 | 3.5956730279 | 3.9106388407 | 3.5956730279 | 9.3895493713 | 0.8759578816 | 0.7889268178 | yes | 35.3663673508 | 1.6046179325 | 5% |
| 95 | 31.3851120319 | 2.9520898642 | 0.3402821317 | 3.2923719958 | 3.5875809822 | 3.2923719958 | 9.5326749443 | 0.8966452964 | 0.7889268178 | yes | 32.7643947471 | 1.3792827152 | 4% |
| 97 | 18.9658862673 | 1.5555249127 | 0.2658576944 | 1.8213826071 | 1.9769350984 | 1.8213826071 | 10.4129062139 | 0.8540352294 | 0.7889268178 | yes | 19.7919306692 | 0.8260444019 | 4% |
| 15 | 38.3086599587 | 3.6310411311 | 0.4862467866 | 4.1172879177 | 4.4803920308 | 4.1172879177 | 9.3043432289 | 0.8819011941 | 0.7889268178 | yes | 39.9552734949 | 1.6466135361 | 4% |
| 68 | 17.8264362883 | 1.4316631887 | 0.250069918 | 1.6817331067 | 1.8248994256 | 1.6817331067 | 10.6000388629 | 0.8513022566 | 0.7889268178 | yes | 18.5674049536 | 0.7409686654 | 4% |
| 3 | 18.930716101 | 1.4795201956 | 0.3248344277 | 1.8043546232 | 1.9523066428 | 1.8043546232 | 10.4916826533 | 0.8199719592 | 0.7889268178 | yes | 19.5935681624 | 0.6628520614 | 4% |
| 33 | 19.0408676849 | 1.4845846935 | 0.3120541652 | 1.7966388587 | 1.945097328 | 1.7966388587 | 10.5980495708 | 0.8263122476 | 0.7889268178 | yes | 19.5355028993 | 0.4946352144 | 3% |
| 41 | 13.4294172161 | 0.9508497425 | 0.1839819665 | 1.134831709 | 1.2299166832 | 1.134831709 | 11.833840304 | 0.8378773126 | 0.7889268178 | yes | 13.7752949502 | 0.3458777341 | 3% |
| 37 | 45.0907059238 | 4.3221038369 | 0.4987990392 | 4.8209028761 | 5.2531132598 | 4.8209028761 | 9.3531662185 | 0.8965341032 | 0.7889268178 | yes | 46.1789248174 | 1.0882188936 | 2% |
| 23 | 14.4281390697 | 1.0562749111 | 0.1914682753 | 1.2477431865 | 1.3533706776 | 1.2477431865 | 11.5633883849 | 0.8465483303 | 0.7889268178 | yes | 14.7696181114 | 0.3414790417 | 2% |
| 72 | 33.3418396626 | 2.9724994801 | 0.3844874194 | 3.3569868996 | 3.6542368476 | 3.3569868996 | 9.9320732133 | 0.8854665118 | 0.7889268178 | yes | 33.3012544178 | -0.0405852449 | -0% |
| 78 | 33.2731866654 | 3.0831213556 | 0.2398935546 | 3.3230149102 | 3.6313270457 | 3.3230149102 | 10.0129513604 | 0.9278084628 | 0.7889268178 | yes | 33.1167342919 | -0.1564523736 | -0% |
| 21 | 28.5957550442 | 2.4664621612 | 0.335789507 | 2.8022516682 | 3.0488978843 | 2.8022516682 | 10.2045634833 | 0.8801715382 | 0.7889268178 | yes | 28.4257333399 | -0.1700217043 | -1% |
| 92 | 19.1606211934 | 1.4621534753 | 0.2434511852 | 1.7056046605 | 1.851820008 | 1.7056046605 | 11.2339170014 | 0.8572640009 | 0.7889268178 | yes | 18.7842287087 | -0.3763924847 | -2% |
| 29 | 23.8433525884 | 2.0118296743 | 0.2002652879 | 2.2120949622 | 2.4132779297 | 2.2120949622 | 10.7786297584 | 0.9094680421 | 0.7889268178 | yes | 23.3063231012 | -0.5370294873 | -2% |
| 25 | 27.8152691728 | 2.3643989455 | 0.2936967165 | 2.658095662 | 2.8945355565 | 2.658095662 | 10.4643597183 | 0.8895085979 | 0.7889268178 | yes | 27.1824682795 | -0.6328008932 | -2% |
| 100 | 20.9032990506 | 1.6970328748 | 0.1674760367 | 1.8645089115 | 2.034212199 | 1.8645089115 | 11.2111553456 | 0.9101768644 | 0.7889268178 | yes | 20.2532518934 | -0.6500471571 | -3% |
| 66 | 21.9749100932 | 1.7343599258 | 0.2203710575 | 1.9547309833 | 2.1281669759 | 1.9547309833 | 11.2419101559 | 0.8872627183 | 0.7889268178 | yes | 21.0099824571 | -0.9649276361 | -4% |
| 16 | 45.1878317502 | 4.113573701 | 0.2984623542 | 4.4120360551 | 4.8233934252 | 4.4120360551 | 10.2419452573 | 0.9323526938 | 0.7889268178 | yes | 42.7178753256 | -2.4699564246 | -5% |
| 27 | 16.9031205449 | 1.1980071483 | 0.1765190079 | 1.3745261562 | 1.494326871 | 1.3745261562 | 12.2974164361 | 0.8715782838 | 0.7889268178 | yes | 15.9049074845 | -0.9982130605 | -6% |
| 75 | 21.561094137 | 1.6370420298 | 0.1244042174 | 1.7614462472 | 1.9251504501 | 1.7614462472 | 12.2405632143 | 0.9293738213 | 0.7889268178 | yes | 19.3748467556 | -2.1862473815 | -10% |
Permanent earnings > median
4.4120360551431599 4.8209028761470716 4.117287917737789 4.1836081066890687 4.3500122639195489 3.5956730278599855 3. 356986899563319 3.3230149101866706 3.5345522016563335 3.622982834823723 4.0155545864224456 3.2923719958202717 3.4655383638096104 3.5466721194151929 2.8022516681951868 3.0411400737230121 2.6580956619988361 2.8672412397831186 3.0280172413793105 2.8207334700326063 2.7838634223396821 2.7988733885297341 2.2120949622370807 1.9547309833024118 1.7614462471715373 2.3466238182429655 2.2910398177590054 1.8645089115456002 2.1668716983862799 2.3199934201250176 2.1790544109878498 2.1083485706640506 1.7056046605062274 1.7966388586627977 2.0333675793987585 1.8213826070968926 1.8043546232341319 2.0653706164423133 1.6817331067271906 1.7467060673426231 1.7640956898329554 1.3745261561789235 1.7314319912499743 1.7453181076672104 1.5019334880123743 1.7101859718682149 1.3428147018086 196 1.2477431864698914 1.134831708988044 1.0871240214256284 45.187831750158757 45.090705923786437 38.308659958746105 35.737010463687888 35.515952907931954 33.761749418259619 33.341839662646997 33.273186665445522 32.776282608713046 32.171418917834458 32.132747816201849 31.385112031888138 30.109325621256751 29.485246933794173 28.595755044168893 28.204702887318991 27.815269172764197 27.342614625411315 26.502842989608716 26.244613275127165 25.365078216197347 24.349522106707727 23.843352588437117 21.974910093215172 21.561094137031326 21.518034347346383 21.15615162441269 20.903299050558658 20.608587015526034 19.992936657140966 19.763589582513436 19.475830381655534 19.160621193412371 19.040867684899467 18.973304676372141 18.965886267340579 18.930716101003043 18.325566313355168 17.826436288278003 17.182172843272099 16.992492363616741 16.903120544912255 16.785650391584905 16.773597545821705 15.944499817985674 15.664344829307534 14.62832670856597 14.428139069728218 13.429417216082477 12.397075486543283
EPS
Stock Price
Higher TOP 10
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | 8.0542x + 3.8693 | |||
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | y= projected stock price | projected returns | Projected ROI | ||||||
| 67 | 35.5159529079 | 3.5212165808 | 0.8287956831 | 4.3500122639 | 4.702133922 | 4.3500122639 | 8.1645638571 | 0.8094727939 | 0.7889268178 | yes | 41.7412270346 | 6.2252741267 | 18% |
| 20 | 32.1327478162 | 3.2479042496 | 0.7676503368 | 4.0155545864 | 4.3403450114 | 4.0155545864 | 8.0020697327 | 0.8088308052 | 0.7889268178 | yes | 38.8273067907 | 6.6945589745 | 21% |
| 71 | 29.4852469338 | 2.9128923423 | 0.6337797771 | 3.5466721194 | 3.8379613536 | 3.5466721194 | 8.3134966924 | 0.8213029692 | 0.7889268178 | yes | 34.7810083345 | 5.2957614007 | 18% |
| 73 | 26.5028429896 | 2.3990917488 | 0.6289254926 | 3.0280172414 | 3.2679264163 | 3.0280172414 | 8.7525403183 | 0.7922979156 | 0.7889268178 | yes | 30.1898329418 | 3.6869899522 | 14% |
| 32 | 24.3495221067 | 2.3150731541 | 0.4838002344 | 2.7988733885 | 3.0303807039 | 2.7988733885 | 8.6997583408 | 0.8271446517 | 0.7889268178 | yes | 28.2765922657 | 3.927070159 | 16% |
| 2 | 19.9929366571 | 1.8582036941 | 0.461789726 | 2.3199934201 | 2.5058137895 | 2.3199934201 | 8.6176695519 | 0.8009521398 | 0.7889268178 | yes | 24.0516254237 | 4.0586887666 | 20% |
| 77 | 19.7635895825 | 1.7969360803 | 0.3821183307 | 2.179054411 | 2.358748019 | 2.179054411 | 9.0698008654 | 0.8246402987 | 0.7889268178 | yes | 22.8671282948 | 3.1035387123 | 16% |
| 14 | 19.4758303817 | 1.7539579896 | 0.3543905811 | 2.1083485707 | 2.2837443696 | 2.1083485707 | 9.2374812461 | 0.8319108206 | 0.7889268178 | yes | 22.2630339018 | 2.7872035201 | 14% |
| 96 | 18.3255663134 | 1.660436767 | 0.4049338494 | 2.0653706164 | 2.2314142931 | 2.0653706164 | 8.8727738099 | 0.8039413139 | 0.7889268178 | yes | 21.8415569998 | 3.5159906865 | 19% |
| 39 | 15.6643448293 | 1.3609695082 | 0.3492164637 | 1.7101859719 | 1.8462829227 | 1.7101859719 | 9.1594394335 | 0.7958020534 | 0.7889268178 | yes | 18.7396319159 | 3.0752870866 | 20% |
Lower than median
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | = 6.6138x + 3.7352 | |||
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | y= projected stock price | projected returns | Projected ROI | ||||||
| 90 | 17.4488716824 | 1.6452180872 | 0.8766306523 | 2.5218487395 | 2.456040016 | 2.5218487395 | 6.9190794076 | 0.6523857127 | 0.7889268178 | no | 19.9789574579 | 2.5300857755 | 14% |
| 54 | 12.8649438924 | 1.064529635 | 0.633599372 | 1.6981290069 | 1.6236119325 | 1.6981290069 | 7.5759520271 | 0.6268838413 | 0.7589934744 | no | 14.4734445991 | 1.6085007067 | 13% |
| 50 | 15.4847138722 | 1.4422788606 | 0.5920083437 | 2.0342872042 | 2.0487099928 | 2.0342872042 | 7.6118621992 | 0.7089848757 | 0.7889268178 | no | 17.2849581506 | 1.8002442783 | 12% |
| 56 | 19.4234674356 | 1.7360973103 | 0.8321055337 | 2.5682028439 | 2.6029247901 | 2.5682028439 | 7.5630581446 | 0.6759969581 | 0.7889268178 | no | 20.950423977 | 1.5269565413 | 8% |
| 80 | 24.6686299114 | 2.5164226572 | 1.1410868016 | 3.6575094588 | 3.4310314196 | 3.6575094588 | 6.7446523896 | 0.6880153519 | 0.7889268178 | no | 26.4273556032 | 1.7587256918 | 7% |
| 52 | 19.5338876676 | 1.8512449457 | 0.8201745052 | 2.6714194509 | 2.5973696531 | 2.6714194509 | 7.3121754282 | 0.6929817573 | 0.7889268178 | no | 20.9136834118 | 1.3797957441 | 7% |
| 48 | 13.5217125396 | 1.2029669413 | 0.5102461153 | 1.7132130566 | 1.6169757013 | 1.7132130566 | 7.8926041845 | 0.7021700755 | 0.7889268178 | no | 14.4295538934 | 0.9078413538 | 7% |
| 93 | 43.5117438586 | 4.7530327166 | 1.5092513172 | 6.2622840338 | 6.4048750153 | 6.2622840338 | 6.948222665 | 0.7589934744 | 0.7889268178 | no | 46.0957623763 | 2.5840185177 | 6% |
| 84 | 39.0944408386 | 4.0652073581 | 1.4700995583 | 5.5353069163 | 5.6572631371 | 5.5353069163 | 7.0627413131 | 0.7344140839 | 0.7889268178 | no | 41.151206936 | 2.0567660974 | 5% |
| 79 | 18.0659509551 | 1.6957203597 | 0.5460374991 | 2.2417578588 | 2.3095866732 | 2.2417578588 | 8.05883244 | 0.7564244073 | 0.7889268178 | no | 19.010344339 | 0.944393384 | 5% |
| 22 | 25.4923933382 | 2.5640112263 | 0.7706174439 | 3.3346286701 | 3.4628292314 | 3.3346286701 | 7.6447472448 | 0.7689045708 | 0.7889268178 | no | 26.6376599709 | 1.1452666326 | 4% |
| 88 | 24.1934832955 | 2.2874397082 | 0.9449433356 | 3.2323830438 | 3.2552574409 | 3.2323830438 | 7.484720396 | 0.707663565 | 0.7889268178 | no | 25.2648216625 | 1.071338367 | 4% |
| 10 | 18.2951804739 | 1.6904878847 | 0.742018664 | 2.4325065488 | 2.3141723969 | 2.4325065488 | 7.5211228036 | 0.6949571772 | 0.7889268178 | no | 19.0406733983 | 0.7454929244 | 4% |
| 44 | 17.5754111464 | 1.5775379402 | 0.6436569913 | 2.2211949315 | 2.1896441727 | 2.2211949315 | 7.9125928559 | 0.7102203944 | 0.7889268178 | no | 18.2170686293 | 0.6416574829 | 4% |
| 82 | 18.8831321592 | 1.7845191893 | 0.5546787408 | 2.3391979301 | 2.3927335058 | 2.3391979301 | 8.0724815612 | 0.7628765255 | 0.7889268178 | no | 19.5602608608 | 0.6771287016 | 4% |
| 28 | 15.2468587331 | 1.2817067557 | 0.5145874094 | 1.796294165 | 1.8219283001 | 1.796294165 | 8.4879520458 | 0.7135283188 | 0.7889268178 | no | 15.7850693915 | 0.5382106585 | 4% |
| 60 | 30.2615260785 | 3.1288708512 | 0.9321176405 | 4.0609884917 | 4.1548546172 | 4.0609884917 | 7.4517635646 | 0.7704702581 | 0.7889268178 | no | 31.2145774674 | 0.9530513889 | 3% |
| 98 | 32.2048296757 | 3.337340186 | 0.9481374506 | 4.2854776367 | 4.4189712441 | 4.2854776367 | 7.5148752149 | 0.7787557115 | 0.7889268178 | no | 32.9613920143 | 0.7565623385 | 2% |
| 63 | 14.1267759917 | 1.2394714442 | 0.4386526691 | 1.6781241133 | 1.6161505411 | 1.6781241133 | 8.418194983 | 0.7386053477 | 0.7889268178 | no | 14.4240964489 | 0.2973204572 | 2% |
| 6 | 20.1045520364 | 1.7903381643 | 0.7787439614 | 2.5690821256 | 2.497468599 | 2.5690821256 | 7.8255777953 | 0.6968785258 | 0.7889268178 | no | 20.2529578203 | 0.1484057839 | 1% |
| 65 | 22.1462931992 | 2.0668295184 | 0.6650381495 | 2.7318676679 | 2.7938725535 | 2.7318676679 | 8.1066493298 | 0.7565628243 | 0.7889268178 | no | 22.213314294 | 0.0670210948 | 0% |
| 34 | 38.1380085248 | 4.0982133189 | 1.2840822956 | 5.3822956145 | 5.2183670818 | 5.3822956145 | 7.0858256878 | 0.761424792 | 0.7889268178 | no | 38.2484362053 | 0.1104276805 | 0% |
| 24 | 26.4814162464 | 2.5911212856 | 0.837328306 | 3.4284495915 | 3.4284495915 | 3.4284495915 | 7.7240208845 | 0.7557705652 | 0.7889268178 | no | 26.4102799084 | -0.0711363379 | -0% |
| 1 | 32.0428669757 | 3.1965317919 | 0.9015370468 | 4.0980688387 | 4.2578954283 | 4.0980688387 | 7.8190162823 | 0.7800092965 | 0.7889268178 | no | 31.8960687835 | -0.1467981922 | -0% |
| 86 | 23.1689674538 | 2.2966621031 | 0.7103135798 | 3.0069756829 | 2.9151091988 | 3.0069756829 | 7.7050731024 | 0.7637780765 | 0.7889268178 | no | 23.0151492189 | -0.1538182349 | -1% |
| 51 | 20.9095264484 | 2.0442079765 | 0.6700694985 | 2.714277475 | 2.5711829166 | 2.714277475 | 7.7035331285 | 0.7531315406 | 0.7889268178 | no | 20.740489574 | -0.1690368744 | -1% |
| 69 | 25.4954040325 | 2.438362954 | 0.71932309 | 3.157686044 | 3.2552205622 | 3.157686044 | 8.0740781943 | 0.7721993004 | 0.7889268178 | no | 25.2645777543 | -0.2308262782 | -1% |
| 85 | 20.0535890811 | 1.8071336346 | 0.5661717237 | 2.3733053583 | 2.4275193673 | 2.3733053583 | 8.4496455591 | 0.7614416865 | 0.7889268178 | no | 19.7903275917 | -0.2632614894 | -1% |
| 81 | 13.7036693822 | 1.1398060885 | 0.3073202703 | 1.4471263588 | 1.4699224806 | 1.4471263588 | 9.4695734747 | 0.7876341147 | 0.7889268178 | no | 13.4569733023 | -0.2466960799 | -2% |
| 87 | 18.7006656156 | 1.6621393697 | 0.5570942447 | 2.2192336144 | 2.185990827 | 2.2192336144 | 8.4266322815 | 0.7489699863 | 0.7889268178 | no | 18.1929061319 | -0.5077594837 | -3% |
| 9 | 16.2248198788 | 1.3961752267 | 0.5430752454 | 1.9392504721 | 1.7996329494 | 1.9392504721 | 8.3665416676 | 0.7199561103 | 0.7889268178 | no | 15.637612401 | -0.5872074778 | -4% |
| 31 | 38.0023282738 | 3.8768768769 | 1.046046046 | 4.9229229229 | 4.9616916917 | 4.9229229229 | 7.7194644053 | 0.7875152501 | 0.7889268178 | no | 36.5508365105 | -1.4514917633 | -4% |
| 19 | 32.8838979302 | 3.3135375494 | 1.2225790514 | 4.5361166008 | 4.2047628458 | 4.5361166008 | 7.2493502315 | 0.7304789186 | 0.7889268178 | no | 31.5446605099 | -1.3392374203 | -4% |
| 38 | 17.0872414628 | 1.566189792 | 0.4806959455 | 2.0468857375 | 1.9059286562 | 2.0468857375 | 8.3479215033 | 0.7651574112 | 0.7889268178 | no | 16.3406309465 | -0.7466105164 | -4% |
| 91 | 21.9169483259 | 2.046891261 | 0.6746751509 | 2.7215664119 | 2.5987529363 | 2.7215664119 | 8.0530639377 | 0.7521004272 | 0.7889268178 | no | 20.92283217 | -0.994116156 | -5% |
| 74 | 16.1246526708 | 1.319777732 | 0.3818481169 | 1.7016258489 | 1.7544169582 | 1.7016258489 | 9.4760271072 | 0.7755980746 | 0.7889268178 | no | 15.3385628783 | -0.7860897925 | -5% |
| 7 | 15.7656377786 | 1.2188594559 | 0.4834203737 | 1.7022798297 | 1.6900912351 | 1.7022798297 | 9.2614842188 | 0.7160159186 | 0.7889268178 | no | 14.9131254109 | -0.8525123677 | -5% |
| 61 | 17.5471501025 | 1.5219110762 | 0.509494315 | 2.0314053913 | 1.9400907267 | 2.0314053913 | 8.6379361687 | 0.7491912165 | 0.7889268178 | no | 16.5665720482 | -0.9805780543 | -6% |
| 36 | 39.5186407574 | 4.1047607163 | 1.2069632495 | 5.3117239658 | 5.0243907157 | 5.3117239658 | 7.439889763 | 0.7727737252 | 0.7889268178 | no | 36.9655153153 | -2.5531254421 | -6% |
| 70 | 22.5508224942 | 2.2011266614 | 0.6375319074 | 2.8386585688 | 2.6185459026 | 2.8386585688 | 7.9441827707 | 0.7754108527 | 0.7889268178 | no | 21.0537388909 | -1.4970836033 | -7% |
| 89 | 12.8488485268 | 0.9315722256 | 0.270372611 | 1.2019448365 | 1.2392077256 | 1.2019448365 | 10.6900484415 | 0.7750540601 | 0.7889268178 | no | 11.9310720554 | -0.9177764714 | -7% |
| 45 | 28.4030823374 | 2.6389516958 | 0.7262076053 | 3.3651593011 | 3.417938335 | 3.3651593011 | 8.4403381224 | 0.7841981492 | 0.7889268178 | no | 26.3407605603 | -2.0623217771 | -7% |
| 18 | 22.4555261805 | 1.974841609 | 0.6175040519 | 2.5923456608 | 2.5725972447 | 2.5923456608 | 8.6622422773 | 0.7617971781 | 0.7889268178 | no | 20.7498436572 | -1.7056825233 | -8% |
| 64 | 45.5201412487 | 4.6486686847 | 1.2663248286 | 5.9149935133 | 5.7290467659 | 5.9149935133 | 7.6957212457 | 0.7859127274 | 0.7889268178 | no | 41.6259695005 | -3.8941717482 | -9% |
| 99 | 30.7334787233 | 3.0311551872 | 0.8339446633 | 3.8650998506 | 3.6226074356 | 3.8650998506 | 7.9515355131 | 0.7842372266 | 0.7889268178 | no | 27.6944010575 | -3.0390776659 | -10% |
| 5 | 23.3001521692 | 2.0581456116 | 0.607008279 | 2.6651538906 | 2.5416651539 | 2.6651538906 | 8.7425166147 | 0.7722426907 | 0.7889268178 | no | 20.5452649948 | -2.7548871743 | -12% |
| 49 | 14.5414780053 | 1.0481779958 | 0.3768395235 | 1.4250175193 | 1.3411632796 | 1.4250175193 | 10.2044205132 | 0.7355544627 | 0.7889268178 | no | 12.6053856987 | -1.9360923067 | -13% |
| 47 | 22.7037822551 | 1.9664788144 | 0.5389271551 | 2.5054059695 | 2.4070820288 | 2.5054059695 | 9.061917522 | 0.78489428 | 0.7889268178 | no | 19.6551591221 | -3.048623133 | -13% |
| 26 | 21.3121409817 | 1.8083403538 | 0.5068600313 | 2.3152003851 | 2.2066999639 | 2.3152003851 | 9.2053116087 | 0.7810729324 | 0.7889268178 | no | 18.3298722212 | -2.9822687605 | -14% |
| 58 | 18.9083290525 | 1.5438292964 | 0.47189892 | 2.0157282164 | 1.8767835797 | 2.0157282164 | 9.3803960764 | 0.7658915938 | 0.7889268178 | no | 16.1478712397 | -2.7604578128 | -15% |
Permanent earnings < Median
1.6981290069344497 2.5218487394957982 2.5682028439266746 3.6575094587925649 2.6714194509470102 2.4325065487884743 2.569082125603865 1.7132130566273855 3.2323830438022041 2.034287204223975 2.2211949314866657 1.7962941650362527 1.7022798296944148 1.9392504721121364 4.536116600790514 5.5353069163315087 1.4250175192711985 1.678124113331442 2.219233614440006 2.0314053912588328 2.7215664119413638 2.7142774749834184 3.4284495915252715 2.2417578587858089 2.7318676679031335 6.2622840338193848 5.3822956145100154 2.3733053582956747 2.59234566082216 2.3391979301423027 3.0069756828997978 2.0468857374898484 2.0157282164202579 3.3346286701208983 4.060988491688442 3.1576860440416343 2.6651538905850316 5.3117239658077002 1.2019448365485874 2.8386585687879586 1.701625848940111 4.285477636664826 4.0980688386757755 2.3152003851245637 3.3651593011305243 3.8650998505637824 2.505405969526195 5.9149935133131519 4.9229229229229237 1.4471263588491874 12.864943892378065 17.448871682406164 19.423467435629771 24.66862991139125 19.533887667640556 18.295180473882105 20.104552036379957 13.521712539611666 24.193483295482785 15.48471387223589 17.575411146430191 15.246858733066912 15.765637778644008 16.224819878796975 32.88389793015665 39.094440838563301 14.541478005323928 14.126775991673135 18.700665615621435 17.547150102471345 21.91694832594591 20.909526448401909 26.481416246355465 18.0659509550511 22.146293199228889 43.511743858563165 38.138008524785974 20.053589081064683 22.455526180549693 18.883132159173236 23.168967453762527 17.087241462824927 18.908329052472375 25.492393338220829 30.261526078476152 25.495404032547818 23.30015216915038 39.518640757354483 12.848848526750913 22.550822494198499 16.12465267078629 32.204829675735937 32.042866975679445 21.312140981738935 28.403082337424987 30.733478723341307 22.703782255084779 45.520141248702501 38.00232827378008 13.703669382234308
EPS
Stock Pice
Lower TOP 10
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings | Earnings per share | Price to earning ratio | Permanent Earnings Ratio | 0.8450930805 | = 6.6138x + 3.7352 | |||
| Total earnings / # of outstanding shares | Stock price / EPS | Permanent earnings / total earnings | PERMANENT EARNING RATIO MEDIAN | HIGHER OR NO????? | y= projected stock price | projected returns | Projected ROI | ||||||
| 54 | 12.8649438924 | 1.064529635 | 0.633599372 | 1.6981290069 | 1.6236119325 | 1.6981290069 | 7.5759520271 | 0.6268838413 | 0.7577781493 | no | 14.4734445991 | 1.6085007067 | 13% |
| 90 | 17.4488716824 | 1.6452180872 | 0.8766306523 | 2.5218487395 | 2.456040016 | 2.5218487395 | 6.9190794076 | 0.6523857127 | 0.7889268178 | no | 19.9789574579 | 2.5300857755 | 14% |
| 56 | 19.4234674356 | 1.7360973103 | 0.8321055337 | 2.5682028439 | 2.6029247901 | 2.5682028439 | 7.5630581446 | 0.6759969581 | 0.7889268178 | no | 20.950423977 | 1.5269565413 | 8% |
| 80 | 24.6686299114 | 2.5164226572 | 1.1410868016 | 3.6575094588 | 3.4310314196 | 3.6575094588 | 6.7446523896 | 0.6880153519 | 0.7889268178 | no | 26.4273556032 | 1.7587256918 | 7% |
| 52 | 19.5338876676 | 1.8512449457 | 0.8201745052 | 2.6714194509 | 2.5973696531 | 2.6714194509 | 7.3121754282 | 0.6929817573 | 0.7889268178 | no | 20.9136834118 | 1.3797957441 | 7% |
| 48 | 13.5217125396 | 1.2029669413 | 0.5102461153 | 1.7132130566 | 1.6169757013 | 1.7132130566 | 7.8926041845 | 0.7021700755 | 0.7889268178 | no | 14.4295538934 | 0.9078413538 | 7% |
| 50 | 15.4847138722 | 1.4422788606 | 0.5920083437 | 2.0342872042 | 2.0487099928 | 2.0342872042 | 7.6118621992 | 0.7089848757 | 0.7889268178 | no | 17.2849581506 | 1.8002442783 | 12% |
| 84 | 39.0944408386 | 4.0652073581 | 1.4700995583 | 5.5353069163 | 5.6572631371 | 5.5353069163 | 7.0627413131 | 0.7344140839 | 0.7889268178 | no | 41.151206936 | 2.0567660974 | 5% |
| 79 | 18.0659509551 | 1.6957203597 | 0.5460374991 | 2.2417578588 | 2.3095866732 | 2.2417578588 | 8.05883244 | 0.7564244073 | 0.7889268178 | no | 19.010344339 | 0.944393384 | 5% |
| 93 | 43.5117438586 | 4.7530327166 | 1.5092513172 | 6.2622840338 | 6.4048750153 | 6.2622840338 | 6.948222665 | 0.7589934744 | 0.7889268178 | no | 46.0957623763 | 2.5840185177 | 6% |
MEDIAN PERMANENT EARNINGS RATIO
| Median (Permanent Earnings Ratio) | 0.8450930805 |