NATCO PHARMA 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 825.28 1,042.30 2,020.20 2,184.80 2,094.50 1,915.00 2,052.10 1,944.80 2,707.10 3,998.80 3,998.80 5,906.84 4,408.51
Expenses 614.92 776.70 1,336.80 1,256.40 1,299.70 1,332.40 1,445.90 1,681.30 1,771.50 2,247.40 2,247.40 3,319.75 2,962.29
Operating Profit 210.36 265.60 683.40 928.40 794.80 582.60 606.20 263.50 935.60 1,751.40 1,751.40 2,587.09 1,446.22
Other Income 0.36 11.80 13.90 40.40 130.20 107.40 103.60 99.00 104.60 128.10 128.10 - -
Depreciation 47.27 50.80 54.40 66.20 81.00 99.80 116.90 142.60 163.80 186.80 186.80 186.80 186.80
Interest 31.68 22.90 18.50 15.40 19.30 21.50 13.30 17.70 14.50 19.20 19.20 19.20 19.20
Profit before tax 131.77 203.70 624.40 887.20 824.70 568.70 579.60 202.20 861.90 1,673.50 1,673.50 2,381.09 1,240.22
Tax 1.51 47.90 139.50 192.00 182.30 110.60 137.20 32.20 146.60 285.20 285.20 17% 17%
Net profit 134.62 157.10 486.00 696.20 644.40 460.80 440.90 170.00 715.30 1,388.30 1,388.30 1,975.30 1,028.86
EPS 8.10 9.02 27.88 37.73 35.23 25.30 24.19 9.32 39.17 77.52 77.60 110.41 57.51
Price to earning 52.07 45.76 30.46 19.97 16.28 19.98 34.13 81.17 14.38 12.28 15.18 30.76 15.18
Price 421.79 412.70 849.20 753.65 573.45 505.55 825.55 756.15 563.35 952.05 1,178.10 3,395.63 873.08

RATIOS:
Dividend Payout 12.35% 13.84% 24.24% 21.86% 17.70% 26.66% 21.73% 48.31% 14.03% 12.25%
OPM 25.49% 25.48% 33.83% 42.49% 37.95% 30.42% 29.54% 13.55% 34.56% 43.80% 43.80%

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

Sales Growth 19.16% 10.25% 13.81% 24.90% 47.72% 47.72% 10.25%
OPM 33.78% 34.70% 32.81% 34.11% 43.80% 43.80% 32.81%
Price to Earning 31.06 26.67 29.52 30.76 15.18 30.76 15.18
NATCO PHARMA LTD SCREENER.IN

Narration Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24
Sales 560.50 596.80 884.60 432.10 492.50 897.90 1,140.50 1,031.40 758.60 1,068.30
Expenses 458.70 615.40 489.30 336.80 386.60 558.80 612.50 573.40 490.50 571.00
Operating Profit 101.80 -18.60 395.30 95.30 105.90 339.10 528.00 458.00 268.10 497.30
Other Income 30.20 13.80 34.30 20.50 20.80 29.00 19.70 29.40 37.00 42.00
Depreciation 36.00 38.10 39.60 41.70 41.50 41.00 43.50 43.60 44.20 55.50
Interest 5.00 6.70 4.20 3.80 3.80 2.70 4.20 4.20 4.60 6.20
Profit before tax 91.00 -49.60 385.80 70.30 81.40 324.40 500.00 439.60 256.30 477.60
Tax 10.60 0.90 65.40 13.50 19.10 48.60 79.70 70.60 43.60 91.30
Net profit 80.40 -50.50 320.40 56.80 62.30 275.80 420.30 369.00 212.70 386.30

OPM 18% -3% 45% 22% 22% 38% 46% 44% 35% 47%
NATCO PHARMA 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 33.23 34.80 34.90 36.90 36.50 36.40 36.50 36.50 36.50 35.80
Reserves 812.82 1,260.90 1,614.40 3,035.30 3,452.50 3,737.10 4,085.10 4,227.10 4,837.30 5,817.30
Borrowings 311.84 112.60 221.80 173.20 386.30 315.90 267.60 415.50 166.70 371.20
Other Liabilities 226.16 413.40 446.50 469.70 427.80 498.40 402.70 430.00 616.90 682.00
Total 1,384.05 1,821.70 2,317.60 3,715.10 4,303.10 4,587.80 4,791.90 5,109.10 5,657.40 6,906.30

Net Block 709.97 710.10 833.00 1,018.60 1,227.20 1,584.40 2,023.20 2,311.80 2,426.90 2,490.80
Capital Work in Progress 128.96 211.80 336.30 480.00 637.60 518.00 223.40 129.50 64.30 137.30
Investments 1.69 22.20 32.20 76.50 168.60 112.30 303.70 308.10 392.30 539.40
Other Assets 543.43 877.60 1,116.10 2,140.00 2,269.70 2,373.10 2,241.60 2,359.70 2,773.90 3,738.80
Total 1,384.05 1,821.70 2,317.60 3,715.10 4,303.10 4,587.80 4,791.90 5,109.10 5,657.40 6,906.30

Working Capital 317.27 464.20 669.60 1,670.30 1,841.90 1,874.70 1,838.90 1,929.70 2,157.00 3,056.80
Debtors 192.43 261.60 475.20 637.50 506.20 551.30 412.90 620.60 856.10 1,188.90
Inventory 220.00 357.30 348.90 438.40 529.00 558.00 798.20 762.00 742.90 700.50

Debtor Days 85.11 91.61 85.86 106.50 88.21 105.08 73.44 116.47 115.43 108.52
Inventory Turnover 3.75 2.92 5.79 4.98 3.96 3.43 2.57 2.55 3.64 5.71

Return on Equity 16% 12% 29% 23% 18% 12% 11% 4% 15% 24%
Return on Capital Emp 18% 39% 35% 24% 15% 14% 5% 18% 30%
NATCO PHARMA 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 92.67 112.20 345.80 463.60 668.80 417.30 298.80 46.50 849.10 1,211.60
Cash from Investing Activity -119.52 -176.30 -298.80 -1,116.30 -611.30 -175.00 -107.10 4.00 -465.30 -1,032.70
Cash from Financing Activity 29.07 154.00 -47.70 650.90 -50.90 -250.80 -185.70 34.80 -363.00 -246.90
Net Cash Flow 2.23 89.90 -0.70 -1.80 6.60 -8.50 6.00 85.30 20.80 -68.00
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 NATCO PHARMA LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 17.89
Face Value 2.00
Current Price 1,178.10
Market Capitalization 21,077.08

PROFIT & LOSS

Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 825.28 1,042.30 2,020.20 2,184.80
Raw Material Cost 251.54 318.90 617.90 436.40
Change in Inventory 9.17 48.30 18.80 25.30
Power and Fuel 43.24 43.70 50.50 56.20
Other Mfr. Exp 53.59 77.60 101.40 120.50
Employee Cost 136.97 179.90 243.30 325.70
Selling and admin 119.22 180.80 299.50 304.40
Other Expenses 19.53 24.10 43.00 38.50
Other Income 0.36 11.80 13.90 40.40
Depreciation 47.27 50.80 54.40 66.20
Interest 31.68 22.90 18.50 15.40
Profit before tax 131.77 203.70 624.40 887.20
Tax 1.51 47.90 139.50 192.00
Net profit 134.62 157.10 486.00 696.20
Dividend Amount 16.62 21.75 117.79 152.21

Quarters
Report Date Dec-21 Mar-22 Jun-22 Sep-22
Sales 560.50 596.80 884.60 432.10
Expenses 458.70 615.40 489.30 336.80
Other Income 30.20 13.80 34.30 20.50
Depreciation 36.00 38.10 39.60 41.70
Interest 5.00 6.70 4.20 3.80
Profit before tax 91.00 -49.60 385.80 70.30
Tax 10.60 0.90 65.40 13.50
Net profit 80.40 -50.50 320.40 56.80
Operating Profit 101.80 -18.60 395.30 95.30

BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 33.23 34.80 34.90 36.90
Reserves 812.82 1,260.90 1,614.40 3,035.30
Borrowings 311.84 112.60 221.80 173.20
Other Liabilities 226.16 413.40 446.50 469.70
Total 1,384.05 1,821.70 2,317.60 3,715.10
Net Block 709.97 710.10 833.00 1,018.60
Capital Work in Progress 128.96 211.80 336.30 480.00
Investments 1.69 22.20 32.20 76.50
Other Assets 543.43 877.60 1,116.10 2,140.00
Total 1,384.05 1,821.70 2,317.60 3,715.10
Receivables 192.43 261.60 475.20 637.50
Inventory 220.00 357.30 348.90 438.40
Cash & Bank 13.36 45.20 35.80 183.70
No. of Equity Shares 33,234,849.00 ### ### ###
New Bonus Shares
Face value 10.00 2.00 2.00 2.00

CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 92.67 112.20 345.80 463.60
Cash from Investing Activity -119.52 -176.30 -298.80 -1,116.30
Cash from Financing Activity 29.07 154.00 -47.70 650.90
Net Cash Flow 2.23 89.90 -0.70 -1.80

PRICE: 421.79 412.70 849.20 753.65

DERIVED:
Adjusted Equity Shares in Cr 16.62 17.42 17.43 18.45
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

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

2,094.50 1,915.00 2,052.10 1,944.80 2,707.10 3,998.80
388.10 456.80 559.50 577.70 651.00 673.90
33.90 75.20 48.10 16.80 23.70 -42.70
59.60 62.40 61.10 76.40 81.90
120.20 135.20 114.40 149.90 151.60
356.00 375.10 415.10 445.10 487.00 525.00
351.00 311.50 300.70 367.40 388.50
58.70 66.60 43.20 81.60 35.20 1,005.80
130.20 107.40 103.60 99.00 104.60 128.10
81.00 99.80 116.90 142.60 163.80 186.80
19.30 21.50 13.30 17.70 14.50 19.20
824.70 568.70 579.60 202.20 861.90 1,673.50
182.30 110.60 137.20 32.20 146.60 285.20
644.40 460.80 440.90 170.00 715.30 1,388.30
114.06 122.85 95.81 82.12 100.38 170.05

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

492.50 897.90 1,140.50 1,031.40 758.60 1,068.30
386.60 558.80 612.50 573.40 490.50 571.00
20.80 29.00 19.70 29.40 37.00 42.00
41.50 41.00 43.50 43.60 44.20 55.50
3.80 2.70 4.20 4.20 4.60 6.20
81.40 324.40 500.00 439.60 256.30 477.60
19.10 48.60 79.70 70.60 43.60 91.30
 62.30 275.80 420.30 369.00 212.70 386.30
105.90 339.10 528.00 458.00 268.10 497.30

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

36.50 36.40 36.50 36.50 36.50 35.80
3,452.50 3,737.10 4,085.10 4,227.10 4,837.30 5,817.30
386.30 315.90 267.60 415.50 166.70 371.20
427.80 498.40 402.70 430.00 616.90 682.00
4,303.10 4,587.80 4,791.90 5,109.10 5,657.40 6,906.30
1,227.20 1,584.40 2,023.20 2,311.80 2,426.90 2,490.80
637.60 518.00 223.40 129.50 64.30 137.30
168.60 112.30 303.70 308.10 392.30 539.40
2,269.70 2,373.10 2,241.60 2,359.70 2,773.90 3,738.80
4,303.10 4,587.80 4,791.90 5,109.10 5,657.40 6,906.30
506.20 551.30 412.90 620.60 856.10 1,188.90
529.00 558.00 798.20 762.00 742.90 700.50
279.50 66.00 283.50 206.10 546.30 952.90
### ### ### ### ###

2.00 2.00 2.00 2.00 2.00 2.00

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

668.80 417.30 298.80 46.50 849.10 1,211.60
-611.30 -175.00 -107.10 4.00 -465.30 -1,032.70
-50.90 -250.80 -185.70 34.80 -363.00 -246.90
6.60 -8.50 6.00 85.30 20.80 -68.00

573.45 505.55 825.55 756.15 563.35 952.05

18.29 18.21 18.23 18.25 18.26 17.91