Balance Sheet(2009-2003) of TCS (US Format) *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 Miscellaneous Expenses not written off Deferred Tax Assets Investments Total Asset Current Liabilities Provisions Total Current Liabilities Deferred Tax Liabilities 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 16.95 3717.73 1605.26 3907.2 9247.14 4359.24 1690.16 0 2669.08 0 685.13 0 71 5936.03 18608.38 3501.08 1450.23 4951.31 170.4 32.63 7.74 40.37 197.86 13248.39 0 0 13446.25 18608.33 0.05
200803 17.19 3747.01 527.52 3037.85 7329.57 3240.64 1300.11 0 1940.53 0 889.74 0 54.91 4509.33 14724.08 2404.13 1187.44 3591.57 109.4 9.27 8.98 18.25 197.86 10806.95 0 0 11004.81 14724.03 0.05
200703 12.06 2799.8 557.14 1837.78 5206.78 2315.36 854.75 0 1460.61 0 757.85 0 44 3252.04 10721.28 1639.5 905.05 2544.55 67 41.76 8.98 50.74 97.86 7961.13 0 0 8058.99 10721.28 0
200603 22.94 2325.83 171.17 1471.15 3991.09 1695.13 525.35 0 1169.78 0 280 0 26.36 1963.52 7430.75 1180.14 540.54 1720.68 65.24 26.52 8.98 35.5 48.93 5560.4 0 0 5609.33 7430.75 0
200503 0 1468.05 120.74 726.32 2315.11 1041.09 132.93 0 908.16 0 120.28 0 4.83 1404.42 4752.8 714.28 527.58 1241.86 69.15 111.01 9.73 120.74 48.01 3273.04 0 0 3321.05 4752.8 0
200403 0 0.25 2.25 9.77 12.27 226.5 0.95 0 225.55 0 0 0 0 417.39 655.21 227.22 4.93 232.15 0.98 0 375 375 36.44 10.64 0 0 47.08 655.21 0
200303 0 0.22 1.13 0.57 1.92 226.26 0.1 0 226.16 0 0 0 0.11 37.91 266.1 228.4 0.15 228.55 0.71 0 0 0 36.44 0.4 0 0 36.84 266.1 0
Income Statement(2009-2003) of TCS *All numbers are in INR and in x10M
200903 (12) 200803 (12) INCOME : Operating Income Excise Duty Net Operating Income Other Income Stock Adjustments
22406.08 2.08 22404 289.87 1.73
18292.68 2.83 18289.85 689.82 -0.04
22695.6
18979.63
EXPENDITURE : Cost of Traded Software Packages Operating Expenses Employee Cost Power/Electricity Charges Selling and Administration Exp. Miscellaneous Expenses Less : Pre-operative Expenses Capitalised
52.67 2587.48 11663.54 164.34 1622.63 1040.35 0
45.13 2272.97 9401.97 135.57 1384.63 273.3 0
Total Expenditure
17131.01
13513.57
Operating Profit Interest Gross Profit Depreciation Profit Before Tax Tax Fringe Benefit tax Deferred Tax Reported Net Profit Extraordinary Items Adjusted Net Profit
5564.59 7.44 5557.15 417.46 5139.69 375.59 23 44.89 4696.21 51.42 4644.79
5466.06 3.42 5462.64 458.78 5003.86 440.47 24.65 29.98 4508.76 7.18 4501.58
Adjustment below Net Profit P & L Balance brought forward Appropriations P & L Balance carried down
0 7374.89 2080.69 9990.41
0 4919.99 2053.86 7374.89
Dividend Preference Dividend Equity Dividend %
1370.05 7 1400
1370.05 0.08 1400
45.53
43.69
Total Income
Earnings Per Share-Unit Curr
Earnings Per Share(Adj)-Unit Curr Book Value-Unit Curr
22.76 136.38
21.84 111.43
200703 (12) 200603 (12) 200503 (12) 200403 (12) 200303 (12) 14942.09 2.12 14939.97 216.55 -2.78
11236.01 5.51 11230.5 63.26 4.14
8051.11 0 8051.11 95.22 0
0 0 0 17.74 0
0 0 0 1.97 0
15153.74
11297.9
8146.33
17.74
1.97
21.5 1938.66 7314.05 93.89 1099.15 168.97 0
160.33 1541.47 5108.84 66.85 866.9 217.29 0
0 3049.89 1863.86 44.59 578.32 353.87 0
0 0 0 0 0.01 0.02 0
0 0.01 0 0 0.08 0.01 0
10636.22
7961.68
5890.53
0.03
0.1
4517.52 3.43 4514.09 343.41 4170.68 406.84 17.75 -11.2 3757.29 66.51 3690.78
3336.22 4.49 3331.73 257.38 3074.35 322.41 20.25 14.82 2716.87 2.98 2713.89
2255.8 10.4 2245.4 133.22 2112.18 241 0 39.76 1831.42 -171.45 2002.87
17.71 0.2 17.51 0.84 16.67 1.11 0 0.38 15.18 12.3 2.88
1.87 0 1.87 0.1 1.77 0.15 0 0.6 1.02 0.06 0.96
0 2833.3 1670.6 4919.99
136.16 1005.47 1025.2 2833.3
0 0.64 826.59 1005.47
0 0.4 14.94 0.64
0 0.47 1.09 0.4
1125.39 0 1300
660.56 0 1350
552.13 0 1150
4.38 0 12
1.09 0 3
36.66
53.63
36.6
4.01
0.28
18.33 82.35
13.41 114.64
9.15 69.17
12.92
10.11
Cash Flow Statement(2009-2000) of TCS *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
398.79 4892.33 5139.69 417.46 -74.8 -127.85 -8.27 -48.98 46.48 -29.93 0 0 174.11 5313.8 -11.05 0.24 516.16 -198.73 0 0 0 0 0 0 53.12 359.74 5673.54 0 -799.42 0 0 -799.42 4874.12 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
18.21 0 -3162.22
-978.58 45.45 0 0 -31322.88 30047.76 0 65.06 25.25 0 -29.28 0 0 0 0 -80 -935 -1588.25
0 0 0 22.12 0 0 0 0 0 0 0 0 0 0 -1602.88 0 -7.49 0
Net Cash Used in Financing Activities Net Inc/(Dec) in Cash and Cash Equivalent Cash and Cash Equivalents at End of the year
-1588.25 141.86 540.65
200803
200703
200603
200503
200403
200303
429.38 3800.05
171.17 3537.74
120.74 2342.17
2.25 1969.17
1.13 50.21
0.18 -0.58
5003.86
4170.68
3074.35
2308.65
3.22
1.77
458.78 -33.06 -111.08 0.36 -8.35 19.1 39.08 0 0 364.83 5368.69
343.41 -12.44 -39.92 0.51 -74.26 1.74 -22.96 0 0 196.08 4366.76
257.38 -17.67 -20 -1.56 -1.84 15.51 2.2 0 0 234.02 3308.37
133.22 1.82 -14.53 1.39 -0.13 39.43 -16.19 0 0 145.01 2453.66
0.84 0.2 -2.18 0 -0.06 0 0 0 0 -1.2 2.02
0.11 0 -1.6 0 -0.1 0 0 0 0 -1.59 0.18
-957.57 -5.13 647.99 -106.18 0 0 0 0 0 0 -346.3 -767.19 4601.5 0 -773.59 0 0 -773.59 3827.91
-474.73 10.88 444.63 -262.22 0 0 0 0 0 0 -169.97 -451.41 3915.35 0 -364.09 0 0 -364.09 3551.26
-705.49 10.28 369.35 -30.93 0 0 0 0 0 0 -204.23 -561.02 2747.35 0 -402.93 0 0 -402.93 2344.42
-532.33 0 53.35 78.34 0 0 0 0 0 0 128.05 -272.59 2181.07 0 -202.08 0 0 -202.08 1978.99
-0.03 0 0.12 0 0 0 0 0 0 0 0 0.09 2.11 0 -1.47 0 0 -1.47 0.64
-0.59 0 0 0 0 0 0 0 0 0 0 -0.59 -0.41 0 -0.17 0 0 -0.17 -0.58
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
-27.86 0 -2405.03
-13.52 0 -2076.42
-2.25 0 -1409.44
0 -9.82 -2804.03
0 49.57 -424.07
0 0 3.72
-1075.76 4.81 0 0
-1117.8 5.2 0 0
-606.5 9.4 0 0
-337.21 2.92 0 0
-3.99 0 0 0
-63.4 0 0 0
-28147.06 26984.09 0 20.7 24.73 0 -196.41 0 0 0 0 -20 -0.13 -1425.61
-988.52 76.98 0 7.78 7.26 0 -75.32 0 0 0 0 8 0 -1075.35
-537.67 3.92 0 21.95 4.95 0 -376.02 0 0 0 0 15 55.53 -882.3
-400.73 161 0 8.38 10.77 0 -12.42 0 0 0 0 0 -2236.74 953.35
-459.5 43.94 0 0 2.18 0 0 0 0 0 0 2.3 -9 374.98
-1.79 1.79 0 0 1.6 0 0 0 0 0 0 65.52 0 -2.19
98.58 0 0 0 0 0 0 0 0
0 0 15.24 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
1882.49 0 0 0 0 0 0 0 0
0 0 0 0 0 375 0 0 0
0 0 0 0 0 0 0 0 0
0 0 -32.49 0 0 -1488.4 0 -3.3 0
0 0 0 0 0 -1087.1 0 -3.49 0
0 0 -85.48 0 0 -792.31 0 -4.51 0
0 0 -561.89 0 0 -357.13 0 -10.12 0
0 0 0 0 0 0 0 -0.02 0
0 0 0 0 0 -2.19 0 0 0
-1425.61 -30.59 398.79
-1075.35 385.97 557.14
-882.3 50.43 171.17
953.35 118.49 120.74
374.98 1.12 2.25
-2.19 0.95 1.13
Key Ratios of TCS 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
200503
0 0 1.89
0 0 1.99
0.01 0 2.08
0.02 0 1.96
0.15 0 1.15
5.9 1312.6 6 691.82
6.58 1250.78 5.59 1464.12
7.45 853.83 5.83 1216.94
8.21 979.6 5.92 685.71
12.7 0 10.97 204.09
24.84 22.97 24.8 22.82 20.96
29.88 27.37 29.86 27.16 24.65
30.23 27.94 30.21 27.44 25.15
29.69 27.4 29.65 26.47 24.18
28.02 26.36 27.89 24.4 22.75
42 38.67
52.34 47.55
60.69 54.98
67.77 60.85
109.87 108.75
200403
200303
4.47 0 0.02
0 0 0.01
0 0 0 16.8
0 0 0 0
0 0 0 0 0
0 0 0 0 0
1.46 6.86
4.8 2.77
Balance Sheet(2009-2003) of Tata Motors (India Format) *All numbers are in INR and in x10M
200903
200803
SOURCES OF FUNDS : Share Capital Reserves Total Equity Share Warrants Equity Application Money Total Shareholders Funds Secured Loans Unsecured Loans Total Debt
197.86 197.86 13248.39 10806.95 0 0 0 0 13446.25 11004.81 32.63 9.27 7.74 8.98 40.37 18.25
Total Liabilities
13486.62 11023.06
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 Liabilities Net Deferred Tax Total Assets Contingent Liabilities
4359.24 1690.16 0 2669.08 0 685.13 5936.03
3240.64 1300.11 0 1940.53 0 889.74 4509.33
16.95 3717.73 1605.26 3907.2 9247.14
17.19 3747.01 527.52 3037.85 7329.57
3501.08 1450.23 4951.31 4295.83 0 71 170.4 -99.4
2404.13 1187.44 3591.57 3738 0 54.91 109.4 -54.49
13486.67 11023.11 2287.26
2222.71
200703
200603
200503
200403
200303
97.86 7961.13 0 0 8058.99 41.76 8.98 50.74
48.93 5560.4 0 0 5609.33 26.52 8.98 35.5
48.01 3273.04 0 0 3321.05 111.01 9.73 120.74
36.44 10.64 0 0 47.08 0 375 375
36.44 0.4 0 0 36.84 0 0 0
8109.73
5644.83
3441.79
422.08
36.84
2315.36 854.75 0 1460.61 0 757.85 3252.04
1695.13 525.35 0 1169.78 0 280 1963.52
1041.09 132.93 0 908.16 0 120.28 1404.42
226.5 0.95 0 225.55 0 0 417.39
226.26 0.1 0 226.16 0 0 37.91
12.06 2799.8 557.14 1837.78 5206.78
22.94 2325.83 171.17 1471.15 3991.09
0 1468.05 120.74 726.32 2315.11
0 0.25 2.25 9.77 12.27
0 0.22 1.13 0.57 1.92
1639.5 905.05 2544.55 2662.23 0 44 67 -23
1180.14 540.54 1720.68 2270.41 0 26.36 65.24 -38.88
714.28 527.58 1241.86 1073.25 0 4.83 69.15 -64.32
227.22 4.93 232.15 -219.88 0 0 0.98 -0.98
228.4 0.15 228.55 -226.63 0 0.11 0.71 -0.6
8109.73
5644.83
3441.79
422.08
36.84
2253.51
335.06
152.38
0
0