Payrolls database ahoy!

by Mahesh Vyas

Earlier this month, on January 2, I wrote in this column that the government could be employing about 23 million people. This was an estimate based on some simple projections of the number of people employed in state governments, quasi governments and local government bodies. Last week, Dr. Pulak Ghosh of IIM, Bangalore and Dr. Soumya Kanti Ghosh, Group Economist at State Bank of India (Ghosh and Ghosh) released results of their work that, among many other things, said that a conservative estimate of employment in government is 17 million.

Ghosh and Ghosh make their estimate using one set of assumptions and I have made the estimate using another set of assumptions. None of us need to do our respective statistical gymnastics and leave an unexplained gap of 6 million. The government can end this confusion by releasing data that it has in its own records. To get an estimate of this greatest employer in the country, the government, there is no need for any expert committee or any survey with challenges of having a sampling frame or setting up a high-tech execution machinery. It can be done almost immediately with an executive order without any ado.

The Task Force on Improving Employment Data was remiss in not mentioning this low-hanging fruit. All its suggestions will take years to execute. But, making the government to release data on its employment takes little time and effort.

If the government provides jobs to about 20 million people, any change in this number would be large enough to help us understand changes in the organised labour markets. Factory employment is of the order of 13 million; unregistered manufacturing establishments hire another 13 million. Ergo, government employment is almost as large as the people hired in the entire organised and unorganised manufacturing sector in the country.

It would be a great step forward if the government immediately starts releasing monthly data on its own employment.

The main story presented by Ghosh and Ghosh is that about 7 million new jobs were created in 2017-18. Their estimate is based on crunching data sourced from Employees’ Provident Fund Organisation, Employee State Insurance Scheme and National Pension Scheme. Ghosh and Ghosh seem to have had privileged access to this rich database as this data is not available publicly.

All this data is primarily available with the government. There is no need of a sampling frame or a complex execution machinery in deploying this database.

Apparently, Ghosh and Ghosh have overcome several known problems in using data from the EPFO, ESIC and NPS. The problems are duplication of accounts within a database and across databases; weeding out of inactive accounts and differentiating between new jobs and change in job when we see an addition of an account. Ghosh and Ghosh make several assumptions in crunching the massive database. Their assumptions seem primitive but, this is a beginning. A lot more can be done by the government with expert help from the Ghosh duo to deploy this awesome database to tell us what is happening to the formal jobs sector as reflected in payrolls. Progress made by the authors should be consolidated and built upon further.

Household surveys such as the ones done by NSSO or CMIE provide a comprehensive estimate of employment and unemployment, but they do not provide us an estimate of the jobs that people want. People want sarkari jobs above any other form of earning. And, they would like to get a "permanent" job in the organised sector that offers sufficient social security. Such jobs are reflected in the databases of EPFO, ESIC and NPS. The importance of measuring these cannot be overstated.

One limitation of the estimates put out by Ghosh and Ghosh is that there is no base-line estimate to judge the growth in employment. The estimate of 7 million formal jobs being added during 2017-18 is an impressively large number. But, how do we compare this to the stock of such jobs?

According to the BSE-CMIE initiative, total employment during 2017 was of the order of 405 million. An addition of 7 million implies a growth of 1.7 per cent. That’s not much but, if organised employment is about 40 million (20 million in government and 20 million in the formal non-government sectors according to the QES) then 7 million implies a 17.4 per cent growth. That’s a very big growth in meaningful jobs. Is this growth incredible or incredulous?

Ghosh and Ghosh have whetted our appetite. The government needs to pick up the baton from here, as the authors suggest.

First Published in Business Standard Link

Unemployment Rate
Per cent
5.7 +0.1
Consumer Sentiments Index
Base September-December 2015
92.8 -0.4
Consumer Expectations Index
Base September-December 2015
91.9 -0.3
Current Economic Conditions Index
Base September-December 2015
94.1 -0.5
Quarterly CapeEx Aggregates
(Rs.trillion) Mar 17 Jun 17 Sep 17 Dec 17
New projects 4.07 2.13 1.22 1.08
Completed projects 1.96 0.86 1.05 0.92
Stalled projects 0.74 2.67 0.67 0.93
Revived projects 0.86 0.30 0.29 0.23
Implementation stalled projects 0.33 0.69 0.73 0.58
Updated on: 18 Feb 2018 12:20PM
Quarterly Financials of Listed Companies
(% change) Mar 17 Jun 17 Sep 17 Dec 17
All listed Companies
 Income 10.2 9.7 7.9 12.1
 Expenses 11.9 10.0 9.0 12.9
 Net profit 16.4 -19.8 -16.8 -10.4
 PAT margin (%) 6.0 5.3 5.7 5.2
 Count of Cos. 4,469 4,454 4,426 3,985
Non-financial Companies
 Income 11.8 10.3 7.7 13.0
 Expenses 15.6 10.6 7.5 11.8
 Net profit -2.2 -25.2 -4.2 15.7
 PAT margin (%) 6.1 5.2 6.4 6.8
 Net fixed assets 6.9 9.2
 Current assets 2.7 78.8
 Current liabilities 8.9 11.0
 Borrowings 4.9 10.5
 Reserves & surplus 6.1 5.2
 Count of Cos. 3,453 3,439 3,408 3,095
Numbers are net of P&E
Updated on: 18 Feb 2018 12:20PM
Annual Financials of All Companies
(% change) FY14 FY15 FY16 FY17
All Companies
 Income 10.0 5.4 1.4 6.7
 Expenses 9.9 5.5 1.6 7.1
 Net profit -2.5 0.9 -12.9 18.8
 PAT margin (%) 3.1 3.1 2.8 5.6
 Assets 12.3 9.5 9.8 8.4
 Net worth 9.6 8.6 10.8 7.5
 RONW (%) 6.1 6.0 5.0 8.2
 Count of Cos. 24,506 24,447 22,230 10,161
Non-financial Companies
 Income 9.7 4.6 0.5 6.6
 Expenses 9.4 4.7 -0.1 7.7
 Net profit -3.1 -6.9 12.6 11.7
 PAT margin (%) 2.2 2.1 2.5 5.2
 Net fixed assets 11.7 13.2 15.4 7.5
 Net worth 8.2 7.1 11.2 5.5
 RONW (%) 5.1 4.8 5.3 8.9
 Debt / Equity (times) 1.1 1.1 1.1 0.8
 Interest cover (times) 2.0 1.9 1.9 2.8
 Net working capital cycle (days) 69 67 66 52
 Count of Cos. 19,752 19,893 18,615 7,888
Numbers are net of P&E
Updated on: 04 Feb 2018 9:54AM

Data added for HPI at Assessment prices and HPI at Market prices