[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

PRICEMAT

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

Syntax

PRICEMAT(settle, mature, issue, rate, yield, [basis])

Arguments

This function has these arguments:

Argument

Description

settle

[Required] Settlement date for the security

mature

[Required] Maturity date for the security

issue

[Required] Issue date for the security

rate

[Required] Interest rate for the security at the issue date

yield

[Required] Annual yield for the security

basis

[Optional] Integer representing the basis for day count

Remarks

This function returns a #VALUE! error when settle, mature, or issue is invalid. Settle, mature, issue, and basis are truncated to integers.

The function returns an error in the following cases:

  • If rate or yield is less than 0, a #NUM! error is returned.

  • If basis is less than 0 or greater than 4, a #NUM! error is returned.

  • If settle is greater than or equal to mature, a #NUM! error is returned.

Examples

PRICEMAT(A1,A2,A5,A7,A7,1)

PRICEMAT(R1C1,R2C1,R5C5,R5C7,R5C9,2)

PRICEMAT("5/15/2004","9/1/2004","5/15/2003",0.06,0.07,3) gives the result 99.5842915904314