PRICEDISC Function in Google Sheets

Calculate the price of a discounted security, such as a treasury bill, per $100 face value.

PRICEDISC Function

The PRICEDISC function in Google Sheets calculates the price per $100 face value of a discounted security, such as a treasury bill, based on its discount rate.

Syntax

PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
  • settlement: The security’s settlement date.
  • maturity: The security’s maturity date.
  • discount: The security’s discount rate.
  • redemption: The security’s redemption value per $100 face value.
  • day_count_convention: (Optional) The day count basis to use. Defaults to 0 (US (NASD) 30/360).

Examples

  1. Basic Discounted Security Price Calculation

Calculate the price of a treasury bill:

=PRICEDISC(DATE(2023, 1, 1), DATE(2023, 12, 31), 0.05, 100)

This will output 95.24.

Notes

  • The function is useful for calculating the price of zero-coupon bonds and treasury bills.
  • The result is a percentage of the face value.
  • PRICE: Calculate the price of a security with periodic interest payments.
  • YIELD: Calculate the yield of a security that pays periodic interest.