ProMill Projects & InvestmentContract Economics

The Escalator You Signed, and the One That Pays

Everybody signs the clause believing it makes the cost a pass-through. The shortfall is not an accident; it is four ordinary terms nobody added together.

The Contract Base

The two numbers the clause was written against

The index level the contract price was struck at

What the fibre in a kilogram of product cost you when the contract was signed

The Four Terms

Each is defensible alone, and each will be defended alone

The fraction of the index move the clause passes on

No adjustment until the index has moved this far. Moves inside it are absorbed entirely by the seller

Maximum adjustment in either direction. Zero for no cap

How many periods back the index the clause reads is drawn from

The Contract Period, Month by Month

One row per period IN ORDER - the lag is applied by counting rows, so the sequence is part of the model. The index is the one the contract names. Your actual raw cost is what you paid for the fibre that went into that period, which is the whole point: the gap between it and the index is the basis, and no clause term recovers that.

PeriodIndex pointsWhat You Actually Paid cost/kgVolume kgIndex Move the Clause Reads %Adjustment Granted %Recovered cost/kgIncurred cost/kgGap cost/kgGap on the Volume costRow actions
——————
——————
——————
——————
——————
——————
——————
——————
——————
——————
——————
——————

Add line opens a form. Cells in the sheet stay directly editable.

How to read this sheet

The four term costs are independent sensitivities - each is what removing that one term alone would have been worth - and they deliberately do not add up to the shortfall. They interact, sometimes strongly: on the seeded contract, removing the lag lets the index run higher and the cap then bites harder, so the two cannot simply be summed. Any split that reconciled exactly would be an allocation convention invented here, and the question a negotiator actually has is which single sentence to reopen. Whatever is left after all four is the basis, and no clause term recovers it: the index is a market and you buy a growth, a staple, a grade and a delivery point, and the differential between them moves on its own. If the basis is the largest part of your shortfall the answer is not a better clause but a different index, or a formula written on your own purchase records. This is a backward look and its honesty comes entirely from using real history: run it on the period that hurt and on a period that did not, because a clause that recovers well in a rising market can pay out against you in a falling one, and a cap is symmetric on this sheet whether or not your contract says so. Nothing here prices the commercial reality that a supplier who wins every clause argument may lose the account, that the buyer conceded something elsewhere for these terms, or that an unindexed contract at a higher base price might have been the better trade all along.

Textile SchoolThe Escalator You Signed, and the One That Payswww.textileschool.com

The Escalator You Signed, and the One That Pays — free while in preview, with every line item and the download, at Textile School.