Manuals/calci/TBILLYIELD

From ZCubes Wiki
Revision as of 17:29, 28 February 2014 by Swapna (talk | contribs)
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:

Need to add examples after next release

See Also

References