WorksheetFunction.AccrIntM (Excel)

Returns the accrued interest for a security that pays interest at maturity.

AccrIntM (Arg1, Arg2, ..., Arg5)

Dim dblAccrIntM As Double
dblAccrIntM = WorksheetFunction.AccrIntM(Arg1:=, Arg2:=, Arg3:=, Arg4:=)

Arguments

Arg1 - The security's issue date

Arg2 - The security's maturity date

Arg3 - The security's annual coupon rate

Arg4 - The security's par value. If you omit par, ACCRINTM uses $1,000

Arg5 - The type of day count basis to use