Free tool · Money

CPAP escalation calculator

Enter the amount and the index for the base month and the valuation month. You get the escalation factor and the amount, with the fixed portion taken out.

Enter the amount and both index values.

The formula

Contract price adjustment moves the adjustable part of a payment with a published cost index. The standard formula holds back a fixed portion (x, usually 15%) that never escalates: escalation = amount × (1 − x) × (current index ÷ base index − 1).

The base month is set in the contract data, usually the month before tenders closed. The indices come from Statistics South Africa's contract price adjustment provisions (P0151.1), by work group.

Where the indices come from

Pick a series to fill the index values from Sakhani's index library where it holds them, or type the values from the Stats SA table yourself. The result shows which values were used.

Worked example

R1 000 000 of work valued this month, a base index of 100.0 and a current index of 110.0 give a ratio of 1.10. With the 15% fixed portion, the escalation is 0.85 × 10% = 8.5%, which is R85 000.

Questions about the cpap escalation calculator

What is the fixed portion (x)?

The share of the price that does not escalate, set in the contract data. 15% is the common figure; some contracts use 10% or 20%.

Which work group should I use?

The one named in your contract data. Building work and civil work use different work groups with different mixes of labour, plant, materials and fuel.

Can escalation be negative?

Yes. If the index falls below the base, the adjustment reduces the amount.

Does escalation apply to the whole contract value?

To the value of work done in each valuation period, as the contract specifies, not the contract sum as a whole.

More free tools

All 11 free tools

Upload one contract this week. See the last day appear.

Free trial, no card. Hosted on AWS in Cape Town under POPIA. Your contracts never train anything.

Built by construction professionalsSecure HTTPSHosted on AWS in Cape TownA person accepts every deadline