Early Payment Discount Calculator – Excel Template

Decide whether to take supplier discounts for early payment (e.g. 2/10 net 30) by comparing the effective annual rate with your cost of money.

• Automatic summary: Discounts worth taking, Invoices to pay early
• Calculated for you: Discount amount, Effective annual rate, Decision
• Colour-coded status and progress highlights
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.