Difference between revisions of "Manuals/calci/TBILLEQ"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''TBILLEQ (Settlement,Maturity,Discount)'''</div><br/> | <div style="font-size:30px">'''TBILLEQ (Settlement,Maturity,Discount)'''</div><br/> | ||
| − | |||
where, | where, | ||
*<math>Settlement</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) | ||
Revision as of 15:55, 27 July 2018
TBILLEQ (Settlement,Maturity,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 Settlement} 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)
- 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.
is the Treasury Bill's maturity date (a date when the Treasury Bill expires)TBILLEQ(), returns the bond-equivalent yield for a Treasury bill.
Description
TBILLEQ (Settlement,Maturity,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 Settlement} 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 Maturity} 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 Settlement} >= 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 Maturity} , 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 Maturity} 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 Settlement} . 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.
Related Videos
See Also
References