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.4 -0.0
Consumer Sentiments Index
Base September-December 2015
95.6 0.0
Consumer Expectations Index
Base September-December 2015
95.7 -0.3
Current Economic Conditions Index
Base September-December 2015
95.5 +0.5
Quarterly CapeEx Aggregates
(Rs.trillion) Sep 17 Dec 17 Mar 18 Jun 18
New projects 1.25 1.49 3.60 2.27
Completed projects 1.25 1.15 1.42 0.82
Stalled projects 0.69 0.88 3.41 0.30
Revived projects 0.34 0.22 0.26 0.22
Implementation stalled projects 0.78 0.71 1.92 0.03
Updated on: 17 Jul 2018 8:20PM
Quarterly Financials of Listed Companies
(% change) Sep 17 Dec 17 Mar 18 Jun 18
All listed Companies
 Income 7.9 12.0 10.2 18.1
 Expenses 9.0 13.0 17.0 21.4
 Net profit -18.0 -14.3 -81.9 8.4
 PAT margin (%) 5.5 4.8 1.2 17.4
 Count of Cos. 4,501 4,491 4,283 45
Non-financial Companies
 Income 8.2 13.3 11.8 18.5
 Expenses 8.1 12.3 12.7 22.7
 Net profit -6.1 13.2 -2.5 6.7
 PAT margin (%) 6.2 6.4 6.5 18.1
 Net fixed assets 9.2 11.9
 Current assets 2.9 8.0
 Current liabilities 11.0 10.3
 Borrowings 3.4 1.8
 Reserves & surplus 7.9 7.8
 Count of Cos. 3,460 3,463 3,315 32
Numbers are net of P&E
Updated on: 17 Jul 2018 8:21PM
Annual Financials of All Companies
(% change) FY15 FY16 FY17 FY18
All Companies
 Income 5.6 1.8 5.8 12.3
 Expenses 5.7 1.9 5.8 17.9
 Net profit 0.1 -9.3 26.2 -51.0
 PAT margin (%) 3.0 2.8 3.5 3.6
 Assets 9.5 10.2 7.3 14.1
 Net worth 8.5 11.3 7.0 11.0
 RONW (%) 5.8 4.9 5.9 4.8
 Count of Cos. 26,056 24,316 21,815 218
Non-financial Companies
 Income 4.8 1.0 5.7 9.8
 Expenses 5.0 0.3 5.9 9.3
 Net profit -8.5 20.4 21.4 11.9
 PAT margin (%) 2.0 2.5 3.0 13.4
 Net fixed assets 13.3 17.4 6.5 21.2
 Net worth 7.0 12.0 5.7 5.3
 RONW (%) 4.6 5.2 6.1 17.7
 Debt / Equity (times) 1.1 1.1 1.0 0.2
 Interest cover (times) 1.9 1.9 2.1 16.0
 Net working capital cycle (days) 66 65 62 -12
 Count of Cos. 21,269 20,387 18,246 150
Numbers are net of P&E
Updated on: 04 Jul 2018 4:50PM