MITB Banner

Watch More

Application of Regression model to calculate Economic Volatility Factor

In recent times, the industry is facing a shakeup due to the macroeconomic factors which basically involve the policies like the restrictive measures taken by the US Government on immigration and other trade practices globally. At the same time, strengthening of Indian Rupee against US dollar and Yuan being devalued, there is surely going to be a negative impact on the pricing strategies for the outsourcing countries, which outsource most part of their operations to India, Philippines and some areas of China. In wake of all of this, there needs to be a viable option, to counter these macroeconomic effects in the interest of the countries, which outsource a major portion of their operations to countries with knowingly cheap labor.

India as an export hub of IT services and owing to the significant rate movements against the USD in recent past, there is expected a big effect, both in profits and revenues, to the outsourcing countries, considering US as an outsourcing leader. A viable option to mitigate this is hedging in the commodity market, but the very nature of commodity market trade being speculative, this might not be a very profitable option considering the quantum of currency exchange in question.

This article talks about an alternate solution for the above problem as an application of the analytics tools like SPSS, which are used for performing regression based on the empirical data available for certain macroeconomic factors. This is explained further in more details.

Below model aims to ensure that the profitability of the company remains intact in the highly volatile currency market. This model is a simple application of analytics regression model and gives out a fixed contract rate as an output. This can be used by the company without worrying about the currency volatility, at least for 1 or 2 years down the line after initiating the project.

It is based upon factors such as CPI, inflation rate, trade deficit and other independent variables along with the historical data for past 10 years and then arriving at a fixed rate. This can be used to finalize a contract by the outsourcing company with respective client nations for a 1-year plan (say), on which the returns of the company will be based. Broadly, it focusses on the currency and profitability approach.

With respect to currency, the macroeconomic factors such as Repo rate, Political and economic stability index, inflation rate, trade balance of the target country (geo) are considered. This process can be easily seen in Figure 1 below.

With respect to profitability, this contract price is fixed for a short period, so that the profitability of the company is not affected by the macroeconomic factors to a large extent.

Figure 1

Calculation of Economic Volatility Factor (Derivation)

Suppose, in the client country such as India, the volatility between the INR and USD can affect the price model of the company. So, data of the past 10 years of the target country (India in this case) is taken and a regression analysis is performed over the data. Coefficients are calculated, related to various independent variables.

Year Average Inflation Rate India’s Interest Rate Trade Deficit Political & Trade Stability Index Exchange Rate (USD vs INR)
2005 4.25 6.25 -10,885.60 158 44.11
2006 5.79 7 -12,157.30 161 45.33
2007 6.39 7.5 -9,104.40 167 41.29
2008 8.32 7.91 -8,022.30 167 43.41
2009 10.83 5 -4,724.60 172 48.35
2010 12.11 5.75 -10,284.10 170 45.73
2011 8.87 6.5 -14,612.30 173 46.67
2012 9.3 7.53 -18,406.90 170 53.49
2013 10.92 7.6 -19,999.50 170 58.62
2014 6.37 8 -23,858.90 167 61.02
2015 5.88 7.25 -23,337.10 161 64.15
2016 4.97 6.75 -24,380.10 157 67.21

 

 

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.938619504
R Square 0.881006573
Adjusted R Square 0.813010329
Standard Error 3.869621169
Observations 12
  Coefficients
Intercept 96.36028477
Average Inflation Rate 0.894262226
India’s Interest Rate -1.835227712
Trade Deficit -0.001327113
Political & Trade Stability Index -0.354834882

 

The coefficients found above are then used to form Variable price factor in a model as below

Exchange Volatility Factor (EVF) = 96.36 + 0.89 * (Avg. Inflation Rate of India) – 1.83 * (India’s Interest Rate) – 0.00132 * (India’s Trade Deficit) – 0.3548 * (India’s Political & Trade Stability Index)

 

Using the above equation, along with the various factors associated with the target country, an EVF is calculated and used as a multiplying factor for pricing services and try to smooth out the effect of volatility over a period of around 1 year (say). Thus, making the prices of services relatively immune to the high market volatility and it can then serve as a solution for the given problem.

Final Contract Price = (EVF – Current exchange rate (target country)) / Current exchange rate (target country) * Proposed price by the pricing team

Final price model:

Above model is based upon certain assumptions which are mentioned below and the actual implementation may vary a little, if below left out factors are brought into consideration.

Assumptions:

  • Considering US relation with India and China is independent of each other.
  • Independent variables considered above are good indicators of a country’s performance.
  • Business cycle for the service is 1-year and the macroeconomic factors of the target country are relatively stable.
  • If the final price is coming less that the proposed price by the pricing team, then the proposed price should be considered as the contract price.

Authored by PGPM’18 graduates – Sugam Mahajan, Saurabh Bhavsar, Pratik Menon from Great Lakes Institute of Management, Chennai

Access all our open Survey & Awards Nomination forms in one place >>

Picture of Analytics India Magazine

Analytics India Magazine

Analytics India Magazine chronicles technological progress in the space of analytics, artificial intelligence, data science & big data by highlighting the innovations, players, and challenges shaping the future of India through promotion and discussion of ideas and thoughts by smart, ardent, action-oriented individuals who want to change the world.

Download our Mobile App

CORPORATE TRAINING PROGRAMS ON GENERATIVE AI

Generative AI Skilling for Enterprises

Our customized corporate training program on Generative AI provides a unique opportunity to empower, retain, and advance your talent.

3 Ways to Join our Community

Telegram group

Discover special offers, top stories, upcoming events, and more.

Discord Server

Stay Connected with a larger ecosystem of data science and ML Professionals

Subscribe to our Daily newsletter

Get our daily awesome stories & videos in your inbox
Recent Stories