Calculates the yield on a Treasury bill
The TBILLYIELD Function is categorized under Excel FINANCIAL functions. It will calculate the yield on a Treasury bill.
In financial analysis, TBILLYIELD can be useful in calculating the yield on a Treasury bill when we are given the start date, end date, and price.
=TBILLYIELD(settlement, maturity, pr)
The TBILLYIELD function uses the following arguments:
As a worksheet function, TBILLYIELD can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider an example:
Assume we are given the following data:
Using the TBILLYIELD function, we can calculate the yield. The formula is:
We get the results below:
DSM = number of days from settlement to maturity, excluding any maturity date that is more than one calendar year after the settlement date
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial modeling and analysis. To learn more, see these additional CFI resources: