Difference between revisions of "Manuals/calci/TBILLEQ"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TBILLEQ'''(SettlementDate, MaturityDate, Discount) where, '''SettlementDate '''- represents the Treasury b...") |
|||
| Line 1: | Line 1: | ||
| − | + | =TBILLEQ(SettlementDate, MaturityDate, Discount)= | |
| − | '' | + | where, |
| + | *<math>SettlementDate</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased) | ||
| + | *<math>MaturityDate</math> is the Treasury Bill's maturity date (a date when the Treasury Bill expires) | ||
| + | *<math>Discount</math> is the Treasury Bill's discount rate. | ||
| − | + | TBILLEQ() calculates the bond equivalent yield for a Treasury Bill. | |
| − | + | == Description == | |
| + | TBILLEQ(SettlementDate, MaturityDate, Discount) | ||
| − | '''MaturityDate''' - | + | *<math>SettlementDate</math> and <math>MaturityDate</math> should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message. |
| + | *If <math>SettlementDate</math> >= <math>MaturityDate</math>, Calci displays #N/A error message. | ||
| + | *<math>MaturityDate</math> should not be more than one year than that of <math>SettlementDate</math>. Else, Calci displays #N/A error message. | ||
| + | *If <math>Discount</math> <0, Calci displays #N/A error message. | ||
| + | *Formula: | ||
| + | If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLEQ is calculated as - | ||
| − | + | <math>TBILLEQ = \frac{(365 * Discount)}{(360 - (Discount * N))} | |
| − | + | == Examples == | |
| − | |||
| − | |||
| − | + | Consider the following example that shows the use of TBILLEQ function: | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 01/01/2010 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 11/20/2010 | |
| − | | class="sshl_f | ||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 5.85% | |
| − | | class="sshl_f | ||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" | + | | class="sshl_f" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
| − | < | + | =TBILLEQ(A1,A2,A3) : Calculates the bond equivalent yield for the Treasury Bill with values in the range A1 to A3. <br />Displays ''6.26%'' as a result. |
| − | + | =TBILLEQ(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the bond equivalent yield for the Treasury Bill with the mentioned values. Displays ''9.72%'' as a result. | |
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/TBILLPRICE | TBILLPRICE]] | ||
| + | *[[Manuals/calci/TBILLYIELD | TBILLYIELD]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Treasury_bill#Treasury_bill Treasury Bill] | ||
Revision as of 15:46, 28 February 2014
TBILLEQ(SettlementDate, MaturityDate, Discount)
where,
- is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
- is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
- is the Treasury Bill's discount rate.
is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
is the Treasury Bill's discount rate.TBILLEQ() calculates the bond equivalent yield for a Treasury Bill.
Description
TBILLEQ(SettlementDate, MaturityDate, Discount)
- and should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
- If >= , Calci displays #N/A error message.
- should not be more than one year than that of . Else, Calci displays #N/A error message.
- If <0, Calci displays #N/A error message.
- Formula:
If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLEQ is calculated as -
<math>TBILLEQ = \frac{(365 * Discount)}{(360 - (Discount * N))}
Examples
Consider the following example that shows the use of TBILLEQ function:
| 01/01/2010 | ||
| 11/20/2010 | ||
| 5.85% | ||
=TBILLEQ(A1,A2,A3) : Calculates the bond equivalent yield for the Treasury Bill with values in the range A1 to A3.
Displays 6.26% as a result. =TBILLEQ(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the bond equivalent yield for the Treasury Bill with the mentioned values. Displays 9.72% as a result.