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. |
ACCRUED INTEREST (ACCRINT) Bug
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" wrote in message ... 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. |
ACCRUED INTEREST (ACCRINT) Bug
thanks. That is my interpretation as well.
"Fred Smith" wrote: 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" wrote in message ... 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. |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com