Microsoft® Excel® 2010 Formulas & Functions Inside Out

DISC()

Syntax. DISC(Settlement,Maturity,Price,Redemption,Basis)

Definition. This function calculates the anticipative interest rate (percent markdown, discount, disagio) of a given cash value or final value and the given duration (simple interest yield).

Arguments

• Settlement (required) The date when the ownership of the security changes.

• Maturity (required) The date when the payments from the security must take place.

• Price (required) Specifies the price at which the ownership changes.

• Redemption (required) Describes the payment at the day of maturity.

• Basis (optional) Defines the method you want to use for determining the days in the year according to Table 15-2, shown earlier. If this argument is not used, Excel calculates with Basis = 0.

All function ...