The RATE formula is calculated by iteration and does not always converge on the correct CAGR value when the inputs take unusually large or very small values. For example, in Excel 2007, RATE returns a #NUM error when asked to calculate the CAGR over 10 periods with P = 10 and A >707 (the correct CAGR is >53.08%).