NMDC LTD SCREENER.

IN

Narration Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Trailing Best Case Worst Case
Sales 12,058.20 12,356.41 6,455.80 8,828.14 11,614.90 12,152.67 11,699.22 15,370.06 25,964.79 17,666.88 20,669.91 20,669.91 18,562.96
Expenses 4,334.84 4,591.45 3,770.64 5,233.44 5,812.20 5,228.16 5,697.34 6,579.79 13,338.33 11,613.14 13,316.44 11,046.26 11,959.05
Operating Profit 7,723.36 7,764.96 2,685.16 3,594.70 5,802.70 6,924.51 6,001.88 8,790.27 12,626.46 6,053.74 7,353.47 9,623.65 6,603.91
Other Income 2,181.94 2,155.17 1,682.21 909.80 667.16 588.45 417.17 351.00 715.85 2,003.60 1,927.02 - -
Depreciation 150.65 172.56 218.02 196.65 256.63 279.04 294.93 228.54 287.74 336.18 333.41 333.41 333.41
Interest 1.85 0.14 65.65 20.78 37.10 40.32 9.88 16.81 39.06 75.23 68.61 68.61 68.61
Profit before tax 9,752.80 9,747.43 4,083.70 4,287.07 6,176.13 7,193.60 6,114.24 8,895.92 13,015.51 7,645.93 8,878.47 9,221.63 6,201.89
Tax 3,339.72 3,346.26 1,380.05 1,704.04 2,373.34 2,556.53 2,512.72 2,648.45 3,575.09 2,108.21 2,445.90 28% 28%
Net profit 6,370.98 6,346.74 2,546.10 2,543.86 3,808.46 4,617.95 3,572.96 6,276.64 9,428.16 5,602.56 6,433.92 6,681.20 4,493.35
EPS 16.07 16.01 6.42 8.04 12.04 15.08 11.67 21.42 32.17 19.12 21.96 22.81 15.34
Price to earning 6.71 6.23 11.81 12.82 7.62 5.36 5.31 4.89 3.91 5.83 10.69 10.69 6.00
Price 107.81 99.68 75.87 103.04 91.78 80.86 61.93 104.79 125.84 111.55 234.70 243.72 92.02

RATIOS:
Dividend Payout 52.90% 53.41% 171.29% 64.05% 35.72% 36.60% 45.33% 36.23% 45.82% 34.52%
OPM 64.05% 62.84% 41.59% 40.72% 49.96% 56.98% 51.30% 57.19% 48.63% 34.27% 35.58%

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

Sales Growth 4.34% 15.47% 8.75% 14.73% 17.00% 17.00% 4.34%
OPM 50.66% 48.21% 48.76% 46.56% 35.58% 46.56% 35.58%
Price to Earning 7.38 7.05 6.00 6.33 10.69 10.69 6.00
NMDC LTD [Link]

Narration Sep-21 Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23
Sales 6,793.51 5,873.77 6,785.30 4,767.07 3,328.45 3,719.99 5,851.37 5,394.66 4,013.98 5,409.90
Expenses 3,681.00 3,262.57 4,060.78 2,868.67 2,477.29 2,579.37 3,689.02 3,401.14 2,823.55 3,402.73
Operating Profit 3,112.51 2,611.20 2,724.52 1,898.40 851.16 1,140.62 2,162.35 1,993.52 1,190.43 2,007.17
Other Income 88.75 152.78 332.37 145.86 426.19 204.63 1,228.23 294.05 320.83 83.91
Depreciation 59.92 60.68 111.80 84.93 74.15 83.71 93.39 69.22 88.80 82.00
Interest 1.72 9.19 25.15 15.34 18.19 29.93 11.77 6.19 18.60 32.05
Profit before tax 3,139.62 2,694.11 2,919.94 1,943.99 1,185.01 1,231.61 3,285.42 2,212.16 1,403.86 1,977.03
Tax 800.04 647.23 1,057.85 472.75 299.36 327.62 1,008.48 551.12 379.00 507.30
Net profit 2,327.09 2,048.29 1,866.56 1,445.48 972.22 912.33 2,271.53 1,652.22 1,026.24 1,483.93

OPM 46% 44% 40% 40% 26% 31% 37% 37% 30% 37%
NMDC LTD [Link]

Narration Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
Equity Share Capital 396.47 396.47 396.47 316.39 316.39 306.19 306.19 293.07 293.07 293.07
Reserves 29,550.36 31,870.17 28,783.62 22,265.82 24,101.02 25,737.81 27,366.88 29,590.98 17,725.18 22,327.76
Borrowings - - 1,496.95 - 500.09 364.15 565.57 2,000.28 1,799.94 422.66
Other Liabilities 1,497.05 2,197.20 2,078.74 3,201.45 3,773.82 3,483.08 3,055.79 5,045.46 5,094.15 5,204.22
Total 31,443.88 34,463.84 32,755.78 25,783.66 28,691.32 29,891.23 31,294.43 36,929.79 24,912.34 28,247.71

Net Block 1,365.85 1,468.17 2,058.46 2,095.13 3,457.21 3,512.41 3,809.50 3,933.40 3,662.49 3,198.57
Capital Work in Progress 5,297.41 7,800.58 9,747.08 11,855.45 12,545.06 13,818.90 15,529.86 17,157.93 1,333.31 1,998.04
Investments 219.30 319.11 591.64 612.30 672.73 858.87 910.10 874.90 894.95 934.68
Other Assets 24,561.32 24,875.98 20,358.60 11,220.78 12,016.32 11,701.05 11,044.97 14,963.56 19,021.59 22,116.42
Total 31,443.88 34,463.84 32,755.78 25,783.66 28,691.32 29,891.23 31,294.43 36,929.79 24,912.34 28,247.71

Working Capital 23,064.27 22,678.78 18,279.86 8,019.33 8,242.50 8,217.97 7,989.18 9,918.10 13,927.44 16,912.20
Debtors 1,448.42 1,752.33 796.07 1,043.52 1,472.74 1,424.51 2,223.71 2,139.89 2,954.30 2,656.02
Inventory 681.19 691.88 622.05 540.04 571.69 666.17 723.51 921.72 2,125.21 2,660.58

Debtor Days 43.84 51.76 45.01 43.14 46.28 42.78 69.38 50.82 41.53 54.87
Inventory Turnover 17.70 17.86 10.38 16.35 20.32 18.24 16.17 16.68 12.22 6.64

Return on Equity 21% 20% 9% 11% 16% 18% 13% 21% 52% 25%
Return on Capital Emp 31% 13% 16% 26% 28% 22% 30% 50% 36%
NMDC LTD [Link]

Narration Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
Cash from Operating Activity 3,733.52 3,999.14 2,501.96 2,108.52 3,376.28 4,001.54 2,125.97 7,266.13 6,941.80 2,465.61
Cash from Investing Activity 3,443.58 -517.16 3,644.64 5,171.34 -1,864.88 -789.23 -312.76 -4,316.28 -3,213.89 43.29
Cash from Financing Activity -5,800.70 -3,449.44 -6,290.35 -7,249.32 -1,557.17 -3,201.03 -1,753.31 -2,591.32 -4,066.85 -2,536.50
Net Cash Flow 1,376.40 32.54 -143.75 30.54 -45.77 11.28 59.90 358.53 -338.94 -27.60
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 NMDC LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 292.93
Face Value 1.00
Current Price 234.70
Market Capitalization 68,751.57

PROFIT & LOSS

Report Date Mar-14 Mar-15 Mar-16 Mar-17
Sales 12,058.20 12,356.41 6,455.80 8,828.14
Raw Material Cost 26.50 27.67 9.73 5.37
Change in Inventory 14.27 16.99 -63.12 -98.87
Power and Fuel 60.98 64.25 67.69 87.65
Other Mfr. Exp 434.44 423.50 394.30 375.72
Employee Cost 706.71 703.51 650.72 889.70
Selling and admin 2,695.01 3,029.59 1,774.13 2,537.67
Other Expenses 425.47 359.92 810.95 1,238.46
Other Income 2,181.94 2,155.17 1,682.21 909.80
Depreciation 150.65 172.56 218.02 196.65
Interest 1.85 0.14 65.65 20.78
Profit before tax 9,752.80 9,747.43 4,083.70 4,287.07
Tax 3,339.72 3,346.26 1,380.05 1,704.04
Net profit 6,370.98 6,346.74 2,546.10 2,543.86
Dividend Amount 3,370.00 3,389.82 4,361.17 1,629.41

Quarters
Report Date Sep-21 Dec-21 Mar-22 Jun-22
Sales 6,793.51 5,873.77 6,785.30 4,767.07
Expenses 3,681.00 3,262.57 4,060.78 2,868.67
Other Income 88.75 152.78 332.37 145.86
Depreciation 59.92 60.68 111.80 84.93
Interest 1.72 9.19 25.15 15.34
Profit before tax 3,139.62 2,694.11 2,919.94 1,943.99
Tax 800.04 647.23 1,057.85 472.75
Net profit 2,327.09 2,048.29 1,866.56 1,445.48
Operating Profit 3,112.51 2,611.20 2,724.52 1,898.40

BALANCE SHEET
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Equity Share Capital 396.47 396.47 396.47 316.39
Reserves 29,550.36 31,870.17 28,783.62 22,265.82
Borrowings 1,496.95
Other Liabilities 1,497.05 2,197.20 2,078.74 3,201.45
Total 31,443.88 34,463.84 32,755.78 25,783.66
Net Block 1,365.85 1,468.17 2,058.46 2,095.13
Capital Work in Progress 5,297.41 7,800.58 9,747.08 11,855.45
Investments 219.30 319.11 591.64 612.30
Other Assets 24,561.32 24,875.98 20,358.60 11,220.78
Total 31,443.88 34,463.84 32,755.78 25,783.66
Receivables 1,448.42 1,752.33 796.07 1,043.52
Inventory 681.19 691.88 622.05 540.04
Cash & Bank 18,660.51 18,486.06 14,806.14 5,320.51
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 1.00 1.00 1.00 1.00

CASH FLOW:
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Cash from Operating Activity 3,733.52 3,999.14 2,501.96 2,108.52
Cash from Investing Activity 3,443.58 -517.16 3,644.64 5,171.34
Cash from Financing Activity -5,800.70 -3,449.44 -6,290.35 -7,249.32
Net Cash Flow 1,376.40 32.54 -143.75 30.54

PRICE: 107.81 99.68 75.87 103.04

DERIVED:
Adjusted Equity Shares in Cr 396.47 396.47 396.47 316.39
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

11,614.90 12,152.67 11,699.22 15,370.06 25,964.79 17,666.88
17.33 52.00 36.48 42.01 106.95 70.59
38.48 79.22 53.83 161.81 1,159.39 496.60
99.27 109.45 114.73 110.82 122.54 144.07
414.16 423.48 399.28 393.43 588.76 766.38
1,049.94 1,039.98 1,049.81 1,085.58 1,337.40 1,531.03
3,042.97 2,670.19 3,131.09 3,985.38 10,662.22 8,481.69
1,227.01 1,012.28 1,019.78 1,124.38 1,679.85 1,115.98
667.16 588.45 417.17 351.00 715.85 2,003.60
256.63 279.04 294.93 228.54 287.74 336.18
37.10 40.32 9.88 16.81 39.06 75.23
6,176.13 7,193.60 6,114.24 8,895.92 13,015.51 7,645.93
2,373.34 2,556.53 2,512.72 2,648.45 3,575.09 2,108.21
3,808.46 4,617.95 3,572.96 6,276.64 9,428.16 5,602.56
1,360.48 1,690.17 1,619.75 2,274.22 4,319.85 1,934.26

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

3,328.45 3,719.99 5,851.37 5,394.66 4,013.98 5,409.90
2,477.29 2,579.37 3,689.02 3,401.14 2,823.55 3,402.73
426.19 204.63 1,228.23 294.05 320.83 83.91
74.15 83.71 93.39 69.22 88.80 82.00
18.19 29.93 11.77 6.19 18.60 32.05
1,185.01 1,231.61 3,285.42 2,212.16 1,403.86 1,977.03
299.36 327.62 1,008.48 551.12 379.00 507.30
 972.22 912.33 2,271.53 1,652.22 1,026.24 1,483.93
851.16 1,140.62 2,162.35 1,993.52 1,190.43 2,007.17

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

316.39 306.19 306.19 293.07 293.07 293.07
24,101.02 25,737.81 27,366.88 29,590.98 17,725.18 22,327.76
500.09 364.15 565.57 2,000.28 1,799.94 422.66
3,773.82 3,483.08 3,055.79 5,045.46 5,094.15 5,204.22
28,691.32 29,891.23 31,294.43 36,929.79 24,912.34 28,247.71
3,457.21 3,512.41 3,809.50 3,933.40 3,662.49 3,198.57
12,545.06 13,818.90 15,529.86 17,157.93 1,333.31 1,998.04
672.73 858.87 910.10 874.90 894.95 934.68
12,016.32 11,701.05 11,044.97 14,963.56 19,021.59 22,116.42
28,691.32 29,891.23 31,294.43 36,929.79 24,912.34 28,247.71
1,472.74 1,424.51 2,223.71 2,139.89 2,954.30 2,656.02
571.69 666.17 723.51 921.72 2,125.21 2,660.58
5,460.98 4,619.39 2,437.46 5,861.82 7,977.47 7,097.75
### ### ### ### ### ###

1.00 1.00 1.00 1.00 1.00 1.00

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

3,376.28 4,001.54 2,125.97 7,266.13 6,941.80 2,465.61
-1,864.88 -789.23 -312.76 -4,316.28 -3,213.89 43.29
-1,557.17 -3,201.03 -1,753.31 -2,591.32 -4,066.85 -2,536.50
-45.77 11.28 59.90 358.53 -338.94 -27.60

91.78 80.86 61.93 104.79 125.84 111.55

316.39 306.18 306.18 293.06 293.06 293.06