TATA MOTORS 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 232,833.66 263,158.98 273,045.60 269,692.51 291,550.48 301,938.40 261,067.97 249,794.75 278,453.62 345,966.97 423,873.81 429,849.48 360,545.33
Expenses 197,980.30 223,920.33 234,650.35 240,103.82 260,092.80 277,274.07 243,080.90 217,507.32 253,733.53 314,151.17 368,356.38 373,549.38 327,563.22
Operating Profit 34,853.36 39,238.65 38,395.25 29,588.69 31,457.68 24,664.33 17,987.07 32,287.43 24,720.09 31,815.80 55,517.43 56,300.10 32,982.10
Other Income -156.79 714.03 -2,669.62 1,869.10 5,932.73 -26,686.25 101.71 -11,117.83 2,424.05 6,327.59 4,962.72 - -
Depreciation 11,078.16 13,388.63 16,710.78 17,904.99 21,553.59 23,590.63 21,425.43 23,546.71 24,835.69 24,860.36 27,169.80 27,169.80 27,169.80
Interest 4,749.44 4,861.49 4,889.08 4,238.01 4,681.79 5,758.60 7,243.33 8,097.17 9,311.86 10,225.48 10,393.66 10,393.66 10,393.66
Profit before tax 18,868.97 21,702.56 14,125.77 9,314.79 11,155.03 -31,371.15 -10,579.98 -10,474.28 -7,003.41 3,057.55 22,916.69 18,736.64 -4,581.36
Tax 4,764.79 7,642.91 3,025.05 3,251.23 4,341.93 -2,437.45 395.25 2,541.86 4,231.29 704.06 3,686.99 16% 16%
Net profit 13,991.02 13,986.29 11,579.31 7,454.36 8,988.91 -28,826.23 -12,070.85 -13,451.39 -11,441.47 2,414.29 19,399.70 15,722.17 -3,844.28
EPS 48.46 48.44 40.11 25.82 31.13 -99.84 -39.08 -40.51 -34.45 7.27 52.89 42.86 -10.48
Price to earning 8.14 11.24 9.64 18.04 10.50 -1.75 -1.82 -7.45 -12.59 57.89 19.06 38.47 19.06
Price 394.42 544.37 386.60 465.85 326.85 174.25 71.05 301.80 433.75 420.80 1,007.90 1,649.08 -199.73

RATIOS:
Dividend Payout 4.60% 0.00% 0.59% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 31.73%
OPM 14.97% 14.91% 14.06% 10.97% 10.79% 8.17% 6.89% 12.93% 8.88% 9.20% 13.10%

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

Sales Growth 4.50% 3.44% 3.48% 9.84% 24.25% 24.25% 3.44%
OPM 11.02% 9.63% 9.15% 10.16% 13.10% 13.10% 9.15%
Price to Earning 19.22 26.37 38.47 38.47 19.06 38.47 19.06
TATA MOTORS LTD SCREENER.IN

Narration Sep-21 Dec-21 Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23
Sales 61,378.82 72,229.29 78,439.06 71,934.66 79,611.37 88,488.59 105,932.35 102,236.08 105,128.24 110,577.14
Expenses 57,262.21 65,151.27 70,156.27 69,521.93 74,039.06 77,668.35 92,817.95 89,018.36 91,361.30 95,158.77
Operating Profit 4,116.61 7,078.02 8,282.79 2,412.73 5,572.31 10,820.24 13,114.40 13,217.72 13,766.94 15,418.37
Other Income 862.46 788.73 188.74 2,380.98 1,351.14 1,129.98 1,361.61 683.56 1,507.05 1,410.50
Depreciation 6,123.32 6,078.13 6,432.11 5,841.04 5,897.34 6,071.78 7,050.20 6,633.18 6,636.42 6,850.00
Interest 2,327.30 2,400.74 2,380.52 2,420.72 2,487.26 2,675.83 2,641.67 2,615.39 2,651.69 2,484.91
Profit before tax -3,471.55 -612.12 -341.10 -3,468.05 -1,461.15 3,202.61 4,784.14 4,652.71 5,985.88 7,493.96
Tax 1,005.06 726.05 758.22 1,518.96 -457.08 262.83 -620.65 1,563.01 2,202.84 541.79
Net profit -4,441.57 -1,516.14 -1,032.84 -5,006.60 -944.61 2,957.71 5,407.79 3,202.80 3,764.00 7,025.11

OPM 7% 10% 11% 3% 7% 12% 12% 13% 13% 14%

TATA MOTORS LTD SCREENER.IN

Narration Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
Equity Share Capital 643.78 643.78 679.18 679.22 679.22 679.22 719.54 765.81 765.88 766.02
Reserves 64,959.67 55,618.14 78,273.23 57,382.67 94,748.69 59,500.34 61,491.49 54,480.91 43,795.36 44,555.77
Borrowings 60,642.28 73,610.39 69,359.96 78,603.98 88,950.47 106,175.34 124,787.64 142,130.57 146,449.03 134,113.44
Other Liabilities 92,180.26 107,442.48 114,871.75 135,914.49 142,813.43 139,348.59 133,180.72 144,192.62 138,051.22 155,239.20
Total 218,425.99 237,314.79 263,184.12 272,580.36 327,191.81 305,703.49 320,179.39 341,569.91 329,061.49 334,674.43

Net Block 69,091.67 88,479.49 107,231.76 95,944.08 121,413.86 111,234.47 127,107.14 138,707.61 138,855.45 132,079.76
Capital Work in Progress 33,262.56 28,640.09 25,918.94 33,698.84 40,033.50 31,883.84 35,622.29 20,963.93 10,251.09 14,274.50
Investments 10,686.67 15,336.74 23,767.02 20,337.92 20,812.75 15,770.72 16,308.48 24,620.28 29,379.53 26,379.16
Other Assets 105,385.09 104,858.47 106,266.40 122,599.52 144,931.70 146,814.46 141,141.48 157,278.09 150,575.42 161,941.01
Total 218,425.99 237,314.79 263,184.12 272,580.36 327,191.81 305,703.49 320,179.39 341,569.91 329,061.49 334,674.43

Working Capital 13,204.83 -2,584.01 -8,605.35 -13,314.97 2,118.27 7,465.87 7,960.76 13,085.47 12,524.20 6,701.81
Debtors 10,574.23 12,579.20 13,570.91 14,075.55 19,893.30 18,996.17 11,172.69 12,679.08 12,442.12 15,737.97
Inventory 27,270.89 29,272.34 32,655.73 35,085.31 42,137.63 39,013.73 37,456.88 36,088.59 35,240.34 40,755.39

Debtor Days 16.58 17.45 18.14 19.05 24.90 22.96 15.62 18.53 16.31 16.60
Inventory Turnover 8.54 8.99 8.36 7.69 6.92 7.74 6.97 6.92 7.90 8.49

Return on Equity 21% 25% 15% 13% 9% -48% -19% -24% -26% 5%
Return on Capital Emp 21% 14% 10% 10% -15% -2% -1% 1% 7%
TATA MOTORS LTD SCREENER.IN

Narration Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

Cash from Operating Activity - 36,151.00 35,531.00 37,900.00 30,199.00 23,857.00 18,891.00 26,633.00 29,001.00 14,283 35,388
Profit from operations 36,303.00 43,397.00 38,626.00 28,840.00 33,312.00 28,771.00 23,352.00 31,198.00 26,943 41,694
Receivables 445.00 -3,179.00 -2,223.00 -4,152.00 -10,688.00 -9,109.00 9,950.00 -5,505.00 185 -2,213
Inventory -2,853.00 -3,692.00 -5,743.00 -6,621.00 -3,560.00 2,069.00 2,326.00 3,814.00 472 -5,665
Payables 4,694.00 3,598.00 3,947.00 9,301.00 7,320.00 -4,692.00 -8,085.00 5,748.00 -7,012 6,945
Loans Advances 0 0 -520 0 0 0 0 0 0 0
Other WC items 1,870 -398 5,852 4,727 494 4,512 875 -4,150 -4,396 -2,194
Working capital changes 4,157 -3,672 1,313 3,254 -6,434 -7,221 5,065 -93 -10,750 -3,127
Direct taxes -4,308 -4,194 -2,040 -1,895 -3,021 -2,659 -1,785 -2,105 -1,910 -3,179
Cash from Investing Activity - -27,991 -36,232 -36,694 -39,571 -25,139 -20,878 -33,115 -25,672 -4,444 -15,417
Fixed assets purchased -26,975 -31,962 -31,503 -16,072 -35,079 -35,304 -29,702 -20,205 -15,168 -19,230
Fixed assets sold 50 74 59 53 30 67 171 351 230 285
Investments purchased -429 -5,461 -4,728 -6 -329 -130 -1,439 -7,530 -3,008 -50
Investments sold 4 42 89 1,965 2,381 5,644 21 226 104 6,895
Interest received 653 698 731 638 690 761 1,104 428 653 973
Dividends received 40 80 58 620 1,797 232 21 18 32 46
Invest in subsidiaries 0 0 0 0 0 0 0 0 0 0
Investment in group cos 0 -160 0 -107 -4 -9 -606 -10 0 0
Redemption and cancellation of shares 0 0 0 0 14 533 0 0 0 19
Acquisition of companies -185 0 -111 0 0 -8 -27 0 -98 0
Inter corporate deposits 0 0 0 0 0 0 0 0 0 0
Other investing items -1,149 456 -1,289 -26,663 5,360 7,335 -2,659 1,051 12,813 -4,357
Cash from Financing Activity - -3,883 5,201 -3,795 6,205 2,012 8,830 3,390 9,904 -3,380 -26,243
Proceeds from shares 0 0 7,433 5 0 0 3,889 2,603 19 20
Redemption of debentures -658 -744 0 0 0 0 0 0 0 0
Proceeds from borrowings 33,258 36,363 19,519 33,390 37,482 51,128 38,297 46,641 46,578 43,934
Repayment of borrowings -29,141 -23,332 -24,924 -21,732 -29,964 -35,198 -29,847 -29,709 -42,816 -62,557
Interest paid -6,171 -6,307 -5,716 -5,336 -5,411 -7,005 -7,518 -8,123 -9,251 -9,336
Dividends paid -722 -720 -108 -121 -96 -95 -57 -30 -100 -141
Financial liabilities 0 0 0 0 0 0 -1,346 -1,477 -1,559 -1,517
Other financing items -450 -57 0 0 0 0 -29 0 3,750 3,355
Net Cash Flow 4,277 4,500 -2,589 -3,167 730 6,843 -3,092 13,232 6,459 -6,272
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: [email protected]
COMPANY NAME TATA MOTORS LTD
LATEST VERSION 2.10 PLEASE D
CURRENT VERSION 2.10

META
Number of shares 366.79
Face Value 2.00
Current Price 1,007.90
Market Capitalization 369,692.26

PROFIT & LOSS

Report Date Mar-14 Mar-15 Mar-16 Mar-17
Sales 232,833.66 263,158.98 273,045.60 269,692.51
Raw Material Cost 146,426.99 163,250.36 166,134.01 173,294.08
Change in Inventory 2,840.58 3,330.35 2,750.99 7,399.92
Power and Fuel 1,128.69 1,121.75 1,143.63 1,159.82
Other Mfr. Exp 13,806.04 16,173.17 12,101.53 10,067.37
Employee Cost 21,609.92 25,641.95 28,880.89 28,332.89
Selling and admin 22,357.79 23,603.01 21,991.90 30,039.38
Other Expenses -4,508.55 -2,539.56 7,149.38 4,610.20
Other Income -156.79 714.03 -2,669.62 1,869.10
Depreciation 11,078.16 13,388.63 16,710.78 17,904.99
Interest 4,749.44 4,861.49 4,889.08 4,238.01
Profit before tax 18,868.97 21,702.56 14,125.77 9,314.79
Tax 4,764.79 7,642.91 3,025.05 3,251.23
Net profit 13,991.02 13,986.29 11,579.31 7,454.36
Dividend Amount 643.78 67.92

Quarters
Report Date Sep-21 Dec-21 Mar-22 Jun-22
Sales 61,378.82 72,229.29 78,439.06 71,934.66
Expenses 57,262.21 65,151.27 70,156.27 69,521.93
Other Income 862.46 788.73 188.74 2,380.98
Depreciation 6,123.32 6,078.13 6,432.11 5,841.04
Interest 2,327.30 2,400.74 2,380.52 2,420.72
Profit before tax -3,471.55 -612.12 -341.10 -3,468.05
Tax 1,005.06 726.05 758.22 1,518.96
Net profit -4,441.57 -1,516.14 -1,032.84 -5,006.60
Operating Profit 4,116.61 7,078.02 8,282.79 2,412.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 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 218,425.99 237,314.79 263,184.12 272,580.36
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 105,385.09 104,858.47 106,266.40 122,599.52
Total 218,425.99 237,314.79 263,184.12 272,580.36
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
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 2.00 2.00 2.00 2.00

CASH FLOW:
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Cash from Operating Activity 36,151.16 35,531.26 37,899.54 30,199.25
Cash from Investing Activity -27,990.91 -36,232.35 -36,693.90 -39,571.40
Cash from Financing Activity -3,883.24 5,201.44 -3,795.12 6,205.30
Net Cash Flow 4,277.01 4,500.35 -2,589.48 -3,166.85

PRICE: 394.42 544.37 386.60 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

291,550.48 301,938.40 261,067.97 249,794.75 278,453.62 345,966.97
187,896.58 194,267.91 164,899.82 153,607.36 179,295.33 231,251.26
2,046.58 -2,053.28 -2,231.19 -4,684.16 -1,590.49 4,781.62
1,308.08 1,585.93 1,264.95 1,112.87 2,178.29 2,513.33
10,971.66 11,694.54 11,541.51 8,273.17 9,427.38 11,765.97
30,300.09 33,243.87 30,438.60 27,648.48 30,808.52 33,654.70
31,004.58 32,719.80 29,248.32 23,015.79 29,205.40 34,839.19
658.39 1,708.74 3,456.51 -834.51 1,228.12 4,908.34
5,932.73 -26,686.25 101.71 -11,117.83 2,424.05 6,327.59
21,553.59 23,590.63 21,425.43 23,546.71 24,835.69 24,860.36
4,681.79 5,758.60 7,243.33 8,097.17 9,311.86 10,225.48
11,155.03 -31,371.15 -10,579.98 -10,474.28 -7,003.41 3,057.55
4,341.93 -2,437.45 395.25 2,541.86 4,231.29 704.06
8,988.91 -28,826.23 -12,070.85 -13,451.39 -11,441.47 2,414.29
766.02

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

79,611.37 88,488.59 105,932.35 102,236.08 105,128.24 110,577.14
74,039.06 77,668.35 92,817.95 89,018.36 91,361.30 95,158.77
1,351.14 1,129.98 1,361.61 683.56 1,507.05 1,410.50
5,897.34 6,071.78 7,050.20 6,633.18 6,636.42 6,850.00
2,487.26 2,675.83 2,641.67 2,615.39 2,651.69 2,484.91
-1,461.15 3,202.61 4,784.14 4,652.71 5,985.88 7,493.96
-457.08 262.83 -620.65 1,563.01 2,202.84 541.79
-944.61 2,957.71 5,407.79 3,202.80 3,764.00 7,025.11
5,572.31 10,820.24 13,114.40 13,217.72 13,766.94 15,418.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
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
327,191.81 305,703.49 320,179.39 341,569.91 329,061.49 334,674.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
144,931.70 146,814.46 141,141.48 157,278.09 150,575.42 161,941.01
327,191.81 305,703.49 320,179.39 341,569.91 329,061.49 334,674.43
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
### ### ### ### ### ###

2.00 2.00 2.00 2.00 2.00 2.00

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

23,857.42 18,890.75 26,632.94 29,000.51 14,282.83 35,388.01
-25,139.14 -20,878.07 -33,114.55 -25,672.50 -4,443.66 -15,417.17
2,011.71 8,830.37 3,389.61 9,904.20 -3,380.17 -26,242.90
729.99 6,843.05 -3,092.00 13,232.21 6,459.00 -6,272.06

326.85 174.25 71.05 301.80 433.75 420.80

288.73 288.73 308.90 332.03 332.07 332.13

 Historal Financial Statements - TATA MOTORS LTD
Years 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%

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

COGS % 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 & General Expenses ₹ 17,849.24 ₹ 21,063.45 ₹ 29,141.28 ₹ 34,649.58

S&G Exp % 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%

Interest ₹ 4,749.44 ₹ 4,861.49 ₹ 4,889.08 ₹ 4,238.01

Interest % Sales 2.04% 1.85% 1.79% 1.57%

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

Depreciation % Sales 6.15% 6.60% 8.13% 8.71%

Earnings Before Tax ₹ 19,025.76 ₹ 20,988.53 ₹ 16,795.39 ₹ 7,445.69

EBT % Sales 8.17% 7.98% 6.15% 2.76%

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

Effective Tax Rate 25.04% 36.41% 18.01% 43.67%

Net Profit ₹ 14,260.97 ₹ 13,345.62 ₹ 13,770.34 ₹ 4,194.46

Net Margin 6.12% 5.07% 5.04% 1.56%

No. of Equity Shares 288.74 288.74 288.72 288.73

EPS ₹ 49.39 ₹ 46.22 ₹ 47.69 ₹ 14.53

EPS Growth -6.42% 3.19% -69.54%

Dividend per share ₹ 2.23 ₹ 0.00 ₹ 0.24 ₹ 0.00

Divident 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.8 ₹ 643.8 ₹ 679.2 ₹ 679.2
Reserves ₹ 64,959.7 ₹ 55,618.1 ₹ 78,273.2 ₹ 57,382.7
Borrowings ₹ 60,642.3 ₹ 73,610.4 ₹ 69,360.0 ₹ 78,604.0
 Other Liabilities ₹ 92,180.3 ₹ 107,442.5 ₹ 114,871.8 ₹ 135,914.5
Total Liabilities ₹ 218,425.99 ₹ 237,314.79 ₹ 263,184.12 ₹ 272,580.36

Fixed Assets Net Block ₹ 69,091.7 ₹ 88,479.5 ₹ 107,231.8 ₹ 95,944.1

Capital Work in Progress ₹ 33,262.6 ₹ 28,640.1 ₹ 25,918.9 ₹ 33,698.8
Investments ₹ 10,686.7 ₹ 15,336.7 ₹ 23,767.0 ₹ 20,337.9
Other Assets ₹ 37,828.2 ₹ 30,891.2 ₹ 29,579.4 ₹ 37,360.8
Total Non-Current Assets ₹ 150,869.1 ₹ 163,347.5 ₹ 186,497.1 ₹ 187,341.6

Receivables ₹ 10,574.2 ₹ 12,579.2 ₹ 13,570.9 ₹ 14,075.6

Inventory ₹ 27,270.9 ₹ 29,272.3 ₹ 32,655.7 ₹ 35,085.3
Cash & Bank ₹ 29,711.8 ₹ 32,115.8 ₹ 30,460.4 ₹ 36,077.9
Total Current Assets ₹ 67,556.9 ₹ 73,967.3 ₹ 76,687.0 ₹ 85,238.7

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

Check 1 TRUE TRUE TRUE

# Cash Flow Statements

Operating Activities
Profit from operations ₹ 36,303.0 ₹ 43,397.0 ₹ 38,626.0 ₹ 28,840.0
Receivables ₹ 445.0 ₹ (3,179.0) ₹ (2,223.0) ₹ (4,152.0)
Inventory ₹ (2,853.0) ₹ (3,692.0) ₹ (5,743.0) ₹ (6,621.0)
Payables ₹ 4,694.0 ₹ 3,598.0 ₹ 3,947.0 ₹ 9,301.0
Loans Advances ₹ 0.0 ₹ 0.0 ₹ (520.0) ₹ 0.0
Other WC items ₹ 1,870.0 ₹ (398.0) ₹ 5,852.0 ₹ 4,727.0
Working capital changes ₹ 4,157.0 ₹ (3,672.0) ₹ 1,313.0 ₹ 3,254.0
Direct taxes ₹ (4,308.0) ₹ (4,194.0) ₹ (2,040.0) ₹ (1,895.0)
Cash from Operating Activity - ₹ 40,308.0 ₹ 31,860.0 ₹ 39,212.0 ₹ 33,454.0

Investing Activities
Fixed assets purchased ₹ (26,975.0) ₹ (31,962.0) ₹ (31,503.0) ₹ (16,072.0)
Fixed assets sold ₹ 50.0 ₹ 74.0 ₹ 59.0 ₹ 53.0
Investments purchased ₹ (429.0) ₹ (5,461.0) ₹ (4,728.0) ₹ (6.0)
Investments sold ₹ 4.0 ₹ 42.0 ₹ 89.0 ₹ 1,965.0
Interest received ₹ 653.0 ₹ 698.0 ₹ 731.0 ₹ 638.0
Dividends received ₹ 40.0 ₹ 80.0 ₹ 58.0 ₹ 620.0
Invest in subsidiaries ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
Investment in group cos ₹ 0.0 ₹ (160.0) ₹ 0.0 ₹ (107.0)
Redemption and cancellation of shares ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
Acquisition of companies ₹ (185.0) ₹ 0.0 ₹ (111.0) ₹ 0.0
Inter corporate deposits ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
Other investing items ₹ (1,149.0) ₹ 456.0 ₹ (1,289.0) ₹ (26,663.0)
Cash from Investing Activities ₹ (27,991.0) ₹ (36,233.0) ₹ (36,694.0) ₹ (39,572.0)

Financing Activities
Proceeds from shares ₹ 0.0 ₹ 0.0 ₹ 7,433.0 ₹ 5.0
Redemption of debentures ₹ (658.0) ₹ (744.0) ₹ 0.0 ₹ 0.0
Proceeds from borrowings ₹ 33,258.0 ₹ 36,363.0 ₹ 19,519.0 ₹ 33,390.0
Repayment of borrowings ₹ (29,141.0) ₹ (23,332.0) ₹ (24,924.0) ₹ (21,732.0)
Interest paid ₹ (6,171.0) ₹ (6,307.0) ₹ (5,716.0) ₹ (5,336.0)
Dividends paid ₹ (722.0) ₹ (720.0) ₹ (108.0) ₹ (121.0)
Financial liabilities ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
Other financing items ₹ (450.0) ₹ (57.0) ₹ 0.0 ₹ 0.0
Cash from Financing Activities ₹ (3,884.0) ₹ 5,203.0 ₹ (3,796.0) ₹ 6,206.0

Net Cash Flow ₹ 8,433.0 ₹ 830.0 ₹ (1,278.0) ₹ 88.0

 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

9.44% 9.71% 10.18% 12.06% 11.12% 9.06%

₹ 5,222.30 -₹ 4,684.90 -₹ 10,681.69 ₹ 643.55 -₹ 9,427.46 -₹ 3,270.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 -₹ 2,247.45 -₹ 11,076.94 -₹ 1,898.31 -₹ 13,658.75 -₹ 3,974.10

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%

₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 0.00 ₹ 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.2 ₹ 679.2 ₹ 719.5 ₹ 765.8 ₹ 765.9 ₹ 766.0

₹ 94,748.7 ₹ 59,500.3 ₹ 61,491.5 ₹ 54,480.9 ₹ 43,795.4 ₹ 44,555.8
₹ 88,950.5 ₹ 106,175.3 ₹ 124,787.6 ₹ 142,130.6 ₹ 146,449.0 ₹ 134,113.4
 ₹ 142,813.4 ₹ 139,348.6 ₹ 133,180.7 ₹ 144,192.6 ₹ 138,051.2 ₹ 155,239.2
₹ 327,191.81 ₹ 305,703.49 ₹ 320,179.39 ₹ 341,569.91 ₹ 329,061.49 ₹ 334,674.43

₹ 121,413.9 ₹ 111,234.5 ₹ 127,107.1 ₹ 138,707.6 ₹ 138,855.5 ₹ 132,079.8

₹ 40,033.5 ₹ 31,883.8 ₹ 35,622.3 ₹ 20,963.9 ₹ 10,251.1 ₹ 14,274.5
₹ 20,812.8 ₹ 15,770.7 ₹ 16,308.5 ₹ 24,620.3 ₹ 29,379.5 ₹ 26,379.2
₹ 48,286.9 ₹ 56,155.7 ₹ 58,784.9 ₹ 61,718.0 ₹ 62,223.8 ₹ 68,432.1
₹ 230,547.0 ₹ 215,044.8 ₹ 237,822.9 ₹ 246,009.8 ₹ 240,709.8 ₹ 241,165.5

₹ 19,893.3 ₹ 18,996.2 ₹ 11,172.7 ₹ 12,679.1 ₹ 12,442.1 ₹ 15,738.0

₹ 42,137.6 ₹ 39,013.7 ₹ 37,456.9 ₹ 36,088.6 ₹ 35,240.3 ₹ 40,755.4
₹ 34,613.9 ₹ 32,648.8 ₹ 33,727.0 ₹ 46,792.5 ₹ 40,669.2 ₹ 37,015.6
₹ 96,644.8 ₹ 90,658.7 ₹ 82,356.5 ₹ 95,560.1 ₹ 88,351.7 ₹ 93,508.9

₹ 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.0 ₹ 28,771.0 ₹ 23,352.0 ₹ 31,198.0 ₹ 26,943.0 ₹ 41,694.0

₹ (10,688.0) ₹ (9,109.0) ₹ 9,950.0 ₹ (5,505.0) ₹ 185.0 ₹ (2,213.0)
₹ (3,560.0) ₹ 2,069.0 ₹ 2,326.0 ₹ 3,814.0 ₹ 472.0 ₹ (5,665.0)
₹ 7,320.0 ₹ (4,692.0) ₹ (8,085.0) ₹ 5,748.0 ₹ (7,012.0) ₹ 6,945.0
₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
₹ 494.0 ₹ 4,512.0 ₹ 875.0 ₹ (4,150.0) ₹ (4,396.0) ₹ (2,194.0)
₹ (6,434.0) ₹ (7,221.0) ₹ 5,065.0 ₹ (93.0) ₹ (10,750.0) ₹ (3,127.0)
₹ (3,021.0) ₹ (2,659.0) ₹ (1,785.0) ₹ (2,105.0) ₹ (1,910.0) ₹ (3,179.0)
₹ 17,423.0 ₹ 11,671.0 ₹ 31,698.0 ₹ 28,907.0 ₹ 3,532.0 ₹ 32,261.0

₹ (35,079.0) ₹ (35,304.0) ₹ (29,702.0) ₹ (20,205.0) ₹ (15,168.0) ₹ (19,230.0)

₹ 30.0 ₹ 67.0 ₹ 171.0 ₹ 351.0 ₹ 230.0 ₹ 285.0
₹ (329.0) ₹ (130.0) ₹ (1,439.0) ₹ (7,530.0) ₹ (3,008.0) ₹ (50.0)
₹ 2,381.0 ₹ 5,644.0 ₹ 21.0 ₹ 226.0 ₹ 104.0 ₹ 6,895.0
₹ 690.0 ₹ 761.0 ₹ 1,104.0 ₹ 428.0 ₹ 653.0 ₹ 973.0
₹ 1,797.0 ₹ 232.0 ₹ 21.0 ₹ 18.0 ₹ 32.0 ₹ 46.0
₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
₹ (4.0) ₹ (9.0) ₹ (606.0) ₹ (10.0) ₹ 0.0 ₹ 0.0
₹ 14.0 ₹ 533.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 19.0
₹ 0.0 ₹ (8.0) ₹ (27.0) ₹ 0.0 ₹ (98.0) ₹ 0.0
₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
₹ 5,360.0 ₹ 7,335.0 ₹ (2,659.0) ₹ 1,051.0 ₹ 12,813.0 ₹ (4,357.0)
₹ (25,140.0) ₹ (20,879.0) ₹ (33,116.0) ₹ (25,671.0) ₹ (4,442.0) ₹ (15,419.0)

₹ 0.0 ₹ 0.0 ₹ 3,889.0 ₹ 2,603.0 ₹ 19.0 ₹ 20.0

 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0 ₹ 0.0
₹ 37,482.0 ₹ 51,128.0 ₹ 38,297.0 ₹ 46,641.0 ₹ 46,578.0 ₹ 43,934.0
₹ (29,964.0) ₹ (35,198.0) ₹ (29,847.0) ₹ (29,709.0) ₹ (42,816.0) ₹ (62,557.0)
₹ (5,411.0) ₹ (7,005.0) ₹ (7,518.0) ₹ (8,123.0) ₹ (9,251.0) ₹ (9,336.0)
₹ (96.0) ₹ (95.0) ₹ (57.0) ₹ (30.0) ₹ (100.0) ₹ (141.0)
₹ 0.0 ₹ 0.0 ₹ (1,346.0) ₹ (1,477.0) ₹ (1,559.0) ₹ (1,517.0)
₹ 0.0 ₹ 0.0 ₹ (29.0) ₹ 0.0 ₹ 3,750.0 ₹ 3,355.0
₹ 2,011.0 ₹ 8,830.0 ₹ 3,389.0 ₹ 9,905.0 ₹ (3,379.0) ₹ (26,242.0)

₹ (5,706.0) ₹ (378.0) ₹ 1,971.0 ₹ 13,141.0 ₹ (4,289.0) ₹ (9,400.0)

LTM

₹ 423,873.8

₹ 92,817.95 89018.36 91361.3 95158.77

21.90%

₹ 331,055.86

₹ 10,393.66

₹ 20,119.60

₹ 4,307.64
 Ratio Analysis - TATA MOTORS LTD
Years Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

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%

EBITDA Margin 14.97% 14.91% 14.06% 10.97% 10.79%
EBIT Margin 10.21% 9.82% 7.94% 4.33% 3.40%
EBT Margin 8.17% 7.98% 6.15% 2.76% 1.79%
Net Profit Margin 6.12% 5.07% 5.04% 1.56% 0.30%

SalesExpenses%Sales 7.7% 8.0% 10.7% 12.8% 10.9%

Depreciation%Sales 6.2% 6.6% 8.1% 8.7% 9.4%
Operating Income%Sales 10.2% 9.8% 7.9% 4.3% 3.4%

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

Retained Earnings% 95.49% 100.00% 99.51% 100.00% 100.00%
Return on Equity% 21.74% 23.72% 17.44% 7.22% 0.92%
Sell Sustained Growth Rate 20.76% 23.72% 17.36% 7.22% 0.92%
Interest Coverage Ratio 5.01x 5.32x 4.44x 2.76x 2.12x

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

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

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

CFO/Sales 17.31% 12.11% 14.36% 12.40% 5.98%

CFO/Total Assets 18.45% 13.43% 14.90% 12.27% 5.33%
CFO/Total Debt 66.47% 43.28% 56.53% 42.56% 19.59%
 Mar-19 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.57% 19.42% 21.81% 19.81% 20.69% 21.82% 21.81%

8.17% 6.89% 12.93% 8.88% 9.20% 11.40% 10.97%
0.36% -1.32% 3.50% -0.04% 2.01% 4.24% 3.50%
-1.55% -4.09% 0.26% -3.39% -0.95% 2.01% 1.79%
-0.74% -4.24% -0.76% -4.91% -1.15% 0.83% 0.30%

11.4% 12.5% 8.9% 10.9% 11.5% 10.42% 10.86%

9.7% 10.2% 12.1% 11.1% 9.1% 9.12% 9.44%
0.4% -1.3% 3.5% 0.0% 2.0% 4.24% 3.50%

0.65% -1.84% 4.43% -0.06% 3.88% 7.83% 5.37%

0.00% 0.00% 0.00% 0.00% 0.00% 55.00% 95.49%
-3.73% -17.81% -3.44% -30.65% -8.77% 1.71% 0.92%
0.00% 0.00% 0.00% 0.00% 0.00% 7.78% 0.92%
0.19x -0.47x 1.08x -0.01x 0.68x 2.27x 2.12x

15.89x 23.37x 19.70x 22.38x 21.98x 19.80x 20.12x

2.17x 1.96x 1.73x 2.02x 2.23x 2.14x 2.04x
7.74x 6.97x 6.92x 7.90x 8.49x 7.78x 7.74x
2.71x 2.05x 1.80x 2.01x 2.62x 2.52x 2.55x
5.02x 4.20x 4.52x 6.25x 7.63x 4.37x 4.52x

23 days 16 days 19 days 16 days 17 days 19 18

168 days 186 days 211 days 181 days 164 days 173 179
47 days 52 days 53 days 46 days 43 days 47 47
-98 days -118 days -139 days -118 days -104 days -107 -101

3.87% 12.14% 11.57% 1.27% 9.32% 10.11% 12.11%

3.82% 9.90% 8.46% 1.07% 9.64% 9.74% 9.90%
10.99% 25.40% 20.34% 2.41% 24.06% 31.95% 25.40%
 Tata Motors- Sales forecasting
Year weigh Year Sales Sales Growth Tata Motors- EBITA forecasting
1 2014A 232,833.7 Year weigh Year Sales
2 2014A 263,159.0 13.02% 1 1899A 34,853.4
3 2014A 273,045.6 3.76% 2 1899A 39,238.6
4 2014A 269,692.5 -1.23% 3 1900A 38,395.2
5 2014A 291,550.5 8.10% 4 1900A 29,588.7
6 2014A 301,938.4 3.56% 5 1900A 31,457.7
7 2014A 261,068.0 -13.54% 6 1900A 24,664.3
8 2014A 249,794.8 -4.32% 7 1900A 17,987.1
9 2014A 278,453.6 11.47% 8 1900A 32,287.4
10 2014A 345,967.0 24.25% 9 1900A 24,720.1
11 2014E 309,867.7 -10.43% 10 1900A 31,815.8
12 2014E 311,403.6 0.50% 11 1900E 23,797.3
13 2014E 316,504.9 1.64% 12 1900E 22,276.6
14 2014E 323,066.9 2.07% 13 1900E 22,054.1
15 2014E 328,462.3 1.67% 14 1900E 22,648.4
16 2014E 338,286.4 2.99% 15 1900E 22,221.5
16 1900E 22,584.8
- EBITA forecasting
Sales Growth

12.58%
-2.15%
-22.94%
6.32%
-21.60%
-27.07%
79.50%
-23.44%
28.70%
-25.20%
-6.39%
-1.00%
2.69%
-1.89%
1.64%