Excel Function : TBILLYIELD

Download now!

Excel Function : TBILLYIELD

Category

Financial

Description

Returns the yield for a Treasury bill

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TBILLYIELD-function-6d381232-f4b0-4cd5-8e97-45b9c03468ba

Syntax and Description of the TBILLYIELD Excel Function

In Excel, the TBILLYIELD function returns the yield on a Treasury bill, given the price. The syntax for the TBILLYIELD function is: TBILLYIELD(price,settlement,maturity,pr) where: price: The price per $100 face value for which the bill is sold. settlement: The settlement date of the bill, expressed as a serial date number. maturity: The maturity date of the bill, expressed as a serial date number. pr: The number of days from settlement to maturity.

About TBILLYIELD Excel Function

The TBILLYIELD function returns the yield for a Treasury bill, given the price and the par value.