Home / Expatriate insurance / Expatriate Cost Of Living Allowance Formula

Expatriate Cost Of Living Allowance Formula

A Cost of Living Allowance (COLA) is a salary supplement paid to employees to cover differences in the cost of the purchases from the basket group, particularly as a result of an international assignment.

The amount should enable an expatriate to be able to purchase the same basket of goods and services in the host location as they could in their home country. The basis for calculating a COLA is the Cost of Living Index (COLI), which indexes the costs of the same basket of goods and services in different geographic locations. It is a simple accurate method of measuring fluctuating salary purchasing power and ensuring parity.

Cost of Living Index

Xpatulator's Index measures the cost of 230 products and services across 13 different basket groups in 950 cities across the globe. The data is gathered by a team of research analysts who survey comparable items that are available internationally. A minimum of 3 prices for the same brand/size/volume of product is used to determine the average price for each item in each location. The items are priced on a quarterly basis and tend to rise and fall with inflation. The 13 different basket categories are as follows:

1. Alcohol & Tobacco: Alcoholic beverages and tobacco products

2. Clothing: Clothing and footwear products

3. Communication

4. Education

5. Furniture & Appliances: Furniture, household equipment and household appliances

6. Groceries: Food, non-alcoholic beverages and cleaning material

7. Healthcare: General Healthcare, Medical and Medical Insurance

8. Household Accommodation: Housing, water, electricity, household gas, household fuels, local rates and residential taxes

9. Miscellaneous: Stationary, Linen and general goods and services

10. Personal Care: Personal Care products and services

11. Recreation and Culture

12. Restaurants, Meals Out and Hotels

13. Transport: Public Transport, Vehicle Costs, Vehicle Fuel, Vehicle Insurance and Vehicle Maintenance

Each basket category does not count equally and are weighted in the final calculation based on expatriate spending patterns.

In order to calculate an accurate index for a specific individual the basket items that are not relevant to the individual should be excluded from the calculation. For example if education and housing is provided by the employer these basket categories would be excluded from the cost of living index calculation. This increases the accuracy of the index and makes it possible for each individual to have their own customized COLI based on their specific arrangements rather than using an overall “generic” index which is likely to contains costs that are not relevant to the individual.

The formula for calculating the specific index for an international assignment is as follows:

Cost of Living Index = Customized COLI for Host City / COLI for Home City

When moving to a higher cost host city, the index will be greater than 1 (positive). When moving to a lower cost host city the index will be less than 1 (negative). Where the index is negative it means that in real terms the cost in the host city is lower than the home city. This means that if the negative index were to be applied to the employee's salary, they would actually be paid proportionately less spendable salary in the host city. It is important to note that the majority of organizations do not apply a negative cost of living index because it makes it difficult to persuade an employee to take up an assignment as they tend to see it as a reduction in salary.

Examples of Cost of Living Index Calculations using our data:

Example 1)

An Australian employee moving from Perth to London where healthcare and communication will be provided by the employer

More Expensive in London:

Alcohol & Tobacco +4.77%

Clothing +21.85%

Education +31.53%

Furniture & Appliances +16.03%

Groceries +16.35%

Household +50.72%

Miscellaneous +137.47%

Personal Care +11.18%

Recreation & Culture -6.82%

Restaurants Meals Out and Hotels +34.99%

Transport +19.80%

The overall difference in moving from Perth and London is +28.06%.

In this case the index is positive and would be applied as it is.

Example 2)

A British employee moving from London to Mumbai where the employer will provide housing and education

More Expensive in Mumbai:

Alcohol & Tobacco -37.53%

Clothing -9.58%

Communication -44.92%

Furniture & Appliances -19.31%

Groceries -24.03%

Healthcare -31.24%

Miscellaneous -72.43%

Personal Care -24.94%

Recreation & Culture -35.73%

Restaurants Meals Out and Hotels -33.11%

Transport is -27.99%

The overall difference in moving from London Mumbai is -30.53%.

In this case the index is negative and would not be applied.

Net Spendable Salary

Differences in cost of living only impact the portion of the salary that is spendable in the host country. Items in the home country such as retirement funding, medical insurance and other home based costs are not impacted by the cost in the host country.

To determine the Net Spendable Salary establish what amount / portion of the current salary (in home currency) is spent in maintaining the employee's current standard of living / lifestyle. What will the expatriate need to spend their salary on in the host country? For example will accommodation be provided or will the employee pay rent, will healthcare be provided etc. Deduct all items that are either provided in kind or are spendable in the home country. Deduct the hypothetical amount of tax, social contributions and any other statutory deductions applicable in the home country from the Spendable Salary. What is left is the Net Spendable Salary.

The formula for calculating a cost of living allowance (COLA) using the inputs discussed are as follows:

(Net Spendable Salary x Cost of Living Index x Hardship Index x Exchange Rate) less (Net Spendable Salary x Exchange Rate) = COLA

Examples of COLA Calculations using our data

Example 1)

An Australian employee with a net spendable salary of AUD$100,000 moving from Perth to London where healthcare and communication will be provided by the employer

($100,000.00 X 1.2806 X 1 X 0.4768) less ($100,000.00 X 0.4768) = COLA of 13,379.44 (GBP)

Based on all the above factors a person would require a Cost of Living Allowance of 13,379.44 (GBP). In addition to their current salary of 100,000.00 Australian Dollar (AUD) to compensate for relocating from Perth to London. This Cost of Living Allowance compensates for the overall cost of living difference of +28.06% and the relative difference in hardship of 0%.

Example 2)

A British employee with a net spendable salary of 18,000 moving from London to Mumbai where the employer will provide housing and education

Note: Because the COLI is negative it is not applied.

(18,000.00 X 1 X 1.3 X 67.2852) less (18,000.00 X 67.2852) = COLA of 363,340.32 Indian Rupee

Based on all the above factors a person would require a Cost of Living Allowance of 363,340.32 (INR ), in addition to their current salary of 18,000.00 British Pound (GBP ) to compensate for relocating from London to Mumbai. This COLA compensates for the overall cost difference of [-30.53%] and the relative difference in hardship of 30%.

COLA Payment

The COLA is paid as a salary supplement (i.e. as an additional allowance) net of tax in the host country. If the COLA is a taxable allowance in the host country it should be grossed up in order that the full amount of calculated COLA is paid net of tax given that the basis of the calculation is Net Spendable Salary. The cost of living allowance is often accompanied by other allowances and benefits such as flights home, relocation / settling in allowance, and furnishing allowance.


Exchange Rate Fluctuations

Significant changes in the exchange rate can make a considerable difference in the COLA calculation. In 2010-2011 some of the major global exchange rates changed by as much as 30-40%.

The COLI reflects the changes caused by inflation and exchange rates. In the short-term there may be disequilibrium between inflation and the exchange rate (the one pushes the other), however over time the cost of living index provides the most accurate view of the cost of living.

It is important to remind expatriates that when the COL difference is negative, and the negative value has not been applied, they have higher purchasing power in the host country than they would at home.

Where a negative COLI has not been applied (our recommended approach), and a change in the exchange rate indicates an upward adjustment in COLA may be required, it is recommended that the COLA should not be adjusted upward until the COLI becomes positive i.e. the COL reflects that there is a “real” increase in cost of living between home and host countries. This may mean that their would be no increase in the COLA as a result of exchange rate fluctuations for some considerable time. During this time the employee's purchasing power decreases. But it is important to remember that until the cost of living difference becomes positive, the individual will still have a higher purchasing power than they do in their home country.

It is advisable to stipulate a currency protection rule, rather than reacting to every fluctuation in the exchange rate. For example the rule may state that COLA will be reviewed if exchange rates or local inflation move by more than +10% during a year. It is important to keep in mind that the prices of goods and services are unlikely to drop in local currency. This would only occur in a period of deflation (negative inflation). Therefore the currency protection rule would normally make provision for upward adjustments in COLA and not downward adjustments during an employee's assignment. Downward adjustments to an existing COLA due to exchange rate fluctuations without a corresponding drop in the prices of local goods and services puts immense pressure on an employee's host currency budget commitments and can lead to the employee experiencing financial difficulty.

Using an independent service provider provides an independent, objective basis for determining an employee's COLA.

We recommend therefore that a COLA is calculated by applying the specific (customized) cost of living index to the net spendable salary at the beginning of the assignment and monitoring exchange rate fluctuations thereafter in addition to the annual salary review.

About super