Manuals/calci/TBILLYIELD
TBILLYIELD(SettlementDate, MaturityDate, Price)
where,
SettlementDate - represents the Treasury bill's settlement date.
MaturityDate - represents the Treasury bill's maturity date.
Price - represents the Treasury bill's price per $100 face value.
It returns the yield for a Treasury bill.
Formula :-
TBILLYIELD = ((100-Price)/Price) X (360 x N)
where,
N - Number of days between settlement an maturity date.
If SettlementDate >= MaturityDate, TBILLYIELD returns the #ERROR.
If Price <= 0, it returns the #ERROR.
TBILLYIELD
Lets see an example in (Column1, Row1)
=TBILLYIELD(DATE(2008,1,1),DATE(2008,2,20),55.85)
TBILLYIELD returns 5.691674.
Consider an another example
=TBILLYIELD(DATE(DATE(2007/4/1),DATE(2008,5,1),-4)
It returns #ERROR(Price =-4).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5.691674 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
