Changes

*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.

*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.

*If settlement date ≥ maturity date, Calci displays #N/A error message.

*If settlement date ≥ maturity date, Calci displays #N/A error message.

*'discount' and 'redemption' values must be greater than zero, else Calci displays #N/A error message.

*'discount' value must be greater than or equal to zero, else calci displays #N/A error message.

*'redemption' value must be greater than zero, else Calci displays #N/A error message.

*'basis' value is optional. If omitted, Calci assumes it to be 0.  

*'basis' value is optional. If omitted, Calci assumes it to be 0.  

Below table shows the use of 'basis' values:

Below table shows the use of 'basis' values:

|}

|}

  =PRICE(A1,A2,A3,A4,A5) : Calculates the Discounted Price Value with the inputs in the range A1 to A5. Returns ''''.

  =PRICEDISC(A1,A2,A3,A4,A5) : Calculates the Discounted Price Value with the inputs in the range A1 to A5. Returns ''56.33879781420765''.

== See Also ==

== See Also ==

*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]

*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]