View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keith Keith is offline
external usenet poster
 
Posts: 262
Default ACCRUED INTEREST (ACCRINT) Bug

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.