If you want a calculation that includes idle cash, I suggest XIRR.

如果你需要一种包括闲置资金的计算方式，我推荐XIRR。

youdao

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工作表。

youdao

As with the XNPV function, the XIRR function cannot be used unless you have installed the Analysis Toolpak.

与xnpv函数一样必须安装分析工具库才能使用xirr函数。

youdao