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).

Syntax

Remarks

Examples

Description