Tata Motors

  • Uploaded by: Girish Ramachandra
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Tata Motors as PDF for free.

More details

  • Words: 2,666
  • Pages: 21
Balance Sheet(2009-2000) in US Format for Tata Motors *All numbers are in INR and in x10M

Inventories Sundry Debtors Cash and Bank Loans and Advances Total Current Assets Gross Block Less : Accumulated Depreciation Less:Impairment of Assets Net Block Lease Adjustment Capital Work in Progress Investments Miscellaneous Expenses not written off Deferred Tax Assets Total Asset Current Liabilities Provisions Total Current Liabilities Deferred Tax Liability Secured Loans Unsecured Loans Total Debt Share Capital Reserves Total Equity Share Warrants Equity Application Money Total Shareholders Funds Total Liability Check Integrity* *It checks asset and liability mismatch if any

200903 2229.81 1555.2 1141.82 4764.86 9691.69 13905.17 6259.9 0 7645.27 0 6954.04 12968.13 2.02 1144.89 38406.04 9122.37 1877.26 10999.63 2010.7 5251.65 7913.91 13165.56 514.05 11716.1 0 0 12230.15 38406.04 0

200803 2421.83 1130.73 2397.31 4410.38 10360.25 10830.83 5443.52 0 5387.31 0 5064.96 4910.27 6.05 397.45 26126.29 8643.67 1989.43 10633.1 1373.17 2461.99 3818.53 6280.52 385.54 7453.96 0 0 7839.5 26126.29 0

200703 200603 200503 200403 2500.95 2012.24 1601.36 1147.44 782.18 716.6 798.58 614.99 826.76 1119.43 2005.04 770.49 6402.16 5639.54 2681.05 1162.78 10512.05 9487.81 7086.03 3695.7 8775.8 7971.55 6611.95 5985.4 4894.54 4401.51 3454.28 3023.69 0 0 0 0 3881.26 3570.04 3157.67 2961.71 0 0 0 0 2513.32 951.19 538.84 286.09 2477 2015.15 2912.06 3056.77 10.09 14.12 18.16 22.19 176.6 150.75 102.69 135.06 19570.32 16189.06 13815.45 10157.52 6363.68 5726.82 5414.61 4228.13 1364.32 1215.04 1126.06 430.64 7728 6941.86 6540.67 4658.77 963.43 773.29 667.97 649.21 2022.04 822.76 489.81 942.65 1987.1 2114.08 2005.61 317.12 4009.14 2936.84 2495.42 1259.77 385.41 382.87 361.79 353 6484.34 5154.2 3749.6 3236.77 0 0 0 0 0 0 0 0 6869.75 5537.07 4111.39 3589.77 19570.32 16189.06 13815.45 10157.52 0 0 0 0

200303 1159.29 946.1 245.35 631.27 2982.01 5888.99 2713.07 0 3175.92 0 192.15 1271.8 30.06 548 8199.94 3175.26 315.91 3491.17 653.3 1037.32 420.99 1458.31 319.83 2277.33 0 0 2597.16 8199.94 0

200203 987.51 785.62 326.63 595.87 2695.63 5769.5 2431.72 0 3337.78 0 140.56 1189.92 0 708.17 8072.06 2528.81 160.06 2688.87 613.17 1344.78 960.18 2304.96 319.82 2145.24 0 0 2465.06 8072.06 0

200103 1105.1 758.02 115.46 782.98 2761.56 5638.14 2090.67 0 3547.47 0 276.13 1387.18 891.88 0 8864.22 2434.38 177.18 2611.56 0 1813.33 1185.55 2998.88 255.9 2997.88 0 0 3253.78 8864.22 0

200003 990.86 865.21 65.27 1081.83 3003.17 5420.44 1828.18 0 3592.26 0 391.89 1200.74 787.18 0 8975.24 1957.21 259.65 2216.86 0 1650.27 1353.99 3004.26 255.9 3498.22 0 0 3754.12 8975.24 0

Income Statement(2009-2000) - Tata Motors *All numbers are in INR and in x10M

200903 (12) 200803 (12) INCOME : Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments

28292.56 32885.03 2877.53 4347.04 25415.03 28537.99 1369.9 996.05 -238.04 -40.48

Total Income

26546.89 29493.56

EXPENDITURE : Raw Materials Power & Fuel Cost Employee Cost Other Manufacturing Expenses Selling and Administration Expenses Miscellaneous Expenses Less: Pre-operative Expenses Capitalised

18398.94 20190.19 304.94 325.19 1539.26 1534.41 1300.24 1396.22 1350.93 1298.67 1869.4 1838.72 916.02 744.23

Total Expenditure

23847.69 25839.17

Operating Profit Interest Gross Profit Depreciation Profit Before Tax Tax Fringe Benefit tax Deferred Tax Reported Net Profit Extraordinary Items Adjusted Net Profit

2699.2 810.9 1888.3 874.54 1013.76 0 15 -2.5 1001.26 531.63 469.63

3654.39 425.61 3228.78 652.31 2576.47 139.01 7 401.54 2028.92 149.49 1879.43

Adjst. below Net Profit P & L Balance brought forward Statutory Appropriations Appropriations P & L Balance carried down

15.29 1383.07 0 713.63 1685.99

0 1013.83 0 1659.68 1383.07

311.61 0 60 21.5

578.43 0 150 48.93

Dividend Preference Dividend Equity Dividend % Earnings Per Share(Adj)-Unit Curr

Earnings Per Share-Unit Curr Earnings Per Share(Adj)-Unit Curr Book Value-Unit Curr

21.5 21.5 269.88

50.52 48.93 202.68

200703 (12)200603 (12) 200503 (12)200403 (12) 200303 (12)200203 (12)200103 (12) 200003 (12) 31611.21 23673.43 20152.03 15165.85 10585.43 4425.44 3380.13 3063.44 2270.3 1743.79 27185.77 20293.3 17088.59 12895.55 8841.64 574.11 693.92 560.29 427.79 323.65 349.68 256.91 144 -141.98 119.74

8676.86 1389.29 7287.57 271.67 -49.03

7927.63 1292.24 6635.39 284.5 56.67

8691.62 1487.82 7203.8 457.44 154.14

28109.56 21244.13 17792.88 13181.36

9285.03

7510.21

6976.56

7815.38

19374.93 14263.86 11929.48 327.41 258.51 237.81 1361.2 1141.48 1037.93 1618.68 1251.02 1017.11 1322.88 985.74 795.03 1153.53 784.56 673.78 577.05 308.85 218.13

8341.39 214.52 879.49 722.95 645.73 644.75 144.89

5699.58 193.51 720.37 510.39 606.25 529.6 156.46

4716.47 184.78 716.07 639.15 290.12 447.23 144.63

4728.07 185.18 624.3 457.32 279.52 475.97 112.32

5086.54 213.8 701.64 547.86 186.06 414.99 226.58

24581.58 18376.32 15473.01 11303.94

8103.24

6849.19

6638.04

6924.31

3527.98 368.51 3159.47 586.29 2573.18 476 6.5 177.22 1913.46 37.4 1876.06

2867.81 293.49 2574.32 520.94 2053.38 363.35 19 142.15 1528.88 145.42 1383.46

2319.87 217.81 2102.06 450.16 1651.9 363.82 0 51.13 1236.95 24.77 1212.18

1877.42 202.48 1674.94 382.6 1292.34 96 0 386 810.34 -29.95 840.29

1181.79 309.29 872.5 362.13 510.37 19.71 0 190.55 300.11 4.94 295.17

661.02 415.55 245.47 354.68 -109.21 0 0 -55.48 -53.73 -45.46 -8.27

338.52 491.49 -152.97 347.37 -500.34 0 0 0 -500.34 -9.79 -490.55

891.07 473.26 417.81 342.61 75.2 4 0 0 71.2 258.23 -187.03

0 776.76 0 1676.39 1013.83

0 585.6 0 1337.72 776.76

0 365.8 0 1017.15 585.6

0 123.71 0 568.25 365.8

0 0 0 176.4 123.71

0 0 0 -53.73 0

0 135.49 0 -364.85 0

0 130.77 0 66.48 135.49

578.07 0 150 45.61

497.94 19.94 130 36.4

452.19 0 125 31.42

282.11 0 80 21.24

127.91 0 40 8.59

0 0 0 0

0 0 0 0

63.96 0 25 2.16

47.1 45.61 177.57

37.59 36.4 143.93

32.44 31.42 113.64

21.93 21.24 101.69

8.87 8.59 81.2

0 0 77.08

0 0 127.15

2.23 2.16 146.7

00003 (12)

Cash Flow Statement(2009-2000) - Tata Motors *All numbers are in INR and in x10M

200903 Cash Flow Summary Cash and Cash Equivalents at Beginning of the year Net Cash from Operating Activities Cash Flow From Operating Activities Net Profit before Tax & Extraordinary Items Adjustment For Depreciation Interest (Net) Dividend Received P/L on Sales of Assets P/L on Sales of Invest Prov. & W/O (Net) P/L in Forex Fin. Lease & Rental Chrgs Others Total Adjustments (PBT & Extraordinary Items) Op. Profit before Working Capital Changes Adjustment For Trade & 0th receivables Inventories Trade Payables Loans & Advances Investments Net Stock on Hire Leased Assets Net of Sale Trade Bill(s) Purchased Change in Borrowing Change in Deposits Others Total (OP before Working Capital Changes) Cash Generated from/(used in) Operations Interest Paid(Net) Direct Taxes Paid Advance Tax Paid Others Total-others Cash Flow before Extraordinary Items Extraordinary Items Excess Depreciation W/b Premium on Lease of land Payment Towards VRS Prior Year 's Taxation

2397.31 1284.48 1001.26 870.05 270.69 0 -13.07 -518.56 -57.77 126.4 0 -134.8 542.94 1544.2 -256.18 192.02 -30.83 0 0 0 0 0 0 0 0 -94.99 1449.21 0 -154.19 0 0 -154.19 1295.02 0 0 0 0

Gain on Forex Exch. Tran Others Net Cash Used in Investing Activities Cash Flow from Investing Activities Investment in Assets : Purchased of Fixed Assets Sale of Fixed Assets capital WIP Capital Subsidy Recd Financial/Capital Investment : Purchase of Investments Sale of Investments Investment Income Interest Received Dividend Received Invest.In Subsidiaires Loans to Subsidiaires Investment in Group Cos Issue of Sh. on Acqu. of Cos Canc. of Invest. in Cos Acq. Acquisition of Companies Inter Corporate Deposits Others Net Cash Used in Financing Activities Cash Flow From Financing Activities Proceeds: Proceeds from Issue of shares (incl share premium) Proceed from Issue of Debentures Proceed from 0ther Long Term Borrowings Proceed from Bank Borrowings Proceed from Short Tem Borrowings Proceed from Deposits Share Application Money Cash/Capital Investment Subsidy Loans from a Corporate Body Payments: Share Application Money Refund On Redemption of Debenture Of the Long Tem Borrowings Of the short term Borrowings Of financial Liabilities Dividend Paid Shelter Assistance Reserve Interest Paid Others

-10.54 0 -10644.67

-4029.06 17.76 0 0 0 1664.53 0 136.94 458.42 -8046.76 -524.05 -151.17 0 0 0 -179.67 8.39 8104.7

4109.66 0 7695.57 0 0 1232.47 0 0 0 0 -0.96 -3178.46 0 0 -642.41 0 -1111.17 0

Net Cash Used in Financing Activities Net Inc/(Dec) in Cash and Cash Equivalent Cash and Cash Equivalents at End of the year

8104.7 -1255.49 1141.82

200803

200703

200603

200503

200403

200303

200203

200103

826.76 6164.92

1119.43 2208.85

2005.04 -223.93

771.12 1242.93

245.35 2719.11

326.62 1375.51

115.44 857.87

65.12 662.68

2028.92

1913.46

1528.88

1236.95

810.34

300.11

-53.73

-500.34

647.82 33.36 0 -20.56 -168.62 -64 -46.34 0 -195.36 186.3 2215.22

582.51 103.36 0 -14.64 -35.48 1.74 -62.17 0 4.03 579.35 2492.81

522.48 114.88 0 -5.6 -177.64 -9.26 34.32 0 4.04 483.22 2012.1

450.16 36 0 -0.03 -47.94 10.22 -11.61 0 4.03 440.83 1677.78

382.6 116.18 0 8.73 -13.82 78.91 -40.95 0 4.56 536.21 1346.55

362.13 267.41 0 -14.54 -6.5 6 0 0 210.81 825.31 1125.42

354.68 365.63 0 1.88 -3.61 111.2 0.01 0 -36.55 793.24 739.51

347.37 419.27 0 4.07 -42 181.19 0.13 0 -8.81 901.22 400.88

1558.28 79.12 2076.32 0 0 0 0 0 0 0 0 3713.72 5928.94 0 250.53 0 0 250.53 6179.47

-185.26 -488.71 221.96 0 0 0 0 0 0 0 0 -452.01 2040.8 0 169.33 0 0 169.33 2210.13

-2102.41 -410.88 194.17 0 0 0 0 0 0 0 0 -2319.12 -307.02 0 85.99 0 0 85.99 -221.03

-1139.44 -451.93 1156.31 0 0 0 0 0 0 0 0 -435.06 1242.72 0 7.77 0 0 7.77 1250.49

-259.22 11.85 1164.11 0 0 0 0 0 0 0 -26.75 889.99 2236.54 0 482.57 0 0 482.57 2719.11

-211.66 -171.78 672.76 0 0 0 0 0 0 0 -30.06 259.26 1384.68 0 -9.17 0 0 -9.17 1375.51

43.84 117.59 129.75 0 0 0 0 0 0 0 -173.82 117.36 856.87 0 1 0 0 1 857.87

143.05 -114.24 517.1 0 0 0 0 0 0 0 -258.77 287.14 688.02 0 -25.34 0 0 -25.34 662.68

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

-14.55 0 -5724.65

-1.28 0 -2805.1

-2.9 0 193.59

-7.56 0 -956.57

0 0 -2043.06

0 0 -248.03

0 0 113.09

0 0 217.13

-4411.26 39.32 0 0

-2461.19 95.15 0 0

-1123.49 14.04 0 0

-817.47 3.82 0 0

-288.97 15.58 0 0

-275.72 49.21 0 0

-136.4 2.76 0 0

-48.42 396.19 0 0

-1103.98 289.01 0 125.56 144.5 -664.44 -53.39 -693.5 0 0 0 209.26 394.27 1130.28

-6.75 171.67 0 41.2 207.63 -561.64 0 0 0 0 0 -262.51 -28.66 303.58

-236.65 1068.21 0 79.17 108.1 0 0 0 0 0 194.65 2.49 87.07 -855.27

-462.49 606.27 0 46.65 118.15 0 0 0 0 0 0 -5.71 -445.79 947.56

-1858.76 39.31 0 40.56 45.08 0 0 0 0 0 0 -11.19 -24.67 -150.91

-42.28 16.72 0 33.4 11.26 0 0 0 0 0 0 -40.62 0 -1208.75

-67.98 254.08 0 31.08 16.02 0 0 0 0 0 0 10.48 3.05 -759.78

-227.22 54.85 0 48.02 24.22 0 0 0 0 0 0 -30.51 0 -829.49

0 0 2827.7 0 405.48 0 0 0 0

0 0 1783.92 0 273.8 0 0 0 0

0 0 1 0 84.77 0 0 0 0

71.81 0 98.54 0 0 0 0 0 0

234.21 0 447.7 0 2.74 0 0 0 0

0.01 0 364.66 0 0 0 0 0 0

0 415.51 347.33 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 -2831.24 0 0 -674.91 0 -566.73 1969.98

0 0 -817.33 0 0 -566.7 0 -370.02 -0.09

0 0 -561.81 0 0 -514.16 0 -309.69 444.62

0 -11.86 -499.36 -54.77 0 -165.39 0 -222.91 1731.5

0 -37.14 -712.2 0 0 -298.61 0 -236.75 449.14

0 -16.92 -1018.54 -210.44 0 -0.05 0 -327.21 -0.26

0 -3.9 -604.91 -459.43 0 -0.28 0 -446.89 -7.21

0 0 -222.32 0 0 -74.28 0 0 -532.89

1130.28 1570.55 2397.31

303.58 -292.67 826.76

-855.27 -885.61 1119.43

947.56 1233.92 2005.04

-150.91 525.14 770.49

-1208.75 -81.27 245.35

-759.78 211.18 326.62

-829.49 50.32 115.44

200003 430.42 444.1 75.2 342.61 362.6 0 -135.04 -127.19 57.33 11.4 2.95 -6.98 507.68 582.88 619.8 -204.75 -434.25 0 0 0 0 0 0 0 -104.26 -123.46 459.42 0 -15.32 0 0 -15.32 444.1 0 0 0 0

0 0 323.73

-420.08 198.12 0 0 -281.95 229.66 0 69.38 41.11 0 0 0 0 0 0 487.49 0 -1133.13

0 0 0 0 0 0 0 0 0 0 0 -455.22 0 0 -85.73 0 0 -592.18

-1133.13 -365.3 65.12

Key Ratios for Tata Motors Key Ratios Debt-Equity Ratio Long Term Debt-Equity Ratio Current Ratio Turnover Ratios Fixed Assets Inventory Debtors Interest Cover Ratio Profitability Ratio PBIDTM (%) PBITM (%) PBDTM (%) CPM (%) APATM (%) Return on Capital Ratio ROCE (%) RONW (%)

200903

200803

200703

200603

0.97 0.49 0.62

0.7 0.41 0.86

0.56 0.36 1.07

0.56 0.49 1.08

2.29 12.16 21.07 1.59

3.36 13.36 34.38 7.05

3.79 14.01 42.18 7.98

3.25 13.1 31.25 8

7.66 4.57 4.8 4.75 1.66

11.11 9.13 9.82 8.15 6.17

11.16 9.31 9.99 7.91 6.05

12.11 9.91 10.87 8.66 6.46

6.55 4.71

24.08 27.68

30.52 30.98

31.25 31.36

200503

200403

200303

200203

200103

200003

0.49 0.47 0.87

0.44 0.4 0.76

0.74 0.65 0.88

0.93 0.74 0.88

0.86 0.64 0.91

0.86 0.64 1.08

3.2 14.66 28.51 8.58

2.55 13.15 19.43 7.38

1.82 9.86 12.23 2.65

1.52 8.29 11.24 0.85

1.43 7.56 9.77 -0.02

1.78 9.41 7.19 0.6

11.51 9.28 10.43 8.37 6.14

12.38 9.86 11.04 7.87 5.34

11.16 7.74 8.24 6.26 2.84

8.14 4.05 3.35 3.99 -0.1

4.27 -0.11 -1.93 -1.93 -6.31

7.24 3.29 1.79 1.79 -2.15

32.76 32.12

33.77 26.2

18.64 11.86

6.95 -0.29

-0.16 -14.28

4.6 -4.98

Balance Sheet(2009-2000) - Tata Motors (India Format) *All numbers are in x10MN 200903 SOURCES OF FUNDS : Share Capital 514.05 Reserves Total 11716.1 Equity Share Warrants 0 Equity Application Money 0 Total Shareholders Funds 12230.15 Secured Loans 5251.65 Unsecured Loans 7913.91 Total Debt 13165.56 Total Liabilities APPLICATION OF FUNDS : Gross Block Less : Accumulated Depreciation Less:Impairment of Assets Net Block Lease Adjustment Capital Work in Progress Investments Current Assets, Loans & Advances Inventories Sundry Debtors Cash and Bank Loans and Advances Total Current Assets Less : Current Liabilities and Provisions Current Liabilities Provisions Total Current Liabilities Net Current Assets Miscellaneous Expenses not written off Deferred Tax Assets Deferred Tax Liability Net Deferred Tax

200803 385.54 7453.96 0 0 7839.5 2461.99 3818.53 6280.52

25395.71 14120.02

13905.17 10830.83 6259.9 5443.52 0 0 7645.27 5387.31 0 0 6954.04 5064.96 12968.13 4910.27 2229.81 2421.83 1555.2 1130.73 1141.82 2397.31 4764.86 4410.38 9691.69 10360.25 9122.37 1877.26 10999.63 -1307.94 2.02 1144.89 2010.7 -865.81

8643.67 1989.43 10633.1 -272.85 6.05 397.45 1373.17 -975.72

Total Assets

25395.71 14120.02

Contingent Liabilities

15524.91

2953.57

200703

200603

200503

200403

200303

200203

200103

200003

385.41 6484.34 0 0 6869.75 2022.04 1987.1 4009.14

382.87 5154.2 0 0 5537.07 822.76 2114.08 2936.84

361.79 3749.6 0 0 4111.39 489.81 2005.61 2495.42

353 3236.77 0 0 3589.77 942.65 317.12 1259.77

319.83 2277.33 0 0 2597.16 1037.32 420.99 1458.31

319.82 2145.24 0 0 2465.06 1344.78 960.18 2304.96

255.9 2997.88 0 0 3253.78 1813.33 1185.55 2998.88

255.9 3498.22 0 0 3754.12 1650.27 1353.99 3004.26

10878.89

8473.91

6606.81

4849.54

4055.47

4770.02

6252.66

6758.38

8775.8 4894.54 0 3881.26 0 2513.32 2477

7971.55 4401.51 0 3570.04 0 951.19 2015.15

6611.95 3454.28 0 3157.67 0 538.84 2912.06

5985.4 3023.69 0 2961.71 0 286.09 3056.77

5888.99 2713.07 0 3175.92 0 192.15 1271.8

5769.5 2431.72 0 3337.78 0 140.56 1189.92

5638.14 2090.67 0 3547.47 0 276.13 1387.18

5420.44 1828.18 0 3592.26 0 391.89 1200.74

2500.95 782.18 826.76 6402.16 10512.05

2012.24 716.6 1119.43 5639.54 9487.81

1601.36 798.58 2005.04 2681.05 7086.03

1147.44 614.99 770.49 1162.78 3695.7

1159.29 946.1 245.35 631.27 2982.01

987.51 785.62 326.63 595.87 2695.63

1105.1 758.02 115.46 782.98 2761.56

990.86 865.21 65.27 1081.83 3003.17

6363.68 1364.32 7728 2784.05 10.09 176.6 963.43 -786.83

5726.82 1215.04 6941.86 2545.95 14.12 150.75 773.29 -622.54

5414.61 1126.06 6540.67 545.36 18.16 102.69 667.97 -565.28

4228.13 430.64 4658.77 -963.07 22.19 135.06 649.21 -514.15

3175.26 315.91 3491.17 -509.16 30.06 548 653.3 -105.3

2528.81 160.06 2688.87 6.76 0 708.17 613.17 95

2434.38 177.18 2611.56 150 891.88 0 0 0

1957.21 259.65 2216.86 786.31 787.18 0 0 0

10878.89

8473.91

6606.81

4849.54

4055.47

4770.02

6252.66

6758.38

2527.78

1558.65

1102.68

839.45

914.05

1434.07

1168.73

1811.47

Related Documents

Tata Motors
July 2020 17
Tata Motors
June 2020 18
Tata Motors
June 2020 21
Tata Motors
November 2019 27
Tata Motors
May 2020 19
Tata Motors
October 2019 33

More Documents from "Gourav Bains"