Financail Statement Ratios Tata Motors Rno 89-90-91 Secb

  • Uploaded by: chirag
  • 0
  • 0
  • December 2019
  • 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 Financail Statement Ratios Tata Motors Rno 89-90-91 Secb as PDF for free.

More details

  • Words: 1,076
  • Pages: 8
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

Related Documents

Tata Ratios
December 2019 28
Tata Motors
July 2020 17
Tata Motors
June 2020 18
Tata Motors
June 2020 21
Tata Motors
November 2019 27

More Documents from ""

Basic Concepts Of It
December 2019 27
Respiration 2
May 2020 14
Respiration
May 2020 12
Title_pages_(2).docx
November 2019 12
Radio Script 1.docx
April 2020 6