Accounting Paper/Excel relating
lkjfad
AppendixA-DataDistribution1.xlsxSheet1
| Firm ID number | Stock price | Permanent Earnings per share | Transitory Earnings per share | Earnings per share | Projected Earnings |
| 1 | 32.0428669757 | 3.1965317919 | 0.9015370468 | 4.0980688387 | 4.2578954283 |
| 2 | 19.9929366571 | 1.8582036941 | 0.461789726 | 2.3199934201 | 2.5058137895 |
| 3 | 18.930716101 | 1.4795201956 | 0.3248344277 | 1.8043546232 | 1.9523066428 |
| 4 | 16.9924923636 | 1.4010723861 | 0.3630233038 | 1.7640956898 | 1.9042029284 |
| 5 | 23.3001521692 | 2.0581456116 | 0.607008279 | 2.6651538906 | 2.5416651539 |
| 6 | 20.1045520364 | 1.7903381643 | 0.7787439614 | 2.5690821256 | 2.497468599 |
| 7 | 15.7656377786 | 1.2188594559 | 0.4834203737 | 1.7022798297 | 1.6900912351 |
| 8 | 35.7370104637 | 3.5500367531 | 0.6335713536 | 4.1836081067 | 4.538611782 |
| 9 | 16.2248198788 | 1.3961752267 | 0.5430752454 | 1.9392504721 | 1.7996329494 |
| 10 | 18.2951804739 | 1.6904878847 | 0.742018664 | 2.4325065488 | 2.3141723969 |
| 11 | 15.944499818 | 1.3110740526 | 0.1908594354 | 1.501933488 | 1.6330408933 |
| 12 | 21.5180343473 | 1.9034415754 | 0.4431822428 | 2.3466238182 | 2.5369679758 |
| 13 | 17.1821728433 | 1.4775795695 | 0.2691264979 | 1.7467060673 | 1.8944640243 |
| 14 | 19.4758303817 | 1.7539579896 | 0.3543905811 | 2.1083485707 | 2.2837443696 |
| 15 | 38.3086599587 | 3.6310411311 | 0.4862467866 | 4.1172879177 | 4.4803920308 |
| 16 | 45.1878317502 | 4.113573701 | 0.2984623542 | 4.4120360551 | 4.8233934252 |
| 17 | 18.9733046764 | 1.6948452227 | 0.3385223567 | 2.0333675794 | 2.2028521017 |
| 18 | 22.4555261805 | 1.974841609 | 0.6175040519 | 2.5923456608 | 2.5725972447 |
| 19 | 32.8838979302 | 3.3135375494 | 1.2225790514 | 4.5361166008 | 4.2047628458 |
| 20 | 32.1327478162 | 3.2479042496 | 0.7676503368 | 4.0155545864 | 4.3403450114 |
| 21 | 28.5957550442 | 2.4664621612 | 0.335789507 | 2.8022516682 | 3.0488978843 |
| 22 | 25.4923933382 | 2.5640112263 | 0.7706174439 | 3.3346286701 | 3.4628292314 |
| 23 | 14.4281390697 | 1.0562749111 | 0.1914682753 | 1.2477431865 | 1.3533706776 |
| 24 | 26.4814162464 | 2.5911212856 | 0.837328306 | 3.4284495915 | 3.4284495915 |
| 25 | 27.8152691728 | 2.3643989455 | 0.2936967165 | 2.658095662 | 2.8945355565 |
| 26 | 21.3121409817 | 1.8083403538 | 0.5068600313 | 2.3152003851 | 2.2066999639 |
| 27 | 16.9031205449 | 1.1980071483 | 0.1765190079 | 1.3745261562 | 1.494326871 |
| 28 | 15.2468587331 | 1.2817067557 | 0.5145874094 | 1.796294165 | 1.8219283001 |
| 29 | 23.8433525884 | 2.0118296743 | 0.2002652879 | 2.2120949622 | 2.4132779297 |
| 30 | 27.3426146254 | 2.4725256939 | 0.3947155458 | 2.8672412398 | 3.1144938092 |
| 31 | 38.0023282738 | 3.8768768769 | 1.046046046 | 4.9229229229 | 4.9616916917 |
| 32 | 24.3495221067 | 2.3150731541 | 0.4838002344 | 2.7988733885 | 3.0303807039 |
| 33 | 19.0408676849 | 1.4845846935 | 0.3120541652 | 1.7966388587 | 1.945097328 |
| 34 | 38.1380085248 | 4.0982133189 | 1.2840822956 | 5.3822956145 | 5.2183670818 |
| 35 | 16.7856503916 | 1.4456115731 | 0.2858204181 | 1.7314319912 | 1.8759931486 |
| 36 | 39.5186407574 | 4.1047607163 | 1.2069632495 | 5.3117239658 | 5.0243907157 |
| 37 | 45.0907059238 | 4.3221038369 | 0.4987990392 | 4.8209028761 | 5.2531132598 |
| 38 | 17.0872414628 | 1.566189792 | 0.4806959455 | 2.0468857375 | 1.9059286562 |
| 39 | 15.6643448293 | 1.3609695082 | 0.3492164637 | 1.7101859719 | 1.8462829227 |
| 40 | 32.1714189178 | 3.0532428821 | 0.5697399527 | 3.6229828348 | 3.928307123 |
| 41 | 13.4294172161 | 0.9508497425 | 0.1839819665 | 1.134831709 | 1.2299166832 |
| 42 | 20.6085870155 | 1.7123043153 | 0.4545673831 | 2.1668716984 | 2.3381021299 |
| 43 | 12.3970754865 | 0.8638854553 | 0.2232385661 | 1.0871240214 | 1.173512567 |
| 44 | 17.5754111464 | 1.5775379402 | 0.6436569913 | 2.2211949315 | 2.1896441727 |
| 45 | 28.4030823374 | 2.6389516958 | 0.7262076053 | 3.3651593011 | 3.417938335 |
| 46 | 26.2446132751 | 2.3150021849 | 0.5057312851 | 2.82073347 | 3.0522336885 |
| 47 | 22.7037822551 | 1.9664788144 | 0.5389271551 | 2.5054059695 | 2.4070820288 |
| 48 | 13.5217125396 | 1.2029669413 | 0.5102461153 | 1.7132130566 | 1.6169757013 |
| 49 | 14.5414780053 | 1.0481779958 | 0.3768395235 | 1.4250175193 | 1.3411632796 |
| 50 | 15.4847138722 | 1.4422788606 | 0.5920083437 | 2.0342872042 | 2.0487099928 |
| 51 | 20.9095264484 | 2.0442079765 | 0.6700694985 | 2.714277475 | 2.5711829166 |
| 52 | 19.5338876676 | 1.8512449457 | 0.8201745052 | 2.6714194509 | 2.5973696531 |
| 53 | 25.3650782162 | 2.2419879097 | 0.5418755126 | 2.7838634223 | 3.0080622133 |
| 54 | 12.8649438924 | 1.064529635 | 0.633599372 | 1.6981290069 | 1.6236119325 |
| 55 | 14.6283267086 | 1.1688379469 | 0.1739767549 | 1.3428147018 | 1.4596984965 |
| 56 | 19.4234674356 | 1.7360973103 | 0.8321055337 | 2.5682028439 | 2.6029247901 |
| 57 | 16.7735975458 | 1.3796846112 | 0.3656334965 | 1.7453181077 | 1.8832865688 |
| 58 | 18.9083290525 | 1.5438292964 | 0.47189892 | 2.0157282164 | 1.8767835797 |
| 59 | 30.1093256213 | 2.7911429738 | 0.67439539 | 3.4655383638 | 3.7446526612 |
| 60 | 30.2615260785 | 3.1288708512 | 0.9321176405 | 4.0609884917 | 4.1548546172 |
| 61 | 17.5471501025 | 1.5219110762 | 0.509494315 | 2.0314053913 | 1.9400907267 |
| 62 | 32.7762826087 | 3.0634475268 | 0.4711046748 | 3.5345522017 | 3.8408969543 |
| 63 | 14.1267759917 | 1.2394714442 | 0.4386526691 | 1.6781241133 | 1.6161505411 |
| 64 | 45.5201412487 | 4.6486686847 | 1.2663248286 | 5.9149935133 | 5.7290467659 |
| 65 | 22.1462931992 | 2.0668295184 | 0.6650381495 | 2.7318676679 | 2.7938725535 |
| 66 | 21.9749100932 | 1.7343599258 | 0.2203710575 | 1.9547309833 | 2.1281669759 |
| 67 | 35.5159529079 | 3.5212165808 | 0.8287956831 | 4.3500122639 | 4.702133922 |
| 68 | 17.8264362883 | 1.4316631887 | 0.250069918 | 1.6817331067 | 1.8248994256 |
| 69 | 25.4954040325 | 2.438362954 | 0.71932309 | 3.157686044 | 3.2552205622 |
| 70 | 22.5508224942 | 2.2011266614 | 0.6375319074 | 2.8386585688 | 2.6185459026 |
| 71 | 29.4852469338 | 2.9128923423 | 0.6337797771 | 3.5466721194 | 3.8379613536 |
| 72 | 33.3418396626 | 2.9724994801 | 0.3844874194 | 3.3569868996 | 3.6542368476 |
| 73 | 26.5028429896 | 2.3990917488 | 0.6289254926 | 3.0280172414 | 3.2679264163 |
| 74 | 16.1246526708 | 1.319777732 | 0.3818481169 | 1.7016258489 | 1.7544169582 |
| 75 | 21.561094137 | 1.6370420298 | 0.1244042174 | 1.7614462472 | 1.9251504501 |
| 76 | 33.7617494183 | 3.1496581284 | 0.4460148995 | 3.5956730279 | 3.9106388407 |
| 77 | 19.7635895825 | 1.7969360803 | 0.3821183307 | 2.179054411 | 2.358748019 |
| 78 | 33.2731866654 | 3.0831213556 | 0.2398935546 | 3.3230149102 | 3.6313270457 |
| 79 | 18.0659509551 | 1.6957203597 | 0.5460374991 | 2.2417578588 | 2.3095866732 |
| 80 | 24.6686299114 | 2.5164226572 | 1.1410868016 | 3.6575094588 | 3.4310314196 |
| 81 | 13.7036693822 | 1.1398060885 | 0.3073202703 | 1.4471263588 | 1.4699224806 |
| 82 | 18.8831321592 | 1.7845191893 | 0.5546787408 | 2.3391979301 | 2.3927335058 |
| 83 | 28.2047028873 | 2.5218865192 | 0.5192535545 | 3.0411400737 | 3.2933287256 |
| 84 | 39.0944408386 | 4.0652073581 | 1.4700995583 | 5.5353069163 | 5.6572631371 |
| 85 | 20.0535890811 | 1.8071336346 | 0.5661717237 | 2.3733053583 | 2.4275193673 |
| 86 | 23.1689674538 | 2.2966621031 | 0.7103135798 | 3.0069756829 | 2.9151091988 |
| 87 | 18.7006656156 | 1.6621393697 | 0.5570942447 | 2.2192336144 | 2.185990827 |
| 88 | 24.1934832955 | 2.2874397082 | 0.9449433356 | 3.2323830438 | 3.2552574409 |
| 89 | 12.8488485268 | 0.9315722256 | 0.270372611 | 1.2019448365 | 1.2392077256 |
| 90 | 17.4488716824 | 1.6452180872 | 0.8766306523 | 2.5218487395 | 2.456040016 |
| 91 | 21.9169483259 | 2.046891261 | 0.6746751509 | 2.7215664119 | 2.5987529363 |
| 92 | 19.1606211934 | 1.4621534753 | 0.2434511852 | 1.7056046605 | 1.851820008 |
| 93 | 43.5117438586 | 4.7530327166 | 1.5092513172 | 6.2622840338 | 6.4048750153 |
| 94 | 21.1561516244 | 1.8604005505 | 0.4306392672 | 2.2910398178 | 2.4770798728 |
| 95 | 31.3851120319 | 2.9520898642 | 0.3402821317 | 3.2923719958 | 3.5875809822 |
| 96 | 18.3255663134 | 1.660436767 | 0.4049338494 | 2.0653706164 | 2.2314142931 |
| 97 | 18.9658862673 | 1.5555249127 | 0.2658576944 | 1.8213826071 | 1.9769350984 |
| 98 | 32.2048296757 | 3.337340186 | 0.9481374506 | 4.2854776367 | 4.4189712441 |
| 99 | 30.7334787233 | 3.0311551872 | 0.8339446633 | 3.8650998506 | 3.6226074356 |
| 100 | 20.9032990506 | 1.6970328748 | 0.1674760367 | 1.8645089115 | 2.034212199 |
