Author: Oscar Cronquist Article last updated on December 10, 2018

The TBILLPRICE function calculates the par amount (face value) for a Treasury bill.

Formula in cell C6:

=TBILLPRICE(C2,C3,C4)

### Excel Function Syntax

TBILLPRICE(settlement,Â maturity,Â discount)

### Arguments

 settlement Required. The Treasury bill's settlement date which is the date after the issue date. maturity Required. The date when the security expires. discount Required. The Treasury bill's discount rate.

### Comments

Treasury bills are issued at a discount from the face value, the interest paid is the face value - purchase price.

Keep in mind to use theÂ DATE functionÂ if you enter dates in the function instead of using cell references.

For example,

=TBILLPRICE(DATE(2018, 9, 30), DATE(2018, 12, 31), C4)

Date arguments are truncated to integers.

The TBILLPRICE function returns:

• #VALUE! error ifÂ settlementÂ orÂ maturityÂ is not a valid data type.
• #NUM! error if
• discountÂ <=0 (zero)
• settlement > maturity, or if maturity is more than a year after the settlement

Calculation formula:

TBILLPRICE = 100 * (1-(discount*DSM/360))

DSM = days betweenÂ settlementÂ toÂ maturityÂ ignoringÂ maturityÂ date that is more than a year afterÂ settlement.