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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999