Excel financial functions, e.g. IRR

[larryww]

I'm asking this here in order to AVOID having to write a VBA function! The task is to give a compounded rate of growth for the following sequence (which I'm artificially making symmetric to illustrate a point):

1000 1500 2250 3375

The user wants to say that he's averaged a 50% growth rate for the past 3 years.

Now the easy solution is just to enter the solutoin directly on the sheet, giving (3375-1000) ^ (1/3). However the desire is to have a general function foo(A,B,C) that returns (B-A) ^ (1/C).

So is that functionality already available, or do I have to give function foo?

The number of years (or periods) may vary, but all that's under control. I just want to know if there is a function for this compound growth rate.

 

[LittleSmudge]

Excel certainly has an IRR function but Im not sure that want you want is IRR

For a compound growth rate over a given number of years you need to know the first and last value and the number of years in between.

You don't need to know the intermediate values. So its

[ ( FinalValue / InitialValue ) ^ 1/Years ] - 1 as a decimal and the div 100 to get a %


G LS

 

[larryww]

Thanks for responding. I guess I wasn't clear in the original question. I have the formula. I know A,B, and C as I described. I just want to know if there is a built-in. IOW ...
1. The V.P. of Finance doesn't want to have to use exponentiation - he just wants to go FOO(startval,endval,periods).
2. The bastion of peonism (me) doesn't want to use code if the function already exists.

IRR, MIRR, XIRR, RATE, and others that I checked don't seem to be the right ones.

It's such a trivial financial calculation that I'd really expect there to be a builtin for it. Anyone know?