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?