Re: [問題] 88年買的儲蓄險(預定利率7%)面臨每滿5꘠…
※ 引述《ajj1 (醜小鴨)》之銘言:
: 民國88年幫14歲的兒子買了3張保單 預定利率7%
: 還本終身壽險 (繳費10年) 保障100萬 年繳保費 93100
: 還本終身壽險 (繳費15年) 保障100萬 年繳保費 53800
: 還本終身壽險 (繳費20年) 保障100萬 年繳保費 36400
: 滿24.27.29.30.32歲 各領20萬. 之後每年均可領20萬.領終身.
: 請問:
覺得問題很有趣,想算一下,剛卡在不會算
突然好像有想起來
請大家看一下算法是否有誤 @@"
再用淨現金流量去跑IRR
這樣推算應該是活越久IRR越高
年度 歲數 10年期 15年期 20年期 年金 淨現金流量 IRR
1 14 -93100 -53800 -36400 -183300
2 15 -93100 -53800 -36400 -183300
3 16 -93100 -53800 -36400 -183300
4 17 -93100 -53800 -36400 -183300
5 18 -93100 -53800 -36400 -183300
6 19 -93100 -53800 -36400 -183300
7 20 -93100 -53800 -36400 -183300
8 21 -93100 -53800 -36400 -183300
9 22 -93100 -53800 -36400 -183300
10 23 -93100 -53800 -36400 -183300
11 24 -53800 -36400 200000 109800
12 25 -53800 -36400 -90200
13 26 -53800 -36400 -90200
14 27 -53800 -36400 200000 109800
15 28 -53800 -36400 -90200
16 29 -36400 200000 163600 -25.4248%
17 30 -36400 200000 163600 -16.6503%
18 31 -36400 -36400 -18.2636%
19 32 -36400 200000 163600 -12.3330%
20 33 -36400 200000 163600 -9.0377%
21 34 200000 200000 -6.3737%
22 35 200000 200000 -4.4859%
23 36 200000 200000 -3.0515%
24 37 200000 200000 -1.9160%
25 38 200000 200000 -0.9920%
26 39 200000 200000 -0.2252%
27 40 200000 200000 0.4211%
28 41 200000 200000 0.9722%
29 42 200000 200000 1.4468%
30 43 200000 200000 1.8590%
31 44 200000 200000 2.2194%
32 45 200000 200000 2.5365%
33 46 200000 200000 2.8169%
34 47 200000 200000 3.0661%
35 48 200000 200000 3.2885%
36 49 200000 200000 3.4876%
37 50 200000 200000 3.6666%
38 51 200000 200000 3.8279%
39 52 200000 200000 3.9738%
40 53 200000 200000 4.1060%
41 54 200000 200000 4.2261%
42 55 200000 200000 4.3354%
43 56 200000 200000 4.4352%
44 57 200000 200000 4.5264%
45 58 200000 200000 4.6100%
46 59 200000 200000 4.6866%
47 60 200000 200000 4.7570%
48 61 200000 200000 4.8217%
49 62 200000 200000 4.8814%
50 63 200000 200000 4.9365%
51 64 200000 200000 4.9873%
52 65 200000 200000 5.0343%
53 66 200000 200000 5.0778%
54 67 200000 200000 5.1181%
55 68 200000 200000 5.1555%
56 69 200000 200000 5.1902%
57 70 200000 200000 5.2224%
58 71 200000 200000 5.2524%
59 72 200000 200000 5.2803%
60 73 200000 200000 5.3063%
61 74 200000 200000 5.3305%
62 75 200000 200000 5.3531%
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.168.75.43
推
08/23 12:14, , 1F
08/23 12:14, 1F
→
08/23 12:16, , 2F
08/23 12:16, 2F
→
08/23 12:17, , 3F
08/23 12:17, 3F
→
08/23 12:17, , 4F
08/23 12:17, 4F
→
08/23 12:18, , 5F
08/23 12:18, 5F
→
08/23 12:21, , 6F
08/23 12:21, 6F
→
08/23 12:21, , 7F
08/23 12:21, 7F
→
08/23 12:22, , 8F
08/23 12:22, 8F
推
08/23 12:26, , 9F
08/23 12:26, 9F
→
08/23 12:27, , 10F
08/23 12:27, 10F
→
08/23 12:29, , 11F
08/23 12:29, 11F
→
08/23 12:29, , 12F
08/23 12:29, 12F
→
08/23 12:30, , 13F
08/23 12:30, 13F
→
08/23 12:30, , 14F
08/23 12:30, 14F
→
08/23 12:31, , 15F
08/23 12:31, 15F
→
08/23 12:31, , 16F
08/23 12:31, 16F
→
08/23 12:31, , 17F
08/23 12:31, 17F
→
08/23 12:32, , 18F
08/23 12:32, 18F
→
08/23 12:35, , 19F
08/23 12:35, 19F
→
08/23 12:40, , 20F
08/23 12:40, 20F
→
08/23 13:13, , 21F
08/23 13:13, 21F
→
08/23 13:14, , 22F
08/23 13:14, 22F
→
08/23 13:15, , 23F
08/23 13:15, 23F
推
08/23 13:21, , 24F
08/23 13:21, 24F
→
08/23 14:18, , 25F
08/23 14:18, 25F
→
08/23 14:20, , 26F
08/23 14:20, 26F
→
08/23 14:20, , 27F
08/23 14:20, 27F
→
08/23 14:37, , 28F
08/23 14:37, 28F
→
08/23 14:38, , 29F
08/23 14:38, 29F
→
08/23 14:39, , 30F
08/23 14:39, 30F
→
08/23 14:39, , 31F
08/23 14:39, 31F
→
08/23 14:40, , 32F
08/23 14:40, 32F
※ 編輯: renriver 來自: 118.168.75.43 (08/23 15:50)
→
08/23 16:01, , 33F
08/23 16:01, 33F
→
08/23 16:02, , 34F
08/23 16:02, 34F
→
08/23 16:03, , 35F
08/23 16:03, 35F
→
08/23 16:04, , 36F
08/23 16:04, 36F
推
08/23 17:30, , 37F
08/23 17:30, 37F
→
08/23 17:32, , 38F
08/23 17:32, 38F
還有 54 則推文
→
08/23 19:27, , 93F
08/23 19:27, 93F
推
08/23 19:43, , 94F
08/23 19:43, 94F
→
08/23 19:43, , 95F
08/23 19:43, 95F
→
08/23 19:44, , 96F
08/23 19:44, 96F
→
08/23 19:45, , 97F
08/23 19:45, 97F
→
08/23 19:46, , 98F
08/23 19:46, 98F
→
08/23 19:47, , 99F
08/23 19:47, 99F
→
08/23 19:47, , 100F
08/23 19:47, 100F
→
08/23 19:47, , 101F
08/23 19:47, 101F
→
08/23 19:48, , 102F
08/23 19:48, 102F
→
08/23 19:50, , 103F
08/23 19:50, 103F
→
08/23 19:51, , 104F
08/23 19:51, 104F
→
08/23 19:52, , 105F
08/23 19:52, 105F
→
08/23 19:53, , 106F
08/23 19:53, 106F
→
08/23 19:53, , 107F
08/23 19:53, 107F
※ 編輯: renriver 來自: 118.168.75.43 (08/23 19:55)
→
08/23 20:05, , 108F
08/23 20:05, 108F
ㄟ...我只是重複讚嘆而已 :p
推
08/23 20:07, , 109F
08/23 20:07, 109F
推
08/23 20:09, , 110F
08/23 20:09, 110F
→
08/23 20:10, , 111F
08/23 20:10, 111F
→
08/23 20:11, , 112F
08/23 20:11, 112F
數字出不來應該是調整的問題...IRR沒有錯
用的是淨現金流量在算的.......這不會有問題
而你的算法就是我說的年金終值
你在算支出保費時去假設他的機會成本
那麼收到年金20萬一樣可以去存起來,當然也要複利去算啊
那個部分真的沒有問題
※ 編輯: renriver 來自: 118.168.75.43 (08/23 20:16)
→
08/23 20:13, , 113F
08/23 20:13, 113F
支出保費的機會成本是假設那筆錢存銀行可以得到的終值
而收到的年金自然會拿去存銀行一樣會有終值
※ 編輯: renriver 來自: 118.168.75.43 (08/23 20:21)
推
08/23 20:38, , 114F
08/23 20:38, 114F
→
08/23 20:38, , 115F
08/23 20:38, 115F
→
08/23 20:38, , 116F
08/23 20:38, 116F
→
08/23 20:39, , 117F
08/23 20:39, 117F
→
08/23 20:39, , 118F
08/23 20:39, 118F
→
08/23 20:39, , 119F
08/23 20:39, 119F
→
08/23 20:40, , 120F
08/23 20:40, 120F
→
08/23 20:40, , 121F
08/23 20:40, 121F
→
08/23 20:40, , 122F
08/23 20:40, 122F
→
08/23 20:41, , 123F
08/23 20:41, 123F
→
08/23 20:41, , 124F
08/23 20:41, 124F
→
08/23 20:45, , 125F
08/23 20:45, 125F
→
08/23 20:55, , 126F
08/23 20:55, 126F
→
08/23 21:06, , 127F
08/23 21:06, 127F
※ 編輯: renriver 來自: 118.168.75.43 (08/24 00:58)
討論串 (同標題文章)
完整討論串 (本文為第 2 之 10 篇):