Back to Class Index
ACCRINTM(I, S, R, P [, B])This function returns the accrued interest for a security that pays interest at maturity. Parameters I The issue date, a date/time value S The settlement date, a date/time value R The annual coupon rate P The par value of the security B (Optional) the day count basis to be used: 0 or omitted 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 Example ACCRINTM(C6, C7, C8.C9, C10) = 39.3442 where C6 = 02/03/92, C7 = 07/12/92, C8 = 9%, C9 = 1000 and C10 = 1 |