市盈率模型.xls

10 00 15 00 20 00 25 00 30 00 35 00 40 00 45 00 50 00 0 00 10 00 20 00 30 00 40 00 50 00 60 00 70 00 80 00 增长率 PE率 10 00 15 00 20 00 25 00 30 00 35 00 40 00 45 00 50 00 55 00 60 00 65 00 70 00 75 00 80 00 85 00 90 00 95 00 100 00 0 0 0 00 0 1 10 00 0 0 00 0 2 20 00 0 0 00 0 3 30 00 0 0 00 0 4 40 00 0 0 00 0 5 50 00 0 0 00 0 6 60 00 0 0 00 0 增长率 PE率 增长率合理市盈率合理市盈率 平均年收益增长率 翻倍年长72法则 不思当期E 1 00 9 37 9 36852731 69 66172 0008 368527 2 00 9 75 9 75462842 35 00336 0008 754628 3 00 10 16 10 1591063 23 45024 0009 159106 4 00 10 58 10 5827954 17 67318 0009 582795 5 00 11 03 11 0265645 14 20714 40010 02656 6 00 11 49 11 4913166 11 89612 00010 49132 7 00 11 98 11 9779897 10 24510 28610 97799 8 00 12 49 12 4875588 9 0069 00011 48756 9 00 13 02 13 0210369 8 0438 00012 02104 10 00 13 58 13 57947710 7 2737 20012 57948 15 00 16 79 16 78584215 4 9594 80015 78584 20 00 20 80 20 79890220 3 8023 60019 7989 25 00 25 80 25 80232225 3 1062 88024 80232 30 00 32 01 32 01499830 2 6422 40031 015 35 00 39 70 39 69641535 2 3102 05738 69641 40 00 49 15 49 15261740 2 0601 80048 15262 45 00 60 74 60 74282145 1 8651 60059 74282 50 00 74 89 74 88671950 1 7101 44073 88672 55 00 92 07 92 07252255 1 5821 30991 07252 60 00 112 87 112 8657960 1 4751 200111 8658 65 00 137 92 137 9191265 1 3841 108136 9191 70 00 167 98 167 9826870 1 3061 029166 9827 75 00 203 92 203 9157375 1 2390 960202 9157 80 00 246 70 246 6991180 1 1790 900245 6991 85 00 297 45 297 4488585 1 1270 847296 4489 90 00 357 43 357 4307890 1 0800 800356 4308 95 00 428 0