PRICEMAT

PRICEMAT(arg1, arg2, arg3, arg4, arg5, arg6) → { number | string | boolean }

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

Parameters:

Name Type Description
arg1 any

Is the security's settlement date, expressed as a serial date number.

arg2 any

Is the security's maturity date, expressed as a serial date number.

arg3 any

Is the security's issue date, expressed as a serial date number.

arg4 any

Is the security's interest rate at date of issue.

arg5 any

Is the security's annual yield.

arg6 any

Is the type of day count basis to use.

Returns:

Type
number | string | boolean