On Mon, 7 Jan 2008 14:40:47 -0700, "Carl LaFong" wrote:

The dates are the dates of each interim addition to the account during that
particular quarter. The values are the account values on those dates, as
reported by my broker. For instance, on Feb 24, I might have added $400 to
the account and the broker reports an account value on that date of
$11.099.87. (those are just examples, not the actual figures)

This may be the problem.

For XIRR, the dates should be as you write -- the dates of each interim
addition to the account.

BUT, the Values should be the AMOUNT of the ADDITIONS. Not the account value
on that date.

Your table should look something like:

Column
A B

Dates Value

Start Value of Account
Add'n1 Amount of first addition
Add'n2 Amount of second addition
Add'n3 Amount of third addition
Withdr1 Amount of 1st withdrawal as a negative number
.... ...
End Value of Account at end of period AS A NEGATIVE NUMBER


--ron