股票内在价值计算

用excel做很方便，可以直接用公式，不会公式可以算出每年的现值然后累加，也很方便现在用累加法算，到100年后现值基本很小，我一共算了100年，对各年现值累加求和为43.5999具体看下边年度 分红 贴现 现值 0 2 1 2 1 2.1 1.1 1.909090909 2 2.205 1.21 1.82231405 3 2.31525 1.331 1.739481593 4 2.4310125 1.4641 1.660414248 5 2.552563125 1.61051 1.584940873 6 2.680191281 1.771561 1.512898106 7 2.814200845 1.9487171 1.44413001 8 2.954910888 2.14358881 1.378487737 9 3.102656432 2.357947691 1.315829203 10 3.257789254 2.59374246 1.256018785 11 3.420678716 2.853116706 1.198927022 12 3.591712652 3.138428377 1.144430339 13 3.771298285 3.452271214 1.092410778 14 3.959863199 3.797498336 1.042755743 15 4.157856359 4.177248169 0.995357755 16 4.365749177 4.594972986 0.95011422 17 4.584036636 5.054470285 0.90692721 18 4.813238467 5.559917313 0.865703246 19 5.053900391 6.115909045 0.826353099 20 5.30659541 6.727499949 0.788791594 21 5.571925181 7.400249944 0.752937431 22 5.85052144 8.140274939 0.718713002 23 6.143047512 8.954302433 0.686044229 24 6.450199887 9.849732676 0.654860401 25 6.772709882 10.83470594 0.625094019 26 7.111345376 11.91817654 0.596680654 27 7.466912645 13.10999419 0.569558806 28 7.840258277 14.42099361 0.54366977 29 8.232271191 15.86309297 0.518957508 30 8.64388475 17.44940227 0.49536853 31 9.076078988 19.1943425 0.472851779 32 9.529882937 21.11377675 0.451358516 33 10.00637708 23.22515442 0.43084222 34 10.50669594 25.54766986 0.411258482 35 11.03203074 28.10243685 0.392564915 36 11.58363227 30.91268053 0.374721055 37 12.16281389 34.00394859 0.35768828 38 12.77095458 37.40434344 0.341429722 39 13.40950231 41.14477779 0.325910189 40 14.07997742 45.25925557 0.31109609 41 14.7839763 49.78518112 0.296955358 42 15.52317511 54.76369924 0.283457387 43 16.29933387 60.24006916 0.270572961 44 17.11430056 66.26407608 0.25827419 45 17.97001559 72.89048369 0.246534454 46 18.86851637 80.17953205 0.235328342 47 19.81194218 88.19748526 0.224631599 48 20.80253929 97.01723378 0.214421072 49 21.84266626 106.7189572 0.20467466 50 22.93479957 117.3908529 0.195371266 51 24.08153955 129.1299382 0.186490754 52 25.28561653 142.042932 0.178013902 53 26.54989735 156.2472252 0.169922361 54 27.87739222 171.8719477 0.162198617 55 29.27126183 189.0591425 0.154825953 56 30.73482492 207.9650567 0.147788409 57 32.27156617 228.7615624 0.141070754 58 33.88514448 251.6377186 0.134658447 59 35.5794017 276.8014905 0.128537609 60 37.35837179 304.4816395 0.12269499 61 39.22629038 334.9298035 0.117117945 62 41.1876049 368.4227838 0.111794402 63 43.24698514 405.2650622 0.106712839 64 45.4093344 445.7915685 0.101862255 65 47.67980112 490.3707253 0.097232152 66 50.06379117 539.4077978 0.092812509 67 52.56698073 593.3485776 0.088593759 68 55.19532977 652.6834354 0.08456677 69 57.95509626 717.9517789 0.080722826 70 60.85285107 789.7469568 0.077053606 71 63.89549362 868.7216525 0.07355117 72 67.09026831 955.5938177 0.070207935 73 70.44478172 1051.1532 0.067016665 74 73.96702081 1156.268519 0.063970453 75 77.66537185 1271.895371 0.061062705 76 81.54864044 1399.084909 0.058287127 77 85.62607246 1538.993399 0.055637713 78 89.90737608 1692.892739 0.053108726 79 94.40274489 1862.182013 0.050694693 80 99.12288213 2048.400215 0.048390388 81 104.0790262 2253.240236 0.046190825 82 109.2829776 2478.56426 0.044091242 83 114.7471264 2726.420686 0.042087095 84 120.4844828 2999.062754 0.040174045 85 126.5087069 3298.96903 0.038347952 86 132.8341422 3628.865933 0.036604864 87 139.4758493 3991.752526 0.034941006 88 146.4496418 4390.927778 0.033352779 89 153.7721239 4830.020556 0.031836743 90 161.4607301 5313.022612 0.030389618 91 169.5337666 5844.324873 0.029008272 92 178.0104549 6428.75736 0.027689714 93 186.9109777 7071.633096 0.026431091 94 196.2565266 7778.796406 0.025229678 95 206.0693529 8556.676047 0.024082874 96 216.3728205 9412.343651 0.022988198 97 227.1914616 10353.57802 0.02194328 98 238.5510346 11388.93582 0.020945858 99 250.4785864 12527.8294 0.019993774 100 263.0025157 13780.61234 0.019084966 20210311