HISTORICAL STATEMENT - TATA MO
YEARS Mar-15 Mar-16 Mar-17 Mar-18
# INCOME STATEMENT
SALES ₹ 263,158.98 ₹ 273,045.60 ₹ 269,692.51 ₹ 291,550.48
SALES GROWTH - 3.76% -1.23% 8.10%
COGS ₹ 196,196.18 ₹ 200,007.09 ₹ 190,654.40 ₹ 224,336.67
COGS % SALES 74.55% 73.25% 70.69% 76.95%
GROSS PROFIT ₹ 66,962.80 ₹ 73,038.51 ₹ 79,038.11 ₹ 67,213.81
SELLING AND GENERAL EXPENSES ₹ 21,063.45 ₹ 29,141.28 ₹ 34,649.58 ₹ 31,662.97
S&G EXPENSES % SALES 8.00% 10.67% 12.85% 10.86%
EBITDA ₹ 45,899.35 ₹ 43,897.23 ₹ 44,388.53 ₹ 35,550.84
EBITDA % margins 17.44% 16.08% 16.46% 12.19%
INTEREST ₹ 4,861.49 ₹ 4,889.08 ₹ 4,238.01 ₹ 4,681.79
INTEREST % SALES 1.85% 1.79% 1.57% 1.61%
DEPRICIATION ₹ 13,388.63 ₹ 16,710.78 ₹ 17,904.99 ₹ 21,553.59
DEPRICIATION % SALES 5.09% 8.36% 9.39% 9.61%
EARNING BEFORE TAX ₹ 27,649.23 ₹ 22,297.37 ₹ 22,245.53 ₹ 9,315.46
EBT % SALES 10.51% 8.17% 8.25% 3.20%
TAX ₹ 7,642.91 ₹ 3,025.05 ₹ 3,251.23 ₹ 4,341.93
EFFECTIVE TAX RATE 27.64% 13.57% 14.62% 46.61%
NET PROFIT ₹ 20,006.32 ₹ 19,272.32 ₹ 18,994.30 ₹ 4,973.53
NET MARGINS 7.60% 7.06% 7.04% 1.71%
TORICAL STATEMENT - TATA MOTORS LTD
Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
₹ 301,938.40 ₹ 261,067.97 ₹ 249,794.75 ₹ 278,453.62 ₹ 345,966.97 ₹ 437,927.77
3.56% -13.54% -4.32% 11.47% 24.25% 26.58%
₹ 246,952.09 ₹ 214,838.45 ₹ 204,694.36 ₹ 226,480.99 ₹ 264,840.40 ₹ 331,420.73
81.79% 82.29% 81.95% 81.34% 76.55% 75.68%
₹ 54,986.31 ₹ 46,229.52 ₹ 45,100.39 ₹ 51,972.63 ₹ 81,126.57 ₹ 106,507.04
₹ 34,428.54 ₹ 32,704.83 ₹ 22,181.28 ₹ 30,433.52 ₹ 39,747.53 ₹ 43,837.64
11.40% 12.53% 8.88% 10.93% 11.49% 10.01%
₹ 20,557.77 ₹ 13,524.69 ₹ 22,919.11 ₹ 21,539.11 ₹ 41,379.04 ₹ 62,669.40
6.81% 5.18% 9.18% 7.74% 11.96% 14.31%
₹ 5,758.60 ₹ 7,243.33 ₹ 8,097.17 ₹ 9,311.86 ₹ 10,225.48 ₹ 9,985.76
1.91% 2.77% 3.24% 3.34% 2.96% 2.28%
₹ 23,590.63 ₹ 21,425.43 ₹ 23,546.71 ₹ 24,835.69 ₹ 24,860.36 ₹ 27,270.13
9.55% 9.97% 11.50% 10.97% 9.39% 8.23%
(₹ 8,791.46) (₹ 15,144.07) (₹ 8,724.77) (₹ 12,608.44) ₹ 6,293.20 ₹ 25,413.51
-2.91% -5.80% -3.49% -4.53% 1.82% 5.80%
(₹ 2,437.45) ₹ 395.25 ₹ 2,541.86 ₹ 4,231.29 ₹ 704.06 (₹ 3,851.64)
27.73% -2.61% -29.13% -33.56% 11.19% -15.16%
(₹ 6,354.01) (₹ 15,539.32) (₹ 11,266.63) (₹ 16,839.73) ₹ 5,589.14 ₹ 29,265.15
-2.10% -5.95% -4.51% -6.05% 1.62% 6.68%
LTM
₹ 443,059.00
1.17%
₹ 100,532.00
22.69%
₹ 342,527.00
-
0.00%
₹ 342,527.00
77.31%
₹ 8,081.00
1.82%
₹ 25,138.00
25.00%
₹ 309,308.00
69.81%
(₹ 569.00)
-0.18%
₹ 309,877.00
69.94%
COMPANY NAME TATA MOTORS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10
META
Number of shares 368.12
Face Value 2.00
Current Price 648.30
Market Capitalization 238,651.50
PROFIT & LOSS
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Sales 263,158.98 273,045.60 269,692.51 291,550.48
Raw Material Cost 163,250.36 166,134.01 173,294.08 187,896.58
Change in Inventory 3,330.35 2,750.99 7,399.92 2,046.58
Power and Fuel 1,121.75 1,143.63 1,159.82 1,308.08
Other Mfr. Exp 16,173.17 12,101.53 10,067.37 10,971.66
Employee Cost 25,641.95 28,880.89 28,332.89 30,300.09
Selling and admin 23,603.01 21,991.90 30,039.38 31,004.58
Other Expenses -2,539.56 7,149.38 4,610.20 658.39
Other Income 714.03 -2,669.62 1,869.10 5,932.73
Depreciation 13,388.63 16,710.78 17,904.99 21,553.59
Interest 4,861.49 4,889.08 4,238.01 4,681.79
Profit before tax 21,702.56 14,125.77 9,314.79 11,155.03
Tax 7,642.91 3,025.05 3,251.23 4,341.93
Net profit 13,986.29 11,579.31 7,454.36 8,988.91
Dividend Amount 67.92
Quarters
Report Date Sep-22 Dec-22 Mar-23 Jun-23
Sales 79,611.37 88,488.59 105,932.35 102,236.00
Expenses 74,039.06 77,668.35 92,817.95 89,019.00
Other Income 1,351.14 1,129.98 1,452.86 895.00
Depreciation 5,897.34 6,071.78 7,050.20 6,633.00
Interest 2,487.26 2,675.83 2,641.67 2,615.00
Profit before tax -1,461.15 3,202.61 4,875.39 4,864.00
Tax -457.08 262.83 -620.65 1,563.00
Net profit -944.61 2,957.71 5,407.79 3,203.00
Operating Profit 5,572.31 10,820.24 13,114.40 13,217.00
BALANCE SHEET
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 643.78 679.18 679.22 679.22
Reserves 55,618.14 78,273.23 57,382.67 94,748.69
Borrowings 73,610.39 69,359.96 78,603.98 88,950.47
Other Liabilities 107,442.48 114,871.75 135,914.49 142,813.43
Total 237,314.79 263,184.12 272,580.36 327,191.81
Net Block 88,479.49 107,231.76 95,944.08 121,413.86
Capital Work in Progress 28,640.09 25,918.94 33,698.84 40,033.50
Investments 15,336.74 23,767.02 20,337.92 20,812.75
Other Assets 104,858.47 106,266.40 122,599.52 144,931.70
Total 237,314.79 263,184.12 272,580.36 327,191.81
Receivables 12,579.20 13,570.91 14,075.55 19,893.30
Inventory 29,272.34 32,655.73 35,085.31 42,137.63
Cash & Bank 32,115.76 30,460.40 36,077.88 34,613.91
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 2.00 2.00 2.00 2.00
CASH FLOW:
Report Date Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 35,531.26 37,899.54 30,199.25 23,857.42
Cash from Investing Activity -36,232.35 -36,693.90 -39,571.40 -25,139.14
Cash from Financing Activity 5,201.44 -3,795.12 6,205.30 2,011.71
Net Cash Flow 4,500.35 -2,589.48 -3,166.85 729.99
PRICE: 544.37 386.60 465.85 326.85
DERIVED:
Adjusted Equity Shares in Cr 288.74 288.72 288.73 288.73
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
301,938.40 261,067.97 249,794.75 278,453.62 345,966.97 437,927.77
194,267.91 164,899.82 153,607.36 179,295.33 231,251.26 274,321.23
-2,053.28 -2,231.19 -4,684.16 -1,590.49 4,781.62 1,565.53
1,585.93 1,264.95 1,112.87 2,178.29 2,513.33 2,195.12
11,694.54 11,541.51 8,273.17 9,427.38 11,765.97 17,114.33
33,243.87 30,438.60 27,648.48 30,808.52 33,654.70 42,486.64
32,719.80 29,248.32 23,015.79 29,205.40 34,839.19 42,765.33
1,708.74 3,456.51 -834.51 1,228.12 4,908.34 1,072.31
-26,686.25 101.71 -11,117.83 2,424.05 6,663.97 5,672.66
23,590.63 21,425.43 23,546.71 24,835.69 24,860.36 27,270.13
5,758.60 7,243.33 8,097.17 9,311.86 10,225.48 9,985.76
-31,371.15 -10,579.98 -10,474.28 -7,003.41 3,393.93 27,955.11
-2,437.45 395.25 2,541.86 4,231.29 704.06 -3,851.64
-28,826.23 -12,070.85 -13,451.39 -11,441.47 2,414.29 31,399.09
766.02 2,299.50
Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24
105,129.00 110,577.00 119,986.00 108,048.00 101,450.00 113,575.00
91,362.00 95,159.00 102,851.00 92,263.00 89,291.00 100,532.00
1,557.00 1,604.00 1,619.00 1,747.00 1,647.00 1,764.00
6,637.00 6,850.00 7,151.00 6,574.00 6,005.00 5,408.00
2,652.00 2,485.00 2,234.00 2,088.00 2,034.00 1,725.00
6,035.00 7,687.00 9,369.00 8,870.00 5,767.00 7,674.00
2,203.00 542.00 -8,160.00 3,178.00 2,317.00 2,096.00
3,764.00 7,025.00 17,407.00 5,566.00 3,343.00 5,451.00
13,767.00 15,418.00 17,135.00 15,785.00 12,159.00 13,043.00
Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
679.22 719.54 765.81 765.88 766.02 766.50
59,500.34 62,358.99 54,480.91 43,795.36 44,555.77 84,151.52
106,175.34 124,787.64 142,130.57 146,449.03 134,113.44 107,262.50
139,348.59 132,313.22 144,192.62 138,051.22 155,239.20 177,340.09
305,703.49 320,179.39 341,569.91 329,061.49 334,674.43 369,520.61
111,234.47 127,107.14 138,707.61 138,855.45 132,079.76 121,285.46
31,883.84 35,622.29 20,963.93 10,251.09 14,274.50 35,698.43
15,770.72 16,308.48 24,620.28 29,379.53 26,379.16 22,971.07
146,814.46 141,141.48 157,278.09 150,575.42 161,941.01 189,565.65
305,703.49 320,179.39 341,569.91 329,061.49 334,674.43 369,520.61
18,996.17 11,172.69 12,679.08 12,442.12 15,737.97 16,951.81
39,013.73 37,456.88 36,088.59 35,240.34 40,755.39 47,788.29
32,648.82 33,726.97 46,792.46 40,669.19 37,015.56 45,806.69
### ### ### ### ### ###
2.00 2.00 2.00 2.00 2.00 2.00
Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
18,890.75 26,632.94 29,000.51 14,282.83 35,388.01 67,915.36
-20,878.07 -33,114.55 -25,672.50 -4,443.66 -15,417.17 -22,781.56
8,830.37 3,389.61 9,904.20 -3,380.17 -26,242.90 -37,005.99
6,843.05 -3,092.00 13,232.21 6,459.00 -6,272.06 8,127.81
174.25 71.05 301.80 433.75 420.80 992.80
288.73 308.90 332.03 332.07 332.13 332.37
