TBILLEQ function

TBILLEQ(SettlementDate, MaturityDate, DiscountRate) TBILLEQ(SettlementDate; MaturityDate; DiscountRate)

SettlementDate

Number or { Number }

The settlement (purchase) date of the US Treasury bill.

MaturityDate

Number or { Number }

The maturity (redemption) date of the US Treasury bill.

DiscountRate

Number or { Number }

The discount rate of the US Treasury bill.

Returns

Number or { Number }

The bond-equivalent-yield (BEY) for a US Treasury bill.

Returns the bond-equivalent-yield (BEY) for a US Treasury bill.

Example

TBILLEQ(DATE(2008, 1, 1), DATE(2008, 5, 1), 8%)TBILLEQ(DATE(2008; 1; 1); DATE(2008; 5; 1); 8%)

Returns a bond-equivalent yield (BEY) of roughly 8.3%, where January 1, 2008, is the settlement date, May 1, 2008, is the maturity date and 8% is the discount rate.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.