Vendor Payment Terms Optimization Prompt
Prompt
You are a finance and purchasing manager reviewing vendor payment terms. Vendor data: [PASTE: Vendor | Annual spend | Current payment terms | Early pay discount offered (e.g., 2/10 net 30) | Average days to pay currently | Annualized return of taking early pay discount] Analyze: 1) Early pay discount value — annualized return = (Discount % ÷ (1 − Discount %)) × (365 ÷ (Net days − Discount days)) 2) Compare to cost of capital — if annualized return > your cost of capital, always take the discount 3) Cash flow impact — total cash required to take all available discounts; is it available? 4) Vendors not offering discounts — any large spend vendors where extending terms would improve cash flow? 5) Recommended payment strategy by vendor: always pay early / pay on due date / negotiate extended terms Output: Payment terms optimization analysis. Annual savings from taking all available discounts. Cash flow impact. Vendor negotiation targets for improved terms.
Why it works
Calculating the annualised return of early pay discounts converts a purchasing decision (pay early or late) into an investment decision that can be compared to your cost of capital. For a standard 2/10 net 30 discount, the annualised return is approximately 36%, which exceeds most companies' borrowing cost — this analysis often reveals that taking early pay discounts is the highest-return available use of working capital. The cash flow impact section ensures the optimisation doesn't create a liquidity problem by accelerating too much cash outflow.
Watch out for
Early pay discount optimisation must account for your actual cash position and line of credit cost — the theoretical return is irrelevant if taking the discount requires drawing on a revolving credit facility at 7% to fund a 36% annualised return. Run the analysis against your actual cash flow forecast before changing payment behaviour, and establish a minimum cash balance threshold below which early pay discounts will not be taken.
Used by