ACCRUED INTEREST (ACCRINT) Bug

[Keith]

I used the Following Data:

Copy Paste into Cell A1:

Data Description
11/30/2008 Issue date
5/31/2009 First interest date
6/26/2009 Settlement date
1.25% Coupon rate
1,000,000 Par value
2 Frequency is semiannual (see above)
1 Actual/Actual
0 CALC METHOD
Formula Description (Result)
=ACCRINT(A2,A3,A4,A5,A6,A7,A8,A9)
$7,142.86 MS answer

End Copy Paste section

The Real Answer is 887.98

The help file States "A value of FALSE (0) returns the accrued interest from
first_interest to settlement."

That is not the result of this formula.

 

[Fred Smith]

I agree it's returning the wrong value. It looks like it's ignoring the
final parameter -- it's assuming True regardless.

Regards,
Fred.

 

[Keith]

thanks. That is my interpretation as well.

I agree it's returning the wrong value. It looks like it's ignoring the
final parameter -- it's assuming True regardless.

Regards,
Fred.