Bernie Deitrick wrote:
You could calculate the compound growth rate.
[....]
=(most recent value/oldest value)^(1/(most recent year - oldest year))-1

And alternatively:

=RATE(lastyear - firstyear,, -firstvalue, lastvalue)

I prefer to use the financial functions because it
takes some of the mystique out of the calculation.
And the financial functions have broader application.