DISC

Discount rate of security

Description
Calculates a security's discount rate based on price.
Function signature
DISC(settlement: String, maturity: String, price: Number, redemption: Number, basis: String = us_nasd) => Number
Parameter
Description
Settlement
The security's settlement date.
Maturity
The security's maturity or end date.
Price
The price at which the security is bought.
Redemption
The redemption value of the security.
Basis
Method to use for counting days per month/year:
`us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD).
`actual`: Actual number of days per month/year.
`actual_360`: 360 day year, actual number of days per month.
`actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account.
`european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.
Examples
date1 = "2010-01-02T13:06:15+03:00"
date2 = "2039-12-31T13:06:15+03:00"
date3 = "2009-01-31T13:06:15+03:00"
date4 = "2023-10-31T13:06:15+03:00"
date5 = "2009-01-30T13:06:15+03:00"
date6 = "2023-10-30T13:06:15+03:00"
date7 = "2009-01-31T13:06:15+03:00"
date8 = "2023-10-30T13:06:15+03:00"
Formula
Return value
DISC(date1, date2, 90, 100, "us_nasd")
0.00333364
DISC(date1, date2, 90, 100)
0.00333364
DISC(date3, date4, 280, 300, "us_nasd")
0.00451977
DISC(date5, date6, 280, 300, "actual_360")
0.004456
DISC(date7, date8, 250, 300, "actual")
0.011303

DECLINING_BALANCE

DOUBLE_DECLINING_BALANCE

Last updated 8 months ago

Formula	Return value
`DISC(date1, date2, 90, 100, "us_nasd")`	`0.00333364`
`DISC(date1, date2, 90, 100)`	`0.00333364`
`DISC(date3, date4, 280, 300, "us_nasd")`	`0.00451977`
`DISC(date5, date6, 280, 300, "actual_360")`	`0.004456`
`DISC(date7, date8, 250, 300, "actual")`	`0.011303`

Parameter	Description
Settlement	The security's settlement date.
Maturity	The security's maturity or end date.
Price	The price at which the security is bought.
Redemption	The redemption value of the security.
Basis	Method to use for counting days per month/year: `us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD). `actual`: Actual number of days per month/year. `actual_360`: 360 day year, actual number of days per month. `actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account. `european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.