Microsoft Office Tutorials and References
In Depth Information
The average figures (column I) are calculated by using the RATE function. This results in an annual growth rate
over the entire period.
The formula in cell I23 that calculates the average growth rate over the term is
The nper argument is 6 in the formula because that is the number of years since the base date.