# Vendor Early Pay Discount Worksheet (2/10 Net 30 Annualized Return)

> Source: https://netray.co/tools/eclipse-vendor-early-pay-discount-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List your vendors' payment terms, see the annualized return of taking each discount and the dollars saved, and export to Excel.

## Category

cost-finance

## Erp

Epicor Eclipse

## Industry

Wholesale Distribution

## Audience

- Accounts payable manager
- Controller
- Treasury analyst

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Vendor

**Key:** vendor

**Type:** text

#### Annual spend

**Key:** spend

**Type:** number

**Format:** currency

#### Discount

**Key:** disc

**Type:** number

**Unit:** %

#### Discount days

**Key:** disc_days

**Type:** number

**Unit:** days

#### Net days

**Key:** net_days

**Type:** number

**Unit:** days

#### Annualized return

**Key:** annual_rate

**Type:** number

**Expr:** disc / (100 - disc) * 365 / (net_days - disc_days) * 100

**Format:** percent

#### Annual discount value

**Key:** savings

**Type:** number

**Expr:** spend * disc / 100

**Format:** currency

**Rows:**

**Vendor:** Fastener supplier

**Spend:** 1200000

**Disc:** 2

**Disc days:** 10

**Net days:** 30

**Vendor:** Electrical products

**Spend:** 2600000

**Disc:** 1

**Disc days:** 10

**Net days:** 45

**Vendor:** Bearings manufacturer

**Spend:** 850000

**Disc:** 1.5

**Disc days:** 15

**Net days:** 60

**Vendor:** Packaging vendor

**Spend:** 310000

**Disc:** 0.5

**Disc days:** 10

**Net days:** 30

**Vendor:** Tools importer

**Spend:** 940000

**Disc:** 2

**Disc days:** 15

**Net days:** 45

**Totals:**

#### Total spend

**Key:** spend

**Agg:** sum

**Format:** currency

#### Total discount value

**Key:** savings

**Agg:** sum

**Format:** currency

**Summary:**

#### Blended discount rate

**Key:** blended

**Expr:** if(gt(sum_spend, 0), sum_savings / sum_spend * 100, 0)

**Format:** percent

**Notes:** Compare the annualized return to your borrowing rate or return on cash. Take the discount when the return exceeds your cost of funds.

## Content

**Intro:** Early-payment discounts can be the best risk-free return in the company, or a poor deal if the terms are long. This worksheet ranks each vendor by annualized return so AP knows what to pay early.

**Sections:**

#### How to use it

**Body:** List each vendor with annual spend and its terms: the discount percent, the days to earn it and the net due days. The worksheet computes the annualized return of paying early and the dollar value of the discount. Compare each return to your cost of borrowing or your return on cash. Sort mentally from highest to lowest and fund the early payments in that order.

**Bullets:**

- Use only spend that is actually eligible for the discount.
- Update net days if a vendor changes terms.
- Export to Excel and share with treasury before the weekly pay run.

#### The formula

**Body:** Annualized return equals discount divided by (100 minus discount), times 365 divided by (net days minus discount days). For 2/10 net 30, that is 2 over 98 times 365 over 20, which is about 37 percent. A 1/10 net 45 term yields about 10.5 percent. The same discount is far more valuable when the gap between discount date and net date is short.

#### Reading the result

**Body:** If the annualized return exceeds the interest on your revolver, taking the discount is almost always right. If a vendor offers 0.5 percent for paying 20 days early, the return is around 9 percent and may not beat your cost of funds. Remember to check that the vendor honors the discount on partial payments and short shipments.

#### Common mistakes

**Body:** Calculating the return on the full net period instead of the accelerated days badly understates it. Taking the discount but paying late forfeits the benefit and annoys the vendor. Also ensure the discount is calculated on net invoice amounts, excluding freight and tax if the terms say so.

**Cta:** Netray can help identify missed early-payment discounts by comparing payment dates to vendor terms in your ERP data.

**Faq:**

#### What does 2/10 net 30 mean?

**Answer:** The buyer may deduct 2 percent if the invoice is paid within 10 days; otherwise the full amount is due in 30 days. Paying on day 10 instead of day 30 earns roughly 37 percent annualized.

#### Should I always take early pay discounts?

**Answer:** Not always. Take them when the annualized return exceeds your cost of funds or the return on your cash. Cash-strapped firms may borrow to take high-return discounts.

#### How do I handle several vendors?

**Answer:** List each vendor on its own row. The blended rate in the summary shows the average discount value across all spend, but rank by annualized return when funding payments.

#### Does it work in any ERP?

**Answer:** Yes. Enter terms from your vendor master or AP aging, whether the system is Eclipse, Prophet 21 or something else. The sheet does not connect to any system.

## Search terms

early payment discount calculator, 2/10 net 30 annualized, vendor discount worksheet, cash discount analysis, accounts payable discount excel, payment terms analysis template, take or skip early pay discount

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json