View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
my
 
Posts: n/a
Default monthly growth rate

Thanks. Greatly appreciate it!

But, is there a more methodical approach to solve it rather than the short
cut?



"Gary''s Student" wrote:

Use 11.57%

In A1 enter 750000
in A2 enter:
=A1*(1+$B$1) and copy down
In B1 enter say .01 and then pull-down:
Tools Goal seek... and request A12 be 2500000 by setting B1
Goal seek should prodect the following in column A:

750,000.00
836,749.95
933,533.97
1,041,512.67
1,161,980.90
1,296,383.28
1,446,331.52
1,613,623.77
1,800,266.15
2,008,496.81
2,240,812.80
2,500,000.00



--
Gary's Student


"my" wrote:

Hi,

Not sure how relevant this is... but 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?

Thanks in advance :)