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 :)
|