writer
6,694
edits
Changes
Manuals/calci/TBILLPRICE (view source)
Revision as of 21:16, 16 November 2018
, 21:16, 16 November 2018→Related Videos
=TBILLEQ(SettlementDate, MaturityDate, Discount)=
<div style="font-size:30px">'''TBILLPRICE (Settlement,Maturity,Discount)'''</div><br/>
where,
where,
*<math>SettlementDate</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
*<math>Settlement</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>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>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.
*<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>MaturityDate</math>, Calci displays #N/A error message.
*If <math>SettlementDate</math> >= <math>Maturity</math>, Calci displays #N/A error message.
*<math>MaturityDate</math> should not be greater than one year from <math>SettlementDate</math>. Else, Calci displays #N/A error message.
*<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))}{360}) </math>
<math>TBILLPRICE = 100 * (1 - \frac{(Discount * N)}{360}) </math>
== Examples ==
== Examples ==
=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 ==
*[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 ]]