How to use the TBILLEQ function
The TBILLPRICE function calculates the equivalent bond yield for a Treasury bill.
Formula in cell C6:
Excel Function Syntax
TBILLEQ(settlement, maturity, discount)
Arguments
settlement | Required. The Treasury bill's settlement date which is the date after the issue date. |
maturity | Required. The date when the security expires. |
discount | Required. The Treasury bill's discount rate. |
Comments
Treasury bills are issued at a discount from the face value, the interest paid is the face value - purchase price.
Keep in mind to use the DATE function if you enter dates in the function instead of using cell references.
For example,
Date arguments are truncated to integers.
The TBILLEQ function returns:
- #VALUE! error if settlement or maturity is not a valid data type.
- #NUM! error if
- discount <=0 (zero)
- settlement > maturity, or if maturity is more than a year after the settlement
Calculation formula:
TBILLEQ = (365 * rate)/(360-(rate*DSM))
DSM = days between settlement to maturity ignoring maturity date that is more than a year after settlement.
Functions in this article
More than 1300 Excel formulas
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.