Manuals/calci/TBILLEQ
TBILLEQ(SettlementDate, MaturityDate, Discount)
where,
SettlementDate - represents the Treasury bill's settlement date.
MaturityDate - represents the Treasury bill's maturity date.
Discount - represents the Treasury bill's discount rate
It returns the bond-equivalent yield for a Treasury bill.
Formula :-
TBILLEQ = (365 x Discount)/(360-(Discount x N))
where,
N - Number of days between settlement an maturity date.
If SettlementDate > MaturityDate, TBILLEQ returns the #ERROR.
If Discount <= 0, it returns the #ERROR.
TBILLEQ
Lets see an example in (Column1, Row1)
=TBILLEQ(DATE(2008,1,1),DATE(2008,2,20),"5.85%")
TBILLEQ returns 0.059798.
Consider an another example
=TBILLEQ(DATE(DATE(2007/4/1),DATE(2008,5,1),"-4%")
It returns #ERROR(discount=-4%).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 0.059798 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
