next up previous contents index
Next: ACOS Up: A. Function Reference Previous: ACCRINT   Contents   Index


ACCRINTM

Syntax: ACCRINTM(I, S, R, P [, B])

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

ACCRINTM returns the accrued interest for a security that pays interest at maturity.

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

Excel function: N/A


next up previous contents index
Next: ACOS Up: A. Function Reference Previous: ACCRINT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003