Syntax. YIELD(Settlement,Maturity,Rate,Pr,Redemption,Frequency,Basis)

Definition. This function determines the yield of a fixed-interest security (loan).


  • Settlement (required) The date when the ownership of the security changes.

  • Maturity (required) The date when the repayment of the loan certified by the security takes place.

  • Rate (required) The agreed-upon annual interest rate as the price for the borrowed money.

  • Pr (required) The price of the security at the day of settlement (without accrued interest).

  • Redemption (required) The percentage of the par value of a security (as if it was 100 monetary units) at which repayment takes place on the day of maturity.

  • Frequency (required) Because it is quite common to have fixed-interest securities ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.