Difference between revisions of "Manuals/calci/TBILLEQ"
Jump to navigation
Jump to search
| 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. | *<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 | + | *<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 == | ||
| Line 48: | Line 48: | ||
|} | |} | ||
| − | =TBILLEQ(A1,A2,A3) : Calculates the bond equivalent yield for the Treasury Bill | + | =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 | + | =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 == | ||
Revision as of 15:49, 28 February 2014
TBILLEQ(SettlementDate, MaturityDate, Discount)
where,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate} is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate} is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Discount} is the Treasury Bill's discount rate.
TBILLEQ() calculates the bond equivalent yield for a Treasury Bill.
Description
TBILLEQ(SettlementDate, MaturityDate, Discount)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate} should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate} >= Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate} , Calci displays #N/A error message.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate} should not be greater than one year from Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate} . Else, Calci displays #N/A error message.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Discount} <0, Calci displays #N/A error message.
- Formula:
If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLEQ is calculated as -
Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle TBILLEQ={\frac {(365*Discount)}{(360-(Discount*N))}}}
Examples
Consider the following example that shows the use of TBILLEQ function:
| 01/01/2010 | ||
| 11/20/2010 | ||
| 5.85% | ||
=TBILLEQ(A1,A2,A3) : Calculates the bond equivalent yield for the Treasury Bill for values in the range A1 to A3.
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 for mentioned values. Displays 9.72% as a result.