Difference between revisions of "Manuals/calci/PRICEDISC"

Latest revision as of 15:02, 16 November 2018

PRICEDISC (SettlementDate,MaturityDate,DiscountRate,RedemptionValue,Basis)

where $SettlementDate$ is the security's settlement date (a date when coupon or a bond is purchased),
$MaturityDate$ is security's maturity date (a date when coupon or a bond expires),
$DiscountRate$ is security's discount rate,
$RedemptionValue$ is security's redemption value per $100 face value, and
is the type of day count basis to use.
- PRICEDISC(), returns the price per $100 face value of a discounted security.

Description

PRICEDISC (SettlementDate,MaturityDate,DiscountRate,RedemptionValue,Basis)

The function returns the price of a discounted security per $100 face value.
PRICEDISC is calculated by subtracting discounted amount from redemption value.
and 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 ≥ , Calci displays #N/A error message.
value must be greater than or equal to zero, else calci displays #N/A error message.
value must be greater than zero, else Calci displays #N/A error message.
value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of values:

Basis	Description
0	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/365

If value is other than 0 to 4, Calci displays #N/A error message.

Examples

PRICEDISC (SettlementDate,MaturityDate,DiscountRate,RedemptionValue,Basis) function with inputs in order is calculated as follows:

2/2/2008
11/2/2016
5%
100
1

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

References

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=PRICEDISC(settlement, maturity, discount, redemption, basis)=
+<div style="font-size:25px">'''PRICEDISC (SettlementDate,MaturityDate,DiscountRate,RedemptionValue,Basis)'''</div><br/>
-*where <math>settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),
+*where <math>SettlementDate</math> is the security's settlement date (a date when coupon or a bond is purchased),
-*<math>maturity</math> is security's maturity date (a date when coupon or a bond expires),
+*<math>MaturityDate</math> is security's maturity date (a date when coupon or a bond expires),
-*<math>discount</math> is security's discount rate,
+*<math>DiscountRate</math> is security's discount rate,
-*<math>redemption</math> is security's redemption value per &#36;100 face value, and
+*<math>RedemptionValue</math> is security's redemption value per &#36;100 face value, and
-*<math>basis</math> is the type of day count basis to use.
+*<math>Basis</math> is the type of day count basis to use.
+**PRICEDISC(), returns the price per $100 face value of a discounted security.
-PRICEDISC() calculates the price of a discounted security per &#36;100 face value.
 == Description ==
-PRICEDISC(settlement, maturity, discount, redemption, basis)
+PRICEDISC (SettlementDate,MaturityDate,DiscountRate,RedemptionValue,Basis)
 *The function returns the price of a discounted security per &#36;100 face value.
 *PRICEDISC is calculated by subtracting discounted amount from redemption value.
-*<math>settlement</math> and <math>maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>SettlementDate</math> and <math>MaturityDate</math> 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 <math>settlement</math> date ≥ <math>maturity</math> date, Calci displays #N/A error message.
+*If <math>SettlementDate</math>  ≥ <math>MaturityDate</math> , Calci displays #N/A error message.
-*<math>discount</math> value must be greater than or equal to zero, else calci displays #N/A error message.
+*<math>DiscountRate</math> value must be greater than or equal to zero, else calci displays #N/A error message.
-*<math>redemption</math> value must be greater than zero, else Calci displays #N/A error message.
+*<math>RedemptionValue</math> value must be greater than zero, else Calci displays #N/A error message.
-*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
+*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
-Below table shows the use of <math>basis</math> values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"
@@ Line 37: / Line 36: @@
 |}
-*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.
+*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
 == Examples ==
@@ Line 43: / Line 42: @@
 <div id="2SpaceContent" class="zcontent" align="left">
-PRICEDISC(settlement, maturity, discount, redemption, basis) function with inputs in order is calculated as follows:
+PRICEDISC (SettlementDate,MaturityDate,DiscountRate,RedemptionValue,Basis) function with inputs in order is calculated as follows:
 <div id="2SpaceContent" class="zcontent" align="left">
@@ Line 61: / Line 60: @@
 |- class="odd"
-| class="sshl_f" | $100
+| class="sshl_f" | 100
 | class="sshl_f" |
@@ Line 71: / Line 70: @@
   =PRICEDISC(A1,A2,A3,A4,A5) : Calculates the Discounted Price Value with the inputs in the range A1 to A5. Returns ''56.33879781420765''.
+==Related Videos==
+{{#ev:youtube|v=zEG9RXcQQr4|280|center|PRICEDISC}}
 == See Also ==
@@ Line 81: / Line 84: @@
 *[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]
 *[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]