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

=RATE(6,0,B23,–H23,0)

The nper argument is 6 in the formula because that is the number of years since the base date.