TBILLPRICE

TBILLPRICE(settlement, maturity, discount)

Returns the price per $100 face value for a treasury bill.

settlementThe settlement date of the treasury bill.
maturityThe maturity date of the treasury bill.
discountThe discount rate of the treasury bill.

REMARKS
* The "settlement" is the date after the issue date when the treasury bill is traded to the buyer.
* The "maturity" is the date when the treasury bill expires.
* Dates must be entered as text strings within quotation marks or as serial numbers.
* If "settlement" is not an integer, it is truncated.
* If "settlement" > "maturity" , then #NUM! is returned.
* If "settlement" is not a valid date, then #NUM! is returned.
* If "maturity" is not an integer, it is truncated.
* If "maturity" is more than one year after "settlement", then #NUM! is returned.
* If "maturity" is not a valid date, then #NUM! is returned.
* If "discount" = 0, then #NUM! is returned.
* You can use the ODDFPRICE function to return the price per $100 face value of a security with an odd first period.
* You can use the ODDLPRICE function to return the price per $100 face value of a security with an odd last period.
* You can use the PRICE function to return the price of a security that pays periodic interest.
* You can use the PRICEDISC function to return the price of a discounted security (no interest payments).
* You can use the PRICEMAT function to return the price of a security that pays interest at maturity.
* You can use the TBILLEQ function to return the yield (bond-equivalent) for a treasury bill.
* You can use the TBILLYIELD function to return the yield for a treasury bill.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=100*(1-((0.0425*DATEDIF("01/01/2025", "31/03/2025", "D")/360))) = 98.949
2=TBILLPRICE("01/01/2025", "31/3/2025", 0.0425) = 98.949
3=TBILLPRICE("01/01/2025", "30/6/2025", 0.0416) = 97.920
4=TBILLPRICE("01/01/2025", "31/12/2025", 0.0398) = 95.976
5=TBILLPRICE("2001/08/31", "2002/01/30", 0.07) = 97.044
6=TBILLPRICE("2001/08/31", "2002/01/30", -2) = #NUM!
7=TBILLPRICE("3/31/1999", "6/1/1999", 0.09) = #VALUE!

1 - What is the price of a 3M US Treasury bill with a yield of 4.25% using a formula.
2 - What is the price of a 3M US Treasury bill with a yield of 4.25%.
3 - What is the price of a 6M US Treasury bill with a yield of 4.16%.
4 - What is the price of a 1Y US Treasury bill with a yield of 3.98%.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top