Menu
EXCEL TBILLYIELD FUNCTION
Excel TBILLYIELD Function Introduction
The Tbillyield function in Excel estimates the yield on a Treasury Bill.
Description of Excel TBILLYIELD Function
Syntax :
=TBILLYIELD( settlement, maturity, pr )
Parameters :
- Settlement – The finance bill’s settlement date.
- Maturity – The treasury bill’s expiry date.
- Pr – The price of a treasury bill per $100 face value.
Step By Step Guide of TBILLYIELD Function
Example :
the Excel Tbillyield function was used to determine the yield on a t – bills with a closing date of 01-Feb-2017, an expiry of 30-Jun-2017, and a face value of $99: In the above example, the Tbillyield function produces a yield of 2.44 percent.
Key Points
- #NUM! – Occurs if the final payment or the maturity date is more than one year after the date of settlement; the provided pr argument is 0.
- #VALUE! – Occurs if any of the given parameters are non-numeric, or if the settlements or age arguments are not valid dates.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
