Microsoft Office Tutorials and References
In Depth Information
TBILLPRICE
The treasur y bill’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
The treasur y bill’s maturity date—when the security expires.
MATURITY
The discount rate of the treasur y bill.
DISCOUNT
Figure 6.37
For a treasury bill,
TBILLEQ returns the
bond equivalent yield.
A
Building bond
yields with cell
referencing
TBILLPRICE
For a treasur y bill, TBILLPRICE returns the price per $100 face value.
=TBILLPRICE(settlement,maturity,discount)
The TBILLPRICE function returns the price per $100 face value of a treasur y bill. The TBILLPRICE
function is found only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins
command from the Tools menu. In Figure 6.38, for example, the treasur y bill’s settlement date is
11/15/1999 and the maturity date is 2/25/2000. The treasur y bill’s discount rate is 8.9% and the
result is $97.48 price per $100 face value.
The treasur y bill’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
The treasur y bill’s maturity date—when the security expires.
MATURITY
The discount rate of the treasur y bill.
DISCOUNT
TBILLPRICE is calculated as follows:
Search JabSto ::




Custom Search