TBILLEQ function - Calculates the returns corresponding to bonds in treasury in Excel

The following article details the meaning and usage of TBILLEQ function - Calculate the profit corresponding to bonds in the treasury.

Description: The function calculates the returns corresponding to bonds in the treasury.

Syntax : = TBILLEQ (settlement, maturity, discount) .

Inside:

- settlement : The settlement date of the securities is the date after the issue date of securities to be sold to buyers, which is a required parameter.

- maturity : The maturity or maturity date of a security, which is a mandatory parameter.

- discount : Discount rate of the stock.

Attention:

- TBILLEQ function () performs calculations according to the following formula:

- Use the Date function (year, month, day) when entering date values.

- If and invalid function returns error value #VALUE!

- If discount ≤ 0 -> the function returns the #VALUE! Error value

- If settlement> maturity or settlement - maturity> 12 months -> the function returns the #NUM! Error value

For example:

Calculate the profit of the bond knowing the settlement date is 1/1/2016, the maturity date is 1/12/2016 and the discount rate is 8.9%.

TBILLEQ function - Calculates the returns corresponding to bonds in treasury in Excel Picture 1

In the cell to calculate the bond yield enter the formula: = TBILLEQ (B6, C6, D6) .

TBILLEQ function - Calculates the returns corresponding to bonds in treasury in Excel Picture 2

Press Enter -> Bond yield with a discount rate of 8.9% is:

TBILLEQ function - Calculates the returns corresponding to bonds in treasury in Excel Picture 3

If you enter the due date greater than 1 year from the settlement date -> the function returns the #NUM! Error value.

TBILLEQ function - Calculates the returns corresponding to bonds in treasury in Excel Picture 4

The above is a usage and some special cases of TBILLEQ function hope to help you.

Good luck!