The great thing about Screener is that you can view how everything is calculated once you download the excel file.
Here’s what Screener is using to calculate Asian Paint’s Return on Capital Employed as on 2018:
Operating Profit = Rs. 2923.26 Cr
Depreciation = Rs. 311.11 Cr
Tax = Rs. 917.03 Cr
Fixed Assets = Rs. 2568.53 Cr
Working Capital (Other Assets - Other Liabilities) = Rs. 1271.74 Cr
The final calculation done by Screener is as follows:
(2923.23-311.11-917.03)/(2568.33+1271.71) = 43% (As on 2018)
You can see this specific formula in Cell K24 of the ‘Balance Sheet’ sheet.
Incidentally, queries specific to Screener can be posted in this thread: