Skip to content
Excel

PRICEMAT function in Excel

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

=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])

PRICEMAT syntax and parameters

Six arguments, five required.

  • settlementanyRequired

    The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

  • maturityanyRequired

    The security's maturity date. The maturity date is the date when the security expires.

  • issuenumberRequired

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

  • ratenumberRequired

    The security's interest rate at date of issue.

  • yldnumberRequired

    The security's annual yield.

  • basisnumberOptional

    The type of day count basis to use.

PRICEMAT examples

Formulas you'll actually reuse.

  1. Price of a one-year note that pays its 4% interest at maturity, bought to yield 3.5%:

    =PRICEMAT(DATE(2026, 3, 15), DATE(2027, 1, 15), DATE(2026, 1, 15), 4%, 3.5%, 0)

    Result100.386

  2. What $10,000 face of it costs, from cells:

    =PRICEMAT(B2, C2, D2, E2, F2) * 10000 / 100

PRICEMAT in Google Sheets

Same name — your formula ports as-is.

Try PRICEMAT in the playground

Edit the example — nothing to install.

Preloaded with the PRICEMAT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.