O*******a
发帖数: 692 | 1 头好晕啊，用excel里的IRR结果得不到值
JMS帮帮忙啊，谢拉？ | l****z
发帖数: 29846 | 2 怎么可能呢? 你是精简版的excel? 还是excel2003里面的那个add in没有加? | O*******a
发帖数: 692 | | c*********k
发帖数: 220 | 4 Write down your cashflows (A1: A5), use excel IRR function, you should be
able to calculate it. eg. =IRR(A1:A5,0.01)
Or, if you have financial calculator, you can use cf function.
Good luck. | k*n
发帖数: 108 | 5 if there are significant inflow/outflow of cash, IRR won't work for the
return performance calculation in the way below.
solution:
google time weighted return,
or use investment segment method in AIMR.
【在 c*********k 的大作中提到】
: Write down your cashflows (A1: A5), use excel IRR function, you should be
: able to calculate it. eg. =IRR(A1:A5,0.01)
: Or, if you have financial calculator, you can use cf function.
: Good luck.
|
|
