ExcelFlux

DISC function

the discount rate for a security.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Annualize a discount relative to the redemption amount. The same discount implies a higher annualized rate over shorter maturities.

A worked example from the workbook

RowAB
6First inputSecond input
74602346388
84602346205
94602346113
Record 1
=DISC(A7,B7,90,100,3)

Expected result0.1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=DISC(A7,B7,90,100,3)
Turkish Excel · tr-TR
=İNDİRİM(A7;B7;90;100;3)

Worked examples

Annualize a discount relative to the redemption amount. The same discount implies a higher annualized rate over shorter maturities.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First input Second input
7 46023 46388
8 46023 46205
9 46023 46113
Case Formula Expected result
Record 1 =DISC(A7,B7,90,100,3) 0.1
Record 2 =DISC(A8,B8,90,100,3) 0.2005494505
Record 3 =DISC(A9,B9,90,100,3) 0.4055555556
Microsoft Excel reference