NESTLE INDIA LTD SCREENER.

IN

Narration Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Trailing Best Case Worst Case
Sales 9,101.05 9,854.84 8,175.31 9,141.34 10,009.60 11,292.27 12,368.90 13,350.03 14,740.59 16,896.96 18,782.67 19,368.78 18,233.68
Expenses 7,153.47 7,815.59 6,620.38 7,291.50 7,913.07 8,674.62 9,443.02 10,148.53 11,178.19 13,190.67 14,433.79 14,860.99 14,187.83
Operating Profit 1,947.58 2,039.25 1,554.93 1,849.84 2,096.53 2,617.65 2,925.88 3,201.50 3,562.40 3,706.29 4,348.88 4,507.80 4,045.84
Other Income 96.90 86.87 -390.75 140.12 176.92 258.92 246.88 145.85 -112.38 107.26 226.88 - -
Depreciation 329.95 337.54 347.26 353.67 342.25 335.67 370.15 370.38 391.02 403.01 418.88 418.88 418.88
Interest 36.51 14.23 3.29 90.91 91.90 111.95 129.12 164.18 201.68 154.57 146.00 146.00 146.00
Profit before tax 1,678.02 1,774.35 813.63 1,545.38 1,839.30 2,428.95 2,673.49 2,812.79 2,857.32 3,255.97 4,010.88 3,942.92 3,480.96
Tax 560.89 589.66 250.36 544.02 614.11 822.02 705.05 730.36 738.91 865.45 1,039.76 26% 26%
Net profit 1,117.13 1,184.69 563.27 1,001.36 1,225.19 1,606.93 1,968.44 2,082.43 2,118.41 2,390.52 2,971.12 2,920.77 2,578.58
EPS 115.88 122.89 58.43 103.88 127.09 166.69 204.20 216.02 219.75 247.98 308.16 302.94 267.44
Price to earning 45.64 51.95 99.74 58.03 61.93 66.50 72.41 85.13 89.67 79.06 78.33 83.05 71.67
Price 5,289.25 6,384.85 5,828.00 6,028.35 7,870.90 11,084.85 14,785.35 18,390.25 19,705.70 19,606.00 24,138.95 25,158.87 19,168.67

RATIOS:
Dividend Payout 41.86% 51.28% 83.02% 60.66% 67.68% 69.00% 167.52% 92.60% 91.03% 88.74%
OPM 21.40% 20.69% 19.02% 20.24% 20.95% 23.18% 23.66% 23.98% 24.17% 21.93% 23.15%

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

Sales Growth 7.12% 10.93% 11.04% 10.96% 14.63% 14.63% 7.12%
OPM 22.19% 22.73% 23.33% 23.27% 23.15% 23.27% 22.19%
Price to Earning 71.67 73.88 78.52 83.05 78.33 83.05 71.67
NESTLE INDIA LTD SCREENER.IN

Narration Jun-21 Sep-21 Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23
Sales 3,476.70 3,882.57 3,747.98 3,992.64 4,045.69 4,601.84 4,256.79 4,830.53 4,658.53 5,036.82
Expenses 2,628.70 2,934.58 2,889.29 3,071.69 3,231.16 3,597.76 3,283.78 3,735.05 3,603.01 3,811.95
Operating Profit 848.00 947.99 858.69 920.95 814.53 1,004.08 973.01 1,095.48 1,055.52 1,224.87
Other Income 29.47 33.66 -209.14 21.44 19.37 30.64 29.55 33.69 23.95 139.69
Depreciation 95.29 95.53 105.96 104.51 101.68 98.17 98.66 101.70 107.36 111.16
Interest 51.69 51.88 43.59 35.58 36.97 37.19 44.83 37.01 32.78 31.38
Profit before tax 730.49 834.24 500.00 802.30 695.25 899.36 859.07 990.46 939.33 1,222.02
Tax 191.91 216.87 120.52 211.53 185.01 237.90 231.01 253.82 240.99 313.94
Net profit 538.58 617.37 379.48 590.77 510.24 661.46 628.06 736.64 698.34 908.08

OPM 24% 24% 23% 23% 20% 22% 23% 23% 23% 24%
NESTLE INDIA LTD SCREENER.IN

Narration Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Equity Share Capital 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42
Reserves 2,272.33 2,740.79 2,721.42 3,185.91 3,324.17 3,577.32 1,822.45 1,922.92 1,849.96 2,362.75
Borrowings 1,189.49 19.57 17.73 33.15 35.14 35.14 188.94 147.49 266.46 270.52
Other Liabilities 2,756.03 2,962.72 3,250.76 3,494.98 3,906.86 4,379.20 5,065.13 5,732.90 6,021.29 6,249.05
Total 6,314.27 5,819.50 6,086.33 6,810.46 7,362.59 8,088.08 7,172.94 7,899.73 8,234.13 8,978.74

Net Block 3,369.31 3,176.64 2,897.85 2,730.14 2,616.18 2,400.62 2,341.45 2,179.41 2,994.67 3,043.70
Capital Work in Progress 294.71 244.78 230.79 188.17 94.16 105.20 143.30 638.58 246.23 358.36
Investments 851.08 811.82 1,324.92 1,755.66 1,978.87 2,658.49 1,751.05 1,463.77 773.98 777.54
Other Assets 1,799.17 1,586.26 1,632.77 2,136.49 2,673.38 2,923.77 2,937.14 3,617.97 4,219.25 4,799.14
Total 6,314.27 5,819.50 6,086.33 6,810.46 7,362.59 8,088.08 7,172.94 7,899.73 8,234.13 8,978.74

Working Capital -956.86 -1,376.46 -1,617.99 -1,358.49 -1,233.48 -1,455.43 -2,127.99 -2,114.93 -1,802.04 -1,449.91
Debtors 84.27 99.10 78.42 97.93 88.97 124.59 124.33 164.93 165.97 191.89
Inventory 735.93 844.10 820.81 940.06 902.47 965.55 1,283.07 1,416.48 1,592.65 1,928.77

Debtor Days 3.38 3.67 3.50 3.91 3.24 4.03 3.67 4.51 4.11 4.15
Inventory Turnover 12.37 11.67 9.96 9.72 11.09 11.70 9.64 9.42 9.26 8.76

Return on Equity 47% 42% 20% 31% 36% 44% 103% 103% 109% 97%
Return on Capital Emp 56% 29% 53% 57% 71% 96% 139% 140% 138%
NESTLE INDIA LTD SCREENER.IN

Narration Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Cash from Operating Activity 1,796.40 1,644.02 1,098.10 1,465.91 1,817.79 2,052.45 2,295.25 2,454.48 2,236.00 2,737.43
Cash from Investing Activity -440.94 -431.70 -70.48 -125.90 -130.56 -52.41 82.99 -321.46 -1,920.33 -391.73
Cash from Financing Activity -580.12 -1,635.28 -498.32 -665.61 -996.62 -1,317.42 -3,601.53 -1,955.89 -2,019.97 -2,122.74
Net Cash Flow 775.34 -422.96 529.30 674.40 690.61 682.62 -1,223.29 177.13 -1,704.30 222.96
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: support@screener.in
s… do ANYTHING.
COMPANY NAME NESTLE INDIA LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 9.64
Face Value 10.00
Current Price 24,138.95
Market Capitalization 232,737.41

PROFIT & LOSS

Report Date Dec-13 Dec-14 Dec-15 Dec-16
Sales 9,101.05 9,854.84 8,175.31 9,141.34
Raw Material Cost 3,313.68 3,833.24 2,908.60 3,227.26
Change in Inventory -105.32 67.43 -11.97 7.66
Power and Fuel 385.38 384.33 221.99 232.79
Other Mfr. Exp 895.68 955.26 718.95 850.85
Employee Cost 741.50 837.05 912.75 901.57
Selling and admin 1,528.64 1,680.48 1,615.41 1,751.78
Other Expenses 183.27 192.66 230.71 334.91
Other Income 96.90 86.87 -390.75 140.12
Depreciation 329.95 337.54 347.26 353.67
Interest 36.51 14.23 3.29 90.91
Profit before tax 1,678.02 1,774.35 813.63 1,545.38
Tax 560.89 589.66 250.36 544.02
Net profit 1,117.13 1,184.69 563.27 1,001.36
Dividend Amount 467.64 607.45 467.64 607.45

Quarters
Report Date Jun-21 Sep-21 Dec-21 Mar-22
Sales 3,476.70 3,882.57 3,747.98 3,992.64
Expenses 2,628.70 2,934.58 2,889.29 3,071.69
Other Income 29.47 33.66 -209.14 21.44
Depreciation 95.29 95.53 105.96 104.51
Interest 51.69 51.88 43.59 35.58
Profit before tax 730.49 834.24 500.00 802.30
Tax 191.91 216.87 120.52 211.53
Net profit 538.58 617.37 379.48 590.77
Operating Profit 848.00 947.99 858.69 920.95

BALANCE SHEET
Report Date Dec-13 Dec-14 Dec-15 Dec-16
Equity Share Capital 96.42 96.42 96.42 96.42
Reserves 2,272.33 2,740.79 2,721.42 3,185.91
Borrowings 1,189.49 19.57 17.73 33.15
Other Liabilities 2,756.03 2,962.72 3,250.76 3,494.98
Total 6,314.27 5,819.50 6,086.33 6,810.46
Net Block 3,369.31 3,176.64 2,897.85 2,730.14
Capital Work in Progress 294.71 244.78 230.79 188.17
Investments 851.08 811.82 1,324.92 1,755.66
Other Assets 1,799.17 1,586.26 1,632.77 2,136.49
Total 6,314.27 5,819.50 6,086.33 6,810.46
Receivables 84.27 99.10 78.42 97.93
Inventory 735.93 844.10 820.81 940.06
Cash & Bank 749.36 445.82 499.55 880.00
No. of Equity Shares 96,415,716.00 96,415,716.00 96,415,716.00 96,415,716.00
New Bonus Shares
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Dec-13 Dec-14 Dec-15 Dec-16
Cash from Operating Activity 1,796.40 1,644.02 1,098.10 1,465.91
Cash from Investing Activity -440.94 -431.70 -70.48 -125.90
Cash from Financing Activity -580.12 -1,635.28 -498.32 -665.61
Net Cash Flow 775.34 -422.96 529.30 674.40

PRICE: 5,289.25 6,384.85 5,828.00 6,028.35

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

Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22

10,009.60 11,292.27 12,368.90 13,350.03 14,740.59 16,896.96
3,696.99 3,829.22 4,520.91 4,901.74 5,301.26 6,660.42
79.56 6.01 144.19 69.33 67.59 250.27
288.44 344.18 340.53 313.68 408.06 572.61
897.84 949.86 1,028.55 1,040.36 1,349.48 1,603.48
1,017.45 1,124.15 1,258.17 1,500.95 1,529.94 1,635.46
1,823.98 2,145.82 2,226.13 2,246.90 2,902.12 3,192.15
267.93 287.40 212.92 214.23 -245.08 -223.18
176.92 258.92 246.88 145.85 -112.38 107.26
342.25 335.67 370.15 370.38 391.02 403.01
91.90 111.95 129.12 164.18 201.68 154.57
1,839.30 2,428.95 2,673.49 2,812.79 2,857.32 3,255.97
614.11 822.02 705.05 730.36 738.91 865.45
1,225.19 1,606.93 1,968.44 2,082.43 2,118.41 2,390.52
829.21 1,108.83 3,297.56 1,928.40 1,928.40 2,121.24

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

4,045.69 4,601.84 4,256.79 4,830.53 4,658.53 5,036.82
3,231.16 3,597.76 3,283.78 3,735.05 3,603.01 3,811.95
19.37 30.64 29.55 33.69 23.95 139.69
101.68 98.17 98.66 101.70 107.36 111.16
36.97 37.19 44.83 37.01 32.78 31.38
695.25 899.36 859.07 990.46 939.33 1,222.02
185.01 237.90 231.01 253.82 240.99 313.94
 510.24 661.46 628.06 736.64 698.34 908.08
814.53 1,004.08 973.01 1,095.48 1,055.52 1,224.87

Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22

96.42 96.42 96.42 96.42 96.42 96.42
3,324.17 3,577.32 1,822.45 1,922.92 1,849.96 2,362.75
35.14 35.14 188.94 147.49 266.46 270.52
3,906.86 4,379.20 5,065.13 5,732.90 6,021.29 6,249.05
7,362.59 8,088.08 7,172.94 7,899.73 8,234.13 8,978.74
2,616.18 2,400.62 2,341.45 2,179.41 2,994.67 3,043.70
94.16 105.20 143.30 638.58 246.23 358.36
1,978.87 2,658.49 1,751.05 1,463.77 773.98 777.54
2,673.38 2,923.77 2,937.14 3,617.97 4,219.25 4,799.14
7,362.59 8,088.08 7,172.94 7,899.73 8,234.13 8,978.74
88.97 124.59 124.33 164.93 165.97 191.89
902.47 965.55 1,283.07 1,416.48 1,592.65 1,928.77
1,457.42 1,610.06 1,308.05 1,769.87 735.41 945.55
96,415,716.00 96,415,716.00 96,415,716.00 96,415,716.00 96,415,716.00 96,415,716.00

10.00 10.00 10.00 10.00 10.00 10.00

Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22

1,817.79 2,052.45 2,295.25 2,454.48 2,236.00 2,737.43
-130.56 -52.41 82.99 -321.46 -1,920.33 -391.73
-996.62 -1,317.42 -3,601.53 -1,955.89 -2,019.97 -2,122.74
690.61 682.62 -1,223.29 177.13 -1,704.30 222.96

7,870.90 11,084.85 14,785.35 18,390.25 19,705.70 19,606.00

9.64 9.64 9.64 9.64 9.64 9.64