Manuals/calci/TBILLYIELD
Jump to navigation
Jump to search
TBILLYIELD(SettlementDate, MaturityDate, Price)
where,
- is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)
- is the Treasury Bill's maturity date (a date when the Treasury Bill expires)
- is the Treasury Bill's price per $100 face value.
TBILLYIELD() calculates the yield for a Treasury Bill.
Description
TBILLYIELD(SettlementDate, MaturityDate, Price)
- and should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
- If >= , Calci displays #N/A error message.
- should not be more than one year than that of . Else, Calci displays #N/A error message.
- If <=0, Calci displays #N/A error message.
- Formula:
If 'N' is number of days from 'Settlement' to 'Maturity', then TBILLYIELD is calculated as -
Examples
Consider the following example that shows the use of TBILLYIELD function: