XIRR Function

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

I'm trying to calculate the IRR for a project using the
XIRR function, but all I get is #NUM for the answer. Any
ideas?

=XIRR({-539300,-98300,29184,-94861,-202050,-139550,-
172665,4466,1746700},
{"1/31/04,2/28/04,3/31/04,4/30/04,5/31/04,6/30/04,7/31/04,8
/31/04,9/30/04"},0.1)
 
Darren,

I believe you need " "s around each date, instead of the entire date range.

It may be easier if you entered the cashflow and date values into a range
and referenced the range.

PC
 
Back
Top