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.
TBILLEQ (settlement, maturity, discount)
– 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.
– Function TBILLEQ Perform calculations according to the following formula:
– 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%.
Step 1: In the cell to calculate bond profits -> you enter the formula: = TBILLEQ (A3, B3, C3)
Step 2: Press Enter -> Bond yield with a discount rate of 8.5% would be:
If you enter the due date greater than 1 year from the settlement date ->, the function returns an error value #NUM!
Where if Settlement and Maturity (settlement and due dates) are not valid dates -> the function will return the error value #VALUE!
The next case if Discount ≤ 0 -> function returns error value #NUM!
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!