TBillYield

Syntax

TBillYield(Settlement, Maturity, Price)

Parameters

Settlement. The treasury bill's settlement date.

Maturity. Maturity date for the treasury bill.

Price. The price per $100 face value for a treasury bill. Value of this parameter must be greater than zero.

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

Description

It returns the income 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
=TBillYield("01.01.2007", "01.09.2008", 87.79) 0,08

Treasury bill income based on the following terms:

  • The settlement date is 01.01.2007.

  • The maturity date is 01.09.2008.

  • The price is 87.79.
=TBillYield(A0, B0, C0) 1,45

Treasury bill income based on the following terms:

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

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

  • The price is specified in the C0 cell, value is 47.6.

See also:

Function Wizard │ Financial Functions │ TBillEq │ TBillPrice