PIDILITE INDUSTRIES LTD SCREENER.

IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Trailing Best Case Worst Case
Sales 5,361.17 5,616.79 6,078.41 7,077.96 7,294.47 7,292.71 9,920.96 11,799.10 12,382.99 13,140.31 13,140.31 14,430.77 13,943.95
Expenses 4,187.69 4,354.90 4,737.19 5,707.32 5,718.45 5,606.36 8,064.55 9,813.01 9,674.54 10,131.08 10,131.08 11,126.02 11,071.89
Operating Profit 1,173.48 1,261.89 1,341.22 1,370.64 1,576.02 1,686.35 1,856.41 1,986.09 2,708.45 3,009.23 3,009.23 3,304.76 2,872.06
Other Income 81.03 115.45 153.00 129.79 97.27 74.03 39.06 54.53 62.75 222.30 222.30 - -
Depreciation 100.47 115.14 119.88 132.74 169.92 200.66 239.61 269.74 340.66 358.48 358.48 358.48 358.48
Interest 13.27 13.93 15.54 26.07 33.60 37.23 42.08 47.64 51.19 50.35 50.35 50.35 50.35
Profit before tax 1,140.77 1,248.27 1,358.80 1,341.62 1,469.77 1,522.49 1,613.78 1,723.24 2,379.35 2,822.70 2,822.70 2,895.93 2,463.23
Tax 333.54 385.05 392.71 413.23 347.72 396.36 407.02 434.37 631.93 726.53 726.53 26% 26%
Net profit 802.83 859.99 962.35 924.91 1,116.42 1,131.21 1,207.56 1,273.25 1,729.38 2,076.24 2,076.24 2,150.55 1,829.22
EPS 15.66 16.77 18.95 18.21 21.97 22.26 23.76 25.05 34.00 40.82 40.82 42.28 35.96
Price to earning 37.63 41.68 48.43 68.45 61.73 81.29 103.31 93.94 88.66 69.80 74.27 81.67 69.93
Price 589.30 699.15 917.80 1,246.25 1,356.40 1,809.40 2,454.30 2,353.00 3,014.70 2,849.30 3,031.70 3,452.82 2,514.71

RATIOS:
Dividend Payout 26.50% 28.32% 31.66% 35.70% 31.86% 38.19% 42.09% 43.91% 47.06% 48.99%
OPM 21.89% 22.47% 22.07% 19.36% 21.61% 23.12% 18.71% 16.83% 21.87% 22.90% 22.90%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST

Sales Growth 10.47% 11.64% 12.49% 9.82% 6.12% 9.82% 6.12%
OPM 20.90% 20.60% 20.62% 20.64% 22.90% 22.90% 20.60%
Price to Earning 69.93 80.18 85.21 81.67 74.27 81.67 69.93
PIDILITE INDUSTRIES LTD [Link]

Narration Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25
Sales 2,997.59 2,689.25 3,275.11 3,076.04 3,129.99 2,901.85 3,395.35 3,234.91 3,368.91 3,141.14
Expenses 2,501.73 2,231.55 2,569.11 2,397.68 2,387.54 2,326.91 2,583.42 2,467.32 2,570.98 2,509.36
Operating Profit 495.86 457.70 706.00 678.36 742.45 574.94 811.93 767.59 797.93 631.78
Other Income 6.73 22.82 23.43 31.59 37.22 -22.79 53.94 57.12 55.78 55.46
Depreciation 68.62 76.16 73.43 75.21 79.49 112.53 84.42 87.88 89.50 96.68
Interest 15.09 11.84 11.88 13.13 12.76 13.42 11.82 11.73 12.45 14.35
Profit before tax 418.88 392.52 644.12 621.61 687.42 426.20 769.63 725.10 751.76 576.21
Tax 111.14 106.66 170.43 163.08 176.50 121.91 198.36 184.80 194.68 148.69
Net profit 304.17 283.03 468.16 450.15 510.48 300.60 566.92 534.56 552.42 422.34

OPM 17% 17% 22% 22% 24% 20% 24% 24% 24% 20%
PIDILITE INDUSTRIES LTD [Link]

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Equity Share Capital 51.27 51.27 50.78 50.80 50.81 50.82 50.83 50.83 50.86 50.86
Reserves 2,586.72 3,419.64 3,523.26 4,097.29 4,404.80 5,542.14 6,352.88 7,161.45 8,356.30 9,703.60
Borrowings 80.02 97.51 124.57 112.74 287.69 331.00 415.83 390.61 382.47 454.14
Other Liabilities 995.87 1,202.01 1,499.99 1,642.96 1,779.40 2,889.87 2,674.80 2,901.98 3,285.98 3,802.87
Total 3,713.88 4,770.43 5,198.60 5,903.79 6,522.70 8,813.83 9,494.34 10,504.87 12,075.61 14,011.47

Net Block 1,137.46 1,275.25 1,342.19 1,447.61 1,806.71 4,417.92 4,703.26 4,914.08 5,450.63 5,705.29
Capital Work in Progress 158.07 147.71 227.73 242.13 259.33 293.87 225.42 405.94 148.09 128.95
Investments 705.54 1,443.10 1,245.94 1,547.70 1,186.19 515.97 458.61 880.85 2,235.04 3,551.32
Other Assets 1,712.81 1,904.37 2,382.74 2,666.35 3,270.47 3,586.07 4,107.05 4,304.00 4,241.85 4,625.91
Total 3,713.88 4,770.43 5,198.60 5,903.79 6,522.70 8,813.83 9,494.34 10,504.87 12,075.61 14,011.47

Working Capital 716.94 702.36 882.75 1,023.39 1,491.07 696.20 1,432.25 1,402.02 955.87 823.04
Debtors 701.59 768.54 938.13 1,056.01 1,088.50 1,321.02 1,430.54 1,535.27 1,674.69 1,811.15
Inventory 627.43 720.86 804.33 934.45 929.47 1,234.15 1,695.09 1,817.08 1,414.90 1,685.09

Debtor Days 47.77 49.94 56.33 54.46 54.47 66.12 52.63 47.49 49.36 50.31
Inventory Turnover 8.54 7.79 7.56 7.57 7.85 5.91 5.85 6.49 8.75 7.80

Return on Equity 30% 25% 27% 22% 25% 20% 19% 18% 21% 21%
Return on Capital Emp 40% 38% 34% 33% 29% 26% 25% 30% 30%
PIDILITE INDUSTRIES LTD [Link]

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Cash from Operating Activity 907.47 793.75 796.43 844.78 1,279.55 1,392.13 955.37 1,557.57 2,724.03 2,286.63
Cash from Investing Activity -491.14 -878.97 39.26 -513.14 102.94 -1,687.89 -558.14 -898.95 -1,769.29 -1,541.59
Cash from Financing Activity -371.06 40.66 -789.75 -360.56 -849.21 -76.24 -467.96 -656.43 -742.45 -917.94
Net Cash Flow 45.27 -44.56 45.94 -28.92 533.28 -372.00 -70.73 2.19 212.29 -172.90
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: [Link]

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: support@[Link]
s… do ANYTHING.
COMPANY NAME PIDILITE INDUSTRIES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 50.86
Face Value 1.00
Current Price 3,031.70
Market Capitalization 154,207.04

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 5,361.17 5,616.79 6,078.41 7,077.96
Raw Material Cost 2,561.41 2,670.29 2,883.88 3,661.79
Change in Inventory -23.27 30.73 -3.77 75.21
Power and Fuel 48.97 53.21 59.16 66.43
Other Mfr. Exp 345.80 56.83 109.42 122.97
Employee Cost 572.46 645.62 712.88 837.13
Selling and admin 434.86 736.40 766.29 845.90
Other Expenses 200.92 223.28 201.79 248.31
Other Income 81.03 115.45 153.00 129.79
Depreciation 100.47 115.14 119.88 132.74
Interest 13.27 13.93 15.54 26.07
Profit before tax 1,140.77 1,248.27 1,358.80 1,341.62
Tax 333.54 385.05 392.71 413.23
Net profit 802.83 859.99 962.35 924.91
Dividend Amount 212.77 243.53 304.68 330.20

Quarters
Report Date Dec-22 Mar-23 Jun-23 Sep-23
Sales 2,997.59 2,689.25 3,275.11 3,076.04
Expenses 2,501.73 2,231.55 2,569.11 2,397.68
Other Income 6.73 22.82 23.43 31.59
Depreciation 68.62 76.16 73.43 75.21
Interest 15.09 11.84 11.88 13.13
Profit before tax 418.88 392.52 644.12 621.61
Tax 111.14 106.66 170.43 163.08
Net profit 304.17 283.03 468.16 450.15
Operating Profit 495.86 457.70 706.00 678.36

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 51.27 51.27 50.78 50.80
Reserves 2,586.72 3,419.64 3,523.26 4,097.29
Borrowings 80.02 97.51 124.57 112.74
Other Liabilities 995.87 1,202.01 1,499.99 1,642.96
Total 3,713.88 4,770.43 5,198.60 5,903.79
Net Block 1,137.46 1,275.25 1,342.19 1,447.61
Capital Work in Progress 158.07 147.71 227.73 242.13
Investments 705.54 1,443.10 1,245.94 1,547.70
Other Assets 1,712.81 1,904.37 2,382.74 2,666.35
Total 3,713.88 4,770.43 5,198.60 5,903.79
Receivables 701.59 768.54 938.13 1,056.01
Inventory 627.43 720.86 804.33 934.45
Cash & Bank 131.76 99.94 163.58 190.43
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 1.00 1.00 1.00 1.00

CASH FLOW:
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activity 907.47 793.75 796.43 844.78
Cash from Investing Activity -491.14 -878.97 39.26 -513.14
Cash from Financing Activity -371.06 40.66 -789.75 -360.56
Net Cash Flow 45.27 -44.56 45.94 -28.92

PRICE: 589.30 699.15 917.80 1,246.25

DERIVED:
Adjusted Equity Shares in Cr 51.27 51.27 50.78 50.80
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

7,294.47 7,292.71 9,920.96 11,799.10 12,382.99 13,140.31
3,381.28 3,494.99 5,689.14 6,821.12 5,867.90 6,135.04
-21.22 118.32 244.96 61.72 -126.12 138.76
67.19 68.66 87.89 97.04 106.92
153.27 226.50 299.49 329.87 412.83
927.66 981.91 1,113.24 1,246.25 1,465.97 1,741.62
905.14 769.96 908.39 1,142.26 1,460.42
262.69 182.66 211.36 238.19 234.38 2,393.18
97.27 74.03 39.06 54.53 62.75 222.30
169.92 200.66 239.61 269.74 340.66 358.48
33.60 37.23 42.08 47.64 51.19 50.35
1,469.77 1,522.49 1,613.78 1,723.24 2,379.35 2,822.70
347.72 396.36 407.02 434.37 631.93 726.53
1,116.42 1,131.21 1,207.56 1,273.25 1,729.38 2,076.24
355.67 431.97 508.30 559.13 813.76 1,017.20

Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25

3,129.99 2,901.85 3,395.35 3,234.91 3,368.91 3,141.14
2,387.54 2,326.91 2,583.42 2,467.32 2,570.98 2,509.36
37.22 -22.79 53.94 57.12 55.78 55.46
79.49 112.53 84.42 87.88 89.50 96.68
12.76 13.42 11.82 11.73 12.45 14.35
687.42 426.20 769.63 725.10 751.76 576.21
176.50 121.91 198.36 184.80 194.68 148.69
 510.48 300.60 566.92 534.56 552.42 422.34
742.45 574.94 811.93 767.59 797.93 631.78

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

50.81 50.82 50.83 50.83 50.86 50.86
4,404.80 5,542.14 6,352.88 7,161.45 8,356.30 9,703.60
287.69 331.00 415.83 390.61 382.47 454.14
1,779.40 2,889.87 2,674.80 2,901.98 3,285.98 3,802.87
6,522.70 8,813.83 9,494.34 10,504.87 12,075.61 14,011.47
1,806.71 4,417.92 4,703.26 4,914.08 5,450.63 5,705.29
259.33 293.87 225.42 405.94 148.09 128.95
1,186.19 515.97 458.61 880.85 2,235.04 3,551.32
3,270.47 3,586.07 4,107.05 4,304.00 4,241.85 4,625.91
6,522.70 8,813.83 9,494.34 10,504.87 12,075.61 14,011.47
1,088.50 1,321.02 1,430.54 1,535.27 1,674.69 1,811.15
929.47 1,234.15 1,695.09 1,817.08 1,414.90 1,685.09
703.25 451.46 355.17 326.65 533.29 336.21
### ### ### ### ###

1.00 1.00 1.00 1.00 1.00 1.00

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

1,279.55 1,392.13 955.37 1,557.57 2,724.03 2,286.63
102.94 -1,687.89 -558.14 -898.95 -1,769.29 -1,541.59
-849.21 -76.24 -467.96 -656.43 -742.45 -917.94
533.28 -372.00 -70.73 2.19 212.29 -172.90

1,356.40 1,809.40 2,454.30 2,353.00 3,014.70 2,849.30

50.81 50.82 50.83 50.83 50.86 50.86