Hello, Dave!
You wrote on Wed, 25 Oct 2006 07:02:01 -0700:

DF 1 $10,000,000.00
DF 2 $14,740,634.86 47.41%
DF 3 $16,736,647.04 13.54%
DF 4 $16,922,847.13 1.11%
DF 5 $18,653,648.44 10.23%
DF 6 $26,127,105.88 40.06%
DF 7 $33,074,355.97 26.59%
DF 8 $42,284,677.94 27.85%
DF 9 $42,545,480.92 0.62%
DF 10 $49,387,299.55 16.08%

DF 20.39%

DF Range is A1:c12.

DF C2 = B2/B1-1 etc, filled down to C10

DF C12 = AVERAGE(C2:C10) = 20.39% average growth rate.

DF Is that what you're looking for?

DF Dave

Maybe an expoential increase would be appropriate? I'd have been
tempted to use:-
INDEX(LOGEST(known_y's,known_x's),1) -1

This would give 0.19052 or 19.05% with your data.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not