YIELDDISC Function in Google Sheets

Calculate the annual yield of a discounted security using the YIELDDISC function.

YIELDDISC Function

The YIELDDISC function in Google Sheets calculates the annual yield of a discounted security.

Syntax

YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
  • settlement: The settlement date of the security. This is a required parameter.
  • maturity: The maturity date of the security. This is a required parameter.
  • price: The price of the security. This is a required parameter.
  • redemption: The security’s redemption value per $100 face value. This is a required parameter.
  • day_count_convention: (Optional) The day-count convention to use. Default is 0 (actual/actual).

Examples

  1. Basic Calculation

Calculate the annual yield of a discounted security:

=YIELDDISC(DATE(2023,1,1), DATE(2023,12,31), 95, 100)

This will output the security’s annual yield.

Notes

  • The function is useful for calculating yields on Treasury bills and other discounted securities.
  • Ensure that the settlement date is before the maturity date.
  • YIELD: Calculate the annual yield of a bond.
  • YIELDMAT: Calculate the annual yield of a bond that pays interest at maturity.