每月买入中行1000元,自己算的二十年利润

来源:百度文库 编辑:神马文学网 时间:2024/04/29 10:42:31
今天突发奇想,用EXCEL的自动计算功能就很容易算出来,就做了一下。 说明:每年固定投入1000*12,年盈利28%,当年投入年终为: 12000*(1+0.28/2)=13680 全年平均算,利润取半 上年结余今年年终为:上年结余*1.28 每年年终为上两项相加,第一年无上年结果是不到一千万,只有六百多万,就多算了几年,到二十五年。越到后面利润越可观,复利的效果惊人。是不是这样算的,对不对大家发表下看法
年 份
当年投入一万二,年终数
上年结余*1.28
年未
1
¥13,680.00
¥0.00
¥13,680.00
2
¥13,680.00
¥17,510.40
¥31,190.40
3
¥13,680.00
¥39,923.71
¥53,603.71
4
¥13,680.00
¥68,612.75
¥82,292.75
5
¥13,680.00
¥105,334.72
¥119,014.72
6
¥13,680.00
¥152,338.84
¥166,018.84
7
¥13,680.00
¥212,504.12
¥226,184.12
8
¥13,680.00
¥289,515.67
¥303,195.67
9
¥13,680.00
¥388,090.46
¥401,770.46
10
¥13,680.00
¥514,266.19
¥527,946.19
11
¥13,680.00
¥675,771.13
¥689,451.13
12
¥13,680.00
¥882,497.44
¥896,177.44
13
¥13,680.00
¥1,147,107.12
¥1,160,787.12
14
¥13,680.00
¥1,485,807.52
¥1,499,487.52
15
¥13,680.00
¥1,919,344.02
¥1,933,024.02
16
¥13,680.00
¥2,474,270.75
¥2,487,950.75
17
¥13,680.00
¥3,184,576.96
¥3,198,256.96
18
¥13,680.00
¥4,093,768.91
¥4,107,448.91
19
¥13,680.00
¥5,257,534.61
¥5,271,214.61
20
¥13,680.00
¥6,747,154.69
¥6,760,834.69
21
¥13,680.00
¥8,653,868.41
¥8,667,548.41
22
¥13,680.00
¥11,094,461.96
¥11,108,141.96
23
¥13,680.00
¥14,218,421.71
¥14,232,101.71
24
¥13,680.00
¥18,217,090.19
¥18,230,770.19
25
¥13,680.00
¥23,335,385.85
¥23,349,065.85
应要求把年利改为38%,结果更是不得了。其实年利多少并不重要,关键是我们要按零风险操作并坚持二十年这才是重要的,二十年后股市将给我们的恒心以丰厚的回报。零友们坚持!!!