SpreadJS 14
Formula Reference / Formula Functions / Financial Functions / YIELDDISC
In This Topic
    YIELDDISC
    In This Topic

    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