Home / Calculators / Price escalation clause calculator
Pricing, payment terms and cost
Price escalation clause calculator: the new price under an index clause
Enter the base price, the index values at signing and now, the share of the price that is fixed and your cap. You get the adjusted price and what it costs over a year.
An escalation clause moves the indexed share of the price with a published index. At the default numbers the price rises from USD 100 to USD 105.36, a change of 5.4%.
Written by Procurement VMS Editorial Team · Reviewed by Michael, Procurement Advisor Expert · Updated
Your numbers
The boxes start with an example so you can see how it works. Replace them with your own figures.
Your result
The price moves from USD 100 to USD 105.36, a change of 5.4%, or USD 53,559 a year at your volume. The cap has not been reached.
| Adjusted price before the cap | USD 105.36 |
|---|---|
| Adjusted price after the cap | USD 105.36 |
| Change in price | 5.4% |
| Change in yearly cost | USD 53,559 |
| Increase removed by the cap | USD 0 |
The currency box changes the label only. Enter amounts in the currency you choose.
Free PDF and Excel
Save this result as a PDF guide and an Excel model
Free to download. You enter your name, work email and phone number, and the files are ready at once.
- PDF guide with the formula, a worked example and a checklist of what to enter
- Excel model with live formulas, so your own numbers recalculate at once
- Ready at once after the form, with no account to create
The files open with the example numbers from the page. Type yours over the blue cells in the Excel file. The calculator on this page is free to use without a form.
How the price escalation clause calculator works
The formula
Adjusted price = base price x (fixed share + indexed share x current index / base index), limited to base price x (1 + cap).
Escalation clauses tie a long contract to something outside the supplier control, such as a producer price index, so neither side is caught out when costs move. Used well they protect the supplier from loss and the buyer from arbitrary increases.
Three terms decide the cost: which index, what share of the price it applies to, and whether there is a cap. A clause with the whole price indexed and no cap transfers all the risk to you.
The example numbers are illustrative and are not benchmarks. Use your own data for any decision.
How to use it with your own data
- Find the index named in the clause and its values at signing and at the adjustment date.
- Enter the indexed share. Ask the supplier to justify any share above the real material cost in the price.
- Set the cap, and test the price with and without it.
Mistakes that skew the answer
Indexing the whole price
Labour and margin do not follow a commodity index. Index only the share that does.
Choosing a vague index
Name the published series, the table and the date of the figure used, so the adjustment can be checked.
Leaving out a cap or a floor
Without a cap you carry the full upside risk. A floor protects the supplier, so a reciprocal floor can be a fair trade for a cap.
What to do with the result
Test the supplier increase against your budget with the supplier price increase impact calculator, and draft the clause with your legal team using the contract negotiation guide. Track adjustment dates on your contract renewal tracker.
Questions about the price escalation clause calculator
What is a price escalation clause?
It is a contract term that adjusts the price during the contract according to a stated index or cost, usually at set dates.
What index should I use?
Use a published index that tracks the cost the supplier carries, for example a materials or producer price index. Name the exact series in the contract.
Why have a cap?
A cap limits how far the price can rise in one adjustment, which protects your budget when the index spikes.
Can the price go down?
Only if the clause is written to work both ways. Ask for symmetry, so a falling index lowers the price.