Buzz
This article provides a detailed guide on the meaning and usage of the TBILLEQ function, which calculates the profit corresponding to bonds in Excel Treasury.
Description: The function calculates the profit corresponding to bonds in Excel Treasury.
Syntax: = TBILLEQ(settlement, maturity, discount).
Wherein:
- settlement: Securities settlement date is the day after the issuance date of securities sold to the buyer, which is a required parameter.
- maturity: The maturity date or redemption date of securities, which is a required parameter.
- discount: The discount rate of securities.
Important Note:
- The function TBILLEQ() computes according to the formula:
- Prefer using the Date function (year, month, day) while entering date values.
- If invalid, the function returns the error value #VALUE!
- If discount ≤ 0, the function returns the error value #VALUE!
- If settlement > maturity or settlement – maturity > 12 months, the function returns the error value #NUM!
Example:
Calculate the profit of a bond given the settlement date is 1/1/2016, the maturity date is 1/12/2016, and the discount rate is 8.9%.
Enter the formula =TBILLEQ(B6,C6,D6) into the cell where you want to calculate bond yield.
Press Enter to compute the bond yield with a discount rate of 8.9%:
If the maturity date is more than 1 year later than the settlement date, the function returns the error value #NUM!
Above is the usage and some special cases of the TBILLEQ function, hoping it will be helpful for you.
Wishing you all success!
