Skip to main content

TBILLPRICE

Definition of TBILLPRICE

Calculates the price of a US Treasury Bill based on discount rate.

Sample Usage

TBILLPRICE(DATE(2010,1,2), DATE(2010,12,31), 1.25)

TBILLPRICE(A2,B2,C2)

Syntax

TBILLPRICE(settlement, maturity, discount)

  • settlement - The settlement date of the security, the date after issuance when the security is delivered to the buyer.

  • maturity - The maturity or end date of the security, when it can be redeemed at face or par value.

  • discount - The discount rate of the bill at time of purchase.

Notes

  • settlement and maturity should be entered using DATETO_DATE or other date parsing functions rather than by entering text.

  • TBILLPRICE is equivalent to using PRICEDISC with US Treasury Bill conventions for the absent parameters.

See Also

TBILLYIELD: Calculates the yield of a US Treasury Bill based on price.

PRICEDISC: Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

PRICE: Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

 

 

In order to use the TBILLPRICE formula, start with your edited Excellentable:

Then type in the TBILLPRICE Formula in the area you would like to display the outcome:

By adding the values you would like to calculate the TBILLPRICE formula for, Excellentable will generate the outcome:

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.