Difference between revisions of "Manuals/calci/TBILLPRICE"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | = | + | <div style="font-size:30px">'''TBILLPRICE (Settlement,Maturity,Discount)'''</div><br/> |
| − | |||
where, | where, | ||
| − | *<math> | + | *<math>Settlement</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased) |
| − | *<math> | + | *<math>Maturity</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. | *<math>Discount</math> is the Treasury Bill's discount rate. | ||
| − | + | **TBILLPRICE(), returns the price per $100 face value for a Treasury bill. | |
| − | |||
== Description == | == Description == | ||
| − | + | TBILLPRICE (Settlement,Maturity,Discount) | |
| − | *<math> | + | *<math>Settlement</math> and <math>Maturity</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> | + | *If <math>SettlementDate</math> >= <math>Maturity</math>, Calci displays #N/A error message. |
| − | *<math> | + | *<math>Maturity</math> should not be greater than one year from <math>Settlement</math>. Else, Calci displays #N/A error message. |
*If <math>Discount</math> <=0, Calci displays #N/A error message. | *If <math>Discount</math> <=0, Calci displays #N/A error message. | ||
*Formula: | *Formula: | ||
If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLPRICE is calculated as - | If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLPRICE is calculated as - | ||
| − | <math>TBILLPRICE = 100 * (1 - \frac{(Discount * N | + | <math>TBILLPRICE = 100 * (1 - \frac{(Discount * N)}{360}) </math> |
== Examples == | == Examples == | ||
| Line 50: | Line 48: | ||
=TBILLPRICE(A1,A2,A3) : Calculates the price for the Treasury Bill with values in the range A1 to A3. <br />Displays '''94.75125''' as a result. | =TBILLPRICE(A1,A2,A3) : Calculates the price for the Treasury Bill with values in the range A1 to A3. <br />Displays '''94.75125''' as a result. | ||
=TBILLPRICE(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the price for the Treasury Bill with <br />the mentioned values. Displays '''93.925''' as a result. | =TBILLPRICE(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the price for the Treasury Bill with <br />the mentioned values. Displays '''93.925''' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=OdEI6TMOz78|280|center|TBILLPRICE}} | ||
== See Also == | == See Also == | ||
| Line 59: | Line 61: | ||
*[http://en.wikipedia.org/wiki/Treasury_bill#Treasury_bill Treasury Bill] | *[http://en.wikipedia.org/wiki/Treasury_bill#Treasury_bill Treasury Bill] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15:16, 16 November 2018
TBILLPRICE (Settlement,Maturity,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.
- TBILLPRICE(), returns the price per $100 face value for a Treasury bill.
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.
Description
TBILLPRICE (Settlement,Maturity,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 greater than one year from . 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 TBILLPRICE is calculated as -
Examples
Consider the following example that shows the use of TBILLPRICE function:
| 01/01/2010 | ||
| 11/20/2010 | ||
| 5.85% | ||
=TBILLPRICE(A1,A2,A3) : Calculates the price for the Treasury Bill with values in the range A1 to A3.
Displays 94.75125 as a result. =TBILLPRICE(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the price for the Treasury Bill with
the mentioned values. Displays 93.925 as a result.
Related Videos
See Also
References