V-GUARD INDUSTRIES LTD SCREENER.

IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Trailing Best Case Worst Case
Sales 1,731.19 1,844.89 2,085.64 2,311.74 2,566.44 2,481.96 2,699.00 3,476.67 4,050.75 4,559.43 4,826.28 5,430.17 5,107.70
Expenses 1,598.18 1,666.88 1,875.70 2,124.02 2,346.74 2,227.95 2,392.22 3,141.85 3,749.65 4,205.17 4,433.06 4,985.32 4,691.55
Operating Profit 133.01 178.01 209.94 187.72 219.70 254.01 306.78 334.82 301.10 354.26 393.22 444.85 416.15
Other Income 4.49 7.23 12.13 10.33 17.98 23.24 20.81 10.25 14.63 51.20 47.23 - -
Depreciation 15.44 15.36 16.24 19.11 21.82 28.09 37.32 47.50 58.44 66.95 66.88 66.88 66.88
Interest 20.61 8.92 2.10 1.66 1.27 3.73 5.60 7.52 15.92 37.46 34.24 34.24 34.24
Profit before tax 101.45 160.96 203.73 177.28 214.59 245.43 284.67 290.05 241.37 301.05 339.33 343.73 315.03
Tax 30.72 49.28 59.12 44.19 49.07 60.28 85.69 63.25 62.05 70.14 79.67 23% 23%
Net profit 70.72 111.68 144.62 133.09 165.53 185.16 198.98 226.80 179.32 230.91 259.66 263.03 241.06
EPS 1.68 2.65 3.41 3.13 3.88 4.32 4.63 5.26 4.15 5.32 5.97 6.05 5.54
Price to earning 38.75 23.71 50.92 71.07 57.34 35.89 54.56 41.06 60.27 62.34 79.44 79.44 52.30
Price 65.24 62.89 173.40 222.20 222.35 155.15 252.35 215.80 250.05 331.35 474.40 480.55 289.97

RATIOS:
Dividend Payout 19.08% 18.86% 20.56% 22.39% 20.63% 20.82% 25.94% 24.74% 31.34% 26.34%
OPM 7.68% 9.65% 10.07% 8.12% 8.56% 10.23% 11.37% 9.63% 7.43% 7.77% 8.15%

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

Sales Growth 11.36% 11.82% 12.18% 19.10% 12.56% 19.10% 11.36%
OPM 8.92% 8.84% 8.98% 8.19% 8.15% 8.19% 8.15%
Price to Earning 52.30 57.75 55.59 60.78 79.44 79.44 52.30
V-GUARD INDUSTRIES LTD SCREENER.IN

Narration Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24
Sales 1,050.27 1,009.64 981.07 978.67 1,080.52 1,147.68 1,071.86 1,078.26 1,261.63 1,414.53
Expenses 939.45 927.75 909.97 917.85 994.20 1,059.44 991.57 993.03 1,161.77 1,286.69
Operating Profit 110.82 81.89 71.10 60.82 86.32 88.24 80.29 85.23 99.86 127.84
Other Income 3.30 5.06 3.06 5.53 1.96 11.13 13.50 2.24 24.97 6.52
Depreciation 12.32 12.90 14.00 15.50 16.04 16.62 16.44 16.87 17.02 16.55
Interest 1.56 1.72 1.81 2.31 10.08 10.77 8.97 8.92 8.80 7.55
Profit before tax 100.24 72.33 58.35 48.54 62.16 71.98 68.38 61.68 99.01 110.26
Tax 9.63 18.30 15.20 12.72 15.83 18.85 16.39 15.06 19.84 28.38
Net profit 90.60 54.02 43.15 35.82 46.33 53.13 51.99 46.62 79.17 81.88

OPM 11% 8% 7% 6% 8% 8% 7% 8% 8% 9%
V-GUARD INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Equity Share Capital 29.97 30.09 42.47 42.57 42.69 42.83 43.02 43.15 43.22 43.44
Reserves 347.76 440.69 591.90 709.05 856.97 950.95 1,164.75 1,359.35 1,544.78 1,724.63
Borrowings 67.77 10.39 5.66 2.40 10.02 10.00 66.25 66.35 500.56 355.70
Other Liabilities 279.42 235.34 294.24 400.62 446.54 436.52 585.77 613.48 626.37 762.12
Total 724.92 716.51 934.27 1,154.64 1,356.22 1,440.30 1,859.79 2,082.33 2,714.93 2,885.89

Net Block 162.37 161.02 168.65 200.87 213.79 267.76 354.06 400.27 446.68 435.29
Capital Work in Progress 1.21 0.08 10.42 7.46 7.71 66.87 19.55 16.48 15.82 36.25
Investments - 19.39 88.87 84.01 91.98 44.85 42.25 102.05 851.38 918.59
Other Assets 561.34 536.02 666.33 862.30 1,042.74 1,060.82 1,443.93 1,563.53 1,401.05 1,495.76
Total 724.92 716.51 934.27 1,154.64 1,356.22 1,440.30 1,859.79 2,082.33 2,714.93 2,885.89

Working Capital 281.92 300.68 372.09 461.68 596.20 624.30 858.16 950.05 774.68 733.64
Debtors 243.71 279.24 312.12 444.49 454.32 321.77 384.72 479.24 519.79 553.58
Inventory 260.88 204.69 274.33 310.51 370.88 476.40 628.66 849.89 689.41 709.47

Debtor Days 51.38 55.25 54.62 70.18 64.61 47.32 52.03 50.31 46.84 44.32
Inventory Turnover 6.64 9.01 7.60 7.44 6.92 5.21 4.29 4.09 5.88 6.43

Return on Equity 19% 24% 23% 18% 18% 19% 16% 16% 11% 13%
Return on Capital Emp 37% 37% 26% 26% 26% 25% 22% 14% 16%
V-GUARD INDUSTRIES LTD SCREENER.IN

Narration Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Cash from Operating Activity 88.72 131.07 129.85 54.12 153.42 139.39 221.75 -32.90 415.95 350.40
Cash from Investing Activity -16.88 -31.60 -105.54 -27.11 -49.79 -110.45 41.21 -133.49 -774.15 -107.32
Cash from Financing Activity -72.38 -94.14 -16.09 -36.96 -24.07 -89.80 -5.65 -60.89 328.40 -231.66
Net Cash Flow -0.55 5.33 8.23 -9.96 79.56 -60.86 257.31 -227.27 -29.80 11.42
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: https://www.screener.in/excel/

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: [email protected]
s… do ANYTHING.
COMPANY NAME V-GUARD INDUSTRIES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 43.48
Face Value 1.00
Current Price 474.40
Market Capitalization 20,628.34

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 1,731.19 1,844.89 2,085.64 2,311.74
Raw Material Cost 1,303.46 1,249.28 1,530.67 1,643.55
Change in Inventory 13.38 -63.05 52.69 28.41
Power and Fuel 7.93 8.48 11.21 13.49
Other Mfr. Exp 28.29 28.23 55.03 65.00
Employee Cost 94.48 110.93 144.07 170.29
Selling and admin 153.20 171.63 159.98 229.76
Other Expenses 24.20 35.28 27.43 30.34
Other Income 4.49 7.23 12.13 10.33
Depreciation 15.44 15.36 16.24 19.11
Interest 20.61 8.92 2.10 1.66
Profit before tax 101.45 160.96 203.73 177.28
Tax 30.72 49.28 59.12 44.19
Net profit 70.72 111.68 144.62 133.09
Dividend Amount 13.49 21.06 29.73 29.80

Quarters
Report Date Mar-22 Jun-22 Sep-22 Dec-22
Sales 1,050.27 1,009.64 981.07 978.67
Expenses 939.45 927.75 909.97 917.85
Other Income 3.30 5.06 3.06 5.53
Depreciation 12.32 12.90 14.00 15.50
Interest 1.56 1.72 1.81 2.31
Profit before tax 100.24 72.33 58.35 48.54
Tax 9.63 18.30 15.20 12.72
Net profit 90.60 54.02 43.15 35.82
Operating Profit 110.82 81.89 71.10 60.82

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 29.97 30.09 42.47 42.57
Reserves 347.76 440.69 591.90 709.05
Borrowings 67.77 10.39 5.66 2.40
Other Liabilities 279.42 235.34 294.24 400.62
Total 724.92 716.51 934.27 1,154.64
Net Block 162.37 161.02 168.65 200.87
Capital Work in Progress 1.21 0.08 10.42 7.46
Investments 19.39 88.87 84.01
Other Assets 561.34 536.02 666.33 862.30
Total 724.92 716.51 934.27 1,154.64
Receivables 243.71 279.24 312.12 444.49
Inventory 260.88 204.69 274.33 310.51
Cash & Bank 2.21 7.59 14.96 5.04
No. of Equity Shares 29,973,141.00 30,085,244.00 ### ###
New Bonus Shares ###
Face value 10.00 10.00 1.00 1.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 88.72 131.07 129.85 54.12
Cash from Investing Activity -16.88 -31.60 -105.54 -27.11
Cash from Financing Activity -72.38 -94.14 -16.09 -36.96
Net Cash Flow -0.55 5.33 8.23 -9.96

PRICE: 65.24 62.89 173.40 222.20

DERIVED:
Adjusted Equity Shares in Cr 42.00 42.10 42.47 42.57
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

2,566.44 2,481.96 2,699.00 3,476.67 4,050.75 4,559.43
1,844.08 1,771.11 1,919.45 2,553.65 2,790.94 3,175.61
44.90 112.91 70.72 139.70 -89.12 36.22
13.59 14.54 13.11 15.64 18.01 22.11
78.55 85.06 97.42 154.86 171.68 190.52
202.22 207.08 224.98 267.23 295.42 377.62
205.06 204.81 143.55 229.26 328.40 388.66
48.14 58.26 64.43 60.91 56.08 86.87
17.98 23.24 20.81 10.25 14.63 51.20
21.82 28.09 37.32 47.50 58.44 66.95
1.27 3.73 5.60 7.52 15.92 37.46
214.59 245.43 284.67 290.05 241.37 301.05
49.07 60.28 85.69 63.25 62.05 70.14
165.53 185.16 198.98 226.80 179.32 230.91
34.15 38.55 51.62 56.10 56.19 60.82

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

1,080.52 1,147.68 1,071.86 1,078.26 1,261.63 1,414.53
994.20 1,059.44 991.57 993.03 1,161.77 1,286.69
1.96 11.13 13.50 2.24 24.97 6.52
16.04 16.62 16.44 16.87 17.02 16.55
10.08 10.77 8.97 8.92 8.80 7.55
62.16 71.98 68.38 61.68 99.01 110.26
15.83 18.85 16.39 15.06 19.84 28.38
 46.33 53.13 51.99 46.62 79.17 81.88
86.32 88.24 80.29 85.23 99.86 127.84

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

42.69 42.83 43.02 43.15 43.22 43.44
856.97 950.95 1,164.75 1,359.35 1,544.78 1,724.63
10.02 10.00 66.25 66.35 500.56 355.70
446.54 436.52 585.77 613.48 626.37 762.12
1,356.22 1,440.30 1,859.79 2,082.33 2,714.93 2,885.89
213.79 267.76 354.06 400.27 446.68 435.29
7.71 66.87 19.55 16.48 15.82 36.25
91.98 44.85 42.25 102.05 851.38 918.59
1,042.74 1,060.82 1,443.93 1,563.53 1,401.05 1,495.76
1,356.22 1,440.30 1,859.79 2,082.33 2,714.93 2,885.89
454.32 321.77 384.72 479.24 519.79 553.58
370.88 476.40 628.66 849.89 689.41 709.47
84.65 111.53 281.14 53.88 24.10 35.63
### ### ### ### ### ###

1.00 1.00 1.00 1.00 1.00 1.00

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

153.42 139.39 221.75 -32.90 415.95 350.40
-49.79 -110.45 41.21 -133.49 -774.15 -107.32
-24.07 -89.80 -5.65 -60.89 328.40 -231.66
79.56 -60.86 257.31 -227.27 -29.80 11.42

222.35 155.15 252.35 215.80 250.05 331.35

42.69 42.83 43.02 43.15 43.22 43.44