On Wed, 1 Mar 2006 15:55:27 -0800, "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 :)


I don't think there's an Excel Financial function, but the basic
formula to calculate the periodic compound interest rate is:

1 - (FV/PV) ^ (1/n)

where PV = Present Value, FV = Future Value and n = number of periods.
Slotting your numbers in we get

1 - (1500000/750000) ^ (1/12) = .059463094 %

HTH




Richard Buttrey
__