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 datetime value.

 

S

The settlement date, a datetime value.

 

R

The annual coupon rate.

 

P

The par value of the security.

 

B

(Optional)  The day count basis to be used:

 

 

 

Examples

 

ACCRINTM(C6, C7, C8.C9, C10) = 39.3442

Where C6 = 02/03/92, C7 = 07/12/92, C8 = 9%, C9 = 1000 and C10 = 1.