Syntax. YIELDMAT(Settlement,Maturity,Issue,Rate,Pr,Basis)

Definition. This function calculates the annual yield of a fixed-interest security in the intra-annual area (without compound interest).


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

  • Maturity (required) The maturity date of the security.

  • Issue (required) The date of the emission of the security.

  • Rate (required) The agreed-upon nominal interest rate of the security based on one year.

  • Pr (required) The percentage of the par value of a security (as if it was 100 monetary units).

  • Basis (optional) The method you want to use for determining the days in the year according to Table 15-2, shown earlier. If this argument is omitted, Excel calculates with ...

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

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