TBILLYIELD function

The TBILLYIELD function is one of the financial functions. It is used to calculate the yield of a Treasury bill.

Syntax

TBILLYIELD(settlement, maturity, pr)

The TBILLYIELD function has the following arguments:

Argument	Description
settlement	The date when the Treasury bill is purchased.
maturity	The date when the Treasury bill expires. This date must be within one year of the settlement date.
pr	The purchase price of the Treasury bill, per $100 par value.

Notes

Dates must be entered by using the DATE function.

How to apply the TBILLYIELD function.

Examples

The figure below displays the result returned by the TBILLYIELD function.