Tbillprice (T-Bill Price)

Returns the price of a treasury bill per $100 of face value.

Syntax

Tbillprice(Settlement, Maturity, Discount)

Where:

Settlement is the settlement date. This is the date on which the treasury bill is purchased.

Maturity is the maturity date. This is the date on which the treasury bill expires.

Discount is the discount rate.

Expression

Where:

DSM is the number of days from settlement to maturity.

This excludes any maturity date that is more than one calendar year past Settlement.

Usage Notes

If Settlement or Maturity is not an integer, it is truncated.

The engine returns an empty cell if:

• Either Settlement or Maturity is not a valid date
• Discount £ 0
• Settlement > Maturity
• Maturity is more than one year after Settlement

The Settlement date and the Maturity date should be included within single quotations in the expression for the expression to be considered as a valid expression.