Tata Motors Ratio Analysis

GP Ratio   Gross Profit

Mar ' 08

Mar ' 07

6576.35 5934.01

Mar ' 06

Mar ' 05

Mar ' 04

4782.7 4267.44 3679.34

sales

28,738.3 26664.2 20088.6 17199.1 13028.1 0 5 3 7 7

GP Ratio

22.88357 22.2545 23.8079 24.8118 28.2414 3 5 9 9 18

Net Profit Ratio   sales

Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05 Mar ' 04 28,738.3 026664.2520088.6317199.1713028.17

3,000.91 2586.51 2146.36 2000.05 1727.28 Net Profit 10.44219 79.70029210.6844511.6287613.25804 Ratio net profit

Operating ratio  

Mar ' 08

sales 28,738.30 cost of goods  sold 22,161.95 operating  expenses 4,706.84 Operating ratio

Mar ' 07

Mar ' 06

Mar ' 05

Mar ' 04

26664.25 20088.63 17199.17 13028.17 20730.24 15305.93 12931.73

3,924.55 93.49 92.46

2945.19 90.85

2549.82 90.01

9348.83 2096.95 87.85

Debt Equity ratio  

Mar ' 08

Mar ' 07

Mar ' 06

Mar ' 05

Mar ' 04

Debt

6,280.52

4,009.14

2,936.84

2,495.42

1,259.77

14,094.51 10,852.94

8,447.52

6,606.81

4,853.37

0.347657

0.377704

0.259566

Equity Debt Equity ratio

0.4456005

0.369406

Current ratio  

Mar ' 08

Current Assets 10,781.23 Current  Liabilities 12,029.80 0.896210 Current ratio

Mar ' 07

Mar ' 06

Mar ' 05

Mar ' 04

10,318.42 9,812.06 7,248.88 3,835.78

8,321.20 7,888.65 7,268.80 5,309.17 2 1.240016 1.24382 0.99726 0.722482

Fixed Asset T.O ratio  

Mar ' 08

cost of goods  sold 22,161.95

Mar ' 07

Mar ' 06

Mar ' 05

Mar ' 04

20730.24 15305.93 12931.73 9348.83 fixed Assets 15,337.03 8,845.63 6,509.99 6,608.57 6,304.57 1.482865 Fixed Asset  1.444996 2 2.343557 2.351145 1.956812 6 T.O ratio

Return on networth  

Mar ' 08

Mar ' 07

Mar ' 06

Mar ' 05

Mar ' 04

3,000.91 2586.51 2146.36 2000.05 1727.28 Equity 14,094.51 10,852.94 8,447.52 6,606.81 4,853.37 35.58929 Return on  2 networth 21.29134 23.83234 25.40817 30.27255 net profit

Profit and Loss A/c Income:  Operating  income  Expenses  Material  consumed  Manufacturing  expenses  Personnel  expenses

28,738.30

26,664.25

20,088.63

17,199.17

13,028.17

20,931.81

19,529.88

14,376.11

12,101.28

8,720.10

1,230.14

1,200.36

929.82

830.45

628.73

1,544.57

1,367.83

1,143.13

1,039.34

882.49

1,179.48

1,068.56

759.54

598.75

455.56

Selling expenses Adminstrative  expenses Expenses  capitalised

1,982.79

1,488.16

1,042.52

911.73

758.9

-1,131.40

-577.05

-308.85

-282.43

-144.89

Cost of sales

25,737.39

24,077.74

17,942.27

15,199.12

11,300.89

Operating profit Other recurring  income

3,000.91

2,586.51

2,146.36

2,000.05

1,727.28

389.03

887.23

685.18

399.94

235.65

Adjusted PBDIT Financial  expenses

3,389.94

3,473.74

2,831.54

2,399.99

1,962.93

471.56

455.75

350.24

234.3

225.96

652.31

586.29

520.94

450.16

382.6

Depreciation 

Cntd… Other write  offs Adjusted PBT Tax charges  Adjusted PAT Non recurring  items Other non  cash  adjustments Reported net  profit Earnigs before  appropriation Equity  dividend Preference  dividend Dividend tax Retained  earnings

64.35

85.02

73.78

67.12

51.64

2,201.72

2,346.68

1,886.58

1,648.41

1,302.73

547.55

660.37

524.93

415.5

482.55

  1,654.17

  1,686.31

  1,361.65

  1,232.91

  820.18

374.75

227.15

167.23

4.04

-6.82

-

-0.07

-

-1.54

-3.02

2,028.92

1,913.39

1,528.88

1,235.41

810.34

3,042.75

2,690.15

2,094.54

1,601.21

934.05

578.43

578.07

497.94

452.19

282.11

-

-

-

-

-

81.25

98.25

69.84

63.42

36.14

2,383.07

2,013.83

1,526.76

1,085.60

615.8

Balance sheet Sources of funds Owner's fund Equity share  capital Share  application  money Preference  share capital Reserves &  surplus

385.54

385.41

382.87

361.79

353

-

-

-

-

3.83

-

-

-

-

-

7,428.45

6,458.39

5,127.81

3,749.60

3,236.77

2,461.99

2,022.04

822.76

489.81

942.65

3,818.53

1,987.10

2,114.08

2,005.61

317.12

14,094.51

10,852.94

8,447.52

6,606.81

4,853.37

Loan funds Secured loans Unsecured  loans Total

Uses of funds Fixed assets Gross block Less :  revaluation  reserve Less :  accumulated  depreciation

10,830.83

8,775.80

7,971.55

6,611.95

5,985.40

25.51

25.95

26.39

-

-

5,443.52

4,894.54

4,401.51

3,454.28

3,023.69

Net block Capital work-inprogress

5,361.80

3,855.31

3,543.65

3,157.67

2,961.71

5,064.96

2,513.32

951.19

538.84

286.09

Investments

4,910.27

2,477.00

2,015.15

2,912.06

3,056.77

10,781.23

10,318.42

9,812.06

7,248.88

3,835.78

12,029.80

8,321.20

7,888.65

7,268.80

5,309.17

-1,248.57

1,997.22

1,923.41

-19.92

-1,473.39

6.05

10.09

14.12

18.16

22.19

14,094.51

10,852.94

8,447.52

6,606.81

4,853.37

Net current assets Current assets,  loans &  advances Less : current  liabilities &  provisions Total net current  assets Miscellaneous  expenses not  written Total

Notes: Book value  of unquoted  investments 4,145.82 Market value  of quoted  investments 2,530.55 Contingent  liabilities 5,590.83 Number of  equity  sharesoutsta nding (Lacs) 3855.04

2,117.86

1,648.57

2,480.15

2,778.87

1,323.08

1,550.00

1,260.05

732.76

5,196.07

2,185.63

1,450.32

896.07

3853.74

3828.34

3617.52

3529.58