Syntax. PRICE(Settlement,Maturity,Rate,Yield,Repayment,Frequency,Basis)

Definition. This function calculates the price of a fixed-interest security (loan); that is, the purchase price without accrued interest.


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

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

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

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.