It is solving for the rate of return. Rate is the result, not an input
item. In my note I asked if anyone knew of a formula providing the result
but listed under another name in the included worksheet functions.

Here is an example of how the rate would be calculated.
Say you made a single investment in some sort of fund, etc. The first year
showed a gain of 5%, the second -3%, fourth +25%, fifth + 6.8%, etc. etc.
What I am looking for is the average annual rate of return over the period
of time.

No one has answered the question so far.
"J Sedoff comRemove" <RemoveSageoficar,at,RemoveHotmail<dot wrote in
message ...
What is the CAGR formula (I don't believe I've heard of it before)? Have
you
looked at the formulas provided under the "Financial" category in the
"Insert
Function" window?

Is it something like the following?
ISPMT(rate,per,nper,pv)

- Rate is the interest rate for the investment.
- Per is the period for which you want to find the interest, and must
be
between 1 and nper.
- Nper is the total number of payment periods for the investment.
- Pv is the present value of the investment. For a loan, pv is the loan
amount.

Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes"
I/someone else did answer your question. Thank you.