TBillPrice

Syntax

TBillPrice(Settlement, Maturity, Discount)

Parameters

Settlement. The treasury bill's settlement date.

Maturity. Maturity date for the treasury bill.

Discount. Discount for a treasurer's bill.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the price per $100 face value for a treasury bill.

Comments

The Settlement parameter value should not be less or equal to the Maturity parameter value.

The function is calculated according to the following formula:

,

where:

Example

Formula Result Description
=TBillPrice("01.01.2007", "01.09.2008", 0.05) 91,45

The price per $100 face value for a treasury bill based on the following conditions:

  • The settlement date is 01.01.2007.

  • The maturity date is 01.09.2008.

  • The discount is 0.05.
=TBillPrice(A0, B0, C0) 62,08

The price per $100 face value for a treasury bill based on the following conditions:

  • The calculation date is specified in the A0 cell, value is 01.01.2007.

  • The maturity date is specified in the B0 cell, value is 01.10.2007.

  • The discount is specified in the C0 cell, value is 0.5.

See also:

Function Wizard │ Financial Functions │ TBillEq │ TBillYield