|
YIELDDISC |
  
|
|
YIELDDISC |
|
This function calculates the annual yield for a discounted security.
Syntax
YIELDDISC(settle,maturity,price,redeem,basis)
Arguments
This function has these arguments:
Argument |
Description |
settle |
Settlement date for the security |
maturity |
Maturity date for the security |
price |
Price per $100 face value for the security |
redeem |
Redemption value per $100 face value |
basis |
[Optional] Integer representing the basis for day count (Refer to Day Count Basis.) |
Remarks
This function returns a #VALUE! error when settle or maturity is invalid. If price or redeem is less than or equal to 0, a #NUM! error is returned. If basis is less than 0 or greater than 4, a #NUM! error is returned. If settle is greater than or equal to maturity, a #NUM! error is returned. Settle, maturity, and basis are truncated to integers.
Data Types
Accepts numeric data and dates. Returns numeric data.
Examples
YIEDDISC(B1,B2,B3,B4,B5)
See Also