TBILLEQ function in Excel


In Excel, there are quite a lot of calculation functions, serving in fields such as statistics, mathematics, securities, treasury … And the TBILLEQ function in Excel is one of the functions used by many users to calculate relative profits. with treasury bonds.


In the article below Taimienphi.vn would like to introduce to readers TBILLEQ function in Excel, this is a function that helps you calculate the return corresponding to the treasury bonds.

TBILLEQ function in Excel

How to use TBILLEQ Function in Excel

1. Description and syntax used

This is the function that calculates the profits corresponding to bonds in the treasury.

Syntax:

TBILLEQ (settlement, maturity, discount)

Inside:

Settlement: Securities settlement date is the date after the issue date of securities sold to buyers, which is a required parameter.

Maturity: Stock expiry or maturity date, which is a required parameter.

Discount: Discount rate of the security.

Attention:

– Function TBILLEQ Perform calculations according to the following formula:

ham tbilleq in excel 2

– Should use functions Date (year, month, day) when entering date values.

– If Settlement and Maturity is not valid dates -> the function will return the error value #VALUE!

– If Discount ≤ 0 -> function returns error value #NUM!

– If Settlement> Maturity or Settlement – Maturity> 12 months -> function returns error value #NUM!

2. Examples of specific situations

Let’s say you need to calculate the yield of a bond knowing the settlement date is January 1, 2018, the maturity date is December 1, 2018, and the discount rate is 8.5%.

ham tbilleq in excel 3

Step 1: In the cell to calculate bond profits -> you enter the formula: = TBILLEQ (A3, B3, C3)

ham tbilleq in excel 4

Step 2: Press Enter -> Bond yield with a discount rate of 8.5% would be:

ham tbilleq in excel 5

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

ham tbilleq in excel 6

Where if Settlement and Maturity (settlement and due dates) are not valid dates -> the function will return the error value #VALUE!

ham tbilleq in excel 7

The next case if Discount ≤ 0 -> function returns error value #NUM!

ham tbilleq in excel 8

https://thuthuat.taimienphi.vn/ham-tbilleq-trong-excel-43739n.aspx
Above is the usage and some special cases of TBILLEQ function in Excel. Using this calculation function helps you calculate the profits corresponding to bonds in the treasury. Good luck!

.

Add a Comment

Your email address will not be published. Required fields are marked *