calculates yield-to-maturity of a cash-flow stream and returns a scalar The YIELD function returns a scaler containing yield-to-maturity of a cash-flow stream based on frequency and value specified.