financial modelling 3000 words paper

profilelinjy581
CG1.xls

Sheet1

MBV Identity Con Size ROCE Industry
1.94 3 39.1 217307 43.4 2
2.22 3 36.3 190638 41.8 1
1.99 3 32.8 260402 32.4 1
2.10 3 32.3 291598 44.3 1
1.74 3 38.3 196831 36.7 3
1.77 3 30.6 158168 43.9 1
1.87 3 44.4 261499 48.7 3
2.01 3 30.8 123445 40.8 1
1.54 3 38.1 192514 40.7 3
1.65 3 36.0 103027 41.6 2
1.46 3 27.2 231968 23.2 2
1.80 3 36.4 221142 43.9 2
1.35 3 31.9 239584 33.3 3
1.85 3 32.1 203439 36.6 1
2.88 3 54.8 187445 49.4 1
2.61 3 47.9 226852 37.3 1
1.43 3 33.1 220021 34.3 2
2.46 3 44.2 274063 53.2 1
1.98 3 30.9 246573 39.6 1
2.48 3 41.8 163499 33.4 1
1.71 3 35.6 309195 38.5 2
2.10 3 34.7 299959 51.5 1
1.62 3 36.1 293866 43.9 2
2.11 3 37.1 76049 41.4 1
1.31 3 23.8 216060 31.3 2
2.11 3 32.3 128911 48.8 1
2.50 3 44.9 221061 53.1 1
1.61 3 24.0 280352 27.5 1
2.16 3 36.3 279874 35.3 1
2.34 3 43.8 198253 49.3 1
1.63 3 28.0 162329 25.6 1
2.38 3 43.0 337687 44.8 1
1.61 3 36.5 251322 46.2 2
2.45 3 37.9 203682 34.7 1
2.11 3 32.2 156086 24.8 1
1.79 3 41.6 281260 36.7 2
1.20 3 27.9 204013 30.0 3
2.01 3 35.4 148854 35.7 1
1.84 3 27.9 87925 26.7 1
2.32 3 50.4 157738 48.2 2
1.98 3 32.2 164833 41.0 1
2.70 3 50.5 97223 52.0 1
1.97 3 39.6 229580 42.7 2
1.85 3 39.0 219070 44.1 3
2.01 3 34.6 198708 42.6 1
2.60 3 47.7 190257 37.4 1
1.56 3 29.6 130041 31.0 2
2.03 3 44.0 236385 42.6 2
2.76 3 51.1 241670 43.9 1
1.62 3 37.9 134803 46.1 3
1.67 3 30.5 238563 41.4 1
1.93 3 32.0 213756 35.4 1
1.72 3 24.4 74763 27.1 1
2.18 3 41.0 246073 40.6 1
1.62 3 30.6 153842 34.1 2
2.12 3 45.8 253168 40.3 2
1.69 3 33.1 131956 39.0 2
2.10 3 40.2 271448 40.3 2
2.17 3 34.9 107692 39.0 1
2.25 3 37.5 184301 43.4 1
1.49 3 30.3 85707 36.8 3
1.83 3 30.7 202670 35.6 1
1.87 3 40.8 262426 44.9 2
2.30 3 39.0 110769 46.5 1
2.27 3 42.3 339326 39.9 1
2.13 3 32.8 230202 41.0 1
1.69 3 36.0 308326 42.3 3
2.31 3 51.5 316742 47.4 2
2.23 3 39.4 89640 37.8 1
1.77 3 36.7 201251 35.2 2
1.33 3 28.1 187391 34.0 3
2.98 3 57.3 282693 39.4 1
1.45 3 31.0 158096 35.9 3
1.66 3 33.7 201353 43.7 3
2.01 3 45.2 99490 52.3 3
1.73 3 35.5 186886 34.6 2
1.77 3 30.7 161482 30.9 1
2.46 3 49.9 218114 44.5 2
1.77 3 32.6 262136 41.9 1
2.02 3 33.1 145727 42.3 1
1.73 3 39.7 316776 38.1 2
2.05 3 34.1 217910 42.4 1
1.61 3 37.0 208566 33.4 2
2.11 3 37.6 337780 41.2 1
1.95 3 31.1 203761 39.7 1
2.41 3 38.4 276823 34.8 1
2.04 3 45.3 189151 43.7 2
2.24 3 35.5 280739 38.4 1
1.73 3 29.8 184333 29.9 1
1.85 3 41.0 83311 37.1 2
2.73 3 52.2 130745 53.5 1
2.37 3 38.8 250768 28.0 1
2.26 3 36.2 226342 45.5 1
2.08 3 36.8 282456 52.5 1
2.31 3 37.4 86174 35.7 1
1.58 3 34.5 255740 37.7 2
2.54 3 45.2 206842 50.7 1
1.67 3 34.4 176986 40.7 3
2.44 3 46.0 366872 37.8 1
2.40 3 42.3 286951 36.0 1
1.75 3 42.9 182495 34.4 3
1.50 3 35.0 282264 26.5 3
1.53 3 32.0 212525 33.8 3
1.87 3 40.2 228780 42.9 3
2.21 3 47.9 158769 38.0 2
2.20 3 38.0 192740 37.0 1
2.32 3 55.1 220281 51.1 2
2.03 3 43.6 214201 38.8 2
2.28 3 46.8 199237 46.8 2
1.48 3 34.1 220563 41.4 3
1.89 3 34.2 250179 40.0 1
1.73 3 30.0 347927 37.7 1
2.10 3 34.0 287162 34.3 1
2.04 3 45.3 270357 39.3 2
1.45 3 27.2 137918 28.9 2
1.71 3 38.7 190635 42.3 3
2.34 3 44.6 119968 47.1 1
1.92 3 36.1 274044 36.5 2
1.48 4 25.7 211510 34.4 1
1.97 4 46.3 219102 37.1 3
1.64 4 36.4 129955 43.7 2
2.01 4 34.1 144725 41.9 1
1.32 4 25.5 201407 28.5 2
2.07 4 40.9 180870 31.6 1
1.79 4 36.3 337183 47.6 2
1.62 4 41.4 259519 40.0 3
2.24 4 51.8 208039 50.5 3
1.85 4 32.8 169278 43.5 1
2.09 4 47.2 248731 45.5 3
1.56 4 32.6 259227 44.3 2
2.09 4 33.8 93762 34.5 1
1.60 4 38.5 125476 54.2 3
2.40 4 44.3 66751 44.2 1
1.33 4 26.0 202046 30.3 2
2.03 4 36.4 155173 38.5 1
1.31 4 27.7 282914 34.3 2
1.95 4 28.1 223490 31.6 1
1.55 4 34.7 175080 33.5 2
1.97 4 32.8 233597 42.1 1
1.64 4 36.7 298497 37.1 2
2.50 4 46.8 161665 39.7 1
1.73 4 34.4 224496 42.6 2
2.14 4 45.1 280462 47.5 2
1.95 4 32.1 188799 44.3 1
1.21 4 25.2 147424 26.6 2
1.76 4 33.5 148260 40.7 2
1.65 4 34.8 254238 43.2 2
2.13 4 49.1 222223 43.9 3
1.41 4 29.6 143361 30.3 2
1.53 4 33.6 157922 42.0 2
1.95 4 35.0 258945 38.4 1
1.62 4 40.4 247994 45.9 3
1.53 4 33.2 97684 53.0 2
1.85 4 41.8 170106 45.2 3
1.99 4 35.7 227588 33.2 1
2.12 4 47.1 161821 49.2 2
2.06 4 42.7 335155 51.2 2
1.68 4 34.1 289538 41.0 2
2.03 4 35.3 68296 41.4 1
2.17 4 48.4 177602 40.1 3
2.06 4 33.2 129457 28.7 1
2.20 4 39.0 189744 38.2 1
1.69 4 31.8 105044 44.6 2
1.87 4 43.0 169239 44.9 2
2.41 4 40.7 272397 34.1 1
2.17 4 34.5 141898 28.3 1
2.71 4 48.7 335563 46.8 1
1.50 4 30.3 205811 31.4 2
1.90 4 31.9 129379 36.2 1
1.70 4 37.7 164029 39.1 3
2.05 4 33.7 160650 35.6 1
1.94 4 46.1 250408 47.7 2
2.34 4 41.3 166373 38.7 1
1.76 4 39.1 255087 44.6 3
2.60 4 47.6 187867 37.6 1
2.01 4 35.7 229654 43.8 1
2.18 4 52.0 212868 54.4 2
2.26 4 40.2 165334 43.6 1
1.34 4 31.8 277592 34.2 3
2.06 4 36.3 195100 33.9 1
1.61 4 34.7 169722 35.6 3
1.45 4 33.3 191225 33.6 3
2.10 4 47.5 153669 54.5 2
2.37 4 42.5 310967 36.6 1
2.00 4 35.8 247701 34.9 1
2.42 4 45.3 226481 53.2 1
1.64 4 35.1 186263 44.3 3
2.54 4 47.4 170241 42.8 1
1.53 4 31.6 127407 29.2 2
2.31 4 43.6 279486 44.4 1
2.02 4 50.0 241037 42.7 3
1.66 4 33.9 153674 41.3 2
1.88 4 35.8 208814 46.5 2
1.82 4 29.8 171962 25.4 1
2.00 4 36.2 246560 33.6 1
1.63 4 33.8 156051 40.4 3
1.88 4 33.8 251347 41.1 1
2.51 4 44.0 189034 39.1 1
2.35 4 41.8 213343 39.1 1
2.50 4 43.7 123978 49.9 1
2.22 4 39.0 269962 48.9 1
1.54 4 41.3 159482 48.1 3
1.87 4 42.4 334157 36.2 2
1.57 4 28.0 221462 30.6 2
1.64 4 40.3 306655 34.1 3
1.58 4 34.1 224918 34.5 2
1.58 4 34.4 342534 46.6 2
1.56 4 32.2 174714 40.6 3
1.68 4 35.4 120366 47.0 3
2.05 4 36.0 278027 44.6 1
2.28 4 42.9 131834 33.8 1
2.14 4 44.3 222375 43.3 2
1.92 4 45.2 274282 36.1 2
1.72 4 28.8 269860 41.1 1
1.94 4 30.7 310682 43.3 1
1.82 4 42.2 302590 42.9 2
2.61 4 56.8 158403 51.6 2
2.15 4 36.3 67843 35.7 1
1.67 4 39.3 308102 45.6 3
1.57 4 35.1 171486 36.3 2
2.36 4 40.4 277721 47.6 1
1.60 4 25.7 354467 23.7 1
1.87 4 29.2 165040 26.0 1
2.12 4 44.8 264275 45.7 2
1.66 4 36.0 229452 46.8 2
2.11 5 40.1 281048 44.1 1
2.16 5 46.1 207011 35.8 2
1.70 5 32.0 158601 41.4 1
1.83 5 31.6 228902 24.8 1
1.46 5 21.4 215625 32.2 1
2.03 5 46.7 260950 44.1 2
2.37 5 54.6 252488 47.9 3
1.77 5 42.8 177262 39.0 2
2.22 5 41.2 127076 35.4 1
1.25 5 28.0 218748 34.4 2
1.42 5 30.4 307313 26.6 2
1.86 5 34.5 286051 38.7 1
1.95 5 36.9 224405 37.7 1
1.79 5 33.2 281611 26.3 1
1.70 5 35.8 226342 46.7 3
1.68 5 27.4 159162 32.9 1
2.31 5 41.7 132281 37.4 1
1.48 5 32.7 176497 27.1 2
1.49 5 38.8 230152 42.4 3
2.23 5 43.5 107229 33.8 1
2.07 5 34.7 225065 41.1 1
1.65 5 33.2 131531 41.2 2
1.67 5 42.2 202383 40.9 3
1.57 5 38.0 178392 38.6 3
1.99 5 35.5 172576 34.7 1
2.03 5 43.6 192931 45.2 2
2.68 5 55.5 195064 46.6 1
1.75 5 39.7 126261 34.0 2
1.43 5 33.7 217728 33.3 3
1.16 5 25.0 270204 28.3 2
1.50 5 27.7 187884 30.6 1
2.15 5 36.2 177976 38.5 1
1.60 5 39.8 314466 50.8 2
1.78 5 39.5 206007 45.8 3
1.73 5 38.6 159756 37.0 3
1.62 5 38.3 242540 44.1 3
1.69 5 35.9 185325 33.4 1
1.50 5 35.2 209218 30.7 2
1.57 5 39.0 213397 37.1 3
1.63 5 39.6 142119 45.3 3
1.76 5 32.0 249156 33.4 1
1.31 5 21.3 151131 28.0 1
1.80 5 32.7 158877 42.0 1
2.35 5 43.5 211370 34.1 1
1.45 5 29.8 194069 31.6 2
1.36 5 35.9 117900 36.3 3
1.63 5 39.5 169299 39.9 3
1.18 5 22.2 216814 33.4 2
2.39 5 41.8 189169 45.4 1
2.28 5 41.1 277621 54.0 1
1.96 5 36.2 242353 37.3 1
2.37 5 40.5 252727 42.7 1
1.83 5 32.9 274614 39.2 1
2.20 5 40.4 268713 44.1 1
1.98 5 36.3 310298 34.9 1
1.90 5 32.6 216712 38.7 1
1.76 5 45.7 146471 46.5 3
1.39 5 29.6 159329 34.4 2
1.44 5 33.0 233180 43.7 2
2.09 5 34.8 164836 41.2 1
1.95 5 44.4 156465 47.1 2
1.57 5 36.3 225432 49.6 3
1.94 5 44.2 191938 46.2 2
2.32 5 51.4 147344 40.3 2
1.27 5 29.6 299211 25.7 2
1.36 5 33.6 320489 33.8 2
1.57 5 36.0 109760 43.4 2
1.89 5 41.7 231566 35.4 3
1.44 5 33.3 261906 42.3 2
1.27 5 33.5 114308 39.9 3
1.28 5 29.8 142701 24.4 3
2.05 5 51.0 237798 51.9 3
1.66 5 40.2 300278 44.4 2
2.31 5 41.5 249442 38.9 1
1.44 5 29.8 211481 31.9 2
1.81 5 35.3 160903 35.4 3
2.50 5 43.3 207387 53.1 1
2.21 5 40.8 217507 35.1 1
1.63 5 38.8 286795 43.3 2
1.70 5 35.4 178078 38.2 2
2.28 5 42.7 287619 51.7 1
1.60 5 30.0 238515 33.2 2
2.35 5 41.1 102020 35.6 1
1.73 5 41.0 203634 35.8 3
2.22 5 36.8 208170 42.3 1
1.96 5 50.6 212415 43.5 3
1.38 5 33.8 219245 41.9 2
2.00 5 48.7 192240 45.0 3
1.75 5 42.0 190152 49.1 3
1.56 5 29.8 281173 38.9 1
1.52 5 36.2 336511 38.6 2
2.05 5 34.1 316795 46.9 1
1.44 5 37.1 219457 34.1 3
1.66 5 35.7 253039 52.0 2
1.62 5 28.2 144532 30.6 1
1.29 5 29.9 193831 35.4 2
1.16 6 29.1 111139 23.8 2
1.48 6 32.8 92281 45.1 2
1.62 6 25.3 266721 27.6 1
1.82 6 30.5 251762 37.8 1
2.24 6 42.2 215820 47.7 1
1.70 6 39.3 288187 37.5 2
1.35 6 30.9 126554 38.8 2
1.47 6 27.6 96287 32.1 1
1.83 6 28.7 267754 30.5 1
1.55 6 36.2 245166 36.8 2
1.86 6 36.5 138237 29.0 1
1.58 6 34.4 201726 33.6 2
1.58 6 29.7 234409 29.7 1
1.72 6 41.6 175100 39.8 3
1.67 6 30.6 116695 38.8 1
1.64 6 40.3 227267 43.6 3
1.45 6 31.8 214337 34.1 2
1.87 6 35.2 307512 35.2 1
2.43 6 46.7 202865 43.3 1
1.77 6 34.8 349081 35.7 1
1.77 6 43.6 140661 44.4 3
1.27 6 31.6 170519 33.0 2
2.02 6 34.5 263222 43.8 1
1.60 6 37.7 271013 35.1 3
1.37 6 35.4 162740 42.8 2
2.13 6 40.7 109300 35.0 1
1.74 6 43.7 198478 54.2 3
1.99 6 36.7 266161 36.7 1
1.66 6 42.1 243993 34.3 3
1.58 6 40.7 230803 37.1 2
1.21 6 26.6 221198 29.3 3
1.64 6 29.3 252668 26.6 1
1.43 6 36.4 301154 41.9 3
2.22 6 41.4 206275 40.4 1
1.47 6 32.2 251521 38.9 2
1.71 6 36.2 245225 44.5 2
1.53 6 37.9 166881 42.0 3
2.03 6 41.9 129503 33.2 1
1.47 6 35.0 311240 33.3 2
1.90 6 36.5 144734 35.5 1
2.30 6 44.4 144357 47.2 1
2.04 6 43.1 249061 42.7 1
1.22 6 32.2 324794 37.3 3
2.40 6 45.4 270560 46.6 1
1.07 6 25.5 255876 26.2 2
2.11 6 43.2 223568 38.9 1
1.78 6 31.0 175906 34.3 1
1.85 6 36.6 199196 33.8 1
1.67 6 42.5 144329 45.3 2
2.48 6 46.0 287396 38.3 1
1.35 6 24.3 218823 27.1 1
1.86 6 45.6 257706 49.6 3
2.01 6 41.5 191381 37.5 1
1.38 6 34.4 200251 36.3 2
2.12 6 39.4 142969 43.6 1
1.53 6 39.3 209050 44.0 3
1.75 6 32.7 110616 41.8 1
2.03 6 36.6 156280 42.9 1
1.68 6 38.9 129902 33.3 3
2.01 6 38.6 268391 33.2 1
1.89 6 28.5 116435 29.2 1
1.84 6 32.9 162683 43.1 1
1.32 6 32.2 244971 33.5 2
1.48 6 34.5 250677 37.6 2
1.68 6 37.8 96912 42.1 2
2.11 6 40.0 84339 39.1 1
2.00 6 36.2 212412 43.5 1
1.59 6 38.8 283391 47.4 2
2.37 6 44.4 178852 36.3 1
2.01 6 48.1 208211 43.5 2
2.27 6 47.5 141319 43.3 1
1.23 6 27.9 231887 26.5 2
1.77 6 43.5 187767 44.3 2
1.76 6 31.8 201513 34.1 1
1.52 6 30.5 149904 44.5 1
1.36 6 29.6 186720 33.4 3
1.93 6 36.2 282576 33.7 1
1.04 6 27.7 222417 40.4 3
1.51 6 26.4 149235 32.3 1

Sheet2

Sheet3