Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial > TBILLYIELD
 

TBILLYIELD(settlement, maturity, pr)

 
 Returns the yield for a treasury bill.

 settlementThe settlement date of the treasury bill.
 maturityThe maturity date of the treasury bill.
 prThe treasury bill's price per $100 face value.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• The maturity date is the date when the treasury bill expires.
     
  		• If "settlement" is not an integer, it is truncated.
     
  		• If "settlement" > "maturity" , then #NUM! is returned.
     
  		• If "settlement" is not a valid date, then #NUM! is returned.
     
  		• If "maturity" is more than one year after "settlement", then #NUM! is returned.
     
  		• If "maturity" is not an integer, it is truncated.
     
  		• If "maturity" is not a valid date, then #NUM! is returned.
     
  		• If "pr" = 0, then #NUM! is returned.

     EXAMPLES
     
     A
    1=TBILLYIELD("3/1/1999","6/1/1999",98.45) = 1.889
    2=TBILLYIELD("3/1/1999","6/1/1999",10/100) = 119880
    		 
     Functions - T | Index - T | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top