Manuals/calci/TBILLEQ - Revision history

Devika: /* Related Videos */

2018-11-19T19:33:17Z

Devika at 22:24, 22 August 2018

2018-08-22T22:24:40Z

Devika at 21:55, 27 July 2018

2018-07-27T21:55:06Z

Devika at 21:54, 27 July 2018

2018-07-27T21:54:55Z

Jayaram at 11:04, 14 March 2017

2017-03-14T11:04:08Z

Swapna at 18:59, 19 July 2015

2015-07-19T18:59:22Z

Swapna at 22:05, 28 February 2014

2014-02-28T22:05:51Z

Swapna at 21:51, 28 February 2014

2014-02-28T21:51:25Z

Swapna at 21:49, 28 February 2014

2014-02-28T21:49:22Z

Swapna at 21:46, 28 February 2014

2014-02-28T21:46:01Z

@@ Line 51: / Line 51: @@
 ==Related Videos==
-{{#ev:youtube|aReHATnBiIU|280|center|TBILLEQ}}
+{{#ev:youtube|v=QLC8bGbOSfM|280|center|TBILLEQ}}
 == See Also ==

@@ Line 4: / Line 4: @@
 *<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.
+**TBILLEQ(), returns the bond-equivalent yield for a Treasury bill.
 == Description ==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''TBILLEQ (Settlement,Maturity,Discount)'''</div><br/>
 where,
 *<math>Settlement</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)

@@ Line 1: / Line 1: @@
-=TBILLEQ(SettlementDate, MaturityDate, Discount)=
+<div style="font-size:30px">'''TBILLEQ (Settlement,Maturity,Discount)'''</div><br/>
 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.
-TBILLEQ() calculates the bond equivalent yield for a Treasury Bill.
+TBILLEQ(), returns the bond-equivalent yield for a Treasury bill.
 == Description ==
-TBILLEQ(SettlementDate, MaturityDate, Discount)
+TBILLEQ (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> &gt;= <math>MaturityDate</math>, Calci displays #N/A error message.
+*If <math>Settlement</math> &gt;= <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> &lt;=0, Calci displays #N/A error message.
 *Formula:

← Older revision		Revision as of 11:04, 14 March 2017
Line 63:		Line 63:

	*[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 ]]

@@ Line 50: / Line 50: @@
   =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 <br />for mentioned values. Displays '''9.72%''' as a result.
 == See Also ==

@@ Line 13: / Line 13: @@
 *<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> &gt;= <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> &lt;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))}
+<math>TBILLEQ = \frac{(365 * Discount)}{(360 - (Discount * N))}</math>
 == Examples ==
@@ Line 48: / Line 48: @@
 |}
-  =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 ==

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=TBILLEQ(SettlementDate, MaturityDate, Discount)=
-'''TBILLEQ'''(SettlementDate, MaturityDate, Discount)
+where,
-where,
+TBILLEQ() calculates the bond equivalent yield for a Treasury Bill.
-'''SettlementDate '''- represents the Treasury bill's settlement date.
+== Description ==
-'''MaturityDate''' - represents the Treasury bill's maturity date.
+*<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.
-'''Discount '''- represents the Treasury bill's discount rate
+<math>TBILLEQ = \frac{(365 * Discount)}{(360 - (Discount * N))}
-</div>
+== Examples ==
-It returns the bond-equivalent yield for a Treasury bill.
+Consider the following example that shows the use of TBILLEQ function:
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class=" " |
+| class="sshl_f" | 01/01/2010
 | class=" " |
 | class=" " |
 |- class="odd"
-| Row3
+| class="sshl_f" | 11/20/2010
 | class=" " |
 | class=" " |
 |- class="even"
-| Row4
+| class="sshl_f" | 5.85%
 | class=" " |
 | class=" " |
 |- class="odd"
-| class=" " | Row5
+| class="sshl_f" |
 | class=" " |
 | class=" " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =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.