SheetFX
≡
<< Go back to all functions

PRICEMAT

The PRICEMAT function in Google Sheets is a powerful tool to calculate the price of a security paying interest at maturity, based on expected yield. Whether you're analyzing investments, pricing bonds, or evaluating financial securities, the PRICEMAT function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

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

Parameters:

  • settlement: The settlement date of the security.
  • maturity: The maturity date of the security.
  • issue: The issue date of the security.
  • rate: The annual coupon rate of the security.
  • yield: The expected annual yield of the security.
  • [day_count_convention]: [Optional] The day count convention to use.

Step-by-Step Tutorial

  1. Using PRICEMAT with specific parameters:
    • Example: =PRICEMAT("01/01/2022", "01/01/2025", "01/01/2022", 0.05, 0.06, 0)
    • Result: 95.13

Use Cases and Scenarios

  1. Investment Analysis: Calculate the price of a bond based on expected yield.
  2. Financial Security Pricing: Determine the fair price of a security paying interest at maturity.

Related Functions

  • YIELD: Calculates the yield of a security paying periodic interest.
  • PRICE: Calculates the price of a security paying periodic interest.
  • COUPNCD: Calculates the next coupon date before the settlement date.
  • COUPDAYS: Calculates the number of days in the coupon period that contains the settlement date.

Related Articles