## How to use the TBILLPRICE function

**What is the TBILLPRICE function?**

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

**What is the par amount or face value of a treasury bill?**

The par amount or face value of a treasury bill is the amount the bill will be redeemed for at maturity, typically in denominations of $1,000 up to $5 million for institutional investors.

For example, a $1,000 par value T-bill will pay $1,000 at maturity.

**What is a treasury bill?**

A treasury bill, or T-bill, is a short-term U.S. government debt obligation backed by the Treasury Department with a maturity of 1 year or less that is sold at a discount from par in regular auctions.

**Excel functions for bonds and treasury bills**

Function |
Description |

TBILLEQ |
Returns the bond-equivalent yield for a Treasury bill |

TBILLPRICE |
Returns the price per $100 face value for a Treasury bill |

TBILLYIELD | Returns the yield for a Treasury bill |

ACCRINT | Returns the accrued interest for a security that pays periodic interest |

ACCRINTM | Returns the accrued interest for a security that pays interest at maturity |

DURATION | Returns the annual duration of a security with periodic interest payments |

MDURATION | Returns the Macauley modified duration for a security with an assumed par value of $100 |

DISC | Returns the discount rate for a security |

INTRATE | Returns the interest rate for a fully invested security |

### TBILLPRICE function Syntax

TBILLPRICE(*settlement*,Â *maturity*,Â *discount*)

### TBILLPRICE function 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. |

**What is the Treasury bill's settlement date?**

The date after the issue date. A Treasury bill's settlement date is the date 1 business day after the auction when payment must be received and the bill is delivered to the buyer's account in exchange for the purchase price.

**What is the Treasury bill's maturity?**

The maturity date of a Treasury bill is the date when the bill's term expires, typically in 4, 8, 13, 26, or 52 weeks, and the Treasury repays the par value to the investor.

**What is the Treasury bill's discount rate?**

The Treasury bill discount rate is the interest rate used to determine how much less than par the investor will pay at auction for a given bill based on its par value and term to maturity.

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

### TBILLPRICE function example 1

Formula in cell C6:

### TBILLPRICE function example 2

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

For example,

Date arguments are truncated to integers.

### TBILLPRICE function not working

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*

### How is the TBILLPRICE function calculated?

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*.

### Functions in 'Financial' category

The TBILLPRICE function function is one of many functions in the 'Financial' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form