00666
同學
UID 2615
精華
0
積分 0
帖子 13
閱讀權限 99
註冊 2013-7-14
用戶註冊天數 3938
用戶失蹤天數 2174
42.2.50.16
|
|
|
 預期配息率 =(現在配息率+(1-盈再率))/2
RCI預期配息率=(MAX(MIN(N5,90%)=IF(ISNUMBER(N5),MIN(N5,0.9),0),MIN(N6,90%)*IF(ISNUMBER(N6),MIN(N6,0.9),0),MIN(N7,90%)*IF(ISNUMBER(N7),MIN(N7,0.9),0))+(1-IF(ISNUMBER(N9),IF(N9>80,0.2,MIN((100-N9)/100,0.9)),0.9)))/2
1103預期配息率=(MAX(MIN(N25,90%)=IF(ISNUMBER(N25),MIN(N25,0.9),0),MIN(N26,90%)*IF(ISNUMBER(N26),MIN(N26,0.9),0),MIN(N27,90%)*IF(ISNUMBER(N27),MIN(N27,0.9),0))+(1-IF(ISNUMBER(N29),IF(N29>80,0.2,MIN((100-N29)/100,0.9)),0.9)))/2
為何兩者預期配息率都是0.55,我計算的預期配息率公式是否出錯?能指點一下,謝謝... |
|
|
