Syntax. MDURATION(Settlement,Maturity,Coupon,Yield,Frequency,Basis)

Definition. This function calculates the figure known as modified duration for fixed-interest securities.


  • 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.

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

  • Yield (required) The market interest rate on the settlement day, at which during calculation of the duration all future payments are discounted.

  • Frequency (required) Because it is quite common to have fixed-interest securities with several interest dates per year, the required argument Frequency

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.