Skip to content
Excel

YIELDDISC function in Excel

Returns the annual yield for a discounted security; for example, a Treasury bill

=YIELDDISC(settlement, maturity, pr, redemption, [basis])

YIELDDISC syntax and parameters

Five arguments, four required.

  • settlementnumberRequired

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

  • maturitynumberRequired

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

  • prnumberRequired

    The security's price per $100 face value.

  • redemptionnumberRequired

    The security's redemption value per $100 face value.

  • basisnumberOptional

    The type of day count basis to use.

YIELDDISC examples

Formulas you'll actually reuse.

  1. The annual yield of a discounted security bought at 98.8625:

    =YIELDDISC(DATE(2026, 3, 15), DATE(2026, 6, 14), 98.8625, 100, 2)

    Result0.0455

  2. Compare against the target yield in F2:

    =IF(YIELDDISC(B2, C2, D2, 100, 2) > F2, "Buy", "Skip")

YIELDDISC in Google Sheets

Same name — your formula ports as-is.

Try YIELDDISC in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.