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.
Official online calculator:
https://configure.win/resources/price-waterfall-calculator
Official source repository:
https://github.com/configure-to-win/b2b-price-waterfall-calculator
B2B Price Waterfall Calculator
Analyse pocket price, pocket margin and margin leakage in B2B deals.
Brought to you by:
configuretowin
Downloads:
0 This Week