Calculating the "Compound Annual Growth Rate".

[jjay]

I am trying to calculate the Compound Annual Growth Rate. I know what the forumla is (see link below), but cannot work out how to do this calculation within Cold Fusion... which functions to use nor how to string them together.

Was hoping someone with a bit more experience with CFs mathematical functions could help.

The formula I am trying to calculate within CF can be found at: http://www.investopedia.com/terms/c/cagr.asp

Many thanks in advance to the genius that can help me crack this one.

Cheers

[Stressed_Simon · Accepted solution]

<cfset partOne = endingValue / beginningValue>
<cfset partTwo = 1 / numberOfYears>
<cfset compoundAnnualGrowthRate = (partOne ^ partTwo) - 1>

Hope that makes sense!

[jjay]

Simon, your a champ. Works perfectly. Many Thanks !!