Skip to content
Google Sheets

PRICEMAT function in Google Sheets

Calculates the price of a security paying interest at maturity, based on expected yield.

=PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

PRICEMAT syntax and parameters

Six arguments, five required.

  • settlementanyRequired

    The settlement date of the security, the date after issuance when the security is delivered to the buyer.

  • maturityanyRequired

    The maturity or end date of the security, when it can be redeemed at face or par value.

  • issueanyRequired

    The date the security was initially issued.

  • ratenumberRequired

    The annualized rate of interest.

  • yieldnumberRequired

    The expected annual yield of the security.

  • day_count_conventionnumberOptional

    [ OPTIONAL - 0 by default ] - An indicator of what day count method to use. 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months. 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use. 2 indicates Actual/360 - This calculates based on the actual number of days between the specified dates, but assumes a 360 day year. 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year. 4 indicates European 30/360 - Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

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 Excel

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 Google Sheets gets this done.