exact explanation i was looking for! thanks so much!

:D

" wrote:

"my" wrote:
I need help calculating a monthly growth rate for the
following:
Start Value in Month 1: 750,000
End Value in Month 12: 1,500,000
How do I calculate the monthly growth rate so that I
start with 750,000 and end up with 1,500,000 on the
twelfth month?

Depends on what you mean by "growth rate".

The geometric growth rate is (1500000/750000)^(1/11) - 1.
If that formula is in B1 and 750000 is in A1, you compute the
next month in A2 by A1*(1+$B$1) and copy down through A12.

By the way, if the formula throws you for a loop, you can think
of this as a savings account where you start with 750000 at
the start of the 1st month and it grows to 1500000 by the
start of the 12th month. Then the monthly growth rate can
be computed by RATE(11,,-750000,1500000).

The linear growth rate (change per month) is
(1500000-750000)/11. If that formula is in B1 and 7500000
is in A1, then A2 would be A1+$B$1 and copy down through
A12.

Beware of rounding. It will cause a small error in the final
month. Well, in every month. But you might not notice
until you see that the 12th month is not 1500000.