我所了解的计算方法为: 总增长率百分比的n方根,n相等于有关时期内的年数。实在找不到函数公式。没有其他办法吗? 注: 复合增长率的英文缩写为:CAGR(Compound Annual Growth Rate)。 怎么理解下面这个函数? Excel uses an iterative technique for calculating XIRR. Using a changing rate (starting with guess), XIRR cycles through the calculation until the result is accurate within 0.000001 percent. If XIRR can't find a result that works after 100 tries, the #NUM! error value is returned. The rate is changed until: where: di = the ith, or last, payment date. d1 = the 0th payment date. Pi = the ith, or last, payment.
[此贴子已经被作者于2008-4-25 22:16:49编辑过] |