Syntax. PRICEDISC(Settlement,Maturity,Discount,Redemption,Basis)

Definition. This function calculates the disbursement amount of a simply discounted security with anticipative interest yield.


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

  • Maturity (required) The day when the payments from the security must take place.

  • Discount (required) The interest rate of the discount (disagio).

  • Redemption (required) The payment at the day of maturity.

  • 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 Basis = 0.

All function arguments that take a date use the date without time; fractions are rounded. ...

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.