Price Escalation & Index Clause Calculator Dashboard – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Compare five uplift mechanisms year by year and see, in one number, whether the escalation clause costs more over the term than the discount you won at signature.
2. Quantify what a cap is worth before you ask for it, so the ask is proportionate and the case for it is arithmetic rather than assertion.
3. Test the same contract at a low and a high index assumption, and see exactly how much inflation risk is being transferred to you.

PROCUREMENT STRATEGY EXCEL DESCRIPTION

Price Escalation & Index Clause Calculator is an Excel template (XLSX) available for immediate download upon purchase.

The discount is negotiated in the room. The uplift is agreed in a
schedule, three weeks later, by somebody else. Almost nobody puts the two
numbers next to each other, and that is why multi-year indirect contracts
so often deliver a smaller saving than the announcement claimed.

This model puts them next to each other.

WHAT IT DOES

Enter the list price before discount, the discount you have been offered,
the term and your own index assumption for each anniversary. The model
calculates the price paid in every year under five mechanisms: a fixed
price for the whole term, an uncapped index, an index capped at your cap,
a collar with both a cap and a floor, and a fixed annual uplift. The
compounding is done properly rather than approximated, over a term of up
to seven years.

It then produces the comparison that settles the argument. The value of
the signature discount over the whole term, set against the extra cost of
each uplift mechanism over that same term, and a net position line for
both the uncapped and the capped case.

In the worked example supplied, a five per cent discount on a five-year
contract is worth 125,000 and an uncapped index running at four per cent
takes back 197,753. The net position is negative and the cell turns red.
That is not an unusual result. It is the normal one, and it is invisible
until somebody models it.

The model also isolates what the cap alone is worth, which matters
commercially: a cap is a smaller ask than a discount, it is easier to
obtain, it costs the supplier nothing in a normal year, and it is
frequently worth more.

THE SECOND SHEET

A reference on the five mechanisms: what each one does, who it protects,
and the position to open from. It also covers the part that is usually
overlooked entirely, which is the index itself. A general consumer price
index and a sector labour cost index can diverge by several points in the
same year, and a supplier will propose whichever has been rising fastest.
The sheet sets out the five things a clause has to name – the index, the
publishing body, the exact series, the reference month, and what happens
if the series is discontinued or rebased – because a clause saying only
"CPI" is an argument scheduled for the first anniversary. WHO THIS IS FOR

Category managers and procurement leads who negotiate commercial terms and
have to defend the outcome to a finance function. Consultants who need a
defensible model in the first week of an engagement. Finance business
partners who validate what procurement claims. It assumes professional
judgement and supplies the arithmetic, not the other way round.

HOW THE FILE IS BUILT

One Excel workbook, self-contained. A read me sheet stating what the model
does, how to use it and what it is not. The working sheets, with a worked
example filled in throughout and designed to be overwritten. A licence
sheet.

Every cell is unlocked. Every formula is visible and editable. Nothing is
password-protected, because a model a professional cannot adapt into their
own situation is worth nothing. The colour convention is consistent across
the whole catalogue: a yellow fill with blue text is an input you supply,
black text is a formula, green text is a reference to another sheet.

WHAT IS DELIBERATELY NOT IN IT

No benchmarks. No market prices, no index forecasts, no industry margin
ranges, no assumed cost of capital held as a constant. Every field of that
kind is an input, left empty or left as an example, and labelled as an
input. A fabricated benchmark is worse than no benchmark, because a
fabricated number gets reported and then defended.

This is educational and commercial material. It is not legal, tax,
financial or accounting advice and it creates no professional
relationship. Where the subject touches contract wording, classification
or regulation, the file says plainly where your own adviser has to take
over.

LICENCE

Use inside one organisation by up to ten named users, with unlimited
internal adaptation. No resale, redistribution or use as the basis of a
training or consultancy product supplied to third parties. The author
terms inside the file prevail over any more permissive default marketplace
terms.

Source: Best Practices in Procurement Strategy, Contract Excel: Price Escalation & Index Clause Calculator Excel (XLSX) Spreadsheet, Davide Sferrazza