This is what I ended up doing, but I thought maybe there was a function that
peformed that. Thanks.


"Tiro" wrote:

Simple. Compute the rate of return for the first quarter, use this as input
to the second quarter, compute the return, etc. Simple math with do.

"Biff" wrote in message
...
I am trying to take returns for each quarter of a year and calculate the
compounded return for the year. I tried using the XIRR function, but that
isn't returning me a correct value. I think it wants to use the actual
value
in the equation, not the returns for each of those periods. Can anyone
help?