Financial Model of Nestle India - 230819 - 233544
Financial Model of Nestle India - 230819 - 233544
Financial Model of Nestle India - 230819 - 233544
FINANCIAL
MODELING
NESTLE INDIA
PREPARED BY :
Aniruddha Shingre
+ 91 9322360644 [email protected]
Market Cap Revenue Net Profit Revenue Growth Net Profit Growth ROE % ROCE % ROA % ROIC %
216751.21 16896.96 2283.26 14.6% 2.4% 108.0% 138.0% 25.4% 43.1%
Financial Year 2023 Company Registered Name: Nestle India Ltd Sector: FMCG Ticker: NESTLEIND BSE Code:500790 CMP:21989 Status: Hold
Sales Growth Gross Profit Growth EBITDA Growth Net Profit Growth
₹ 16,897.0
₹ 3,706.3
₹ 14,740.6 ₹ 3,562.4 ₹ 2,230.8 ₹ 2,283.3
₹ 6,675.3 ₹ 3,201.5
₹ 13,350.0 ₹ 6,219.4
₹ 12,368.9 ₹ 2,925.9 ₹ 1,936.6
₹ 5,662.6 ₹ 1,721.6
₹ 5,364.9
25,000 ₹ 23,395
9.05 ₹ 17,880
15,000
₹ 15,317
12.38 EV/EBITDA 51.11x
62.76
10,000
₹ 5,525
5,000 ₹ 3,066 ₹ 3,538
Financial Summary
Revenues in Cr. Net Profit in Cr. Average Total Assets
16,897.0
2,390.5 8,606.4
14,740.6 2,118.4
13,350.0 1,968.4 2,082.4
12,368.9
8,066.9
7,630.5
7,536.3
2019 2020 2021 2022 2019 2020 2021 2022 2019 2020 2021 2022
70.39%
26.26% 2.73x
25.80%
2019 2020 2021 2022 2019 2020 2021 2022 2019 2020 2021 2022
Recent Updates
• Nestle India Q1 net profit rises 25% to Rs 737 crore, total sales grow 21%.
• Nestle India Q4 Results: PAT jumps 66% YoY to Rs 628 crore; final dividend declared at Rs 75/share.
• FMCG major Nestle India reported that its profit in the March quarter rose 25 per cent to Rs 737 crore year-on-year.
• total sales grew 21.3 per cent in the first quarter ending March to Rs 4,808 crore, as compared to Rs 3,962.84 crore in same period a year ago.
• The company's sales rose 14% to Rs 4,233 crore in the December quarter, compared with Rs 3,715 crore in the same quarter of last year.
Meanwhile, revenue from operations too jumped 14% YoY to Rs 4,257 crore.
Dupont Analysis - Return On Equity & Return on Asset
# Return On Equity (ROE)
Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Net Profit 1,001.4 1,225.2 1,606.9 1,968.4 2,082.4 2,118.4 2,390.5
Average Shareholder Equity 3,050.1 3,351.5 3,547.2 2,796.3 1,969.1 1,982.9 2,202.8
Return On Equity (ROE) 32.83% 36.56% 45.30% 70.39% 105.76% 106.84% 108.52%
Average Total Asset 6,448.4 7,086.5 7,725.3 7,630.5 7,536.3 8,066.9 8,606.4
Average Shareholder Equity 3,050.1 3,351.5 3,547.2 2,796.3 1,969.1 1,982.9 2,202.8
Equity Multiplier (C) 2.11x 2.11x 2.18x 2.73x 3.83x 4.07x 3.91x
Return on Equity (A*B*C) 32.83% 36.56% 45.30% 70.39% 105.76% 106.84% 108.52%
Return on Asset (A*B) 15.53% 17.29% 20.80% 25.80% 27.63% 26.26% 27.78%
Dupont Summary
• ROE of Nestle India has grown continuously and since 2020 we seen ROE is stable above 100%, Nestle is Successful in Maintain ROE and created
wealth for it's Investors since year 2016 till Current year.
• Nestle's Net Profit Margin is in between the range of 12-14% roughly and it is stable and continued to be stable as it's FMCG company.
• The Asset Efficiency of company is constantly maintained throught the period, current Asset Turnover is at 1.96x which was 1.42x in FY2016.
• Equity Multiplier made a high of 4.07x in FY2021 but in FY2022 its down at 3.91x.
• Return on Asset of Nestle has done exceptionally well from 15.53% to 27.78% growing contineously year by year
Disclaimer - this report is made as part of educational assignment is meant for educational purpose only, author is not liable for any lossses. it is advisable to consult SEBI regrestered Research Analyst
before making Investments
Historical Financial Statement - NESTLE INDIA LTD
Years Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
# Income Statement
Sales ₹ 9,101.1 ₹ 9,854.8 ₹ 8,175.3 ₹ 9,141.3 ₹ 10,009.6 ₹ 11,292.3 ₹ 12,368.9 ₹ 13,350.0 ₹ 14,740.6 ₹ 16,897.0
Sales Growth NA 8.28% -17.04% 11.82% 9.50% 12.81% 9.53% 7.93% 10.42% 14.63%
COGS ₹ 5,441.6 ₹ 5,942.5 ₹ 4,774.3 ₹ 5,204.8 ₹ 5,821.2 ₹ 6,241.4 ₹ 7,004.0 ₹ 7,687.4 ₹ 8,521.2 ₹ 10,221.7
COGS as % of Sales 59.79% 60.30% 58.40% 56.94% 58.16% 55.27% 56.63% 57.58% 57.81% 60.49%
Gross Profit ₹ 3,659.5 ₹ 3,912.4 ₹ 3,401.1 ₹ 3,936.5 ₹ 4,188.4 ₹ 5,050.9 ₹ 5,364.9 ₹ 5,662.6 ₹ 6,219.4 ₹ 6,675.3
Gross Profit Margin 40.21% 39.70% 41.60% 43.06% 41.84% 44.73% 43.37% 42.42% 42.19% 39.51%
Selling & General Exp ₹ 1,711.9 ₹ 1,873.1 ₹ 1,846.1 ₹ 2,086.7 ₹ 2,091.9 ₹ 2,433.2 ₹ 2,439.1 ₹ 2,461.1 ₹ 2,657.0 ₹ 2,969.0
S&G as % of Sales 18.81% 19.01% 22.58% 22.83% 20.90% 21.55% 19.72% 18.44% 18.03% 17.57%
EBITDA ₹ 1,947.6 ₹ 2,039.3 ₹ 1,554.9 ₹ 1,849.8 ₹ 2,096.5 ₹ 2,617.7 ₹ 2,925.9 ₹ 3,201.5 ₹ 3,562.4 ₹ 3,706.3
EBITDA Margin 21.40% 20.69% 19.02% 20.24% 20.95% 23.18% 23.66% 23.98% 24.17% 21.93%
Depreciation ₹ 330.0 ₹ 337.5 ₹ 347.3 ₹ 353.7 ₹ 342.3 ₹ 335.7 ₹ 370.2 ₹ 370.4 ₹ 391.0 ₹ 403.0
Depreciation as % of Sales 3.63% 3.43% 4.25% 3.87% 3.42% 2.97% 2.99% 2.77% 2.65% 2.39%
EBIT ₹ 1,617.6 ₹ 1,701.7 ₹ 1,207.7 ₹ 1,496.2 ₹ 1,754.3 ₹ 2,282.0 ₹ 2,555.7 ₹ 2,831.1 ₹ 3,171.4 ₹ 3,303.3
EBIT Margin 17.77% 17.27% 14.77% 16.37% 17.53% 20.21% 20.66% 21.21% 21.51% 19.55%
Interest ₹ 36.5 ₹ 14.2 ₹ 3.3 ₹ 90.9 ₹ 91.9 ₹ 112.0 ₹ 129.1 ₹ 164.2 ₹ 201.7 ₹ 154.6
Interest as % of Sales 0.40% 0.14% 0.04% 0.99% 0.92% 0.99% 1.04% 1.23% 1.37% 0.91%
EBT ₹ 1,581.1 ₹ 1,687.5 ₹ 1,204.4 ₹ 1,405.3 ₹ 1,662.4 ₹ 2,170.0 ₹ 2,426.6 ₹ 2,666.9 ₹ 2,969.7 ₹ 3,148.7
EBT Margin 17.37% 17.12% 14.73% 15.37% 16.61% 19.22% 19.62% 19.98% 20.15% 18.63%
Tax ₹ 560.9 ₹ 589.7 ₹ 250.4 ₹ 544.0 ₹ 614.1 ₹ 822.0 ₹ 705.1 ₹ 730.4 ₹ 738.9 ₹ 865.5
Effective Tax Rate 35.47% 34.94% 20.79% 38.71% 36.94% 37.88% 29.05% 27.39% 24.88% 27.49%
Net Profit ₹ 1,020.2 ₹ 1,097.8 ₹ 954.0 ₹ 861.2 ₹ 1,048.3 ₹ 1,348.0 ₹ 1,721.6 ₹ 1,936.6 ₹ 2,230.8 ₹ 2,283.3
Net Profit Margin 11.21% 11.14% 11.67% 9.42% 10.47% 11.94% 13.92% 14.51% 15.13% 13.51%
No of Equity Shares 9.64 9.64 9.64 9.64 9.64 9.64 9.64 9.64 9.64 9.64
Earnings Per Share ₹ 105.8 ₹ 113.9 ₹ 99.0 ₹ 89.3 ₹ 108.7 ₹ 139.8 ₹ 178.6 ₹ 200.9 ₹ 231.4 ₹ 236.9
EPS Growth NA 7.61% -13.10% -9.73% 21.72% 28.59% 27.71% 12.49% 15.19% 2.35%
Dividend Per Share ₹ 48.5 ₹ 63.0 ₹ 48.5 ₹ 63.0 ₹ 86.0 ₹ 115.0 ₹ 342.1 ₹ 200.0 ₹ 200.0 ₹ 220.0
Dividend Growth NA 29.90% -23.02% 29.90% 36.51% 33.72% 197.39% -41.52% 0.00% 10.00%
Dividend Payout Ratio 45.84% 55.33% 49.02% 70.53% 79.10% 82.26% 191.54% 99.58% 86.44% 92.90%
Retained Earnings 54.16% 44.67% 50.98% 29.47% 20.90% 17.74% 0.00% 0.42% 13.56% 7.10%
# Balance Sheet
Equity Share Capital ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4 ₹ 96.4
Reserves ₹ 2,272.3 ₹ 2,740.8 ₹ 2,721.4 ₹ 3,185.9 ₹ 3,324.2 ₹ 3,577.3 ₹ 1,822.5 ₹ 1,922.9 ₹ 1,850.0 ₹ 2,362.8
Borrowings ₹ 1,189.5 ₹ 19.6 ₹ 17.7 ₹ 33.2 ₹ 35.1 ₹ 35.1 ₹ 188.9 ₹ 147.5 ₹ 266.5 ₹ 270.5
Other Liabilities ₹ 2,756.0 ₹ 2,962.7 ₹ 3,250.8 ₹ 3,495.0 ₹ 3,906.9 ₹ 4,379.2 ₹ 5,065.1 ₹ 5,732.9 ₹ 6,021.3 ₹ 6,249.1
Total Liabilities ₹ 6,314.3 ₹ 5,819.5 ₹ 6,086.3 ₹ 6,810.5 ₹ 7,362.6 ₹ 8,088.1 ₹ 7,172.9 ₹ 7,899.7 ₹ 8,234.1 ₹ 8,978.7
Fixed Assets Net Block ₹ 3,369.3 ₹ 3,176.6 ₹ 2,897.9 ₹ 2,730.1 ₹ 2,616.2 ₹ 2,400.6 ₹ 2,341.5 ₹ 2,179.4 ₹ 2,994.7 ₹ 3,043.7
Capital Work in Progress ₹ 294.7 ₹ 244.8 ₹ 230.8 ₹ 188.2 ₹ 94.2 ₹ 105.2 ₹ 143.3 ₹ 638.6 ₹ 246.2 ₹ 358.4
Investments ₹ 851.1 ₹ 811.8 ₹ 1,324.9 ₹ 1,755.7 ₹ 1,978.9 ₹ 2,658.5 ₹ 1,751.1 ₹ 1,463.8 ₹ 774.0 ₹ 777.5
Other Assets ₹ 229.6 ₹ 197.2 ₹ 234.0 ₹ 218.5 ₹ 224.5 ₹ 223.6 ₹ 221.7 ₹ 266.7 ₹ 1,725.2 ₹ 1,732.9
Total Non Current Assets ₹ 4,744.7 ₹ 4,430.5 ₹ 4,687.6 ₹ 4,892.5 ₹ 4,913.7 ₹ 5,387.9 ₹ 4,457.5 ₹ 4,548.5 ₹ 5,740.1 ₹ 5,912.5
Receivables ₹ 84.3 ₹ 99.1 ₹ 78.4 ₹ 97.9 ₹ 89.0 ₹ 124.6 ₹ 124.3 ₹ 164.9 ₹ 166.0 ₹ 191.9
Inventory ₹ 735.9 ₹ 844.1 ₹ 820.8 ₹ 940.1 ₹ 902.5 ₹ 965.6 ₹ 1,283.1 ₹ 1,416.5 ₹ 1,592.7 ₹ 1,928.8
Cash & Bank ₹ 749.4 ₹ 445.8 ₹ 499.6 ₹ 880.0 ₹ 1,457.4 ₹ 1,610.1 ₹ 1,308.1 ₹ 1,769.9 ₹ 735.4 ₹ 945.6
Total Current Assets ₹ 1,569.6 ₹ 1,389.0 ₹ 1,398.8 ₹ 1,918.0 ₹ 2,448.9 ₹ 2,700.2 ₹ 2,715.5 ₹ 3,351.3 ₹ 2,494.0 ₹ 3,066.2
Total Assets 6314.27 5819.5 6086.33 6810.46 7362.59 8088.08 7172.94 7899.73 8234.13 8978.74
Bal Check 0 0 0 0 0 0 0 0 0 0
Fixed assets purchased (₹ 345.0) (₹ 415.0) (₹ 151.0) (₹ 207.0) (₹ 199.0) (₹ 166.0) (₹ 155.0) (₹ 478.0) (₹ 735.0) (₹ 550.0)
Fixed assets sold ₹ 17.0 ₹ 10.0 ₹ 1.0 ₹ 94.0 ₹ 3.0 ₹ 3.0 ₹ 2.0 ₹ 4.0 ₹ 4.0 ₹ 9.0
Investments purchased (₹ 145.0) (₹ 80.0) (₹ 37.0) (₹ 153.0) (₹ 112.0) (₹ 160.0) (₹ 16.0) ₹ 0.0 ₹ 0.0 ₹ 0.0
Investments sold ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 25.0
Interest received ₹ 69.0 ₹ 66.0 ₹ 99.0 ₹ 126.0 ₹ 154.0 ₹ 237.0 ₹ 238.0 ₹ 148.0 ₹ 125.0 ₹ 103.0
Dividends received ₹ 11.0 ₹ 10.0 ₹ 12.0 ₹ 13.0 ₹ 16.0 ₹ 19.0 ₹ 13.0 ₹ 2.0 ₹ 0.0 ₹ 0.0
Other investing items (₹ 47.0) (₹ 23.0) ₹ 6.0 ₹ 1.0 ₹ 7.0 ₹ 15.0 ₹ 0.0 ₹ 3.0 (₹ 1,314.0) ₹ 20.0
Cash from Investing Activities (₹ 441.0) (₹ 432.0) (₹ 70.0) (₹ 126.0) (₹ 131.0) (₹ 52.0) ₹ 83.0 (₹ 321.0) (₹ 1,920.0) (₹ 392.0)
Proceeds from borrowings ₹ 0.0 ₹ 4.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 24.0 ₹ 0.0
Repayment of borrowings ₹ 0.0 ₹ 0.0 (₹ 3.0) ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 (₹ 24.0) ₹ 0.0
Investment subsidy ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
Interest paid fin (₹ 36.0) (₹ 15.0) (₹ 3.0) (₹ 4.0) (₹ 1.0) (₹ 4.0) (₹ 63.0) (₹ 69.0) (₹ 9.0) (₹ 18.0)
Dividends paid (₹ 468.0) (₹ 607.0) (₹ 410.0) (₹ 564.0) (₹ 829.0) (₹ 1,090.0) (₹ 2,950.0) (₹ 1,890.0) (₹ 1,928.0) (₹ 2,025.0)
Financial liabilities ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 (₹ 79.0) (₹ 73.0)
Other financing items (₹ 76.0) (₹ 1,017.0) (₹ 82.0) (₹ 98.0) (₹ 167.0) (₹ 224.0) (₹ 588.0) ₹ 3.0 (₹ 3.0) (₹ 7.0)
Cash from Financing Activities (₹ 580.0) (₹ 1,635.0) (₹ 498.0) (₹ 666.0) (₹ 997.0) (₹ 1,317.0) (₹ 3,602.0) (₹ 1,956.0) (₹ 2,020.0) (₹ 2,123.0)
Net Cash Flow ₹ 775.0 (₹ 423.0) ₹ 530.0 ₹ 674.0 ₹ 690.0 ₹ 683.0 (₹ 1,224.0) ₹ 177.0 (₹ 1,704.0) ₹ 222.0
# Common Size Income Statement - NESTLE INDIA LTD
Particulars Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Sales 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Raw Material Cost 36.41% 38.90% 35.58% 35.30% 36.93% 33.91% 36.55% 36.72% 35.96% 39.42%
Change in Inventory -1.16% 0.68% -0.15% 0.08% 0.79% 0.05% 1.17% 0.52% 0.46% 1.48%
Power and Fuel 4.23% 3.90% 2.72% 2.55% 2.88% 3.05% 2.75% 2.35% 2.77% 3.39%
Other Mfr. Exp 9.84% 9.69% 8.79% 9.31% 8.97% 8.41% 8.32% 7.79% 9.15% 9.49%
Employee Cost 8.15% 8.49% 11.16% 9.86% 10.16% 9.96% 10.17% 11.24% 10.38% 9.68%
Selling and admin 16.80% 17.05% 19.76% 19.16% 18.22% 19.00% 18.00% 16.83% 19.69% 18.89%
Other Expenses 2.01% 1.95% 2.82% 3.66% 2.68% 2.55% 1.72% 1.60% -1.66% -1.32%
Other Income 1.06% 0.88% -4.78% 1.53% 1.77% 2.29% 2.00% 1.09% -0.76% 0.63%
Depreciation 3.63% 3.43% 4.25% 3.87% 3.42% 2.97% 2.99% 2.77% 2.65% 2.39%
Interest 0.40% 0.14% 0.04% 0.99% 0.92% 0.99% 1.04% 1.23% 1.37% 0.91%
Profit before tax 18.44% 18.00% 9.95% 16.91% 18.38% 21.51% 21.61% 21.07% 19.38% 19.27%
Tax 6.16% 5.98% 3.06% 5.95% 6.14% 7.28% 5.70% 5.47% 5.01% 5.12%
Net profit 12.27% 12.02% 6.89% 10.95% 12.24% 14.23% 15.91% 15.60% 14.37% 14.15%
Dividend Amount 5.14% 6.16% 5.72% 6.65% 8.28% 9.82% 26.66% 14.44% 13.08% 12.55%
EBITDA 21.40% 20.69% 19.02% 20.24% 20.95% 23.18% 23.66% 23.98% 24.17% 21.93%
Particulars Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Total Liabilities 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Equity Share Capital 1.53% 1.66% 1.58% 1.42% 1.31% 1.19% 1.34% 1.22% 1.17% 1.07%
Reserves 35.99% 47.10% 44.71% 46.78% 45.15% 44.23% 25.41% 24.34% 22.47% 26.31%
Borrowings 18.84% 0.34% 0.29% 0.49% 0.48% 0.43% 2.63% 1.87% 3.24% 3.01%
Other Liabilities 43.65% 50.91% 53.41% 51.32% 53.06% 54.14% 70.61% 72.57% 73.13% 69.60%
Total Assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Net Block 53.36% 54.59% 47.61% 40.09% 35.53% 29.68% 32.64% 27.59% 36.37% 33.90%
Capital Work in Progress 4.67% 4.21% 3.79% 2.76% 1.28% 1.30% 2.00% 8.08% 2.99% 3.99%
Investments 13.48% 13.95% 21.77% 25.78% 26.88% 32.87% 24.41% 18.53% 9.40% 8.66%
Other Assets 3.64% 3.39% 3.84% 3.21% 3.05% 2.76% 3.09% 3.38% 20.95% 19.30%
Receivables 1.33% 1.70% 1.29% 1.44% 1.21% 1.54% 1.73% 2.09% 2.02% 2.14%
Inventory 11.66% 14.50% 13.49% 13.80% 12.26% 11.94% 17.89% 17.93% 19.34% 21.48%
Cash & Bank 11.87% 7.66% 8.21% 12.92% 19.79% 19.91% 18.24% 22.40% 8.93% 10.53%
Ratio Analysis - NESTLE INDIA LTD
Years Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Trend Mean Median
Sales Growth NA 8.28% -17.04% 11.82% 9.50% 12.81% 9.53% 7.93% 10.42% 14.63% 7.54% 9.53%
EBITDA Growth NA 4.71% -23.75% 18.97% 13.34% 24.86% 11.78% 9.42% 11.27% 4.04% 8.29% 11.27%
EBIT Growth NA 5.20% -29.03% 23.89% 17.25% 30.08% 12.00% 10.78% 12.02% 4.16% 9.59% 12.00%
EBT Growth NA 6.73% -28.63% 16.68% 18.30% 30.54% 11.82% 9.90% 11.35% 6.03% 9.19% 11.35%
Dividend Growth NA 29.90% -23.02% 29.90% 36.51% 33.72% 197.39% -41.52% 0.00% 10.00% 30.32% 29.90%
EPS Growth NA 7.61% -13.10% -9.73% 21.72% 28.59% 27.71% 12.49% 15.19% 2.35% 10.32% 12.49%
Gross Margin 40.21% 39.70% 41.60% 43.06% 41.84% 44.73% 43.37% 42.42% 42.19% 39.51% 41.86% 42.19%
EBITDA Margin 21.40% 20.69% 19.02% 20.24% 20.95% 23.18% 23.66% 23.98% 24.17% 21.93% 21.92% 21.93%
EBIT Margin 17.77% 17.27% 14.77% 16.37% 17.53% 20.21% 20.66% 21.21% 21.51% 19.55% 18.68% 19.55%
EBT Margin 17.37% 17.12% 14.73% 15.37% 16.61% 19.22% 19.62% 19.98% 20.15% 18.63% 17.88% 18.63%
Net Profit Margin 11.21% 11.14% 11.67% 9.42% 10.47% 11.94% 13.92% 14.51% 15.13% 13.51% 12.29% 11.94%
Selling Exp as % of Sales 18.81% 19.01% 22.58% 22.83% 20.90% 21.55% 19.72% 18.44% 18.03% 17.57% 19.94% 19.72%
Depreciation exp as % of Sales 3.63% 3.43% 4.25% 3.87% 3.42% 2.97% 2.99% 2.77% 2.65% 2.39% 3.24% 2.99%
Operating Exp as % of Sales 17.77% 17.27% 14.77% 16.37% 17.53% 20.21% 20.66% 21.21% 21.51% 19.55% 18.68% 19.55%
Return on Capital Employed 45.46% 59.57% 42.59% 45.13% 50.76% 61.53% 121.25% 130.66% 143.32% 121.01% 82.13% 61.53%
Retained Earnings % 54.16% 44.67% 50.98% 29.47% 20.90% 17.74% 0.00% 0.42% 13.56% 7.10% 23.90% 17.74%
Return on Equity 43.07% 38.69% 33.86% 26.24% 30.65% 36.69% 89.72% 95.90% 114.61% 92.85% 60.23% 38.69%
Self Sustained Growth Rate 23.33% 17.28% 17.26% 7.73% 6.40% 6.51% 0.00% 0.41% 15.54% 6.59% 10.10% 6.59%
Interest Coverage Ratio 44.31x 119.59x 367.07x 16.46x 19.09x 20.38x 19.79x 17.24x 15.72x 21.37x 66.10x 19.79x
Debtor Turnover Ratio 108.00x 99.44x 104.25x 93.35x 112.51x 90.64x 99.48x 80.94x 88.81x 88.06x 96.55x 93.35x
Creditor Turnover Ratio 3.30x 3.33x 2.51x 2.62x 2.56x 2.58x 2.44x 2.33x 2.45x 2.70x 2.68x 2.56x
Inventory Turnover Ratio 12.37x 11.67x 9.96x 9.72x 11.09x 11.70x 9.64x 9.42x 9.26x 8.76x 10.36x 9.72x
Fixed Asset Turnover Ratio 2.70x 3.10x 2.82x 3.35x 3.83x 4.70x 5.28x 6.13x 4.92x 5.55x 4.24x 4.70x
Capital Turnonver Ratio 2.56x 3.45x 2.88x 2.76x 2.90x 3.04x 5.87x 6.16x 6.66x 6.19x 4.25x 3.45x
(In Days)
Debtor Days 3 4 4 4 3 4 4 5 4 4 4 4
Payable Days 111 110 145 140 142 142 149 157 149 135 138 142
Inventory Days 30 31 37 38 33 31 38 39 39 42 36 38
Cash Conversion Cycle -78 -75 -105 -98 -106 -106 -108 -114 -106 -89 -98 -106
CFO/Sales 19.73% 16.68% 13.43% 16.04% 18.16% 18.17% 18.55% 18.38% 15.17% 16.20% 17.05% 16.68%
CFO/Total Assets 28.44% 28.25% 18.04% 21.53% 24.69% 25.37% 32.00% 31.06% 27.16% 30.48% 26.70% 27.16%
CFO/Total Debt (Borrowings) 150.99% 8400.61% 6192.89% 4422.32% 5173.59% 5839.50% 1214.67% 1663.84% 839.15% 1011.76% 3490.93% 4422.32%
NESTLE INDIA LTD - Sales Forecasting NESTLE INDIA LTD - EBITDA Forecasting NESTLE INDIA LTD - Earnings Per Share Forecasting
Weight Year Sales Growth Weight Year EBITDA Growth Weight Year EPS Growth
1 2013A ₹ 9,101.1 NA 1 2013A ₹ 1,947.6 NA 1 2013A ₹ 105.8 NA
2 2014A ₹ 9,854.8 8.28% 2 2014A ₹ 2,039.3 4.71% 2 2014A ₹ 113.9 7.61%
3 2015A ₹ 8,175.3 -17.04% 3 2015A ₹ 1,554.9 -23.75% 3 2015A ₹ 99.0 -13.10%
4 2016A ₹ 9,141.3 11.82% 4 2016A ₹ 1,849.8 18.97% 4 2016A ₹ 89.3 -9.73%
5 2017A ₹ 10,009.6 9.50% 5 2017A ₹ 2,096.5 13.34% 5 2017A ₹ 108.7 21.72%
6 2018A ₹ 11,292.3 12.81% 6 2018A ₹ 2,617.7 24.86% 6 2018A ₹ 139.8 28.59%
7 2019A ₹ 12,368.9 9.53% 7 2019A ₹ 2,925.9 11.78% 7 2019A ₹ 178.6 27.71%
8 2020A ₹ 13,350.0 7.93% 8 2020A ₹ 3,201.5 9.42% 8 2020A ₹ 200.9 12.49%
9 2021A ₹ 14,740.6 10.42% 9 2021A ₹ 3,562.4 11.27% 9 2021A ₹ 231.4 15.19%
10 2022A ₹ 16,897.0 14.63% 10 2022A ₹ 3,706.3 4.04% 10 2022A ₹ 236.9 2.35%
11 2023E ₹ 16,199.8 -4.13% 11 2023E ₹ 3,832.6 3.41% 11 2023E ₹ 244.1 3.06%
12 2024E ₹ 17,055.6 5.28% 12 2024E ₹ 4,065.8 6.08% 12 2024E ₹ 261.1 6.98%
13 2025E ₹ 17,911.4 5.02% 13 2025E ₹ 4,298.9 5.73% 13 2025E ₹ 278.2 6.52%
14 2026E ₹ 18,767.2 4.78% 14 2026E ₹ 4,532.1 5.42% 14 2026E ₹ 295.2 6.12%
15 2027E ₹ 19,622.9 4.56% 15 2027E ₹ 4,765.3 5.14% 15 2027E ₹ 312.2 5.77%
NESTLE
INDIA LTD
Peer Comps
Debt/ Debt/ Levered Unlevered
1 2 3
Name Of the Comp Total Debt Total Equity Tax Rate Equity Capital Beta Beta
Hind. Unilever 1219 607275.36 30.00% 0.20% 0.20% 0.54 0.54
Nestle India 288.49 216751.21 30.00% 0.13% 0.13% 0.55 0.55
Britannia Inds. 2997.37 118106.16 30.00% 2.54% 2.48% 0.74 0.73
Godrej Consumer 1129.58 105946.93 30.00% 1.07% 1.05% 0.57 0.57
Dabur India 1173.79 103079.26 30.00% 1.14% 1.13% 0.67 0.66
Current Assets
Inventories 966.0 1283.0 1416.0 1593.0 1929.0
Trade receivables 125.0 124.0 165.0 166.0 192.0
Short term loans 23.0 26.0 27.0 21.0 27.0
Other asset items 201.0 196.0 240.0 1704.0 1706.0
Total Current Assets 1315.0 1629.0 1848.0 3484.0 3854.0
Current Liabilities
Trade Payables 1240.0 1492.0 1517.0 1748.0 1934.0
Advance from Customers 41.0 37.0 53.0 69.0 114.0
Other liability items 3098.0 3537.0 4164.0 4204.0 4201.0
Total Current Liabilties 4379.0 5066.0 5734.0 6021.0 6249.0
PV Of FCFF 7,169.74
PV of Terminal Value 21,474.10
Enterprise Value 28,643.84
25,000 ₹ 23,395
20,000
₹ 17,116
₹ 17,880
15,000
₹ 15,317
10,000
₹ 5,525
5,000 ₹ 3,066 ₹ 3,538
₹ 3,538
₹ 2,489 ₹ 2,734
0
Comps DCF Bear DCF Base DCF Bull 52 Week H/L
Return On Markets
Year Annual
2000 -14.65%
2001 -16.18%
2002 3.25% Average Return 15.41%
1
2003 71.90% Dividend Yield 1.36%
2004 10.68% Total Return 15.41%
2005 36.34%
2006 39.83%
2007 54.77% Nifty Returns
2008 -51.79%
100.00%
2009 75.76%
2010 17.95% 80.00%
2011 -24.62% 60.00%
2012 27.70%
2013 6.76% 40.00%
Working Capital / Total Assets Retained Earnings / Total Assets EBIT / Total Assets
3.67% 38.52%
-29.67%
-26.77%
-21.89% 36.79%
-16.15% 1.80%
35.84%
35.63%
0.00% 0.10%
2019 2020 2021 2022 2019 2020 2021 2022 2019 2020 2021 2022
Market cap / Long Term Debt Sales / Total Assets Altman Z Score
1202189.38 188.19%
7215.69
%
179.02%
4529.51 4281.03
754493.55% 713029.79% 698775.15% 172.44% 4195.58
168.99%
2019 2020 2021 2022 2019 2020 2021 2022 2019 2020 2021 2022
Recent Updates
Altman's Z Score Analysis - Calculation
# Working Capital / Total Assets
Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Working Capital -1,358.5 -1,233.5 -1,455.4 -2,128.0 -2,114.9 -1,802.0 -1,449.9
Total Assets 6,810.5 7,362.6 8,088.1 7,172.9 7,899.7 8,234.1 8,978.7
Working Capital / Total Assets -19.95% -16.75% -17.99% -29.67% -26.77% -21.89% -16.15%
Altman's Z Score
Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Final Score 10521.84 12959.50 18250.65 4529.51 7215.69 4281.03 4195.58
Financial Stability Strong Strong Strong Strong Strong Strong Strong
Disclaimer - this report is made as part of educational assignment is meant for educational purpose only, author is not liable for any lossses. it is advisable to consult SEBI regrestered Research Analyst before
making Investments
Date Adj Close Returns Sorted Returns Replications Simulated ReturnsCalculation of VAR Historical Approach
08-01-2010 2099.22 -2.04408 1.554608242 1 -0.03647848
07-04-2020 16210.34 0.186088 0.120481788 2 -0.023114872 Historical Approach
20-03-2020 13457.84 0.790503 0.075235826 3 -0.00615604 Mean 0.08%
05-08-2015 6104.699 0.57963 0.073989177 4 0.003347055 Std 2.46%
09-11-2010 3419.274 -0.47169 0.069937508 5 0.022673218 Min -9.50%
13-05-2016 5480.084 -0.91933 0.069560269 6 -0.017145434 Max 155.46%
25-03-2020 13741.92 0.948138 0.069201366 7 -0.032357145 CMP 22,553
09-06-2015 5324.466 2.453848 0.068584788 8 -0.041170649
23-08-2002 457.7028 -2.64094 0.068211714 9 0.022796726 Monte Carlo Simulation
28-08-2017 6419.923 -0.68953 0.0653653 10 0.003208552 Mean 0.05%
20-09-2019 12793.51 -0.19245 0.06144467 11 -0.004701157 Std 2.48%
03-02-2020 15508.55 0.375732 0.059495441 12 -0.002638406 Min -9.50%
23-08-2018 10651.06 0.201197 0.058655854 13 -0.005242457 Max 8.82%
11-05-2018 8709.915 -0.64351 0.058537613 14 -0.01658222 CMP 22,553
27-10-2020 16576.2 1.041228 0.057975247 15 0.000941119
16-10-2015 5851.748 0.91235 0.054631096 16 -0.013857478 Percentile Confidence VAR % Stock Price VAR (INR)
09-02-2010 2349.941 -1.62513 0.054112964 17 0.025542557 5.0% 95.0% -3.97% 23447.77 -894.47
21-08-2019 11935.55 1.005767 0.050841644 18 -0.008838132 1.0% 99.0% -5.77% 23853.81 -1,300.51
30-04-2013 4365.595 -0.02398 0.050729983 19 -0.020046441 0.5% 99.5% -6.40% 23996.95 -1,443.65
01-07-2013 4471.551 -0.32645 0.049879115 20 0.049830485 10.0% 90.0% -3.08% 23247.39 -694.09
14-10-2016 6197.763 0.184422 0.049838191 21 0.081755404
31-03-2016 5153.963 0.579063 0.049408584 22 -0.013404783
14-02-2011 2888.402 -0.68836 0.049380983 23 -0.013918608
01-06-2016 5749.22 0.440897 0.047005391 24 -0.034281266
01-07-2011 3699.387 -1.50597 0.046909502 25 -0.03208757
20-05-2022 16678.72 1.354119 0.046600507 26 -0.017596416
30-08-2013 4306.023 -0.24537 0.046182625 27 -0.039383558
12-04-2016 5503.494 -0.02993 0.046111855 28 -0.006086079
30-06-2015 5670.706 0.312419 0.045269535 29 0.011753542
10-04-2012 4149.114 -1.45612 0.043827196 30 0.022309525
10-12-2020 17796.8 0.642268 0.043632297 31 -0.002280834
31-10-2018 9362.858 0.300063 0.043235396 32 0.046467608
15-02-2018 6935.737 -0.86568 0.04287367 33 -0.006617388
15-04-2020 16483.63 1.001439 0.042802943 34 -0.000145792
27-04-2017 6055.267 -0.93879 0.04234069 35 -0.006129662
19-10-2020 15482.62 1.144008 0.042063874 36 -0.034012472
13-08-2014 4931.831 0.375746 0.041666939 37 0.059024403
09-03-2011 3387.066 -0.47182 0.041180439 38 -0.008818885
18-06-2015 5429.181 0.791057 0.04073361 39 0.018053984
24-05-2010 2461.401 -1.65052 0.040452795 40 -0.044902754
24-03-2020 12823.12 -0.19012 0.040402042 41 0.022712684
31-03-2020 15508.17 0.469451 0.040178225 42 0.018574735
31-07-2018 9697.961 -0.3768 0.039515406 43 -0.014650149
20-12-2019 14135.93 -0.35416 0.039317112 44 0.027112986
17-04-2023 20143.54 1.215831 0.039242316 45 0.0199843
13-01-2015 5971.824 -1.04248 0.038236499 46 0.021379315
08-05-2020 16937.48 1.292589 0.037806265 47 -0.005007154
15-10-2013 4650.34 0.736663 0.037561317 48 -0.026039797
08-02-2010 2226.158 -1.04103 0.037119781 49 -0.017639978
27-05-2015 6304.8 0.120395 0.037089922 50 0.035308545
27-07-2015 5589.647 0.411922 0.037010428 51 -0.003342539
27-01-2012 3702.449 0.349927 0.036682701 52 0.033501072
26-08-2010 2609.262 -0.7356 0.036615329 53 -0.044991559
24-09-2014 5444.845 0.213138 0.036337928 54 -0.016016287
30-05-2014 4399.676 -0.66956 0.036320129 55 0.024410191
30-04-2018 8594.261 -0.66936 0.036286175 56 0.003677516
22-04-2020 16784.4 0.119262 0.036169235 57 -0.000368003
30-03-2020 14897.43 0.697006 0.035759459 58 0.005245218
27-03-2018 7420.027 0.449832 0.035589634 59 0.022668821
12-07-2013 4732.013 -1.25776 0.035228125 60 0.003526506
30-03-2021 16645.07 1.85071 0.035172912 61 -0.000869204
05-07-2010 2615.367 -0.77852 0.035067339 62 0.080205521
06-02-2017 5696.9 -0.84075 0.035020303 63 -0.002437881
26-09-2019 13205.96 0.467931 0.034763963 64 -0.016682989
26-04-2018 8270.849 -0.21942 0.034698967 65 -0.046275101
27-05-2019 10300.16 0.624064 0.034682401 66 0.021873279
24-11-2016 5518.44 0.377364 0.03449051 67 0.005760359
27-07-2011 3783.808 -1.618 0.034386064 68 -0.002945069
Regression Beta 5 Year Weekly
Adjusted Beta Raw Beta
X Y
Nifty NESTLE INDIA LTD Beta Drifting Beta 1 0.55
Beta 2 0.55
Date Adj Close Returns Date Adj Close Returns Levered Raw Beta 0.55 Beta 3 0.55
Jul 17, 2023 16,904.30 NA Jul 17, 2023 22982.55 NA Beta Weight 75.00%
Jul 10, 2023 16,765.45 -0.82% Jul 10, 2023 23138.05 0.68% Mkt Beta 1.00 SUMMARY OUTPUT
Jul 03, 2023 16,564.90 -1.20% Jul 03, 2023 22906.2 -1.00% Mkt Beta Weight 25.00%
Jun 26, 2023 16,430.00 -0.81% Jun 26, 2023 22894.3 -0.05% Regression Statistics
Jun 19, 2023 16,011.80 -2.55% Jun 19, 2023 22536.85 -1.56% Adjusted Beta 0.66 Multiple R 0.478046582
Jun 12, 2023 16,181.45 1.06% Jun 12, 2023 22968.55 1.92% R Square 0.228528534
Jun 05, 2023 15,877.40 -1.88% Jun 05, 2023 22073.45 -3.90% Adjusted R Square 0.2255267
May 29, 2023 15,811.20 -0.42% May 29, 2023 22046.45 -0.12% Standard Error 0.026055638
May 22, 2023 15,696.75 -0.72% May 22, 2023 21581.75 -2.11% Observations 259
May 15, 2023 15,407.55 -1.84% May 15, 2023 21690.15 0.50%
May 08, 2023 15,477.35 0.45% May 08, 2023 21794.15 0.48% ANOVA
May 01, 2023 15,278.60 -1.28% May 01, 2023 22019.85 1.04% df SS MS F Significance F
Apr 24, 2023 15,219.55 -0.39% Apr 24, 2023 21761.4 -1.17% Regression 1 0.051684117 0.051684117 76.12962489 3.40561E-16
Apr 17, 2023 14,847.10 -2.45% Apr 17, 2023 20394.73 -6.28% Residual 257 0.174476338 0.000678896
Apr 10, 2023 14,954.25 0.72% Apr 10, 2023 19368.37 -5.03% Total 258 0.226160455
Apr 03, 2023 14,759.20 -1.30% Apr 03, 2023 19610.06 1.25%
Mar 27, 2023 14,557.85 -1.36% Mar 27, 2023 19606.33 -0.02% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Mar 20, 2023 14,279.00 -1.92% Mar 20, 2023 18858.67 -3.81% Intercept -0.001955001 0.001623148 -1.204450211 0.229523655 -0.00515136 0.001241363 -0.00515136 0.001241363
Mar 13, 2023 14,420.85 0.99% Mar 13, 2023 18764.2 -0.50% X Variable 1 0.55309466 0.063390273 8.725229217 3.40561E-16 0.428264158 0.677925162 0.428264158 0.677925162
Mar 06, 2023 14,679.85 1.80% Mar 06, 2023 18393.65 -1.97%
Feb 27, 2023 14,774.75 0.65% Feb 27, 2023 18357.98 -0.19%
Feb 20, 2023 14,630.45 -0.98% Feb 20, 2023 18587.83 1.25%
Feb 13, 2023 15,003.95 2.55% Feb 13, 2023 18926.53 1.82%
Feb 06, 2023 15,015.85 0.08% Feb 06, 2023 18929.07 0.01%
Jan 30, 2023 14,962.35 -0.36% Jan 30, 2023 18909.62 -0.10%
Jan 23, 2023 14,874.75 -0.59% Jan 23, 2023 19120.61 1.12%
Jan 16, 2023 15,347.90 3.18% Jan 16, 2023 19104.39 -0.08%
Jan 09, 2023 15,346.10 -0.01% Jan 09, 2023 19685.78 3.04%
Jan 02, 2023 15,272.00 -0.48% Jan 02, 2023 19786.18 0.51%
Dec 26, 2022 15,448.85 1.16% Dec 26, 2022 19508.32 -1.40%
Dec 19, 2022 15,046.00 -2.61% Dec 19, 2022 20032.45 2.69%
Dec 12, 2022 15,636.35 3.92% Dec 12, 2022 19640.36 -1.96%
Dec 05, 2022 15,812.75 1.13% Dec 05, 2022 20140.9 2.55%
Nov 28, 2022 15,963.50 0.95% Nov 28, 2022 19652.79 -2.42%
Nov 21, 2022 15,727.25 -1.48% Nov 21, 2022 19432.05 -1.12%
Nov 14, 2022 15,550.85 -1.12% Nov 14, 2022 19825.83 2.03%
Nov 07, 2022 15,649.10 0.63% Nov 07, 2022 20221.25 1.99%
Oct 31, 2022 15,530.85 -0.76% Oct 31, 2022 20203.3 -0.09%
Oct 24, 2022 15,241.60 -1.86% Oct 24, 2022 20062 -0.70%
Oct 17, 2022 15,081.10 -1.05% Oct 17, 2022 20074.36 0.06%
Oct 10, 2022 14,815.10 -1.76% Oct 10, 2022 18722.27 -6.74%
Oct 03, 2022 15,036.70 1.50% Oct 03, 2022 19111 2.08%
Sep 26, 2022 14,829.35 -1.38% Sep 26, 2022 18936.71 -0.91%
Sep 19, 2022 15,057.65 1.54% Sep 19, 2022 18294.87 -3.39%
Sep 12, 2022 15,243.95 1.24% Sep 12, 2022 18204.16 -0.50%
Sep 05, 2022 15,467.40 1.47% Sep 05, 2022 18844.18 3.52%
Aug 29, 2022 15,201.60 -1.72% Aug 29, 2022 19349.18 2.68%
Aug 22, 2022 15,147.55 -0.36% Aug 22, 2022 19315.85 -0.17%
Aug 15, 2022 15,236.65 0.59% Aug 15, 2022 19229.6 -0.45%
Aug 08, 2022 15,140.55 -0.63% Aug 08, 2022 19330.83 0.53%
Aug 01, 2022 14,900.40 -1.59% Aug 01, 2022 19704.97 1.94%
Jul 25, 2022 14,665.65 -1.58% Jul 25, 2022 19148.68 -2.82%
Jul 18, 2022 14,336.60 -2.24% Jul 18, 2022 18782.56 -1.91%
Jul 11, 2022 13,790.20 -3.81% Jul 11, 2022 18567.47 -1.15%
Jul 04, 2022 13,828.25 0.28% Jul 04, 2022 18218.95 -1.88%
Jun 27, 2022 13,394.45 -3.14% Jun 27, 2022 17601.63 -3.39%
Jun 20, 2022 13,322.50 -0.54% Jun 20, 2022 17044.36 -3.17%
COMPANY NAME NESTLE INDIA LTD
LATEST VERSION 2.10 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
CURRENT VERSION 2.10
META
Number of shares 9.64
Face Value 10
Current Price 22480.9
Market Capitalization 216751.21
EBITDA 2,044.48 2,126.12 1,164.18 1,989.96 2,273.45 2,876.57 3,172.76 3,347.35 3,450.02 3,813.55
EBIT 1,714.53 1,788.58 816.92 1,636.29 1,931.20 2,540.90 2,802.61 2,976.97 3,059.00 3,410.54
Quarters
Report Date Mar-21 Jun-21 Sep-21 Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23
Sales 3610.82 3476.7 3882.57 3747.98 3992.64 4045.69 4601.84 4256.79 4830.53 4658.53
Expenses 2680.95 2628.7 2934.58 2889.29 3071.69 3231.16 3597.76 3283.78 3735.05 3603.01
Other Income 29.65 29.47 33.66 -209.14 21.44 19.37 30.64 29.55 33.69 23.95
Depreciation 93.62 95.29 95.53 105.96 104.51 101.68 98.17 98.66 101.7 107.36
Interest 54.04 51.69 51.88 43.59 35.58 36.97 37.19 44.83 37.01 32.78
Profit before tax 811.86 730.49 834.24 500 802.3 695.25 899.36 859.07 990.46 939.33
Tax 209.61 191.91 216.87 120.52 211.53 185.01 237.9 231.01 253.82 240.99
Net profit 602.25 538.58 617.37 379.48 590.77 510.24 661.46 628.06 736.64 698.34
Operating Profit 929.87 848 947.99 858.69 920.95 814.53 1004.08 973.01 1095.48 1055.52
BALANCE SHEET
Report Date 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 2272.33 2740.79 2721.42 3185.91 3324.17 3577.32 1822.45 1922.92 1849.96 2362.75
Borrowings 1189.49 19.57 17.73 33.15 35.14 35.14 188.94 147.49 266.46 270.52
Other Liabilities 2756.03 2962.72 3250.76 3494.98 3906.86 4379.2 5065.13 5732.9 6021.29 6249.05
Total 6314.27 5819.5 6086.33 6810.46 7362.59 8088.08 7172.94 7899.73 8234.13 8978.74
Net Block 3369.31 3176.64 2897.85 2730.14 2616.18 2400.62 2341.45 2179.41 2994.67 3043.7
Capital Work in Progress 294.71 244.78 230.79 188.17 94.16 105.2 143.3 638.58 246.23 358.36
Investments 851.08 811.82 1324.92 1755.66 1978.87 2658.49 1751.05 1463.77 773.98 777.54
Other Assets 1799.17 1586.26 1632.77 2136.49 2673.38 2923.77 2937.14 3617.97 4219.25 4799.14
Total 6314.27 5819.5 6086.33 6810.46 7362.59 8088.08 7172.94 7899.73 8234.13 8978.74
Receivables 84.27 99.1 78.42 97.93 88.97 124.59 124.33 164.93 165.97 191.89
Inventory 735.93 844.1 820.81 940.06 902.47 965.55 1283.07 1416.48 1592.65 1928.77
Cash & Bank 749.36 445.82 499.55 880 1457.42 1610.06 1308.05 1769.87 735.41 945.55
No. of Equity Shares 96415716 96415716 96415716 96415716 96415716 96415716 96415716 96415716 96415716 96415716
New Bonus Shares
Face value 10 10 10 10 10 10 10 10 10 10
Other Assets 229.61 197.24 233.99 218.50 224.52 223.57 221.69 266.69 1,725.22 1,732.93
Total Assets 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
CASH FLOW:
Report Date Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22
Cash from Operating Activity 1796.4 1644.02 1098.1 1465.91 1817.79 2052.45 2295.25 2454.48 2236 2737.43
Cash from Investing Activity -440.94 -431.7 -70.48 -125.9 -130.56 -52.41 82.99 -321.46 -1920.33 -391.73
Cash from Financing Activity -580.12 -1635.28 -498.32 -665.61 -996.62 -1317.42 -3601.53 -1955.89 -2019.97 -2122.74
Net Cash Flow 775.34 -422.96 529.3 674.4 690.61 682.62 -1223.29 177.13 -1704.3 222.96
PRICE: 5289.25 6384.85 5828 6028.35 7870.9 11084.85 14785.35 18390.25 19705.7 19606
DERIVED:
Adjusted Equity Shares in Cr 9.64 9.64 9.64 9.64 9.64 9.64 9.64 9.64 9.64 9.64