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 DATE, TO_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:

	A	B	C	D
1		Settlement	Maturity	Discount
2		1/31/2012	2/28/2013	4.50%
3		3/2/2014	5/1/2014	1%
4		2/1/2011	6/30/2011	2.50%
5		1/31/2014	12/31/2015	4%
6		2/1/2015	6/30/2015	2.50%
7
8	Result	98.96527778