If you want a calculation that includes idle cash, I suggest XIRR.
如果你需要一种包括闲置资金的计算方式，我推荐XIRR。
For an example of how to use the XIRR function, look at Figure 9-5 and sheet XIRR of the file IRR.xls.
关于如何使用xirr函数的例子请查看图9 - 5和文件IRR . xls里的XIRR工作表。
As with the XNPV function, the XIRR function cannot be used unless you have installed the Analysis Toolpak.
与xnpv函数一样必须安装分析工具库才能使用xirr函数。
Cash flows occur on actual dates, not just at the start or end of the year. The XIRR function has the syntax.
现金流发生在具体日期并不正好是年初或年末。
I was pleased to see my XIRR ROI climb in the past quarter a full percentage point as I received fewer defaults.
我很高兴看到我的XIRRROI在上一季度攀升了一个百分点，同时违约有所减少。
The XIRR function determines the irr of a sequence of cash flows that occur on any set of irregularly spaced dates.
xirr函数确定一序列发生在间隔不规则日期里现金流的IRR。
The XIRR function determines the irr of a sequence of cash flows that occur on any set of irregularly spaced dates.
xirr函数确定一序列发生在间隔不规则日期里现金流的IRR。
应用推荐