NBCC (INDIA) LTD SCREENER.

IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case 1.01
Sales 2,041.20 2,981.98 3,146.05 3,447.69 3,232.29 4,039.74 4,402.11 5,812.43 6,279.39 5,905.01 6,271.94 6,512.39 6,294.74 1.13
Expenses 1,888.90 2,886.14 3,017.67 3,308.35 3,043.17 3,814.62 4,114.01 5,503.73 5,875.36 5,503.54 5,874.49 6,099.70 5,939.14 1.13
Operating Profit 152.30 95.84 128.38 139.34 189.12 225.12 288.10 308.70 404.03 401.47 397.45 412.69 355.60 1.11
Operating Profit % 7.46 3.21 4.08 4.04 5.85 5.57 6.54 5.31 6.43 6.80 6.34 6.34 5.65 0.99
Other Income 93.94 86.75 85.62 153.77 115.16 133.26 146.58 100.76 88.58 106.13 124.23 - - 1.01
EBIDT 246.24 182.59 214.00 293.11 304.28 358.38 434.68 409.46 492.61 507.60 521.68 412.69 355.60 1.08
Depreciation 3.07 3.12 3.21 1.36 1.35 1.35 2.34 2.45 2.61 2.71 2.68 2.68 2.68 0.99
Interest 3.22 4.87 1.16 1.92 1.28 23.52 41.35 3.04 2.34 2.28 0.24 0.24 0.24 0.96
Interest Coverage Ratio 47.30 19.68 110.67 72.57 147.75 9.57 6.97 101.55 172.66 176.08 1,656.04 1,719.53 1,481.65 1.16
Profit before tax 239.95 174.60 209.63 289.83 301.64 333.51 391.01 403.97 487.65 502.62 518.77 409.77 352.68 1.09
Tax 80.79 58.10 69.29 99.66 94.14 86.38 113.70 117.00 136.56 169.02 173.44 33% 33% 1.09
Tax % 33.67 33.28 33.05 34.39 31.21 25.90 29.08 28.96 28.00 33.63 33.43 0.08 0.09 1.00
Net profit 159.16 116.50 140.34 190.17 207.50 247.14 277.30 286.96 351.10 333.61 345.32 272.77 234.77 1.09
Net profit % 7.80 3.91 4.46 5.52 6.42 6.12 6.30 4.94 5.59 5.65 5.51 4.19 3.73 0.96
EPS 1.77 1.29 1.56 1.58 1.73 2.06 2.31 2.39 1.95 1.85 1.92 1.52 1.30 1.01
Price to earning 4.06 5.18 5.85 25.75 27.33 47.10 56.40 27.89 39.68 24.94 #VALUE!
Price - - - 6.43 8.95 12.05 59.51 65.35 91.86 104.53 53.50 60.13 32.53 #DIV/0!
#DIV/0!
RATIOS: #DIV/0!
Dividend Payout 19.79% 20.09% 19.88% 22.09% 21.69% 24.28% 23.80% 41.82% 41.78% 29.95% 1.05
OPM 7.46% 3.21% 4.08% 4.04% 5.85% 5.57% 6.54% 5.31% 6.43% 6.80% 6.34% 0.99

Price/Sales 0.00%
TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST
Sales Growth 12.53% 9.41% 12.81% 10.29% 6.21% 10.29% 6.21%
OPM 5.65% 5.91% 6.16% 6.19% 6.34% 6.34% 5.65%
Price to Earning 24.94 24.94 31.72 39.68 27.89 39.68 24.94
NBCC (INDIA) LTD SCREENER.IN

Narration Mar-16 Jun-16 Sep-16 Dec-16 Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18
Sales 2,292.90 1,264.11 1,248.82 1,420.51 2,345.95 1,266.56 1,132.73 1,321.50 2,184.23 1,633.48
Expenses 2,142.47 1,219.24 1,176.24 1,344.89 2,136.14 1,201.67 1,048.40 1,252.78 2,002.75 1,570.56
Operating Profit 150.43 44.87 72.58 75.62 209.81 64.89 84.33 68.72 181.48 62.92
Other Income 22.19 34.71 21.20 18.93 22.67 19.75 20.99 26.30 39.09 37.85
Depreciation 0.67 0.61 0.61 0.66 0.72 0.69 0.69 0.69 0.64 0.66
Interest 0.31 9.65 0.15 0.16 0.16 0.02 0.16 0.17 -0.14 0.05
Profit before tax 171.64 69.32 93.00 93.74 231.60 83.92 104.47 94.16 220.08 100.06
Tax 49.31 23.90 25.80 30.02 56.83 27.98 30.35 32.26 78.43 32.40
Net profit 122.32 45.41 67.20 63.71 174.77 55.94 74.12 61.89 141.65 67.66

OPM 7% 4% 6% 5% 9% 5% 7% 5% 8% 4%
NBCC (INDIA) LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 90.00 90.00 90.00 120.00 120.00 120.00 120.00 120.00 180.00 180.00
Reserves 370.33 458.79 564.14 675.49 830.69 1,007.29 1,204.13 1,404.61 1,493.60 1,641.37
Total Shareholder Funds 460.33 548.79 654.14 795.49 950.69 1,127.29 1,324.13 1,524.61 1,673.60 1,821.37
Borrowings - - - - - - - 11.63 5.93 -
Other Liabilities 2,176.21 2,485.04 2,619.13 2,842.78 2,779.47 3,067.47 3,422.64 3,900.77 4,846.20 5,833.44
Total 2,636.54 3,033.83 3,273.27 3,638.27 3,730.16 4,194.76 4,746.77 5,437.01 6,525.73 7,654.81
Debt/Equity Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.00 0.00
Current Ratio 0.87 0.84 0.82 0.95 1.08 1.14 1.14 1.13 1.10 0.97
Net Block 13.32 25.14 23.56 23.31 24.33 22.54 26.22 61.78 64.98 63.51
Capital Work in Progress - - - - - - - - - -
Investments 143.25 250.14 172.58 223.60 162.09 113.50 151.85 230.79 104.85 58.60
Other Assets 2,479.97 2,758.55 3,077.13 3,391.36 3,543.74 4,058.72 4,568.70 5,144.44 6,355.90 7,532.70
Total 2,636.54 3,033.83 3,273.27 3,638.27 3,730.16 4,194.76 4,746.77 5,437.01 6,525.73 7,654.81

Working Capital 303.76 273.51 458.00 548.58 764.27 991.25 1,146.06 1,243.67 1,509.70 1,699.26
Debtors 778.40 882.08 567.53 935.67 830.30 1,316.42 1,704.12 1,835.10 2,186.61 2,258.46
Inventory 196.02 266.64 409.49 450.06 632.44 996.72 1,154.84 1,423.56 1,570.37 1,657.51

Debtor Days 139.19 107.97 65.84 99.06 93.76 118.94 141.30 115.24 127.10 139.60
Inventory Turnover 10.41 11.18 7.68 7.66 5.11 4.05 3.81 4.08 4.00 3.56

Return on Equity 35% 21% 21% 24% 22% 22% 21% 19% 21% 18%
Return on Capital Emp 22% 12% 12% 7% 12% 14% 15% 14% 17% 13%
NBCC (INDIA) LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 110.78 118.88 91.45 118.81 90.15 -438.69 -153.92 168.39 439.05 212.50 757.40 1.08
Cash from Investing Activity -15.05 -52.78 157.73 57.02 99.47 818.47 -5.00 -30.25 145.15 174.33 ### -1.31
Cash from Financing Activity -59.18 -31.83 -23.30 -32.73 -48.81 -52.65 -70.20 -85.05 -207.99 -183.55 -795.29 1.13
Net Cash Flow 36.55 34.27 225.88 143.10 140.81 327.13 -229.12 53.10 376.21 203.28 ###

Net profit 159.16 116.5 140.34 190.17 207.5 247.14 277.3 286.96 351.1 333.61 ### 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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: screener.feedback@dalal-street.in
… do ANYTHING.

dalal-street.in
COMPANY NAME NBCC (INDIA) LTD
LATEST VERSION 2.10 PLEASE
CURRENT VERSION 2.10

META
Number of shares 180.00
Face Value 1
Current Price 53.5
Market Capitalization 9630

PROFIT & LOSS

Report Date Mar-09 Mar-10 Mar-11 Mar-12
Sales 2,041.20 2,981.98 3,146.05 3,447.69
Raw Material Cost 34.40 31.85 18.07 92.27
Change in Inventory -90.88 -49.14 -47.19
Power and Fuel 3.66 4.55 3.63 3.93
Other Mfr. Exp 1,612.57 2,639.92 2,826.15 2,962.73
Employee Cost 93.08 106.20 128.18 157.20
Selling and admin 23.20 23.31 21.73 29.78
Other Expenses 31.11 31.17 19.91 15.25
Other Income 93.94 86.75 85.62 153.77
Depreciation 3.07 3.12 3.21 1.36
Interest 3.22 4.87 1.16 1.92
Profit before tax 239.95 174.60 209.63 289.83
Tax 80.79 58.10 69.29 99.66
Net profit 159.16 116.50 140.34 190.17
Dividend Amount 31.50 23.40 27.90 42.00

Quarters
Report Date Mar-16 Jun-16 Sep-16 Dec-16
Sales 2,292.90 1,264.11 1,248.82 1,420.51
Expenses 2,142.47 1,219.24 1,176.24 1,344.89
Other Income 22.19 34.71 21.20 18.93
Depreciation 0.67 0.61 0.61 0.66
Interest 0.31 9.65 0.15 0.16
Profit before tax 171.64 69.32 93.00 93.74
Tax 49.31 23.90 25.80 30.02
Net profit 122.32 45.41 67.20 63.71
Operating Profit 150.43 44.87 72.58 75.62
BALANCE SHEET
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Equity Share Capital 90 90 90 120
Reserves 370.33 458.79 564.14 675.49
Borrowings
Other Liabilities 2176.21 2485.04 2619.13 2842.78
Total 2,636.54 3,033.83 3,273.27 3,638.27
Net Block 13.32 25.14 23.56 23.31
Capital Work in Progress
Investments 143.25 250.14 172.58 223.6
Other Assets 2479.97 2758.55 3077.13 3391.36
Total 2,636.54 3,033.83 3,273.27 3,638.27
Receivables 778.40 882.08 567.53 935.67
Inventory 196.02 266.64 409.49 450.06
Cash & Bank 909.65 943.91 1169.8 1325.2
No. of Equity Shares 900000 900000 900000 120000000
New Bonus Shares
Face value 1000 1000 1000 10

CASH FLOW:
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Cash from Operating Activity 110.78 118.88 91.45 118.81
Cash from Investing Activity -15.05 -52.78 157.73 57.02
Cash from Financing Activity -59.18 -31.83 -23.30 -32.73
Net Cash Flow 36.55 34.27 225.88 143.10

PRICE: 6.43

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

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

3,232.29 4,039.74 4,402.11 5,812.43 6,279.39 5,905.01
46.91 26.55 45.07 23.91 10.01 8.43
-118.81 -88.05 150.77 300.04 152.26 87.23
1.42 1.40 1.58 3.35 1.39 2.37
2,659.93 3,468.19 3,972.89 5,460.79 5,708.50 5,122.35
170.76 182.10 195.14 221.21 236.09 309.67
26.72 30.92 34.46 34.29 28.35 36.67
18.62 17.41 15.64 60.22 43.28 111.28
115.16 133.26 146.58 100.76 88.58 106.13
1.35 1.35 2.34 2.45 2.61 2.71
1.28 23.52 41.35 3.04 2.34 2.28
301.64 333.51 391.01 403.97 487.65 502.62
94.14 86.38 113.70 117.00 136.56 169.02
207.50 247.14 277.30 286.96 351.10 333.61
45.00 60.00 66.00 120.00 146.70 99.90

Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18

2,345.95 1,266.56 1,132.73 1,321.50 2,184.23 1,633.48
2,136.14 1,201.67 1,048.40 1,252.78 2,002.75 1,570.56
22.67 19.75 20.99 26.30 39.09 37.85
0.72 0.69 0.69 0.69 0.64 0.66
0.16 0.02 0.16 0.17 -0.14 0.05
231.60 83.92 104.47 94.16 220.08 100.06
56.83 27.98 30.35 32.26 78.43 32.40
174.77 55.94 74.12 61.89 141.65 67.66
209.81 64.89 84.33 68.72 181.48 62.92
Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
120 120 120 120 180 180
830.69 1007.29 1204.13 1404.61 1493.6 1641.37
11.63 5.93
2779.47 3067.47 3422.64 3900.77 4846.2 5833.44
3,730.16 4,194.76 4,746.77 5,437.01 6,525.73 7,654.81
24.33 22.54 26.22 61.78 64.98 63.51

162.09 113.5 151.85 230.79 104.85 58.6

3543.74 4058.72 4568.7 5144.44 6355.9 7532.7
3,730.16 4,194.76 4,746.77 5,437.01 6,525.73 7,654.81
830.30 1,316.42 1,704.12 1,835.10 2,186.61 2,258.46
632.44 996.72 1154.84 1423.56 1570.37 1657.51
1537.76 1195.9 1059.46 1140.6 1552.96 1713.55
120000000 120000000 120000000 120000000 900000000 900000000

10 10 10 10 2 2

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

90.15 -438.69 -153.92 168.39 439.05 212.50
99.47 818.47 -5.00 -30.25 145.15 174.33
-48.81 -52.65 -70.20 -85.05 -207.99 -183.55
140.81 327.13 -229.12 53.10 376.21 203.28

8.95 12.05 59.51 65.35 91.86 104.53

120.00 120.00 120.00 120.00 180.00 180.00