TBILLEQ

TBILLEQ ( settlement , maturity , discount )

Description: Computes the bond-equivalent yield for a U.S. Treasury bill.

Arguments:

Name	Type	Description
settlement	number	The Treasury bill's settlement date. Any time information in the date is ignored.
maturity	number	The Treasury bill's maturity date. Any time information in the date is ignored.
discount	number	The Treasury bill's discount rate.

Return Type and Value: number – The bond-equivalent yield for a U.S. Treasury bill.

However, if

settlement or maturity is out of range for the current date base value, #NUM! is returned.
settlement > maturity, #NUM! is returned.
maturity is more than one year after settlement, #NUM! is returned.
discount ≤ 0, #NUM! is returned.

example: