Skip to content

Formula

Build the clause as a formula you can read

Weighted baskets, averaging windows, publication lags, caps, floors, FX conversion and a fixed portion. The concepts in the contract, on the screen, with the arithmetic exposed.

The formula page turns the wording of an index-linked escalation clause into arithmetic you can read on one screen: a weighted basket of index components, an averaging window and publication lag, a base period, caps and floors, FX conversion, and a fixed non-escalating portion. Escalake checks that the component weights resolve to a whole, shows each component's contribution once the data is in, and locks a formula version before every reset.

BASKET

Weights, a base period, and a clear total

Split the adjustment across as many index components as the clause names. Escalake checks that the weights resolve to a whole and shows each component's contribution once the data is in.

  • Any number of weighted components
  • Explicit base period and base values
  • Fixed non-escalating portion

Component contributions once data is in

PPI Steel Mill+3.80
ECI Manufacturing+0.93
Fixed portion0.00
Composite factor1.0471
TIMING

Averaging windows and publication lags

Clauses rarely use a single month. Set a rolling average and a lag so the calculation matches the wording, and Escalake picks the exact observations that satisfy it.

Window resolution · 2024-Q3, 3-mo avg, 1-mo lag

Jun 2024132.10 · FINAL
Jul 2024133.20 · FINAL
Aug 2024134.02 · FINAL
Window average133.11

Controls

The rest of what a clause can say

Caps and floors

Bound the adjustment per period or cumulatively. The binding limit is shown on the result.

FX conversion

Convert a foreign-denominated index into the contract currency with a stated rate source.

Formula versioning

Lock a version before a reset. The history shows what changed between versions and when.

Formula, common questions

How does Escalake build a price escalation formula from a contract clause?

You enter the index components the clause names, their weights, the base period, and the timing rules. Escalake checks the weights sum to one, resolves the averaging window and publication lag against real observations, and applies any cap, floor, FX conversion, or fixed portion. The result is a composite adjustment factor.

What is an averaging window and a publication lag in an escalation clause?

An averaging window means the calculation uses the mean of several months rather than a single reading, which smooths short spikes. A publication lag means it uses data from a month or two earlier, because official statistics are not final on the day the period ends.

Can one contract escalate against more than one index?

Yes. A formula can weight any number of index components, plus a fixed portion that does not escalate. Each component shows its own contribution to the adjustment once the data is in, so you can see which index moved the number.

What happens to the formula when the contract terms change?

Lock a formula version before each reset. If an amendment changes a weight, a base period, or a cap, you create a new version, and the history shows what changed between versions and when. Past adjustments keep pointing at the version that produced them.

Interpretation is human. Arithmetic is not.

Escalake Method

Write the clause once, correctly.

Then let the engine run it every period.