Difference between revisions of "Manuals/calci/TBILLYIELD"
Jump to navigation
Jump to search
| Line 50: | Line 50: | ||
=TBILLYIELD(A1,A2,A3) : Calculates the yield for treasury bill with the input values from the cells A1 to A3. <br />Returns '''0.07566204287515763''' as a result. | =TBILLYIELD(A1,A2,A3) : Calculates the yield for treasury bill with the input values from the cells A1 to A3. <br />Returns '''0.07566204287515763''' as a result. | ||
=TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9) : Calculates the yield for treasury bill <br />with the values mentioned as arguments. Returns '''0.09624107600678411''' as a result. | =TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9) : Calculates the yield for treasury bill <br />with the values mentioned as arguments. Returns '''0.09624107600678411''' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|rveNMFjRz58|280|center|TBILLYIELD}} | ||
== See Also == | == See Also == | ||
Revision as of 13:01, 19 July 2015
TBILLYIELD(SettlementDate, MaturityDate, Price)
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 Price} is the Treasury Bill's price per $100 face value.
TBILLYIELD() calculates the yield for a Treasury Bill.
Description
TBILLYIELD(SettlementDate, MaturityDate, Price)
- 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 more than one year than that of 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 Price} <=0, Calci displays #N/A error message.
- Formula:
If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLYIELD is calculated as -
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 TBILLYIELD = \frac{(100 - Price)}{Price} * \frac{360}{N}}
Examples
Consider the following example that shows the use of TBILLYIELD function:
| 06/25/2014 | ||
| 10/25/2014 | ||
| 97.5 | ||
=TBILLYIELD(A1,A2,A3) : Calculates the yield for treasury bill with the input values from the cells A1 to A3.
Returns 0.07566204287515763 as a result. =TBILLYIELD(DATE(2013,10,20),DATE(2014,6,20),93.9) : Calculates the yield for treasury bill
with the values mentioned as arguments. Returns 0.09624107600678411 as a result.