西西河

主题:昨天亲戚向我推销保险,我顺手了道简单的数学题,结果很有趣 -- 米宝

共:💬20 🌺48 🌵1 新:
分页树展主题 · 全看 下页
  • 家园 昨天亲戚向我推销保险,我顺手了道简单的数学题,结果很有趣

    昨天有表弟突然发了我一条微信:“哥,我觉得这个给小宝买很合适,你看一下。”

    就下面这玩意:

    太平信守一生

    我本身对保险一直没啥兴趣,难得有亲戚主动向我推荐,就打开看了看顺手计算了下,虽说我对保险一直没有好感,不过这计算结果还是挺惊人的。

    假设孩子出生时我拿出25万,准备给孩子投保VS投资货币基金(货币基金满大街都是,现在4%左右年收益,风险程度和活期存款差不多),那么对比情况如下:

    孩子10岁,保险净收益-18.8万,货币基金净收益12.2万,比保险多31万。

    孩子20岁,保险净收益-12.8万,货币基金净收益30.4万,比保险多43万。

    孩子30岁,保险净收益-6.8万,货币基金净收益57.3万,比保险多64万。

    孩子40岁,保险净收益-0.8万(40年过去了,本金还没拿回来呢),货币基金净收益97万,比保险多97.8万。

    孩子50岁,保险净收益5.1万(谢天谢地半个世纪过去了,我的投资终于有回报了,有5万多块钱呢),货币基金净收益155.9万,差距150万,是保险的30倍。

    孩子60岁,保险净收益11.1万,货币基金净收益243.1万,差距232万,是保险的22倍。

    孩子70岁,保险净收益20.1万,货币基金净收益372.2万,差距352.1万,是保险的18倍。

    孩子80岁,保险净收益32.1万,货币基金净收益563.2万,差距531.1万,也是18倍。

    保险计划到88岁结束,也就是假设你活不过88岁,货币基金则没有这个限制,我就计算到90岁。

    孩子90岁,保险净收益66.0万,货币基金净收益846.0万,差距780万,是保险的12倍。

    结论是,一保险真够黑的,二这么黑还能生存下来,说明世界上还是傻子太多。

    Excel表对比如下:

    年龄 缴费 收益 年净收益 总净收益 本金+收益 货币基金年净收益 货币基金总净收益 对比

    1 25,544 12,772 -12,772 -12,772 255,440 10,218 10,218 22,990

    2 25,544 6,000 -19,544 -32,316 265,658 10,626 20,844 53,160

    3 25,544 6,000 -19,544 -51,860 276,284 11,051 31,895 83,755

    4 25,544 6,000 -19,544 -71,404 287,335 11,493 43,389 114,793

    5 25,544 6,000 -19,544 -90,948 298,829 11,953 55,342 146,290

    6 25,544 6,000 -19,544 -110,492 310,782 12,431 67,773 178,265

    7 25,544 6,000 -19,544 -130,036 323,213 12,929 80,702 210,738

    8 25,544 6,000 -19,544 -149,580 336,142 13,446 94,147 243,727

    9 25,544 6,000 -19,544 -169,124 349,587 13,983 108,131 277,255

    10 25,544 6,000 -19,544 -188,668 363,571 14,543 122,674 311,342

    11 6,000 6,000 -182,668 378,114 15,125 137,798 320,466

    12 6,000 6,000 -176,668 393,238 15,730 153,528 330,196

    13 6,000 6,000 -170,668 408,968 16,359 169,886 340,554

    14 6,000 6,000 -164,668 425,326 17,013 186,899 351,567

    15 6,000 6,000 -158,668 442,339 17,694 204,593 363,261

    16 6,000 6,000 -152,668 460,033 18,401 222,994 375,662

    17 6,000 6,000 -146,668 478,434 19,137 242,132 388,800

    18 6,000 6,000 -140,668 497,572 19,903 262,035 402,703

    19 6,000 6,000 -134,668 517,475 20,699 282,734 417,402

    20 6,000 6,000 -128,668 538,174 21,527 304,260 432,928

    21 6,000 6,000 -122,668 559,700 22,388 326,649 449,317

    22 6,000 6,000 -116,668 582,089 23,284 349,932 466,600

    23 6,000 6,000 -110,668 605,372 24,215 374,147 484,815

    24 6,000 6,000 -104,668 629,587 25,183 399,330 503,998

    25 6,000 6,000 -98,668 654,770 26,191 425,521 524,189

    26 6,000 6,000 -92,668 680,961 27,238 452,760 545,428

    27 6,000 6,000 -86,668 708,200 28,328 481,088 567,756

    28 6,000 6,000 -80,668 736,528 29,461 510,549 591,217

    29 6,000 6,000 -74,668 765,989 30,640 541,188 615,856

    30 6,000 6,000 -68,668 796,628 31,865 573,053 641,721

    31 6,000 6,000 -62,668 828,493 33,140 606,193 668,861

    32 6,000 6,000 -56,668 861,633 34,465 640,659 697,327

    33 6,000 6,000 -50,668 896,099 35,844 676,502 727,170

    34 6,000 6,000 -44,668 931,942 37,278 713,780 758,448

    35 6,000 6,000 -38,668 969,220 38,769 752,549 791,217

    36 6,000 6,000 -32,668 1,007,989 40,320 792,869 825,537

    37 6,000 6,000 -26,668 1,048,309 41,932 834,801 861,469

    38 6,000 6,000 -20,668 1,090,241 43,610 878,411 899,079

    39 6,000 6,000 -14,668 1,133,851 45,354 923,765 938,433

    40 6,000 6,000 -8,668 1,179,205 47,168 970,933 979,601

    41 6,000 6,000 -2,668 1,226,373 49,055 1,019,988 1,022,656

    42 6,000 6,000 3,332 1,275,428 51,017 1,071,005 1,067,673

    43 6,000 6,000 9,332 1,326,445 53,058 1,124,063 1,114,731

    44 6,000 6,000 15,332 1,379,503 55,180 1,179,243 1,163,911

    45 6,000 6,000 21,332 1,434,683 57,387 1,236,630 1,215,298

    46 6,000 6,000 27,332 1,492,070 59,683 1,296,313 1,268,981

    47 6,000 6,000 33,332 1,551,753 62,070 1,358,383 1,325,051

    48 6,000 6,000 39,332 1,613,823 64,553 1,422,936 1,383,604

    49 6,000 6,000 45,332 1,678,376 67,135 1,490,071 1,444,739

    50 6,000 6,000 51,332 1,745,511 69,820 1,559,891 1,508,559

    51 6,000 6,000 57,332 1,815,331 72,613 1,632,504 1,575,172

    52 6,000 6,000 63,332 1,887,944 75,518 1,708,022 1,644,690

    53 6,000 6,000 69,332 1,963,462 78,538 1,786,561 1,717,229

    54 6,000 6,000 75,332 2,042,001 81,680 1,868,241 1,792,909

    55 6,000 6,000 81,332 2,123,681 84,947 1,953,188 1,871,856

    56 6,000 6,000 87,332 2,208,628 88,345 2,041,533 1,954,201

    57 6,000 6,000 93,332 2,296,973 91,879 2,133,412 2,040,080

    58 6,000 6,000 99,332 2,388,852 95,554 2,228,966 2,129,634

    59 6,000 6,000 105,332 2,484,406 99,376 2,328,342 2,223,010

    60 6,000 6,000 111,332 2,583,782 103,351 2,431,694 2,320,362

    61 6,000 6,000 117,332 2,687,134 107,485 2,539,179 2,421,847

    62 6,000 6,000 123,332 2,794,619 111,785 2,650,964 2,527,632

    63 6,000 6,000 129,332 2,906,404 116,256 2,767,220 2,637,888

    64 6,000 6,000 135,332 3,022,660 120,906 2,888,126 2,752,794

    65 6,000 6,000 141,332 3,143,566 125,743 3,013,869 2,872,537

    66 12,000 12,000 153,332 3,269,309 130,772 3,144,641 2,991,309

    67 12,000 12,000 165,332 3,400,081 136,003 3,280,645 3,115,313

    68 12,000 12,000 177,332 3,536,085 141,443 3,422,088 3,244,756

    69 12,000 12,000 189,332 3,677,528 147,101 3,569,189 3,379,857

    70 12,000 12,000 201,332 3,824,629 152,985 3,722,174 3,520,842

    71 12,000 12,000 213,332 3,977,614 159,105 3,881,279 3,667,947

    72 12,000 12,000 225,332 4,136,719 165,469 4,046,748 3,821,416

    73 12,000 12,000 237,332 4,302,188 172,088 4,218,835 3,981,503

    74 12,000 12,000 249,332 4,474,275 178,971 4,397,806 4,148,474

    75 12,000 12,000 261,332 4,653,246 186,130 4,583,936 4,322,604

    76 12,000 12,000 273,332 4,839,376 193,575 4,777,511 4,504,179

    77 12,000 12,000 285,332 5,032,951 201,318 4,978,829 4,693,497

    78 12,000 12,000 297,332 5,234,269 209,371 5,188,200 4,890,868

    79 12,000 12,000 309,332 5,443,640 217,746 5,405,945 5,096,613

    80 12,000 12,000 321,332 5,661,385 226,455 5,632,401 5,311,069

    81 12,000 12,000 333,332 5,887,841 235,514 5,867,914 5,534,582

    82 12,000 12,000 345,332 6,123,354 244,934 6,112,848 5,767,516

    83 12,000 12,000 357,332 6,368,288 254,732 6,367,580 6,010,248

    84 12,000 12,000 369,332 6,623,020 264,921 6,632,501 6,263,169

    85 12,000 12,000 381,332 6,887,941 275,518 6,908,018 6,526,686

    86 12,000 12,000 393,332 7,163,458 286,538 7,194,557 6,801,225

    87 12,000 12,000 405,332 7,449,997 298,000 7,492,557 7,087,225

    88 255,440 255,440 660,772 7,747,997 309,920 7,802,477 7,141,705

    89 - 8,057,917 322,317 8,124,793 8,124,793

    90 - - 8,380,233 335,209 8,460,003 8,460,003

    通宝推:混沌之源,和平共处,审度,
分页树展主题 · 全看 下页


有趣有益,互惠互利;开阔视野,博采众长。
虚拟的网络,真实的人。天南地北客,相逢皆朋友

Copyright © cchere 西西河