Formula Engine Reference Guide
 

 

Back to Class Index

 

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

Description
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