writer
2,661
edits
Changes
Manuals/calci/TBILLEQ (view source)
Revision as of 21:49, 28 February 2014
, 21:49, 28 February 2014no edit summary
*<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>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.
*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.
*<math>MaturityDate</math> should not be greater than one year from <math>SettlementDate</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 TBILLEQ is calculated as -
If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLEQ is calculated as -
<math>TBILLEQ = \frac{(365 * Discount)}{(360 - (Discount * N))}
<math>TBILLEQ = \frac{(365 * Discount)}{(360 - (Discount * N))}</math>
== Examples ==
== Examples ==
|}
|}
=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(A1,A2,A3) : Calculates the bond equivalent yield for the Treasury Bill for 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.
=TBILLEQ(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the bond equivalent yield <br />for the Treasury Bill for mentioned values. Displays '''9.72%''' as a result.
== See Also ==
== See Also ==