[問題] 貼現
假如我有四張票金額為3.7萬 7.19萬 8.4萬 5.3萬
分別提前36天 11天 21天 31天 貼現 利息是6400元
若要算年利息X的話
3.7/(1+x)^36/365+7.19/(1+x)^11/365+8.4/(1+x)^21/365+5.37/(1+x)^31/365=239.5
x=0.5
請問這樣對嗎? 我是用逼近法算 有辦法用excel做嗎?
謝謝大家
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.171.149.177
推
04/13 20:44, , 1F
04/13 20:44, 1F
→
04/13 20:45, , 2F
04/13 20:45, 2F
推
04/14 13:20, , 3F
04/14 13:20, 3F
→
04/14 13:21, , 4F
04/14 13:21, 4F
→
04/14 13:22, , 5F
04/14 13:22, 5F
→
04/14 13:22, , 6F
04/14 13:22, 6F
→
04/14 13:22, , 7F
04/14 13:22, 7F
→
04/15 22:39, , 8F
04/15 22:39, 8F
→
04/15 22:40, , 9F
04/15 22:40, 9F
→
04/16 17:46, , 10F
04/16 17:46, 10F
→
04/16 17:47, , 11F
04/16 17:47, 11F
→
04/16 21:33, , 12F
04/16 21:33, 12F