PRICEMAT(S, M, I, R, Y [, B])

 

Description

This function returns the price per $100 face value of a security that pays interest at maturity.

 

Parameters

 

S

Settlement date.

 

M

Maturity date.

 

I

Issue date.

 

R

Annual coupon rate of the security.

 

Y

Annual yield of the security.

 

B

(Optional.)  The day count basis to be used:

 

 

Examples

 

PRICEMAT(DATE(93, 3, 1), DATE(93, 6, 15), DATE(92, 11, 1), 6.5%, 0) = 101.8778