Difference between revisions of "Manuals/calci/TBILLPRICE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | = | + | =TBILLPRICE(SettlementDate, MaturityDate, Discount)= |
where, | where, | ||
| Line 6: | Line 6: | ||
*<math>Discount</math> is the Treasury Bill's discount rate. | *<math>Discount</math> is the Treasury Bill's discount rate. | ||
| − | + | TBILLPRICE() calculates the price per $100 face value for a Treasury Bill. | |
== Description == | == Description == | ||
| − | + | TBILLPRICE(SettlementDate, MaturityDate, 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>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. | ||
Revision as of 16:32, 28 February 2014
TBILLPRICE(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.
TBILLPRICE() calculates the price per $100 face value for a Treasury Bill.
Description
TBILLPRICE(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 TBILLPRICE 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 TBILLPRICE = 100 * (1 - \frac{(Discount * N)}{360}) }
Examples
Consider the following example that shows the use of TBILLPRICE function:
| 01/01/2010 | ||
| 11/20/2010 | ||
| 5.85% | ||
=TBILLPRICE(A1,A2,A3) : Calculates the price for the Treasury Bill with values in the range A1 to A3.
Displays 94.75125 as a result. =TBILLPRICE(DATE(2013,10,20),DATE(2014,6,20),9%) : Calculates the price for the Treasury Bill with
the mentioned values. Displays 93.925 as a result.