使用EXCEL97计算内含报酬率

CALCULATING INTERNAL RATE OF RETURN IN EXCEL97

给出了一种使用 Newton切线法在电子表格软件 EXCEL中计算内含报酬率的简单方法。使用本法按投资有效期建立计算表 ,以后每次计算时只要输入初始数据 ,工作量很小 ,而且可以使计算结果达到任意精度。

A newton tangential approximation method to calculate internal rate of return (IRR) in EXCEL97 was given, and it is easy to calculate IRR after saving calculating tables of variety kinds of investing periods. Moreover, the accuracy of result can be controlled easily.