# PRICEDISC

PRICEDISC(settlement, maturity, discount, redemption [,basis])

Returns the price of a discounted security (no interest payments).

 settlement The settlement date of the security. maturity The maturity date of the security. discount The discount rate of the security. redemption The redemption value of the security per \$100 face value. basis (Optional) The type of day counting to use:0 = 30/360 (default)1 = Actual/Actual2 = Actual/3603 = Actual/3654 = 30E/360

 REMARKS
 * The settlement date is the date a buyer purchases a coupon, such as a bond.* The maturity date is the date when a coupon expires.* Dates must be entered as text strings with quotation marks or as serial numbers.* If "settlement" is not an integer, it is truncated.* If "settlement" is not a valid date, then #NUM! is returned.* If "settlement" = "maturity", then #NUM! is returned.* If "maturity" is not an integer, it is truncated.* If "maturity" is not a valid date, then #NUM! is returned.* If "discount" = 0, then #NUM! is returned.* If "redemption" = 0, then #NUM! is returned.* If "basis" is left blank, then 0 is used.* If "basis" is not an integer, it is truncated.* If "basis" < 0, then #NUM! is returned.* If "basis" > 4, then #NUM! is returned.* You can use the PRICE function to return the price of a security that pays interest at regular intervals.* You can use the PRICEMAT function to return the price of a security that pays interest at maturity.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =PRICEDISC("2/15/1999","3/1/1999",0.0525,100,2) = #VALUE!