DISC

Returns the discount rate for a security

Syntax

DISC(settlement, maturity, pr, redemption, [basis])

Arguments

Argument	Description	Required
`settlement`	The settlement date of the security	Required
`maturity`	The maturity date of the security	Required
`pr`	The price per $100 face value of the security	Required
`redemption`	The redemption value per $100 face value of the security	Required
`basis`	The type of day count basis to use	Optional

Examples

Calculate discount rate for security

=DISC(A1, A2, A3, A4)

Result ⇒ 0.0374

	A
1	1/16/2012
2	8/1/2012
3	97.975
4	100

Discount rate with different basis

=DISC(A1, A2, A3, A4, A5)

Result ⇒ 0.0374

	A
1	1/16/2012
2	8/1/2012
3	97.975
4	100
5	1

Treasury bill discount rate

=DISC(A1, A2, A3, A4)

Result ⇒ 0.04

	A
1	3/1/2012
2	6/1/2012
3	99
4	100

Related Functions

Other Financial functions:

CUMIPMT - Returns the cumulative interest paid between start_period and end_period
CUMPRINC - Returns the cumulative principal paid on a loan between start_period and end_period
DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method
EFFECT - Returns the effective annual interest rate
FV - Returns the future value of an investment.
FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates
IPMT - Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
IRR - Returns the internal rate of return for a series of cash flows
NOMINAL - Returns the annual nominal interest rate
NPER - Returns the number of periods for an investment
NPV - Calculates the net present value of a series of cash flows at a given discount rate
PMT - Calculates the payment for a loan based on constant payments and a constant interest rate.
PPMT - Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
PV - Returns the present value of an investment.
RATE - Returns the interest rate per period of a loan or investment.
SLN - Returns the straight-line depreciation of an asset for one period
XIRR - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV - Returns the net present value for a schedule of cash flows that is not necessarily periodic

← Back to Formula Reference