[問題] 美元保單IRR計算
有從網路上使用人家分享的EXCEL
年度 保費 領回 小計(價值)
0 -18375 8967
1 -18375 25228
2 -18375 44052
3 -18375 65547
4 -18374 89824
5 -18375 115860 -> IRR 1.42%
6 0 0 121322
7 0 125812
8 0 130467
9 0 135294
10 0 140299
11 0 145489
12 0 150871
13 0 156452
14 0 162239 -> IRR ??
使用六年期的EXCEL算得 第六年領回115860的話 IRR為1.42%
請問如果是第七年之後呢 ? 因為找不到可用的EXCEL
有看到之前有人分享 可是找不到了
業務宣稱第六年之後的IRR為 3.7%
請各位大大解惑 感激
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.47.42.58
※ 文章網址: https://www.ptt.cc/bbs/CFP/M.1434384163.A.B4B.html
→
06/16 14:15, , 1F
06/16 14:15, 1F
→
06/16 14:15, , 2F
06/16 14:15, 2F
→
06/16 14:18, , 3F
06/16 14:18, 3F
→
06/16 14:19, , 4F
06/16 14:19, 4F
→
06/16 14:21, , 5F
06/16 14:21, 5F
推
06/16 18:49, , 6F
06/16 18:49, 6F
推
06/16 18:52, , 7F
06/16 18:52, 7F
推
06/16 19:42, , 8F
06/16 19:42, 8F
推
06/16 20:26, , 9F
06/16 20:26, 9F
推
06/16 20:31, , 10F
06/16 20:31, 10F
推
06/16 20:33, , 11F
06/16 20:33, 11F
→
06/17 00:53, , 12F
06/17 00:53, 12F
→
06/17 00:56, , 13F
06/17 00:56, 13F
→
06/17 00:56, , 14F
06/17 00:56, 14F
推
06/17 09:26, , 15F
06/17 09:26, 15F
→
06/17 09:26, , 16F
06/17 09:26, 16F
→
06/17 10:59, , 17F
06/17 10:59, 17F
→
06/17 10:59, , 18F
06/17 10:59, 18F
推
06/17 14:09, , 19F
06/17 14:09, 19F
→
06/17 14:09, , 20F
06/17 14:09, 20F
→
06/17 14:25, , 21F
06/17 14:25, 21F
→
06/21 04:44, , 22F
06/21 04:44, 22F
→
06/21 04:45, , 23F
06/21 04:45, 23F
討論串 (同標題文章)
CFP 近期熱門文章
20
156
3
12
7
21
5
27
PTT職涯區 即時熱門文章