TBILLPRICE |
TBILLPRICE(settlement, maturity, discount) |
Returns the price per $100 face value for a treasury bill. |
settlement | The settlement date of the treasury bill. |
maturity | The maturity date of the treasury bill. |
discount | The 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 |
|
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