I am trying to use XIRR to solve for the rate for a known schedule of dates
and value. That schedule is below. I have solved for the rate using IRR and
also a Goal Seek method to confirm the IRR. I have a spreadsheet to show all
this.

The answer per the IRR and the Goal Seek is -0.009270531%. I also confirmed
this on my HP-12C.

How does XIRR need to be set up to handle this sitation? This worksheet will
be updated monthly and I also need to calculate the ROR from inception, from
start of year, for the month.

Dates XIRR
12/31/2007 $61,445.04
1/7/2008 $4,062.21
2/6/2008 $4,062.02
3/6/2008 $3,921.48
3/31/2008 -$72,906.91
#NUM!