Open calculator ↗

Cash discount versus extended terms for a supplier · Calculation guide

Compare early and late settlement using the extra credit days.

Calculation guide

Annualize the implied financing cost on a compound 365-day basis. Compare with a funding rate expressed on the same effective annual basis.

Effective annual cost of forgoing discount = 100 × ((1 / (1 − Early payment discount / 100))^(365 / (Full payment deadline in days − Discount deadline in days)) − 1). Net early-payment saving at late due date = Gross invoice − Gross invoice × (1 − Early payment discount / 100) × (1 + Alternative annual funding cost / 100)^((Full payment deadline in days − Discount deadline in days) / 365)

Inputs

Gross invoice

Example entry 1000 (in the selected currency).

Early payment discount

Example entry 2 %. Allowed range 0 to 100.

Discount deadline in days

Example entry 10. Use whole numbers.

Full payment deadline in days

Example entry 30. Use whole numbers.

Alternative annual funding cost

Example entry 10 %. Allowed range 0 to 100.

Worked example

InputValue
Gross invoice1,000
Early payment discount2%
Discount deadline in days10
Full payment deadline in days30
Alternative annual funding cost10%
ResultValue
Effective annual cost of forgoing discount44.585293%
Net early-payment saving at late due date14.868586

Calculation steps

Effective annual cost of forgoing discount = (100 × (((1 ÷ (1 − (Early payment discount ÷ 100))) ^ (365 ÷ (Full payment deadline in days − Discount deadline in days))) − 1))

(100 × (((1 ÷ (1 − (2 ÷ 100))) ^ (365 ÷ (30 − 10))) − 1)) = 44.585293%

Net early-payment saving at late due date = (Gross invoice − ((Gross invoice × (1 − (Early payment discount ÷ 100))) × ((1 + (Alternative annual funding cost ÷ 100)) ^ ((Full payment deadline in days − Discount deadline in days) ÷ 365))))

(1,000 − ((1,000 × (1 − (2 ÷ 100))) × ((1 + (10 ÷ 100)) ^ ((30 − 10) ÷ 365)))) = 14.868586

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Gross invoice1,0001,100Net early-payment saving at late due date14.86858616.355445
Early payment discount2%3%Effective annual cost of forgoing discount44.585293%74.34755%
Discount deadline in days1011Effective annual cost of forgoing discount44.585293%47.418404%
Full payment deadline in days3033Effective annual cost of forgoing discount44.585293%37.796556%
Alternative annual funding cost10%11%Net early-payment saving at late due date14.86858614.379957
Cash discount versus extended terms for a supplier →

Sources