[go: up one dir, main page]

0% found this document useful (0 votes)
5 views17 pages

TATA MO 3statement

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 17

Historical Financial Statement - TATA M

Year Mar-14 Mar-15 Mar-16 Mar-17


# Income Statement
Sales ₹ 232,833.7 ₹ 263,159.0 ₹ 273,045.6 ₹ 269,692.5
Sales Growth - 13.02% 3.76% -1.23%

COGG ₹ 180,131.06 ₹ 202,856.88 ₹ 205,509.07 ₹ 205,454.24


COGS % of Sales 77.36% 77.09% 75.27% 76.18%

Gross Profit ₹ 52,702.60 ₹ 60,302.10 ₹ 67,536.53 ₹ 64,238.27


Gross Margin 22.64% 22.91% 24.73% 23.82%

Selling & Genral Expanses ₹ 17,849.24 ₹ 21,063.45 ₹ 29,141.28 ₹ 34,649.58


S & G Expanses % of Sales 7.67% 8.00% 10.67% 12.85%

EBITDA ₹ 34,853.36 ₹ 39,238.65 ₹ 38,395.25 ₹ 29,588.69


EBITDA Margin 14.97% 14.91% 14.06% 10.97%

Intrest ₹ 4,749.44 ₹ 4,861.49 ₹ 4,889.08 ₹ 4,238.01


Intrest % of Sales 2.04% 1.85% 1.79% 1.57%

Depriciation ₹ 11,078.16 ₹ 13,388.63 ₹ 16,710.78 ₹ 17,904.99


Depriciation % Sales 4.76% 5.09% 6.12% 6.64%

Earning Before Tax 19025.76 20988.53 16795.39 7445.69


EBT % Sales 8.17% 7.98% 6.15% 2.76%

Tax ₹ 4,764.79 ₹ 7,642.91 ₹ 3,025.05 ₹ 3,251.23


Tax % EBT 25.04% 36.41% 18.01% 43.67%

Net Profit 14260.97 13345.62 13770.34 4194.46


Net Margins 6.12% 5.07% 5.04% 1.56%

No of Equity Shares 288.74 288.74 288.72 288.73

Earning Per Share ₹ 49.39 ₹ 46.22 ₹ 47.69 ₹ 14.53


EPS Growth -6.42% 3.19% -69.54%

Dividend Per Share ₹ 2.23 - ₹ 0.24 -


Dividend Payout Ratio 4.51% 0.00% 0.49% 0.00%

Retained Earnings 95.49% 100.00% 99.51% 100.00%

# Balance sheet
Equity Share Capital ₹ 643.78 ₹ 643.78 ₹ 679.18 ₹ 679.22
Reserves ₹ 64,959.67 ₹ 55,618.14 ₹ 78,273.23 ₹ 57,382.67
Borrowings ₹ 60,642.28 ₹ 73,610.39 ₹ 69,359.96 ₹ 78,603.98
Other Liabilities ₹ 92,180.26 ₹ 107,442.48 ₹ 114,871.75 ₹ 135,914.49
Total Liabilities 218425.99 237314.79 263184.12 272580.36

Fixed Assests Net Block ₹ 69,091.67 ₹ 88,479.49 ₹ 107,231.76 ₹ 95,944.08


Capital Work in Progress ₹ 33,262.56 ₹ 28,640.09 ₹ 25,918.94 ₹ 33,698.84
Investments ₹ 10,686.67 ₹ 15,336.74 ₹ 23,767.02 ₹ 20,337.92
Other Assets ₹ 37,828.18 ₹ 30,891.17 ₹ 29,579.36 ₹ 37,360.78
Total Non Current Assets 150869.08 163347.49 186497.08 187341.62

Receivables ₹ 10,574.23 ₹ 12,579.20 ₹ 13,570.91 ₹ 14,075.55


Inventory ₹ 27,270.89 ₹ 29,272.34 ₹ 32,655.73 ₹ 35,085.31
Cash & Bank ₹ 29,711.79 ₹ 32,115.76 ₹ 30,460.40 ₹ 36,077.88
Total Current Assets 67556.91 73967.3 76687.04 85238.74

Total Assets ₹ 218,425.99 ₹ 237,314.79 ₹ 263,184.12 ₹ 272,580.36

Check 1 TRUE TRUE TRUE

# Cash Flow Statement


Operating Activities
Profit from operations ₹ 36,303.00 ₹ 43,397.00 ₹ 38,626.00 ₹ 28,840.00
Receivables ₹ 445.00 ₹ (3,179.00) ₹ (2,223.00) ₹ (4,152.00)
Inventory ₹ (2,853.00) ₹ (3,692.00) ₹ (5,743.00) ₹ (6,621.00)
Payables ₹ 4,694.00 ₹ 3,598.00 ₹ 3,947.00 ₹ 9,301.00
Loans Advances - - ₹ (520.00) -
Other WC items ₹ 1,870.00 ₹ (398.00) ₹ 5,852.00 ₹ 4,727.00
Working capital changes ₹ 4,157.00 ₹ (3,672.00) ₹ 1,313.00 ₹ 3,254.00
Direct taxes ₹ (4,308.00) ₹ (4,194.00) ₹ (2,040.00) ₹ (1,895.00)
Cash from Operating Activity ₹ 40,308.00 ₹ 31,860.00 ₹ 39,212.00 ₹ 33,454.00

Investing Activities
Fixed assets purchased ₹ (26,975.00) ₹ (31,962.00) ₹ (31,503.00) ₹ (16,072.00)
Fixed assets sold ₹ 50.00 ₹ 74.00 ₹ 59.00 ₹ 53.00
Investments purchased ₹ (429.00) ₹ (5,461.00) ₹ (4,728.00) ₹ (6.00)
Investments sold ₹ 4.00 ₹ 42.00 ₹ 89.00 ₹ 1,965.00
Interest received ₹ 653.00 ₹ 698.00 ₹ 731.00 ₹ 638.00
Dividends received ₹ 40.00 ₹ 80.00 ₹ 58.00 ₹ 620.00
Invest in subsidiaries - - - -
Investment in group cos - ₹ (160.00) - ₹ (107.00)
Redemp n Canc of Shares - - - -
Acquisition of companies ₹ (185.00) - ₹ (111.00) -
Inter corporate deposits - - - -
Other investing items ₹ (1,149.00) ₹ 456.00 ₹ (1,289.00) ₹ (26,663.00)
Cash From Investing Activities ₹ (27,991.00) ₹ (36,233.00) ₹ (36,694.00) ₹ (39,572.00)

Financing Activity
Proceeds from shares - - ₹ 7,433.00 ₹ 5.00
Redemption of debentures ₹ (658.00) ₹ (744.00) - -
Proceeds from borrowings ₹ 33,258.00 ₹ 36,363.00 ₹ 19,519.00 ₹ 33,390.00
Repayment of borrowings ₹ (29,141.00) ₹ (23,332.00) ₹ (24,924.00) ₹ (21,732.00)
Interest paid fin ₹ (6,171.00) ₹ (6,307.00) ₹ (5,716.00) ₹ (5,336.00)
Dividends paid ₹ (722.00) ₹ (720.00) ₹ (108.00) ₹ (121.00)
Financial liabilities - - - -
Other financing items ₹ (450.00) ₹ (57.00) - -
Cash From Financing Activity ₹ (3,884.00) ₹ 5,203.00 ₹ (3,796.00) ₹ 6,206.00

Net Cash Flow ₹ 8,433.00 ₹ 830.00 ₹ (1,278.00) ₹ 88.00


rical Financial Statement - TATA MOTORS LTD
Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

₹ 291,550.5 ₹ 301,938.4 ₹ 261,068.0 ₹ 249,794.8 ₹ 278,453.6 ₹ 345,967.0


8.10% 3.56% -13.54% -4.32% 11.47% 24.25%

₹ 228,429.83 ₹ 242,845.53 ₹ 210,376.07 ₹ 195,326.04 ₹ 223,300.01 ₹ 274,403.64


78.35% 80.43% 80.58% 78.19% 80.19% 79.31%

₹ 63,120.65 ₹ 59,092.87 ₹ 50,691.90 ₹ 54,468.71 ₹ 55,153.61 ₹ 71,563.33


21.65% 19.57% 19.42% 21.81% 19.81% 20.69%

₹ 31,662.97 ₹ 34,428.54 ₹ 32,704.83 ₹ 22,181.28 ₹ 30,433.52 ₹ 39,747.53


10.86% 11.40% 12.53% 8.88% 10.93% 11.49%

₹ 31,457.68 ₹ 24,664.33 ₹ 17,987.07 ₹ 32,287.43 ₹ 24,720.09 ₹ 31,815.80


10.79% 8.17% 6.89% 12.93% 8.88% 9.20%

₹ 4,681.79 ₹ 5,758.60 ₹ 7,243.33 ₹ 8,097.17 ₹ 9,311.86 ₹ 10,225.48


1.61% 1.91% 2.77% 3.24% 3.34% 2.96%

₹ 21,553.59 ₹ 23,590.63 ₹ 21,425.43 ₹ 23,546.71 ₹ 24,835.69 ₹ 24,860.36


7.39% 7.81% 8.21% 9.43% 8.92% 7.19%

5222.3 -4684.9 -10681.69 643.55 -9427.46 -3270.04


1.79% -1.55% -4.09% 0.26% -3.39% -0.95%

₹ 4,341.93 ₹ (2,437.45) ₹ 395.25 ₹ 2,541.86 ₹ 4,231.29 ₹ 704.06


83.14% 52.03% -3.70% 394.97% -44.88% -21.53%

880.37 -2247.45 -11076.94 -1898.31 -13658.75 -3974.1


0.30% -0.74% -4.24% -0.76% -4.91% -1.15%

288.73 288.73 308.9 332.03 332.07 332.13

₹ 3.05 ₹ (7.78) ₹ (35.86) ₹ (5.72) ₹ (41.13) ₹ (11.97)


-79.01% -355.28% 360.68% -84.06% 619.43% -70.91%

- - - - - ₹ 2.31
0.00% 0.00% 0.00% 0.00% 0.00% -19.28%

100.00% 0.00% 0.00% 0.00% 0.00% 0.00%

₹ 679.22 ₹ 679.22 ₹ 719.54 ₹ 765.81 ₹ 765.88 ₹ 766.02


₹ 94,748.69 ₹ 59,500.34 ₹ 61,491.49 ₹ 54,480.91 ₹ 43,795.36 ₹ 44,555.77
₹ 88,950.47 ₹ 106,175.34 ₹ 124,787.64 ₹ 142,130.57 ₹ 146,449.03 ₹ 134,113.44
₹ 142,813.43 ₹ 139,348.59 ₹ 133,180.72 ₹ 144,192.62 ₹ 138,051.22 ₹ 155,239.20
327191.81 305703.49 320179.39 341569.91 329061.49 334674.43

₹ 121,413.86 ₹ 111,234.47 ₹ 127,107.14 ₹ 138,707.61 ₹ 138,855.45 ₹ 132,079.76


₹ 40,033.50 ₹ 31,883.84 ₹ 35,622.29 ₹ 20,963.93 ₹ 10,251.09 ₹ 14,274.50
₹ 20,812.75 ₹ 15,770.72 ₹ 16,308.48 ₹ 24,620.28 ₹ 29,379.53 ₹ 26,379.16
₹ 48,286.86 ₹ 56,155.74 ₹ 58,784.94 ₹ 61,717.96 ₹ 62,223.77 ₹ 68,432.09
230546.97 215044.77 237822.85 246009.78 240709.84 241165.51

₹ 19,893.30 ₹ 18,996.17 ₹ 11,172.69 ₹ 12,679.08 ₹ 12,442.12 ₹ 15,737.97


₹ 42,137.63 ₹ 39,013.73 ₹ 37,456.88 ₹ 36,088.59 ₹ 35,240.34 ₹ 40,755.39
₹ 34,613.91 ₹ 32,648.82 ₹ 33,726.97 ₹ 46,792.46 ₹ 40,669.19 ₹ 37,015.56
96644.84 90658.72 82356.54 95560.13 88351.65 93508.92

₹ 327,191.81 ₹ 305,703.49 ₹ 320,179.39 ₹ 341,569.91 ₹ 329,061.49 ₹ 334,674.43

TRUE TRUE TRUE TRUE TRUE TRUE

₹ 33,312.00 ₹ 28,771.00 ₹ 23,352.00 ₹ 31,198.00 ₹ 26,943.00 ₹ 41,694.00


₹ (10,688.00) ₹ (9,109.00) ₹ 9,950.00 ₹ (5,505.00) ₹ 185.00 ₹ (2,213.00)
₹ (3,560.00) ₹ 2,069.00 ₹ 2,326.00 ₹ 3,814.00 ₹ 472.00 ₹ (5,665.00)
₹ 7,320.00 ₹ (4,692.00) ₹ (8,085.00) ₹ 5,748.00 ₹ (7,012.00) ₹ 6,945.00
- - - - - -
₹ 494.00 ₹ 4,512.00 ₹ 875.00 ₹ (4,150.00) ₹ (4,396.00) ₹ (2,194.00)
₹ (6,434.00) ₹ (7,221.00) ₹ 5,065.00 ₹ (93.00) ₹ (10,750.00) ₹ (3,127.00)
₹ (3,021.00) ₹ (2,659.00) ₹ (1,785.00) ₹ (2,105.00) ₹ (1,910.00) ₹ (3,179.00)
₹ 17,423.00 ₹ 11,671.00 ₹ 31,698.00 ₹ 28,907.00 ₹ 3,532.00 ₹ 32,261.00

₹ (35,079.00) ₹ (35,304.00) ₹ (29,702.00) ₹ (20,205.00) ₹ (15,168.00) ₹ (19,230.00)


₹ 30.00 ₹ 67.00 ₹ 171.00 ₹ 351.00 ₹ 230.00 ₹ 285.00
₹ (329.00) ₹ (130.00) ₹ (1,439.00) ₹ (7,530.00) ₹ (3,008.00) ₹ (50.00)
₹ 2,381.00 ₹ 5,644.00 ₹ 21.00 ₹ 226.00 ₹ 104.00 ₹ 6,895.00
₹ 690.00 ₹ 761.00 ₹ 1,104.00 ₹ 428.00 ₹ 653.00 ₹ 973.00
₹ 1,797.00 ₹ 232.00 ₹ 21.00 ₹ 18.00 ₹ 32.00 ₹ 46.00
- - - - - -
₹ (4.00) ₹ (9.00) ₹ (606.00) ₹ (10.00) - -
₹ 14.00 ₹ 533.00 - - - ₹ 19.00
- ₹ (8.00) ₹ (27.00) - ₹ (98.00) -
- - - - - -
₹ 5,360.00 ₹ 7,335.00 ₹ (2,659.00) ₹ 1,051.00 ₹ 12,813.00 ₹ (4,357.00)
₹ (25,140.00) ₹ (20,879.00) ₹ (33,116.00) ₹ (25,671.00) ₹ (4,442.00) ₹ (15,419.00)

- - ₹ 3,889.00 ₹ 2,603.00 ₹ 19.00 ₹ 20.00


- - - - - -
₹ 37,482.00 ₹ 51,128.00 ₹ 38,297.00 ₹ 46,641.00 ₹ 46,578.00 ₹ 43,934.00
₹ (29,964.00) ₹ (35,198.00) ₹ (29,847.00) ₹ (29,709.00) ₹ (42,816.00) ₹ (62,557.00)
₹ (5,411.00) ₹ (7,005.00) ₹ (7,518.00) ₹ (8,123.00) ₹ (9,251.00) ₹ (9,336.00)
₹ (96.00) ₹ (95.00) ₹ (57.00) ₹ (30.00) ₹ (100.00) ₹ (141.00)
- - ₹ (1,346.00) ₹ (1,477.00) ₹ (1,559.00) ₹ (1,517.00)
- - ₹ (29.00) - ₹ 3,750.00 ₹ 3,355.00
₹ 2,011.00 ₹ 8,830.00 ₹ 3,389.00 ₹ 9,905.00 ₹ (3,379.00) ₹ (26,242.00)

₹ (5,706.00) ₹ (378.00) ₹ 1,971.00 ₹ 13,141.00 ₹ (4,289.00) ₹ (9,400.00)


LTM

₹ 423,873.8
22.52%

₹ 368,356.38
86.90%

₹ 55,517.43
13.10%

₹ 0.00
0.00%

₹ 10,393.66
2.45%

₹ 27,169.80
6.41%

-37563.46
-8.86%

₹ 3,686.99
-9.82%

-41250.45
-9.73%

0
Ratio Analysis - TATA MOTORS LTD
Year Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19

Sales Growth 13.02% 3.76% -1.23% 8.10% 3.56%


EBITDA Growth 12.58% -2.15% -22.94% 6.32% -21.60%
EBIT Growth 10.32% -19.98% -55.67% -29.86% -189.71%
Net Profit Growth -6.42% 3.18% -69.54% -79.01% -355.28%
Dividend Growth -100.00% 0.00% -100.00% 0.00% 0.00%

Gross Margin 22.64% 22.91% 24.73% 23.82% 21.65% 19.57%


EBITDA Margin 14.97% 14.91% 14.06% 10.97% 10.79% 8.17%
EBIT Margin 14.97% 0.00% 10.00% 6.01% 5.06% 2.24%
EBT Margin 8.17% 7.98% 6.15% 2.76% 1.79% -1.55%
Net Profit Margin 6.12% 5.07% 5.04% 1.56% 0.30% -0.74%

Sales Expenses%Sales 7.67% 8.00% 10.67% 12.85% 10.86% 11.40%


Depriciation % Sales 4.76% 5.09% 6.12% 6.64% 7.39% 7.81%
Operating Income % Sales 14.97% 0.00% 10.00% 6.01% 5.06% 2.24%

Return on Capital Employed 18.83% 19.90% 14.62% 8.55% 5.37% 0.65%


Retained Earning 95.49% 100.00% 99.51% 100.00% 100.00% 0.00%
Return On Equity 21.74% 23.72% 17.44% 7.22% 0.92% -3.73%
Self Sustained Growth Rate 20.76% 23.72% 17.36% 7.22% 0.92% 0.00%
Interest Coverage Ratio 5.01x 5.32x 4.44x 2.76x 2.12x 0.19x

Debtor Turnover Ratio 22.02x 20.92x 20.12x 19.16x 14.66x 15.89x


Creditor Turnover Ratio 2.53x 2.45x 2.38x 1.98x 2.04x 2.17x
Inventory Turnover 8.54x 8.99x 8.36x 7.69x 6.92x 7.74x
Fixed Assets Turnover 3.37x 2.97x 2.55x 2.81x 2.40x 2.71x
Capital Turnover 3.55x 4.68x 3.46x 4.64x 3.06x 5.02x

In days
Debtor Days 17 17 18 19 25 23
Payable Days 145 149 154 184 179 168
Inventory Days 43 41 44 47 53 47
Cash Conversion Cycle -85 -91 -92 -117 -101 -98

CFO/sales 17.31% 12.11% 14.36% 12.40% 5.98% 3.87%


CFO/total assets 18.45% 13.43% 14.90% 12.27% 5.33% 3.82%
CFO/ total Debt 66.47% 43.28% 56.53% 42.56% 19.59% 10.99%
- TATA MOTORS LTD
Mar-20 Mar-21 Mar-22 Mar-23 Trend Mean Median

-13.54% -4.32% 11.47% 24.25% 5.01% 3.76%


-27.07% 79.50% -23.44% 28.70% 3.32% -2.15%
128.00% -106.02% -1564.91% -65.31% -210.35% -55.67%
392.87% -82.86% 619.52% -70.90% 39.06% -69.54%
0.00% 0.00% 0.00% 0.00% -22.22% 0.00%

19.42% 21.81% 19.81% 20.69% 21.70% 21.73%


6.89% 12.93% 8.88% 9.20% 11.18% 10.88%
-1.37% 3.48% 1.18% 2.39% 4.40% 2.94%
-4.09% 0.26% -3.39% -0.95% 1.71% 1.02%
-4.24% -0.76% -4.91% -1.15% 0.63% -0.22%

12.53% 8.88% 10.93% 11.49% 10.53% 10.89%


8.21% 9.43% 8.92% 7.19% 7.15% 7.29%
-1.37% 3.48% 1.18% 2.39% 4.40% 2.94%

-1.84% 4.43% -0.06% 3.88% 7.43% 4.90%


0.00% 0.00% 0.00% 0.00% 49.50% 47.74%
-17.81% -3.44% -30.65% -8.77% 0.67% -1.26%
0.00% 0.00% 0.00% 0.00% 7.00% 0.46%
-0.47x 1.08x -0.01x 0.68x 210.90% 159.75%

23.37x 19.70x 22.38x 21.98x 20.02x 20.52x


1.96x 1.73x 2.02x 2.23x 2.15x 2.10x
6.97x 6.92x 7.90x 8.49x 7.85x 7.82x
2.05x 1.80x 2.01x 2.62x 2.53x 2.58x
4.20x 4.52x 6.25x 7.63x 4.70x 4.58x

16 19 16 17 19 18
186 211 181 164 172 174
52 53 46 43 47 47
-118 -139 -118 -104 -107 -103

12.14% 11.57% 1.27% 9.32% 10.03% 11.84%


9.90% 8.46% 1.07% 9.64% 9.73% 9.77%
25.40% 20.34% 2.41% 24.06% 31.16% 24.73%
COMPANY NAME TATA MOTORS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 365.95
Face Value 2
Current Price 911.6
Market Capitalization 333597.78

PROFIT & LOSS


Report Date Mar-14 Mar-15 Mar-16 Mar-17
Sales 232833.66 263158.98 273045.6 269692.51
Raw Material Cost 146426.99 163250.36 166134.01 173294.08
Change in Inventory 2840.58 3330.35 2750.99 7399.92
Power and Fuel 1128.69 1121.75 1143.63 1159.82
Other Mfr. Exp 13806.04 16173.17 12101.53 10067.37
Employee Cost 21609.92 25641.95 28880.89 28332.89
Selling and admin 22357.79 23603.01 21991.9 30039.38
Other Expenses -4508.55 -2539.56 7149.38 4610.2
Other Income -156.79 714.03 -2669.62 1869.1
Depreciation 11078.16 13388.63 16710.78 17904.99
Interest 4749.44 4861.49 4889.08 4238.01
Profit before tax 18868.97 21702.56 14125.77 9314.79
Tax 4764.79 7642.91 3025.05 3251.23
Net profit 13991.02 13986.29 11579.31 7454.36
Dividend Amount 643.78 67.92

Quarters
Report Date Sep-21 Dec-21 Mar-22 Jun-22
Sales 61378.82 72229.29 78439.06 71934.66
Expenses 57262.21 65151.27 70156.27 69521.93
Other Income 862.46 788.73 188.74 2380.98
Depreciation 6123.32 6078.13 6432.11 5841.04
Interest 2327.3 2400.74 2380.52 2420.72
Profit before tax -3471.55 -612.12 -341.1 -3468.05
Tax 1005.06 726.05 758.22 1518.96
Net profit -4441.57 -1516.14 -1032.84 -5006.6
Operating Profit 4116.61 7078.02 8282.79 2412.73
BALANCE SHEET
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Equity Share Capital 643.78 643.78 679.18 679.22
Reserves 64959.67 55618.14 78273.23 57382.67
Borrowings 60642.28 73610.39 69359.96 78603.98
Other Liabilities 92180.26 107442.48 114871.75 135914.49
Total 218425.99 237314.79 263184.12 272580.36
Net Block 69091.67 88479.49 107231.76 95944.08
Capital Work in Progress 33262.56 28640.09 25918.94 33698.84
Investments 10686.67 15336.74 23767.02 20337.92
Other Assets 105385.09 104858.47 106266.4 122599.52
Total 218425.99 237314.79 263184.12 272580.36
Receivables 10574.23 12579.2 13570.91 14075.55
Inventory 27270.89 29272.34 32655.73 35085.31
Cash & Bank 29711.79 32115.76 30460.4 36077.88
No. of Equity Shares 3218930000 3218930067 3395930306 3396100719
New Bonus Shares
Face value 2 2 2 2

CASH FLOW:
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Cash from Operating Activity 36151.16 35531.26 37899.54 30199.25
Cash from Investing Activity -27990.91 -36232.35 -36693.9 -39571.4
Cash from Financing Activity -3883.24 5201.44 -3795.12 6205.3
Net Cash Flow 4277.01 4500.35 -2589.48 -3166.85

PRICE: 394.42 544.37 386.6 465.85

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

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


291550.48 301938.4 261067.97 249794.75 278453.62 345966.97
187896.58 194267.91 164899.82 153607.36 179295.33 231251.26
2046.58 -2053.28 -2231.19 -4684.16 -1590.49 4781.62
1308.08 1585.93 1264.95 1112.87 2178.29 2513.33
10971.66 11694.54 11541.51 8273.17 9427.38 11765.97
30300.09 33243.87 30438.6 27648.48 30808.52 33654.7
31004.58 32719.8 29248.32 23015.79 29205.4 34839.19
658.39 1708.74 3456.51 -834.51 1228.12 4908.34
5932.73 -26686.25 101.71 -11117.83 2424.05 6327.59
21553.59 23590.63 21425.43 23546.71 24835.69 24860.36
4681.79 5758.6 7243.33 8097.17 9311.86 10225.48
11155.03 -31371.15 -10579.98 -10474.28 -7003.41 3057.55
4341.93 -2437.45 395.25 2541.86 4231.29 704.06
8988.91 -28826.23 -12070.85 -13451.39 -11441.47 2414.29
766.02

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


79611.37 88488.59 105932.35 102236.08 105128.24 110577.14
74039.06 77668.35 92817.95 89018.36 91361.3 95158.77
1351.14 1129.98 1361.61 683.56 1507.05 1410.5
5897.34 6071.78 7050.2 6633.18 6636.42 6850
2487.26 2675.83 2641.67 2615.39 2651.69 2484.91
-1461.15 3202.61 4784.14 4652.71 5985.88 7493.96
-457.08 262.83 -620.65 1563.01 2202.84 541.79
-944.61 2957.71 5407.79 3202.8 3764 7025.11
5572.31 10820.24 13114.4 13217.72 13766.94 15418.37
Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
679.22 679.22 719.54 765.81 765.88 766.02
94748.69 59500.34 61491.49 54480.91 43795.36 44555.77
88950.47 106175.34 124787.64 142130.57 146449.03 134113.44
142813.43 139348.59 133180.72 144192.62 138051.22 155239.2
327191.81 305703.49 320179.39 341569.91 329061.49 334674.43
121413.86 111234.47 127107.14 138707.61 138855.45 132079.76
40033.5 31883.84 35622.29 20963.93 10251.09 14274.5
20812.75 15770.72 16308.48 24620.28 29379.53 26379.16
144931.7 146814.46 141141.48 157278.09 150575.42 161941.01
327191.81 305703.49 320179.39 341569.91 329061.49 334674.43
19893.3 18996.17 11172.69 12679.08 12442.12 15737.97
42137.63 39013.73 37456.88 36088.59 35240.34 40755.39
34613.91 32648.82 33726.97 46792.46 40669.19 37015.56
3396100719 3396100719 3597726185 3829060661 3829414903 3830097221

2 2 2 2 2 2

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


23857.42 18890.75 26632.94 29000.51 14282.83 35388.01
-25139.14 -20878.07 -33114.55 -25672.5 -4443.66 -15417.17
2011.71 8830.37 3389.61 9904.2 -3380.17 -26242.9
729.99 6843.05 -3092 13232.21 6459 -6272.06

326.85 174.25 71.05 301.8 433.75 420.8

288.73 288.73 308.90 332.03 332.07 332.13


-
Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17
Cash from Operating Activity - 18,384 22,163 36,151 35,531 37,900 30,199
Profit from operations 22,432 24,406 36,303 43,397 38,626 28,840
Receivables -6,659 -5,177 445 -3,179 -2,223 -4,152
Inventory -2,719 -2,656 -2,853 -3,692 -5,743 -6,621
Payables 5,867 8,132 4,694 3,598 3,947 9,301
Loans Advances 0 0 0 0 -520 0
Other WC items 1,231 -303 1,870 -398 5,852 4,727
Working capital changes -2,280 -3 4,157 -3,672 1,313 3,254
Direct taxes -1,768 -2,240 -4,308 -4,194 -2,040 -1,895
Cash from Investing Activity - -19,464 -22,969 -27,991 -36,232 -36,694 -39,571
Fixed assets purchased -13,876 -18,863 -26,975 -31,962 -31,503 -16,072
Fixed assets sold 93 37 50 74 59 53
Investments purchased -5,857 73 -429 -5,461 -4,728 -6
Investments sold 84 34 4 42 89 1,965
Interest received 467 713 653 698 731 638
Dividends received 70 95 40 80 58 620
Invest in subsidiaries -304 0 0 0 0 0
Investment in group cos -9 0 0 -160 0 -107
Redemp n Canc of Shares 0 0 0 0 0 0
Acquisition of companies 0 0 -185 0 -111 0
Inter corporate deposits -3 45 0 0 0 0
Other investing items -129 -5,103 -1,149 456 -1,289 -26,663
Cash from Financing Activity - 6,567 -1,692 -3,883 5,201 -3,795 6,205
Proceeds from shares 139 1 0 0 7,433 5
Redemption of debentures 0 -97 -658 -744 0 0
Proceeds from borrowings 27,462 27,863 33,258 36,363 19,519 33,390
Repayment of borrowings -15,010 -20,395 -29,141 -23,332 -24,924 -21,732
Interest paid fin -3,374 -4,666 -6,171 -6,307 -5,716 -5,336
Dividends paid -1,503 -1,551 -722 -720 -108 -121
Financial liabilities 0 0 0 0 0 0
Other financing items -1,147 -2,849 -450 -57 0 0
Net Cash Flow 5,488 -2,499 4,277 4,500 -2,589 -3,167
Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
23,857 18,891 26,633 29,001 14,283 35,388
33,312 28,771 23,352 31,198 26,943 41,694
-10,688 -9,109 9,950 -5,505 185 -2,213
-3,560 2,069 2,326 3,814 472 -5,665
7,320 -4,692 -8,085 5,748 -7,012 6,945
0 0 0 0 0 0
494 4,512 875 -4,150 -4,396 -2,194
-6,434 -7,221 5,065 -93 -10,750 -3,127
-3,021 -2,659 -1,785 -2,105 -1,910 -3,179
-25,139 -20,878 -33,115 -25,672 -4,444 -15,417
-35,079 -35,304 -29,702 -20,205 -15,168 -19,230
30 67 171 351 230 285
-329 -130 -1,439 -7,530 -3,008 -50
2,381 5,644 21 226 104 6,895
690 761 1,104 428 653 973
1,797 232 21 18 32 46
0 0 0 0 0 0
-4 -9 -606 -10 0 0
14 533 0 0 0 19
0 -8 -27 0 -98 0
0 0 0 0 0 0
5,360 7,335 -2,659 1,051 12,813 -4,357
2,012 8,830 3,390 9,904 -3,380 -26,243
0 0 3,889 2,603 19 20
0 0 0 0 0 0
37,482 51,128 38,297 46,641 46,578 43,934
-29,964 -35,198 -29,847 -29,709 -42,816 -62,557
-5,411 -7,005 -7,518 -8,123 -9,251 -9,336
-96 -95 -57 -30 -100 -141
0 0 -1,346 -1,477 -1,559 -1,517
0 0 -29 0 3,750 3,355
730 6,843 -3,092 13,232 6,459 -6,272

You might also like