Author: Oscar Cronquist Article last updated on December 07, 2018

The TBILLYIELD function calculates the yield for a Treasury bill.

Formula in cell C6:

=TBILLYIELD(C2,C3,C4)

Excel Function Syntax

TBILLYIELD(settlement, maturity, pr)

Arguments

settlement Required. The Treasury bill's settlement date which is the date after the issue date.
maturity Required. The date when the security expires.
pr Required. The Treasury bill's price per $100 face value (par amount).

Comments

Treasury bills are issued at a discount from the face value, the interest paid is the face value - purchase price.

Keep in mind to use the DATE function if you enter dates in the function instead of using cell references.

For example,

=TBILLYIELD(DATE(2018, 9, 30), DATE(2018, 12, 31), C4)

Date arguments are truncated to integers.

The TBILLYIELD function returns:

  • #VALUE! error if settlement or maturity is not a valid data type.
  • #NUM! error if pr <=0'

Calculation formula:

DSM = days between settlement to maturity ignoring maturity date that is more than a year after settlement.