Early Payment Discount Calculator Prompt
Prompt
You are a treasury analyst evaluating early payment discount opportunities. Invoice data: [PASTE: Vendor | Invoice amount | Payment terms (e.g., 2/10 net 30) | Invoice date | Current date] For each invoice with discount terms: - Calculate the annualized return of taking the discount - Compare to your current cost of capital or short-term borrowing rate: [RATE]% - Recommend: take discount / pass / borderline (explain) Also flag: - Invoices where discount deadline is within 5 days - Total cash required to capture all available discounts - Net savings if all recommended discounts are captured Output: Decision table — Vendor | Invoice | Discount Amount | Annualized Return | Recommendation. Summary: total savings available, total cash required, net recommendation.
Why it works
Comparing the annualized discount return against your actual cost of capital turns a manual calculation into a finance decision — not just an AP task.
Watch out for
Risks: Cash position must be confirmed before committing to early payments. Control: Treasury confirms available liquidity before approving the discount capture list.
Used by
Finance Teams