TBILLPRICE (SettlementDate, MaturityDate, DiscountRate) TBILLPRICE (SettlementDate; MaturityDate; DiscountRate)

SettlementDate

Temporal Temporal

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

MaturityDate

Temporal Temporal

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

DiscountRate

Number Number

The discount rate of the US Treasury bill.

Returns

Number Number

The issue price for a US Treasury bill.

Returns the price per $100 face value of a US Treasury bill, given its discount rate. Use TBILLYIELD to perform the reverse calculation.

Example

TBILLPRICE ( DATE (2010, 3, 15), DATE (2010, 9, 15), 5 % )
TBILLPRICE ( DATE (2010; 3; 15); DATE (2010; 9; 15); 5 % )

Returns roughly $97.44 for a Treasury bill purchased on March 15, 2010, maturing on September 15, 2010, with a discount rate of 5%.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell