Discount Waterfall Calculator

What is Discount Waterfall?

The discount waterfall maps the list-to-invoice bridge: starting from list ARPA, it applies average discount to arrive at realized ARPA, showing how many revenue dollars are surrendered per account per month.

Formula

Version v1. See methodology and the public formula repo for sources and change history.

Worked example

Using the default example inputs (List ARPA (monthly): $1,200; Average discount: 18%), Discount Waterfall equals $984.00 (Realized ARPA). Discounting is within a manageable range; document deal-level approval thresholds so individual rep behavior cannot drift above the average.

What good looks like

Average discounts above 20 to 25% in B2B SaaS often indicate a price architecture problem rather than a competitive one. Sustainable discounting discipline starts with approval thresholds and a documented max-discount policy.

Directional guidance only, not a cohort benchmark claim. Premium cohort bands appear when sample thresholds are met for your profile.

FAQ

What is Discount Waterfall?

The discount waterfall maps the list-to-invoice bridge: starting from list ARPA, it applies average discount to arrive at realized ARPA, showing how many revenue dollars are surrendered per account per month.

What is the Discount Waterfall formula?

Realized ARPA = list ARPA × (1 − average discount %); discount dollars = list ARPA − realized ARPA

What is average discount?

The mean percentage reduction from list price across all new bookings in a period. Compute it as 1 minus the ratio of total realized new ARR to total list-price new ARR.

How should we think about maximum vs. average discount?

Average discount shows systemic behavior; maximum discount shows where approval controls have broken down. Track both. An average of 15% with a max of 60% usually means a few bad deals are masking a bigger problem.

Does this apply to expansion deals?

Run the waterfall separately for new logo and expansion bookings. Expansion discounting is often underreported because it happens through renewal credits and rate holds rather than explicit line items.