Difference between revisions of "Manuals/calci/TBILLPRICE"
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TBILLPRICE'''(SettlementDate, MaturityDate, Discount) where, '''SettlementDate '''- represents the Treasur...") |
(No difference)
|
Revision as of 20:45, 24 October 2013
TBILLPRICE(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 price per $100 face value for a Treasury bill.
Formula :-
TBILLEPRICE = 100 X (1-(Discount x N)/360)
where,
N - Number of days between settlement an maturity date.
If SettlementDate > MaturityDate, TBILLPRICE returns the #ERROR.
If Discount <= 0, it returns the #ERROR.
TBILLPRICE
Lets see an example in (Column1, Row1)
=TBILLPRICE(DATE(2008,1,1),DATE(2008,2,20),"5.85%")
TBILLPRICE returns 99.1875.
Consider an another example
=TBILLPRICE(DATE(DATE(2007/4/1),DATE(2008,5,1),"-4%")
It returns #ERROR(discount=-4%).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 99.1875 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
