Current Ratio Liquid Ratio Absolute Current Ratio Inventory Days Debtor Days Creditor Days WorkingCapital Days
Ratio Analysis Tata Motors 2007 2006 2005 138% 137% 108% 103.85% 107.69% 84.00% 11.24% 16.13% 30.38% 33.152 35.561 33.555 10.368 12.664 17.000 71.217 68.787 68.719 -27.697 -20.561 -18.164
Mahindra & Mahindra 2007 140.61% 107.65% 49.75% 33.305 26.572 97.315 -37.439
Debt Ratio Equity Ratio Debt Equity Ratio Interest Coverage Ratio
59.75% 40.25% 52.36% 9.22
61.59% 38.41% 47.68% 10.07
66.04% 33.96% 53.36% 11.72
54.63% 45.37% 45.79% 73.62
Operating Profit/Sales (%) PBIT/Sales (%) PBDITA/Sales (%) PAT/Sales (%) Depreciation/Sales (%) Interest/Sales (%)
12.03% 10.48% 12.92% 6.95% 2.13% 1.14%
12.47% 11.04% 13.87% 7.40% 2.52% 1.10%
12.46% 10.37% 13.42% 7.10% 2.58% 0.88%
8.73% 15.14% 16.05% 11.10% 2.18% 0.21%
PBIT/TA PBIT/CE PAT/OF PAT/no of shares Price to Earning Ratio Market Value/Book ValueRatio
15.17% 24.74% 24.99% 49.65 14.925 3.730
14.21% 25.06% 24.82% 39.93 22.545 5.596
13.11% 25.18% 26.45% 34.19 19.099 5.052
18.51% 27.98% 29.90% 44.29 17.412 5.207
-758.48% -104.18% 962.66% 76.57%
20.52% 79.39% 0.10% -9.70%
33.61% 53.31% 13.02% 2.03% 34.09% 21.07% 38.68%
28.19% 59.16% 12.56% 2.39% 32.14% 18.31% 43.28%
26.84% 51.89% 21.14% 2.63% 27.22% 18.12% 47.93%
23.76% 47.60% 28.41% 3.06% 42.06% 20.78% 33.85%
24.74% 10.48% 144.74% 163.07%
25.06% 11.04% 128.78% 176.31%
25.18% 10.37% 126.47% 192.03%
27.98% 15.14% 122.27% 151.18%
10.48% 67.27% 20.69%
11.04% 66.48% 21.05%
10.37% 66.83% 20.71%
15.14% 70.66% 20.61%
CFO/Total Cash Generated during the year CFF/TCG CFI/TCG CFO/PBIT FixedAsset/Total Assets Current Assets/Total Assets Investment/Total Assets Capital /Total Assets Reserves/Total Assets LTL/Total Assets CL/Total Assets ROCE (Dupont Ratios) PBIT/CE PBIT/Sales Sales/TA TA/CE Operating Decisions PBIT/Sales COGS/Sales Operating Expenses/Sales
101.29% 183.61% 76.23% 65.67% -77.52% -149.28% 69.20% 80.20%
Depreciation/Sales Investment Decisions Sales/TA Sales/Fixed Assets Sales/Debtors Sales/Stock Sales/Other CA Financing Decisions Assets/CE Assets/RS Assets/LTL Assets/Equity
2.13%
2.52%
2.58%
2.18%
144.74% 128.78% 126.47% 122.27% 430.60% 456.81% 471.23% 514.53% 3520.32% 2882.15% 2147.01% 1373.65% 1100.99% 1026.39% 1087.77% 1095.95% 401.47% 305.57% 368.00% 443.92% 163.07% 293.38% 474.50% 49.36
176.31% 311.17% 546.11% 41.89
192.03% 367.32% 551.93% 38.07
151.18% 237.77% 481.32% 32.64
Mahindra & Mahindra 2006 2005 133.99% 130.68% 91.16% 87.50% 35.60% 35.46% 40.149 42.467 29.148 28.589 85.995 82.979 -16.698 -11.923
Maruti Udyog 2007 2006 2005 155.40% 204.35% 184.82% 126.59% 161.57% 143.39% 57.19% 95.60% 63.69% 17.953 26.856 22.391 19.257 20.171 20.486 30.726 24.397 19.617 6.484 22.631 23.261
48.99% 51.01% 28.91% 41.82
56.38% 43.62% 48.37% 24.63
30.73% 69.27% 9.34% 58.33
32.67% 67.33% 11.82% 81.30
29.96% 70.04% 7.30% 36.49
9.19% 14.11% 13.99% 10.74% 2.50% 0.34%
9.82% 11.40% 14.01% 7.86% 2.82% 0.46%
12.66% 16.01% 17.88% 10.79% 1.87% 0.27%
12.52% 15.00% 17.39% 10.06% 2.39% 0.18%
12.21% 12.53% 16.89% 8.02% 4.36% 0.34%
18.82% 28.62% 28.08% 36.51 24.812 6.966
14.93% 23.07% 23.57% 45.10 11.355 2.677
22.74% 30.03% 22.13% 54.96 16.914 3.743
21.55% 28.63% 21.48% 42.10 22.029 4.732
21.03% 27.99% 19.21% 30.45 20.901 4.015
104.20% -337.93% 48.43% 24.85% -52.63% 413.07% 55.59% 78.86%
151.41% 28.09% -79.50% 79.52%
139.70% -11.33% -28.37% 80.31%
727.14% -95.04% -532.10% 60.94% 25.95% 45.89% 27.86% 3.92% 44.63% 14.75% 34.25%
29.56% 46.10% 23.85% 2.28% 37.54% 21.10% 35.27%
28.39% 37.69% 33.92% 1.39% 66.23% 6.47% 24.26%
24.36% 50.50% 25.14% 1.72% 64.53% 7.96% 24.71%
29.87% 45.93% 24.20% 2.21% 66.11% 5.11% 24.85%
28.62% 14.11% 133.35% 152.09%
23.07% 11.40% 130.91% 154.50%
30.03% 16.01% 142.08% 132.02%
28.63% 15.00% 143.70% 132.82%
27.99% 12.53% 167.81% 133.07%
14.11% 71.34% 19.48%
11.40% 70.29% 19.89%
16.01% 75.81% 11.52%
15.00% 76.82% 10.66%
12.53% 78.05% 9.74%
Tata Motors 2007 Capital 3,854.10 Reserves 64,843.40 LTL 40,091.40 CL 73,577.70 DTL 7,868.30 Total 190,234.90 Fixed Assets 63,945.80 Investments 24,770.00 CA 101,418.20 Miscellaneous Expenditure 100.90 Total 190,234.90
Tata Motors 2007 Sales 275,352.40 COGS 185,241.90 Operating Expenses 56,973.30 Depreciation 5,862.90 Net Non Operating Income 2,451.90 Product Development Exp. 850.20 Provision for Contingencies Add/Less.Exceptional Items (13.50) PBIT 28,862.50 Interest 3,130.70 PBT 25,731.80 Tax 6,597.20 PAT 19,134.60
Tata Motors 2007 Opening CIH 11,194.30 CFF 3,035.80 CFI (28,051.00) CFO 22,101.30 Cash and bank balance taken over-on amalgamation o Cash and bank balance taken over-on merger of spare Less : Exchange fluctuation on(12.80) FCCN proceeds kept o Closing CIH 8,267.60 Current Asset Details 2007 Inventories 25,009.50 Debtors 7,821.80 Cash and Bank Balances 8,267.60
Tata Motors
2.50%
2.39%
4.36%
133.35% 130.91% 142.08% 143.70% 513.93% 442.80% 500.53% 589.90% 1252.22% 1276.71% 1895.42% 1809.54% 909.11% 859.50% 2033.10% 1359.08% 648.26% 635.16% 612.18% 449.24%
167.81% 561.80% 1781.69% 1630.09% 640.17%
152.09% 224.04% 678.15% 25.49
2.82%
1.87%
154.50% 132.02% 132.82% 266.38% 151.00% 154.96% 473.92% 1545.32% 1256.26% 43.85 71.71 58.21
133.07% 151.26% 1956.16% 45.27
Loans And Advances Other Current Assets
60,259.90 59.40
Total
101,418.20
Purchases Creditors
190,129.00 37,097.10
Tata Motors 2006 3,828.70 51,542.00 29,368.40 69,418.60 6,225.40 160,383.10 45,212.30 20,151.50 94,878.10 141.20 160,383.10
Condensed Balance Sheet Mahindra & Mahindra 2005 2007 2006 2005 3,617.90 2,412.14 2,349.87 1,137.59 37,496.00 33,116.96 26,738.84 18,727.71 24,954.20 16,360.07 8,833.82 10,526.20 66,008.30 26,656.44 20,516.43 17,597.09 5,652.80 197.86 1,467.50 1,897.50 137,729.20 78,743.47 59,906.46 49,886.08 36,965.10 18,711.68 15,544.45 14,748.80 29,120.60 22,374.57 16,690.88 11,897.89 71,461.90 37,481.70 27,490.58 22,995.63 181.60 175.53 180.55 243.76 137,729.20 78,743.47 59,906.46 49,886.08
2007 1,445.00 68,620.00 6,705.00 25,132.00 1,712.00 103,614.00 29,412.00 35,146.00 39,056.00 103,614.00
Maruti Udyog 2006 1,445.00 54,285.00 6,696.00 20,788.00 905.00 84,119.00 20,491.00 21,147.00 42,481.00 84,119.00
Tata Motors 2006 206,534.90 137,302.80 43,475.30 5,209.40 2,890.80 737.80 96.90 22,797.30 2,263.50 20,533.80 5,245.00 15,288.80
Condensed Income Statement Mahindra & Mahindra 2005 2007 2006 2005 174,191.30 96,277.11 79,887.68 65,307.41 116,405.90 68,026.80 56,988.42 45,905.73 36,074.50 19,847.26 15,558.16 12,990.42 4,501.60 2,095.87 2,000.05 1,840.55 1,660.90 7,047.64 3,831.29 2,741.30 671.20 7.85 3.40 (138.50) 1,219.85 2,100.12 135.52 18,060.50 14,574.67 11,272.46 7,447.53 1,541.50 197.96 269.56 302.41 16,519.00 14,376.71 11,002.89 7,145.11 4,149.50 3,692.85 2,424.00 2,015.00 12,369.50 10,683.86 8,578.89 5,130.11
2007 147,217.00 111,607.00 16,965.00 2,755.00 7,677.00 23,567.00 404.00 23,163.00 7,280.00 15,883.00
Maruti Udyog 2006 120,877.00 92,858.00 12,889.00 2,891.00 5,890.00 18,129.00 223.00 17,906.00 5,740.00 12,166.00
Tata Motors 2006 20,050.40 (8,552.70) (10.60) (2,210.30) 1,946.50 (29.00) 11,194.30
2005 7,704.90 9,406.70 (9,565.70) 12,498.20 6.30 20,050.40
Condensed CFS Mahindra & Mahindra 2007 2006 2005 7,251.53 6,306.86 2,333.31 4,180.79 (897.78) 1,924.48 (9,503.88) (5,026.58) (2,091.29) 11,689.46 6,869.03 4,140.36 1,361.79 725.15 630.69
2007 19,874.00 (1,367.00) (22,719.00) 18,586.00 14,374.00
Maruti Udyog 2006 10,353.00 2,674.00 (7,569.00) 14,416.00 19,874.00
Tata Motors 2006 20,122.40 7,166.00 11,194.30
2005 16,013.60 8,113.20 20,050.40
Mahindra & Mahindra Maruti Udyog 2007 2006 2005 2007 2006 8,784.84 8,787.44 7,598.30 7,241.00 8,894.00 7,008.87 6,379.69 5,115.28 7,767.00 6,680.00 13,260.72 7,303.06 6,239.79 14,374.00 19,874.00
56,333.80 61.60
27,223.50 61.20
8,394.15 33.12
4,988.98 31.41
4,018.86 9,290.00 23.41 384.00
6,546.00 487.00
94,878.10
71,461.90
37,481.70
27,490.58
22,995.63
39,056.00
42,481.00
141,411.60 26,649.90
120,945.10 22,770.40
68,024.20 18,136.33
58,177.56 13,706.87
48,507.01 11,027.56
109,954.00 9,256.00
95,018.00 6,351.00
ti Udyog 2005 1,445.00 43,247.00 3,344.00 16,255.00 1,123.00 65,414.00 19,539.00 15,833.00 30,042.00 65,414.00
ti Udyog 2005 109,770.00 85,674.00 10,692.00 4,784.00 5,138.00 13,758.00 377.00 13,381.00 4,580.00 8,801.00
ti Udyog 2005 2,444.00 (896.00) (2,244.00) 11,049.00 10,353.00
uti Udyog 2005 6,734.00 6,161.00 10,353.00
6,110.00 684.00 30,042.00 88,010.00 4,730.00