The B2B Price Waterfall Calculator is a free Excel template for modelling how gross list value becomes invoice price, pocket price and pocket margin after customer discounts, promotional discounts, concessions, customer rebates, vendor incentives and cost.

The workbook supports one aggregated deal, a log of up to 100 deals and multi-line, multi-vendor quote analysis.

It calculates price realisation, front-end gross profit and margin, pocket gross profit and margin, margin leakage, leakage percentage, margin delta and an illustrative user-configured commercial review signal.

The workbook does not provide industry benchmarks, recommended margins, acceptable leakage levels or approval policies.

Published by Configure to WIN: https://configure.win/

Official online calculator:
https://configure.win/resources/price-waterfall-calculator

Official source repository:
https://github.com/configure-to-win/b2b-price-waterfall-calculator

Project Activity

See All Activity >

License

Creative Commons Attribution License

Follow B2B Price Waterfall Calculator

B2B Price Waterfall Calculator Web Site

Other Useful Business Software
Cut Data Warehouse Costs by 54% Icon
Cut Data Warehouse Costs by 54%

Easily migrate from Snowflake, Redshift, or Databricks with free tools.

BigQuery delivers 54% lower TCO with exabyte scale and flexible pricing. Free migration tools handle the SQL translation automatically.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of B2B Price Waterfall Calculator!

Additional Project Details

Registered

2026-07-26