Manuals/calci/PRICEDISC
PRICEDISC(SettlementDate, MaturityDate, Discount, Redemption, Basis)
where,
SettlementDate - represents the settlement date.
MaturityDate - represents the maturity date.
Discount - represents the discount rate.
Redemption - represents the redemption value per $100 face value.
Basis - type of day count basis
Basis Day count basis
0 or omitted US 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360
It returns the price per $100 face value of a discounted.
Formula:-
PRICEDISC =(Redemption-Discount )x Redemption x (D/N)
where,
D - number of days from settlement to maturity.
N - number of days in year
If Basis < 0 or Basis > 4 , PRICEDISC returns the #ERROR.
If Discount <= 0, it returns the #ERROR.
If SettlementDate >= MaturityDate, PRICEDISC returns #ERRROR.
If Redemption <= 0, PRICEDISC returns the #ERROR.
PRICEDISC
Lets see an example in (Column2, Row6)
=PRICEDISC(R1C1, R2C1, R3C1, R4C1, R5C1)
PRICEDISC returns 97.852841.
Consider another example
=PRICEDISC(date(1/1/2027),date(2/2/2008), "5%", 100,2)
It returns #ERROR(SettlementDate > MaturityDate).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2/2/2008 | |||
| Row2 | 11/2/2008 | |||
| Row3 | 5% | |||
| Row4 | 100 | |||
| Row5 | 4 | |||
| Row6 | 96.263889 |
