Difference between revisions of "Manuals/calci/TBILLYIELD"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TBILLYIELD'''(SettlementDate, MaturityDate, Price) where, '''SettlementDate '''- represents the Treasury b...") |
|||
| Line 1: | Line 1: | ||
| − | + | =TBILLYIELD(SettlementDate, MaturityDate, Price)= | |
| − | '' | + | 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>Price</math> is the Treasury Bill's price per $100 face value. | ||
| − | + | TBILLYIELD() calculates the yield for a Treasury Bill. | |
| − | + | == Description == | |
| + | TBILLYIELD(SettlementDate, MaturityDate, Price) | ||
| − | '''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>Price</math> <=0, Calci displays #N/A error message. | ||
| + | *Formula: | ||
| + | If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLYIELD is calculated as - | ||
| − | + | <math>TBILLYIELD = \frac{(100 - Price)}{Price} * \frac{360}{N}</math> | |
| − | + | == Examples == | |
| − | |||
| − | |||
| − | + | Consider the following example that shows the use of TBILLYIELD 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" | | ||
| class=" " | | | class=" " | | ||
| − | | | + | | class=" " | |
| − | + | ||
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | |
| − | | class=" | + | | class=" " | |
| − | | | + | | class=" " | |
| − | | | + | |
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | |
| − | | class=" | + | | class=" " | |
| − | + | | class=" " | | |
| − | + | ||
| − | | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | | |
| − | | class="sshl_f | + | | class=" " | |
| − | | | + | | class=" " | |
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | | class=" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | < | + | <font color ="Red">Need to add examples after next release</font> |
| − | + | ||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/TBILLEQ | TBILLEQ]] | ||
| + | *[[Manuals/calci/TBILLPRICE | TBILLPRICE]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Treasury_bill#Treasury_bill Treasury Bill] | ||
Revision as of 17:29, 28 February 2014
TBILLYIELD(SettlementDate, MaturityDate, Price)
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 price per $100 face value.
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 price per $100 face value.TBILLYIELD() calculates the yield for a Treasury Bill.
Description
TBILLYIELD(SettlementDate, MaturityDate, Price)
- 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 TBILLYIELD is calculated as -
Examples
Consider the following example that shows the use of TBILLYIELD function: