TBILLPRICE function

TBILLPRICE(SettlementDate, MaturityDate, DiscountRate) TBILLPRICE(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 issue price for a US Treasury bill.

Returns the issue price for a US Treasury bill, per $100 face value, given a discount rate.

Example

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

Returns roughly $97.33, which is the price of a Treasury Bill with a settlement date of January 1, 2008, a maturity date of May 1, 2008 and a discount rate of 8%.

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