The `TBILLPRICE` function in Excel is used to calculate the price per $100 face value of a Treasury bill given its settlement date, maturity date, and discount rate. Here’s how you can use it:
Syntax
TBILLPRICE(settlement, maturity, discount)
Parameters
- Settlement: This is the T-bill’s settlement date, which is the date after the issue date when the T-bill is delivered to the buyer. It should be entered as a date.
- Maturity: This is the maturity date of the T-bill which is the date when the bill expires and the government pays back the face value. It should also be entered as a date.
- Discount: This is the T-bill’s discount rate, expressed as a decimal.
Important Notes
- Dates: Make sure the settlement and maturity dates are entered in Excel date format. Excel might not recognize the dates if you enter them as text strings.
- Valid Date Range: The settlement date should be before the maturity date. Typically, T-bills have short durations of less than a year.
- Error Values: If the settlement or maturity dates are invalid or the discount rate is not between 0 and 1, the function may return an error.
Example
Assume you purchased a T-bill with the following details:
- Settlement Date: January 1, 2023
- Maturity Date: March 31, 2023
- Discount Rate: 2%
Your `TBILLPRICE` function would look like this:
=TBILLPRICE(DATE(2023, 1, 1), DATE(2023, 3, 31), 0.02)
This function will return the price per $100 face value of the Treasury bill based on the given data.
Tips
- Date Functions: You can use the `DATE` function in Excel to ensure the dates are properly recognized, as shown in the example.
- Cell References: Instead of hardcoding dates and rates into the function, you can reference cells where these values are entered. For example, if `A1` contains the settlement date, `A2` the maturity date, and `A3` the discount rate, your formula could be `=TBILLPRICE(A1, A2, A3)`.
This should help you calculate the price of a Treasury bill efficiently using Excel’s `TBILLPRICE` function.
Unlock Your Potential
Excel
Access
Power BI
