On Jul 26, 5:24 pm, Biff wrote:
Here is my example that you might be able to help me out.
Q1 return - 3%
Q2 return - 2%
Q3 return - (1.5%)
Q4 return - 1%
Simply adding the returns for each quarter together doesn't provide an
accurate yearly return because it doesn't take into consideration the
quarterly compounding as in this example.

Of course; perish the thought! Who said anything about "simply
adding" returns?

Without more data than this, is
there way to calculate the compound rate of return for the year.

There are several ways. For example, enter the following as an array
formula (commit with ctl-shift-Enter, not just Enter):

=geomean(1+Q1:Q4)^4 - 1

I use that form to demonstrate the general paradigm for annualizing
quarterly data. However, in the case above where you have exactly 4
quarters of data, you could get the same answer with the following
array formula:

=product(1+Q1:Q4) - 1

Note that I am using "Q1" etc as cell references.

FYI, you cannot use XIRR() with only the data above. You could use
the above information to synthesize data that would work with XIRR().
But why bother, when there are much simpler and more direct ways to do
the computation, as demonstrated.

Hope this helps. If not, keep posting unapologetically.