tag:blogger.com,1999:blog-5991981.post3520924828211632884..comments2023-04-22T14:57:14.926+08:00Comments on 上班族投資理財 - Invest In Taiwan Stock Market: 拆解話術:每年10%的回報比例Pojen Huanghttp://www.blogger.com/profile/00089859237126287820noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5991981.post-42508517541054434792007-04-20T09:25:00.000+08:002007-04-20T09:25:00.000+08:00喔 原來如此,非常謝謝你的解答!~~喔 原來如此,<BR/>非常謝謝你的解答!~~Kennyhttps://www.blogger.com/profile/14547783905083524557noreply@blogger.comtag:blogger.com,1999:blog-5991981.post-7844689466112718882007-04-19T18:45:00.000+08:002007-04-19T18:45:00.000+08:001 600002 600003 600004 600005 600006 600007 600008...1 60000<BR/>2 60000<BR/>3 60000<BR/>4 60000<BR/>5 60000<BR/>6 60000<BR/>7 60000<BR/>8 60000<BR/>9 60000<BR/>10 60000<BR/>END -660000<BR/>=IRR(B1:B11) 1.726%Pojen Huanghttps://www.blogger.com/profile/00089859237126287820noreply@blogger.comtag:blogger.com,1999:blog-5991981.post-90856666850473048542007-04-19T11:20:00.000+08:002007-04-19T11:20:00.000+08:00-60000-54000(-60000+6000)-54000..共9次600000因保險是年初就繳...-60000<BR/>-54000(-60000+6000)<BR/>-54000<BR/>..共9次<BR/>600000<BR/>因保險是年初就繳,所以財務計算機要設定為BGN模式<BR/>不過我算出來是1.6924%<BR/>供參考Unknownhttps://www.blogger.com/profile/17873018782593127736noreply@blogger.comtag:blogger.com,1999:blog-5991981.post-28745818751766532672007-04-19T10:33:00.000+08:002007-04-19T10:33:00.000+08:00請問1.726%是怎麼算出來的,我利用EXECL算怎麼是1.828%?我的算法:0 -600000...請問1.726%是怎麼算出來的,<BR/>我利用EXECL算怎麼是1.828%?<BR/>我的算法:<BR/>0 -600000<BR/>1 6000<BR/>2 6000<BR/>3 6000<BR/>4 6000<BR/>5 6000<BR/>6 6000<BR/>7 6000<BR/>8 6000<BR/>9 6000<BR/>10 660000 <BR/>IRR(0:10)=1.828%...<BR/>請問哪裡出錯了阿?Kennyhttps://www.blogger.com/profile/14547783905083524557noreply@blogger.com