BillPrice() function

BillPrice() function

BillPrice(argument list…)

This function returns the price per $100 par of a discount money market security such as a Treasury bill. The function uses the following arguments:

Argument	Description	Restrictions
Settlement_Date	bill settlement date	valid Excel date number
Maturity_Date	bill maturity date	valid Excel date number >= Settlement_Date
Yield	money market yield of the bill in decimal form (e.g. six percent entered as 0.06)	> 0
Year_Basis	days per year for calculations	360 or 365