• Preview of Payment Terms and Early Payment Discount CalculatorExcel workbook preview

Negotiation, Cost Analysis and Savings

Payment Terms and Early Payment Discount Calculator

$17.99 Free XLSX
Excel workbook · 15 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A buyer or accounts payable lead asked by finance which supplier discounts to take and what a change of payment terms is worth.

What is inside

  • 10 sample invoices with discount %, discount days and net days, 16 blank rows
  • Annualised return of each discount compared with your hurdle rate
  • Pay by date, due date and days left; missed discounts turn red
  • Totals of discounts open, missed and taken
  • Payment terms change sheet: working capital and annual financing value per supplier
  • Break-even discount for any discount and net days

How to use it: Set your cost of capital with finance, enter the invoices that offer a discount, pay those marked Take it before their date, and model terms changes on the second sheet.

Files & formats
  • XLSXearly-payment-discount-calculator.xlsx15 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.