OracleFree calculatorPDF, Excel, Word exportOracle E-Business Suite

Oracle EBS AP Early Payment Discount Calculator

Payment terms such as 2/10 net 30 look small but are worth well over 30% a year. This calculator shows the true annualized return, the net gain after your cost of funds, and the value across your annual spend.

Your numbers

Invoice amount

Discount percent

Example: 2 for 2/10 net 30.

Discount days

days

Net due days

days

Cost of funds

% per year

Borrowing rate or the return on cash you would otherwise earn.

Annual spend on these terms

Your results

Annualized return of taking the discount

37.2%

Simple annualized rate, no compounding.

Net gain per invoice

$393

Discount per invoice

$500

Cost of paying early

$107

Net gain per year at this spend

$18,845

Simple interest approximation. Ignores tax, supplier relationship effects and whether the discount is taken before or after tax in your Payables setup.

Save results:

Net gain per invoice vs cost of funds

Sweeps Cost of funds from 0 to 40, holding your other inputs fixed.

Lost discount review

Optionally have us outline how to report lost discounts by supplier from your Payables data.

Optional. The tool and every export work without this. No spam.

How to use it

Enter the discount percent and the two day counts from the Payables payment term. In Oracle Payables these live on the term lines, where a discount percent and discount days sit alongside the due days. Add your cost of funds and the annual spend that actually carries those terms. The result tells you whether paying on day 10 beats waiting until day 30, and by how much per invoice and per year.

Only count spend where the supplier really allows the discount.
Use your marginal borrowing rate, not an average rate.
Check how your payment batch selection honors discount dates.

The formula

The annualized return is d / (1 - d) multiplied by 365 / (net days - discount days), where d is the discount as a fraction. For 2/10 net 30 that is 0.02 / 0.98 times 365 / 20, about 37%. The cost of paying early is the discounted amount times the cost of funds times the days accelerated over 365. Net gain is discount minus that financing cost. If annualized return exceeds your cost of funds, taking the discount wins.

ERP notes and common mistakes

Savings are only realized if invoices are entered, approved and selected for payment inside the discount window. Invoices stuck on hold or in approval quietly lose the discount. A useful Payables report is discounts lost by supplier, which is what makes the annual gain figure above worth chasing. Another mistake is applying the discount to tax or freight when the supplier excludes them.

Watch for payment terms where discount days run from the invoice date versus the receipt date.
Pay on the last discount day, not the first, to keep cash longer.
Review holds regularly so approved invoices are not missed.

Frequently Asked Questions

Is 2/10 net 30 really 37% a year?

Using the simple formula, yes: 2 percent for paying 20 days earlier on a 98 percent balance annualizes to about 37 percent. That is far above most borrowing rates, so the discount is usually worth taking.

When is not taking the discount reasonable?

When cash is genuinely constrained and your marginal cost of funds exceeds the annualized return, or when invoices cannot be approved in time. Otherwise the discount normally beats a bank line.

Does Oracle Payables calculate this automatically?

Payables calculates discount amounts from the payment term and selects invoices for payment by discount date, but it does not compare the return to your cost of funds. Finance teams usually do that analysis separately.

Should I compound the return?

Compounding gives a higher effective annual rate and is used by some treasuries. This tool uses the simple form because it is the common convention and is conservative.

If you want a view of discounts taken and lost by supplier directly from your Payables data, we can build a private, read-only dashboard over your EBS tables.

Talk to an Expert Explore More Free Tools

Related Tools

Oracle

More Oracle tools

See all

Back to All Tools