PRICEDISC

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

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

settlementThe settlement date of the security.
maturityThe maturity date of the security.
discountThe discount rate of the security.
redemptionThe redemption value of the security per $100 face value.
basis(Optional) The type of day counting to use:
0 = 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = 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!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top