[問題] 報酬率計算
每年繳25665元,共15年,總繳金額384975元
到第16年開始就不用再繳任何一毛錢
如果想在第20年領回,則可領回486015元.......
請問年化報酬率是不是:=RATE(15,25665,0,-486015,0)
用excel算為3.245%
這樣觀念及算法對嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.112.98.124
※ 編輯: iqlow 來自: 59.112.98.124 (10/11 17:02)
→
10/11 17:33, , 1F
10/11 17:33, 1F
→
10/11 17:35, , 2F
10/11 17:35, 2F
→
10/11 17:39, , 3F
10/11 17:39, 3F
→
10/11 17:42, , 4F
10/11 17:42, 4F
推
10/11 17:50, , 5F
10/11 17:50, 5F
→
10/11 17:51, , 6F
10/11 17:51, 6F
推
10/11 17:58, , 7F
10/11 17:58, 7F
推
10/11 18:33, , 8F
10/11 18:33, 8F
推
10/11 18:41, , 9F
10/11 18:41, 9F
推
10/11 18:45, , 10F
10/11 18:45, 10F
推
10/11 18:48, , 11F
10/11 18:48, 11F
→
10/11 18:49, , 12F
10/11 18:49, 12F
推
10/11 18:50, , 13F
10/11 18:50, 13F
推
10/11 19:31, , 14F
10/11 19:31, 14F
→
10/11 19:37, , 15F
10/11 19:37, 15F
推
10/11 20:06, , 16F
10/11 20:06, 16F
→
10/11 21:27, , 17F
10/11 21:27, 17F
推
10/11 22:02, , 18F
10/11 22:02, 18F
→
10/11 22:03, , 19F
10/11 22:03, 19F
→
10/11 22:04, , 20F
10/11 22:04, 20F
→
10/11 22:04, , 21F
10/11 22:04, 21F
→
10/11 22:09, , 22F
10/11 22:09, 22F
→
10/11 22:55, , 23F
10/11 22:55, 23F
→
10/11 23:07, , 24F
10/11 23:07, 24F
→
10/11 23:07, , 25F
10/11 23:07, 25F
→
10/11 23:08, , 26F
10/11 23:08, 26F
推
10/12 00:51, , 27F
10/12 00:51, 27F
討論串 (同標題文章)