Constructions - 0910 Sub-JV Annex 1-16
Constructions - 0910 Sub-JV Annex 1-16
Constructions - 0910 Sub-JV Annex 1-16
1 Please provide us all figures in crores rounded off upto 2 decimal places unless otherwise specified. (use
'roundof' function).
2 In case, your company is not falling in any of the activities mentioned in the FFC (Schedules 15 to 26),
please enter the name of the activity and details of the income and cost in 'Schedule 27' and 'Schedule 41'
respectively.
3 In case there is no line item mentioned in the FFC schedule (Nos. 15 to 44) with respect to revenue and
cost, kindly insert rows as required and highlight the same.
4 Market value of equity and preference shares should be determined based on the quoted closing price on
the BSE. If the shares are not listed on the BSE, then please consider the quoted closing price on the NSE.
If the shares are not listed on the BSE/NSE, then please consider the quoted closing price on the Regional
Stock Exchanges.
5 Expenses for loan arrangement, bill discounting, bank charges and guarantee commission should be
grouped under the head 'operating expenses-finance charges'.
6 Credit balances in bank accounts, if any, should be classified as 'sundry creditors' only if the same relates
to payments made to sundry creditors, else, the same should be considered as a part of borrowings.
7 Please read the segment instructions before filling the FFC format .
8 Any income/gain/loss related to investments and interest income on bank deposits/inter corporate deposits
(except in case of fund based financial services companies where it should be grouped under 'financial
services activity') should be grouped under 'investment activity' in the FFC.
9 In case of life insurance company, the corporate gratuity/pension fund management activity should be
classified as 'financial services activity' and therefore the corresponding revenue and cost should be
appropriately grouped in the 'financial services activity' in the FFC.
10 In case there are specific interest expenses related to investments the same should be classified under the
cost of investment activity (except in case of investment/fund based financial services companies where
such cost would be grouped under investment activity/ financial services activity respectively).
11 Please ensure that the income from a particular activity in the FFC (for e.g.: income from
telecommunication services) matches with the segment revenue of the same activity.
12 Please ensure that the schedule 28 - other income in the FFC matches with the unallocable income in the
segment reporting.
13 Please ensure that the cost of particular activity in FFC flows into segment expense fully in segment
14 Please ensure that the schedule 44 - Interest (Net) in the FFC matches with the unallocable interest
expenses (net) in the segment reporting.
FFC Instructions
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Not
Submitted/C Applicable/
Sr. No. Annexure No. INDEX ompleted Not Available
Certified Annual Report 2009-10 along with Consolidated Financial
1 Statements (CFS), of your Group, wherever available (3 Copies)
Certified Annual Report 2009-10 along with Consolidated Financial
2 Statements (CFS), of your Group, wherever available (Soft Copy PDF Format)
3 2 Audited Fit For Consolidation (FFC) Accounts
4 Fit for Consolidation certificate from your Auditors
Word document of the Consolidated Notes to Accounts & Accounting
5 policy,wherever applicable
6 Variation from TSL Consolidated Accounting Policies
7 3A Consolidated Cash Flow Statement for the year ended 31st March, 20010
8 3B Additional information in respect of Cash Flow Statement
9 4 Dividend Information
10 5 Purchase and Sale of Investments by your company during the F.Y. 2009-10
11 6A Movement
Investmentin byShare Capital of your Company
Subsidiary/Associate/JV of TSL and TSL in your Company in
12 6B 2009-10
Audited statement of goodwill/capital reserve for investment in associates
13 (Refer 'J' in Appendix)
14 8A Audited Related Party Details
Audited Reconciliation statements in case of unmatched Related party
15 transactions / year end balances
Assets on hand and outstanding as on 31.03.2010 arising out of transactions
with related parties (Refer 'L ii' in Appendix)
List of subsidiary companies,associate companies and joint ventures of your
16 9A company during the FY 2009-10
Details of subsidiary companies acquired/newly incorporated by your
17 9B Company during the year
18 9C Details of subsidiary companies disposed by your Company during the year
19 10B Segment Reporting Working Sheet
Audited Fit For Consolidation Segment Information for the year ended 31st.
20 10C March,2010
21 11A Contingent liability consolidation
22 11B Contingent liability - Break up of claims not acknowledged as debts- others
Contingent liabilities in the nature of Guarantees / Letter of credits or
23 11C comforts in relation to related parties as per list
24 12 Lease Disclosures
25 13 Deferred Tax consolidation
Disclosure for AS -15-Defined benefit: Post employment employee benefit
26 14A plans (Unfunded)
Disclosure for AS -15-Defined benefit: Post employment employee benefit
27 14B plans (Funded)
28 14C Disclosure for AS -15-Defined contribution plans
Foreign Exchange Currency exposures not covered by derivative instruments
29 15A as on 31st March, 2010
30 15B Derivative instruments outstanding as at 31st March, 2010
31 15C Cash flow hedges
32 16 Provisions movement and reconciliations
33 2 Audited Hard copies of the above information
34 Soft copy of the above information in excel format (Email id:
A1
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010 Annexure '2'
(Rs. in crores)
As at As at
31st March, 2010 31st March,
2009
Schedule
SOURCES OF FUNDS
SHAREHOLDERS' FUNDS
SHARE CAPITAL
Ordinary Shares
Preference Shares
1 0.01 0.01
TOTAL - -
APPLICATION OF FUNDS
FIXED ASSETS
(a) Gross Block - -
(b) Less: Accumulated Depreciation - -
(c) Net Block - -
(d) Capital Work-in-Progress (including capital advances) - -
5 - -
GOODWILL (On Consolidation)
INVESTMENTS 6 - -
DEFERRED TAX ASSETS (NET)
ASSETS HELD TO COVER LINKED LIABILITIES
CURRENT ASSETS, LOANS AND ADVANCES
Interest accrued on investments and deposits
Inventories 7 - -
Unbilled revenues
Sundry debtors 8 - -
Cash and bank balances 9 - 0.01
Other current assets 10 - -
Loans and advances 11 - -
- 0.01
Less: CURRENT LIABILITIES AND PROVISIONS
CURRENT LIABILITES 12 - 0.01
PROVISIONS 13 - -
- 0.01
NET CURRENT ASSETS - -
MISCELLANEOUS EXPENDITURE 14 - -
(to the extent not written off or adjusted)
TOTAL - -
Notes to Accounts 45
A2-BS
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010 Annexure '2'
(Rs. in crores)
As at
31st March, As at
2010 31st March, 2009
Schedule
INCOME
Income from Consultancy Services 15 - -
Income from Insurance Services (Net) 16 - -
Income from Telecommunication Services 17 - -
Income from Financial Services 18 - -
Income from Investment Activity 19 - -
Income from Oil and Gas Exploration 20 - -
Income from Direct to Home Services 21 - -
Income from Realty and Infrastructure 22 - -
Income from Business Process Outsourcing 23 - -
Income from Retail Activity 24 - -
Income from Research and Development 25 - -
Income from Trading Activity 26 - -
Income from ------- Activity 27 - -
Other Income 28 - -
- -
EXPENDITURE
Cost Of Consultancy Services 29 - -
Cost Of Insurance Services 30 - -
Cost Of Telecommunication Services 31 - -
Cost Of Financial Services 32 - -
Cost of Investment Activity 33 - -
Cost of Oil and Gas Exploration 34 - -
Cost of Direct to Home Services 35 - -
Cost of Realty and Infrastructure 36 - -
Cost of Business Process Outsourcing 37 - -
Cost of Retail Activity 38 - -
Cost of Research and Development 39 - -
Cost of Trading Activity 40 - -
Cost of --------- Activity 41 - -
Payments To And Provisions For Employees 42 0.00 0.00
Operating, Establishment And Other Expenses 43 0.01 0.00
Interest (Net) 44 0.00 0.00
Depreciation/Amortisation
Amortisation Of Financial Expenses
0.01 0.00
Notes to Accounts 45
A2-PL
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
As at 31st As at 31st March,
1 SHARE CAPITAL March, 2010 2009
AUTHORISED
10,000 equity shares of Rs 10 each 0.01 0.01
ISSUED
10,000 equity shares of Rs 10 each, fully paid-up 0.01 0.01
(Rs. in crores)
As at 31st Deductions/Adjust As at 31st
2 RESERVES AND SURPLUS March, 2009 Addition ments March, 2010
(a) Preference Capital Redemption Reserves -
(b) Capital Reserve -
(c) Capital Reserve On Consolidation -
(d) Securities Premium Account -
(e) General Reserve -
(f) Debenture Redemption Reserve -
(g) Legal Reserve -
(h) Foreign Currency Translation Reserve -
(i) Foreign Project Reserve -
(j) Revaluation Reserve -
(k) Special Reserve Account/Statutory Reserve -
(l) Investment Reserve -
(m) Hedging Reserve -
(n) Reserve for Research and Development -
(o) Contribution for Capital Expenditure -
(p) Amalgamation Reserve -
(q) Capital Subsidy -
(r ) Contingency Reserve -
(s) Exchange Fluctuation Reserve -
(t) Deferred taxation liability fund -
(u) Pension reserve -
(v) Available for sale securities reserve -
(w) Balance in Profit and Loss Account (0.01) (0.01) (0.02)
Total (0.01) (0.01) 0.00 (0.02)
Notes
Please provide all notes/disclosures as required by Companies Act, 1956 and disclosed in your audited accounts.
A2-Sch1-2
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
3 SECURED LOANS As at As at
31st March, 31st March,
(a) Short term (Repayable within 1 year) 2010 2009
(i) Non-Convertible Debentures
(ii) Convertible Debentures
(iii) From Financial Institutions
(iv) From Banks
Overdrafts
Other loans
(v) Buyers credit facility
(vi) Vendor Financing
(vii) From Tata Sons Limited
(viii) From subsidiary/fellow subsidiary company
(ix) From Others
(b) Long Term
(i) Non-Convertible Debentures
(ii) Convertible Debentures
(iii) From Financial Institutions
(iv) From Banks
(v) Buyers credit facility
(vi) Vendor Financing
(vii) From Tata Sons Limited
(viii) From subsidiary/fellow subsidiary company
(ix) From Others
Total - -
Please Note :
1 Short term loans will include those which are due for not more than one year as at the date of the Balance Sheet
2 Interest Accrued & Due should be included under appropriate sub-heads
3 Loans from Directors, managing agents, secretaries, treasurers and manager should be shown separately above
4 Where loans have been guaranteed by any of the above personnel, a mention shall be made
5 Nature of Security should be provided
(Rs. in crores)
4 UNSECURED LOANS As at As at
31st March, 31st March,
(a) Fixed Deposits from 2010 2009
(i) Shareholders
(ii) Others
(b) Short-Term Loans
(Repayable within 1 year)
(i) From Banks
Overdrafts
Other loans
(ii) From Financial Institutions
(iii) Non-Convertible Debentures
(iv) Convertible Debentures
(v) From Tata Sons Limited
(vi) From subsidiary/fellow subsidiary company
(vii) From Others
(c) Others
(i) From Banks
(ii) From Financial Institutions
(iii) Foreign Currency Convertible Bonds (FCCB)
(iv) Commercial Papers
(v) Non-Convertible Debentures
(vi) Convertible Debentures
(vii) Debenture Application Money
(v) From Tata Sons Limited
(vi) From subsidiary/fellow subsidiary company
(vii) From Others - ICD from Holding Company 0.01
Total 0.01 -
Please Note :
1 Short term loans will include those which are due for not more than one year as at the date of the Balance Sheet
2 Interest Accrued & Due should be included under appropriate sub-heads
3 Loans from Directors, managing agents, secretaries, treasurers and manager should be shown separately above
4 Where loans have been guaranteed by any of the above personnel, a mention shall be made
A2-Sch3-4
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
B Intangible Assets:
Goodwill - - - -
Film Rights - - - -
Intellectual Property Rights - - - -
Acquired Contract Rights - - - -
Indefeasible Right of Use ('IRU') - - - -
License Entry Fees - - - -
Computer software - - - -
Website Development Cost - - - -
Trading Rights in BSE - - - -
Development Cost - - - -
Placement fees - - - -
Total - - - - - - - - - - -
Previous Year 2008-09 - - -
CAPITAL WORK-IN-PROGRESS
(Including Capital Advances of
Rs. ------- [Previous Year Rs. -------])
GRAND TOTAL - -
Please note:
1 Amounts included in the above schedule on account of acquisition of a subsidiary needs to be identified & disclosed separately
2 The status of legal formalities, if any, relating to registration of assets needs to be mentioned
3 Any other material information which needs to be disclosed
A2-Sch5
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedule forming part of the Fit for Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
6 INVESTMENTS Book Value As Market Value Book Value As Market Value
at 31st March, As at 31st at 31st March, As at 31st
2010 March, 2010 2009 March, 2009
A2-Sch 6
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedule forming part of the Fit for Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
6 INVESTMENTS Book Value As Market Value Book Value As Market Value
at 31st March, As at 31st at 31st March, As at 31st
2010 March, 2010 2009 March, 2009
Notes:
1) Book value of quoted investments
2) Book value of unquoted investments
3) Market value of quoted investments
4)
The above amount includes Rs. ------ crores (31st March, 2009: Rs. ------- crores) pertaining to Life
Insurance business including Rs. ------ crores (31st March, 2009 :
Rs. -------- crores) towards Policy Holders Investments.
A2-Sch 6
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010 BSE
Please Note:
1 Total Book value and market value of Equity and Preference shares should match with Schedule 5 in the FFC
2 Market value of equity and preference shares is determined based on the quoted closing price on the BSE. If the shares are not listed on the BSE, then please consider the quoted closing price on the NSE. If
the shares are not listed on the BSE/NSE, then please consider the quoted closing price on the Regional Stock Exchanges.
3 Please ensure that Difference is "zero" always and print relevant portions only.
Paid Up Paid Up
Sr. Total No. of capital of Source of Total No. of capital of Source of
Name of the investee Company
No. No.of shares of Investee Market Market No.of shares of Investee Market Market
shares held Investee company Book Value Market Value per Price shares held Investee company Book Value Market Value per Price
as on company as (In Rs.) as Percentage as on Value as on share as on (BSE/NSE/o as on company as (In Rs.) as Percentage as on Value as on share as on (BSE/NSE/o
31.03.10 on 31.03.10 on 31.03.10 of Holding 31.03.10 31.03.10 31.03.10 thers) 31.03.09 on 31.03.09 on 31.03.09 of Holding 31.03.09 31.03.09 31.03.09 thers)
A B C D=(A/B)% E F G=(F/A) A B C D=(A/B)% E F G=(F/A)
1 Long Term-In TSL's subsidiaries
A2-Sch6-Ann
31st March, 2010 31st March, 2009
Paid Up Paid Up
Sr. Total No. of capital of Source of Total No. of capital of Source of
Name of the investee Company
No. No.of shares of Investee Market Market No.of shares of Investee Market Market
shares held Investee company Book Value Market Value per Price shares held Investee company Book Value Market Value per Price
as on company as (In Rs.) as Percentage as on Value as on share as on (BSE/NSE/o as on company as (In Rs.) as Percentage as on Value as on share as on (BSE/NSE/o
31.03.10 on 31.03.10 on 31.03.10 of Holding 31.03.10 31.03.10 31.03.10 thers) 31.03.09 on 31.03.09 on 31.03.09 of Holding 31.03.09 31.03.09 31.03.09 thers)
A B C D=(A/B)% E F G=(F/A) A B C D=(A/B)% E F G=(F/A)
4 Long Term-Others
Current-Insurance Business
5 (Policy Holders')
6 Current-Others
A2-Sch6-Ann
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
7 INVENTORIES As at As at
31st March, 31st March, 2009
(a) Stores and Spares 2010
(b) Raw Materials, Sub Assemblies and Components
(c) Construction Materials
(d) Construction work in progress (at cost)
(e) Work-in-progress
(f) Goods-in-Transit
(g) Finished Goods
(h) Land
Total - -
(Rs. in crores)
8 SUNDRY DEBTORS As at As at
31st March, 31st March, 2009
(a) Over Six Months 2010
(i) Secured and Considered good
(ii) Unsecured and Considered good
(iii) Unsecured and Considered Doubtful
- -
Less: Provision for doubtful debts
- -
(b) Others
(i) Secured and Considered good
(ii) Unsecured and Considered good
(iii) Unsecured and Considered Doubtful
- -
Less: Provision for doubtful debts
Less: Set off against advance billing
- -
(c) Future Finance Lease Receivable
Less: Unearned Finance Iincome
- -
Total - -
Please Note :
1 In case debtors are secured , please give the nature of security
2 Debts due by Directors or any officers of the Company have to be reported seperately.
3 Please ensure that doubtful debts are tallying with provision for doubtful debts
(Rs. in crores)
9 CASH AND BANK BALANCES As at As at
31st March, 31st March, 2009
(a) Cash on hand 2010
(b) Remittances in transit
(c) Cheques on hand
(d) Bank Balances
(i) with Scheduled Banks (please refer the list of scheduled banks in Annexure 18)
in Current Accounts - 0.01
in Deposit Accounts (please fill disclosure below)
(Under lien . Rs. with [Name of the Authority] )
Total - 0.01
Please Note :
Any credit (negative) balance in bank a/c should be shown under secured/unsecured loan as the case may be.
(Rs. in crores)
Disclosure : As at As at
31st March, 31st March, 2009
Deposit with Banks 2010
Maturity from Balance Sheet Date
A Maturing within 3 months
B Maturing within 3-12 months
C Maturing after 12 months
Total - -
Out of (A) above, deposits originally held upto 3 months (cash equivalent)
A2-Sch7-13
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
10 OTHER CURRENT ASSETS As at As at
31st March, 31st March, 2009
(a) Construction work-in-progress 2010
(b) Receivables Insurance Business
(c) Deposit with Reserve Bank Of India
(d) Others
Total - -
(Rs. in crores)
11 LOANS AND ADVANCES As at As at
31st March, 31st March, 2009
(a) Considered good 2010
(i) Advances recoverable in cash or in kind or for value to be received
(ii) Employee loans
(iii) Prepaid Expenses
(iv) Security Deposits
(v) Amount receivable from Customs / Excise Authorities
(vi) Advance Taxes
(vii) Inter Corporate Deposits
(viii)Advance recoverable from subsidiary & fellow subsidiary companies
(ix) Receivable under finance activity
Secured
Unsecured
(x) Assets retired from active use awaiting disposal
(xi) MAT Credit Entitlement
(xii) Others
Advances recoverable in cash or kind or for value to be received include fair values of foreign exchange forward and currency
option contracts Rs.---------- (Previous year Rs. ----------------)
(Rs. in crores)
12 CURRENT LIABILITIES As at As at
31st March, 31st March, 2009
(a) Sundry Creditors (please fill disclosure below): 2010
Dues of micro, small and medium enterprises
Dues of other creditors 0 0.01
(b) Advances from customers and distributors
(c) Interest accrued but not due on Loans
(d) Income received in advance
(e) Accrued Expenses
(f) Taxes Payable
(g) Liabilities Insurance Business
(h) Investor Education and Protection Fund (not due)
(i) Unpaid dividends
(ii) Unpaid matured debentures
(iii) Interest accrued on unpaid matured debentures & matured deposits
(iv) Matured Deposits
(i) Unclaimed Dividend
(j) Due to Subsidiary company
(k) Deposits from customers
(l) Unclaimed deposit
(m) Retention money
(n) Universal Service Obligation (USO) deferred income
(o) Deposits from Holding Company
(p) Other liabilities
Total - 0.01
Other liabilities include Fair value of foreign exchange forward and currency option contracts Rs.---------- (Previous year Rs.
----------------)
(Rs. in crores)
Disclosure : As at As at
31st March, 31st March, 2009
Capital Creditors 2010
A2-Sch7-13
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
Trade Creditors
Total - -
A2-Sch7-13
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
13 PROVISIONS As at As at
31st March, 31st March, 2009
(a) Provision for Employee Retirement Benefits 2010
(i) Provident Fund
(ii) Superannuation Scheme
(iii) Gratuity Fund
(iv) Others
(b) Provision for Taxation
(c) Proposed Dividends on
Equity Shares
Preference Shares
(d) Interim dividend
(e) Tax on divdend
(f) Premium on redemption of FCCB
(g) Reserve for Unexpired Risk
(h) Provisions for contingencies
(i) Others
Total - -
A2-Sch7-13
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Schedules forming part of the Fit For Consolidation Balance Sheet Annexure '2'
(Rs. in crores)
14 MISCELLANEOUS EXPENDITURE As at 31st. Addition Deductions/ As at 31st. As at 31st. Addition Deductions/ As at 31st.
(to the extent not written off or adjusted) March 2008 Adjustments March 2009 March2009 Adjustment March 2010
(a) Expenditure for Funding Acquisition of a Subsidiary - - s -
(b) Finance Set up Cost - - -
(c) Discount on Issue of Debentures - - -
(d) Share Issue Expenses - - -
(e) Preliminary Expenditure - - -
Total - - - - - - - -
Note:
Please provide all notes/disclosures as required by Companies Act, 1956 and disclosed in your audited accounts.
A2-Sch 14
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
(Rs. in crores)
15 INCOME FROM CONSULTANCY SERVICES Year ended Year ended
31st 31st March,
(a) Services rendered March, 2010 2009
(b) Sale of Equipments and software licences
(c) Exchange Gain / (loss) (Net)
(d) Profit/(Loss) on sale of fixed assets (Net)
(e) Excess provision for liabilities written back
(f) Miscellaneous Income
Total - -
(Rs. in crores)
16 INCOME FROM INSURANCE SERVICES Year ended Year ended
31st 31st March,
(a) Premium Earned (Net) March, 2010 2009
(b) Fees and Charges
(c) Exchange Gain / (loss) (Net)
(d) Profit/(Loss) on sale of fixed assets (Net)
(e) Excess provision for liabilities written back
(f) Dividends
(g) Interest income on investments
(h) Profit on sale of investments-Long Term (Net)
(i) Funds for future appropriations
(j) Unrealised gains on investments
(k) Miscellaneous Income
Total - -
(Rs. in crores)
17 INCOME FROM TELECOMMUNICATION SERVICES Year ended Year ended
31st 31st March,
(a) Services rendered March, 2010 2009
(b) Sale of Equipments
(c) Subsidies from DOT
(d) Exchange Gain / (loss) (Net)
(e) Profit/(Loss) on sale of fixed assets (Net)
(f) Excess provision for liabilities written back
(g) Writeback / (Provision) for damaged capital assets
(h) Miscellaneous Income
Total - -
(Rs. in crores)
18 INCOME FROM FINANCIAL SERVICES Year ended Year ended
31st 31st March,
(a) Fees and brokerage March, 2010 2009
(b) Interest Income on financing activity/ICDs
[Interest on bank deposits in case of fund based financial services company
(c) also to be
Income grouped
from here] (only in case of fund based financial services company to be grouped here)
investments
(d) Profit/(Loss) on sale of investments - long term (Net)
(e) Exchange Gain / (loss) (Net)
(f) Profit/(Loss) on sale of fixed assets (Net)
(g) Excess provision for liabilities written back
(h) Miscellaneous Income
Total - -
(Rs. in crores)
19 INCOME FROM INVESTMENT ACTIVITY Year ended Year ended
31st 31st March,
(a) Income from long term investments in immovable properties March, 2010 2009
(b) Diminution in value of investment written back
(c) Dividend
(d) Interest Income
(i) On Investments
(ii) On Inter-corporate deposits
(iii) On staff loan
(iv) On bank deposits
(v) Others
(e) Profit/(Loss) on sale of investments - long term (Net)
(f) Profit/(Loss) on sale of investments - current (Net)
(g) Exchange Gain / (loss) (Net)
(h) Profit/(Loss) on sale of fixed assets (Net)
(i) Excess provision for liabilities written back
(j) Unrealised gains on investment
(k) Miscellaneous Income
Total - -
(Rs. in crores)
20 INCOME FROM OIL AND GAS EXPLORATION Year ended Year ended
31st 31st March,
(a) Sale of Crude Oil March, 2010 2009
(b) Sales of Gas
(c) Sale of Condensate and Commingled Crude
(d) Increase/(Decrease) in Crude Oil Stock
(e) Exchange Gain / (loss) (Net)
(f) Profit/(Loss) on sale of fixed assets (Net)
(g) Excess provision for liabilities written back
(h) Interest income on site restoration deposit
(i) Miscellaneous Income
Total - -
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
(Rs. in crores)
21 INCOME FROM DIRECT TO HOME SERVICES Year ended Year ended
31st 31st March,
(a) Sale of Set Top Boxes and other traded items March, 2010 2009
(b) Subscription,installation and service revenue
(c) Exchange Gain / (loss) (Net)
(d) Profit/(Loss) on sale of fixed assets (Net)
(e) Excess provision for liabilities written back
(f) Writeback / (Provision) for damaged capital assets
(g) Miscellaneous Income
Total - -
(Rs. in crores)
22 INCOME FROM REALTY AND INFRASTRUCTURE Year ended Year ended
31st 31st March,
(a) Sale of Property March, 2010 2009
(b) Management and advisory fees
(c) Exchange Gain / (loss) (Net)
(d) Profit/(Loss) on sale of fixed assets (Net)
(e) Excess provision for liabilities written back
(f) Miscellaneous Income
Total - -
(Rs. in crores)
23 INCOME FROM BUSINESS PROCESS OUTSOURCING Year ended Year ended
31st 31st March,
(a) Service Charges March, 2010 2009
(b) Income from Manpower and Transaction activity
(c) Exchange Gain / (loss) (Net)
(d) Profit/(Loss) on sale of fixed assets (Net)
(e) Excess provision for liabilities written back
(f) Miscellaneous Income
Total - -
(Rs. in crores)
24 INCOME FROM RETAIL ACTIVITY Year ended Year ended
31st 31st March,
(a) Sale of traded retail items March, 2010 2009
(b) Display Income
(c) Exchange Gain / (loss) (Net)
(d) Profit/(Loss) on sale of fixed assets (Net)
(e) Excess provision for liabilities written back
(f) Miscellaneous Income
Total - -
(Rs. in crores)
25 INCOME FROM RESEARCH AND DEVELOPMENT Year ended Year ended
31st 31st March,
(a) Research and development income March, 2010 2009
(b) Exchange Gain / (loss) (Net)
(c) Profit/(Loss) on sale of fixed assets (Net)
(d) Excess provision for liabilities written back
(e) Miscellaneous Income
Total - -
(Rs. in crores)
26 INCOME FROM TRADING ACTIVITY Year ended Year ended
31st 31st March,
(a) Sale of traded items March, 2010 2009
(b) Exchange Gain / (loss) (Net)
(c) Profit/(Loss) on sale of fixed assets (Net)
(d) Excess provision for liabilities written back
(e) Miscellaneous Income
Total - -
(Rs. in crores)
27 INCOME FROM ----------------- ACTIVITY (See instructions) Year ended Year ended
31st 31st March,
(a) Income from ------------------- activity March, 2010 2009
(b) Exchange Gain / (loss) (Net)
(c) Profit/(Loss) on sale of fixed assets (Net)
(d) Excess provision for liabilities written back
(e) Writeback / (Provision) for damaged capital assets
(f) Miscellaneous Income
Total - -
(Rs. in crores)
28 OTHER INCOME Year ended Year ended
31st 31st March,
(a) Income from Services (Brand Equity) March, 2010 2009
(b) Miscellaneous Income
Total - -
(Rs. in crores)
29 COST OF CONSULTANCY SERVICES Year ended Year ended
31st 31st March,
(a) Overseas business expenses March, 2010 2009
(b) Services rendered by business associates and Others
(c) Product Expenses
(d) Material costs
(e) Cost of Software licenses
(f) Software, hardware and material cost
(g) Cost Capitalised
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
(Rs. in crores)
31 COST OF TELECOMMUNICATION SERVICES Year ended Year ended
31st 31st March,
(a) Interconnect Charges March, 2010 2009
(b) License Fee under Revenue Sharing Arrangement (incl. ISP revenue share)
(c) Royalty and License fee to Wireless Planning Commission
(d) Network Operation Expenses
(e) Material Consumption
(f) Cost Of Goods And Equipments Sold
(g) Preoperating expenses
(h) Infrastructure operating expenses
(i) Customer Acquisition/Care costs
(j) Other Expenses
Total - -
(Rs. in crores)
32 COST OF FINANCIAL SERVICES Year ended Year ended
31st 31st March,
(a) Scheme related expenses March, 2010 2009
(b) Interest expense
(i) On Loans for fixed period
(ii) On Other Loans
(iii) discounting charges on commercial paper
(c) Change in fair value
(d) Provision for diminution in value of investments
(e) Amortisation of financial expenses
(f) Loss on sale of investments
(g) Miscellaneous expenses
Total - -
(Rs. in crores)
33 COST OF INVESTMENT ACTIVITY Year ended Year ended
31st 31st March,
(a) Interest expense March, 2010 2009
(i) On Loans for fixed period
(ii) On Other Loans
(iii) Inter-corporate deposits
(iv) Others
(v) Premium payable on swaps
(b) Provision for diminution in value of investments
(c) Unrealised loss on investments
(d) Miscellaneous expenses
Total - -
(Rs. in crores)
34 COST OF OIL AND GAS EXPLORATION Year ended Year ended
31st 31st March,
(a) Share of Profit of Government of India under production sharing contracts March, 2010 2009
(b) Cost of Production
Total - -
(Rs. in crores)
35 COST OF DIRECT TO HOME SERVICES Year ended Year ended
31st 31st March,
(a) Installation cost March, 2010 2009
(b) Warehousing and other charges
(c) Transmission and related cost
(d) Subscriber management cost
(e) Programming Cost
(f) License fees (Revenue share)
(g) Cost Of Goods And Equipments Sold
Total - -
(Rs. in crores)
36 COST OF REALTY AND INFRASTRUCTURE Year ended Year ended
31st 31st March,
(a) Expenditure on completed projects March, 2010 2009
(b) Cost of Sales
Total - -
(Rs. in crores)
37 COST OF BUSINESS PROCESS OUTSOURCING Year ended Year ended
31st 31st March,
(a) Collection charges call centre March, 2010 2009
(b) Connectivity/communication expenses
(c) Equipment hire/maintenance
Total - -
(Rs. in crores)
38 COST OF RETAIL ACTIVITY Year ended Year ended
31st 31st March,
Cost Of Goods And Equipments Sold March, 2010 2009
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
(Rs. in crores)
39 COST OF RESEARCH & DEVELOPMENT ACTIVITY Year ended Year ended
31st 31st March,
(a) Expenditure on Research March, 2010 2009
Total - -
(Rs. in crores)
40 COST OF TRADING ACTIVITY Year ended Year ended
31st 31st March,
Cost Of Goods And Equipments Sold March, 2010 2009
Total - -
(Rs. in crores)
41 COST OF ------------------ ACTIVITY (See instructions) Year ended Year ended
31st 31st March,
(a) March, 2010 2009
(b)
Total - -
(Rs. in crores)
42 PAYMENTS TO AND PROVISIONS FOR EMPLOYEES Year ended Year ended
31st 31st March,
(a) Salaries, Wages and Bonus March, 2010 2009
(b) Contribution to Provident and Other Funds
(i) Provident Fund
(ii) Superannuation Scheme
(iii) Gratuity Fund
(iv) Employees Pension
(v) Employees State Insurance Scheme
(vi) Movement in Pension Deficit
(vii) Social Securtiy and other benefit plans
(viii) Others
(c) Staff Welfare expenses
(d) Compensation under Voluntary Retirement scheme
Total - -
(Rs. in crores)
43 OPERATING, ESTABLISHMENT AND OTHER EXPENSES Year ended Year ended
31st 31st March,
(a) Advertising and Sales Promotion March, 2010 2009
(b) Legal and Professional Fees 0.01 -
(c) Rent
(d) Travel and Conveyance
(e) Electricity, Power and Fuel
(f) Repairs and Maintenance
Buildings
Machinery
Others
(g) Customer Acquisition Costs
(h) Insurance
(i) Communication Expenses
(j) Provision for Doubtful Debts
(k) Provision for Doubtful Advances
(l) Bad debts written off
(m) Advances written off
(n) Provisions for contingencies
(o) Provision for slow moving capital assets
(p) Provision for others
(q) Commission and Incentives
(r) License Fees (Revenue Share)
(s) Rates and taxes - -
(t) Printing and Stationery
(u) Auditors Remuneration
(i) As auditor - -
(ii) As adviser
Taxation matters
Company law matters
Management services
(iii) In any other manner
(v) Postage and Telegram
(w) Entertainment expenses
(x) Inventory adjustment
(y) Administration and other expenses
(z) Director sitting fees
(aa) Director commission
(ab) Debenture issue expenses
(ac) Brokerage
(ad) Immoveable property expenses
(ae) Exploration cost written off
(af) Capital assets written off
(ag) Finance charges
(ah) Recruitment and Training expenses
(ai) Miscellaneous Expenses -
Total 0.01 -
Any expenditure exceeding 1% of the total revenue of the company or Rs 5000 (whichever is higher) shall be shown as a separate and distinct line item.
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
(Rs. in crores)
44 INTEREST (NET) Year ended Year ended
31st 31st March,
(a) Interest Expenses March, 2010 2009
(i) On Loans for fixed period
(ii) On Other Loans
(iii) Inter-corporate deposits
(iv) Others
(v) Premium payable on swaps
Less: Interest capitalised
Less: Apportioned to projects
- -
(b) Less: Interest Income
(i) On refund from Income Tax Dept.
(ii) On staff loan
(ii) Others
- -
Total - -
Note:
Please provide all notes/disclosures as required by Companies Act, 1956 and disclosed in your audited accounts.
A2-Sch 15-44
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Liabilities
9 Minority Interest Unallocable Unallocable Unallocable
10 Deferred Tax Liability Unallocable Unallocable Unallocable
11 Provisions-for taxation Unallocable Unallocable Unallocable
12 Provisions-for proposed dividend including tax thereon Unallocable Unallocable Unallocable
13 Secured/Unsecured Loan Allocate to Investment Segment Allocate to Financial segment Unallocable *
14 Current Liabilities-Interest accrued on the above loan but not due
Allocate to Investment Segment Allocate to Financial segment Unallocable *
Current Liabilities-Unclaimed Div/Investor Education And
15 Protection Fund Unallocable Unallocable Unallocable
Profit and
Interest Loss items
Income-on inter corporate deposits/bank deposits
and Income/Gain/Loss on Investment-For E.g. Dividend Allocate to Investment Segment Allocate to Financial Segment Allocate to Investment Segment
Income/interest income/Profit/(Loss) on sale of investment [in FFC this income/ gain should [in FFC this income/ gain should [in FFC this income/ gain should be
1 (Net) be grouped in schedule 19] be grouped in schedule 18] grouped in schedule 19]
Unallocable
Allocate to Investment Segment Allocate to Financial segment [in FFC this income/gain should be
[in FFC this expense should be [in FFC this expense should be grouped in schedule 44 as the case
2 Interest Expense grouped in schedule 33] grouped in schedule 32] may be] *
* In case there are specific liabilities/ interest expenses related to investments, the same should be allocated under the investment segment.
A10A
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Name of Subsidiary/Joint Venture Company: Annexure '10B'
2008-2009
Busine
Teleco Oil Direct Realty ss
mmuni Financi and to and Proces Researc
Consulta Insuranc cation al Investme Gas Home Infrast s Retail h and Total as
ncy e Service Servic nt Explor Servic ructur Outso Activit Develop Trading --------- Unalloca per P&L Differen
Segments Services Services s es Activity ation es e urcing y ment Activity Activity ted Cost Total a/c ce
Costs
Cost of activity as per P&L - - - - - - - - - - - - - - - -
Payments To And Provisions For Employees - - -
Operating, Establishment And Other Expenses - - -
Depreciation/Amortization - - -
Amortization Of Financial Expenses - - -
Total Segment Expense - - - - - - - - - - - - - - - - -
A10B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Name of Subsidiary/Joint Venture Company: Annexure '10B'
2009-2010
Busine
Teleco Oil Direct Realty ss
mmuni Financi and to and Proces Researc
Consulta Insuranc cation al Investme Gas Home Infrast s Retail h and Unalloca
ncy e Service Servic nt Explor Servic ructur Outso Activit Develop Trading --------- ted Total as Differen
Segments Services Services s es Activity ation es e urcing y ment Activity Activity Assets Total per B/S ce
Assets
Investments - - -
Fixed Assets - - -
Goodwill on consolidation - - -
Deferred tax assets - - - -
Assets
Currentheld to cover linkaccrued
Assets-interest liabilities
on investments & - - -
deposits - -
Current Assets- Cash & Bank bal other than Bank
deposits - - -
Current Assets- Bank deposits - - -
Balance Current Assets - - -
Loans And Advances- Advance tax - - - -
Loans And Advances- MAT Credit Entitlement - - - -
Loans And advances- ICDs - - -
Other Loans And advances - - -
Misc Expenditure - - -
Total Assets - - - - - - - - - - - - - - - - -
2008-2009
Busine
Teleco Oil Direct Realty ss
mmuni Financi and to and Proces Researc
Consulta Insuranc cation al Investme Gas Home Infrast s Retail h and Unalloca
ncy e Service Servic nt Explor Servic ructur Outso Activit Develop Trading --------- ted Total as Differen
Segments Services Services s es Activity ation es e urcing y ment Activity Activity Assets Total per B/S ce
Assets
Investments - - -
Fixed Assets - - -
Goodwill on consolidation - - -
Deferred tax assets - - - -
Assets held
Current to cover linkaccrued
Assets-interest liabilities
on investments & - - -
deposits
Current Assets- Cash & Bank bal other than Bank - -
deposits - - -
Current Assets- Bank deposits - - -
Balance Current Assets - - -
Loans And Advances- Advance tax - - - -
Loans And Advances- MAT Credit Entitlement - - - -
Loans And advances- ICDs - - -
Other Loans And advances - - -
Misc Expenditure - - -
Total Assets - - - - - - - - - - - - - - - - -
A10B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Name of Subsidiary/Joint Venture Company: Annexure '10B'
2009-2010
Busine
Teleco Oil Direct Realty ss
mmuni Financi and to and Proces Researc Unalloca
Consulta Insuranc cation al Investme Gas Home Infrast s Retail h and ted
ncy e Service Servic nt Explor Servic ructur Outso Activit Develop Trading --------- Liabilitie Total as Differen
Segments Services Services s es Activity ation es e urcing y ment Activity Activity s Total per B/S ce
Liabilities
Minority Interest - - - -
Loan funds Secured - - -
Loan funds Unsecured - 0.01 -0.01
Deferred Tax Liability (Net) - - - -
Policy Holders' Fund - - -
Provision For Linked Liabilities - - -
Fair Value Change Account - - -
Funds For Future Appropriation - - -
Fund - - - -
Current Liabilities-Unclaimed dividend - - - -
Current Liabilities-Interest accrued but not due on
loans - - -
Current Liabilities-Others - - -
Provisions-Provision for tax - - - -
Provisions-Provision for dividend including taxation - - - -
Other Provisions - - -
Total Liabilities - - - - - - - - - - - - - - - 0.01 -0.01
2008-2009
Busine
Teleco Oil Direct Realty ss
mmuni Financi and to and Proces Researc Unalloca
Consulta Insuranc cation al Investme Gas Home Infrast s Retail h and ted
ncy e Service Servic nt Explor Servic ructur Outso Activit Develop Trading --------- Liabilitie Total as Differen
Segments Services Services s es Activity ation es e urcing y ment Activity Activity s Total per B/S ce
Liabilities
Minority Interest - - - -
Loan funds Secured - - -
Loan funds Unsecured - - -
Deferred Tax Liability (Net) - - - -
Policy Holders' Fund - - -
Provision For Linked Liabilities - - -
Fair Value Change Account - - -
Funds For Future Appropriation - - -
Fund - - 0.01 -0.01
Current Liabilities-Unclaimed dividend - - - -
Current Liabilities-Interest accrued but not due on
loans - - -
Current Liabilities-Others - - -
Provisions-Provision for tax - - - -
Provisions-Provision for dividend including taxation - - - -
Other Provisions - - -
Total Liabilities - - - - - - - - - - - - - - - 0.01 -0.01
A10B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Name of Subsidiary/Joint Venture Company: Annexure '10B'
Total - -
A10B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Name of Subsidiary/Joint Venture Company: Annexure '10B'
2008-2009
Total
as per Differe
Segments Europe Others India AmericaUnallocatedTotal B/S nce
Assets
Investments - - -
Fixed Assets - - -
Goodwill on consolidation - - -
Deferred tax assets - - -
Assets held
Current to cover linkaccrued
Assets-interest liabilities
on investments & - - -
deposits
Current Assets- Cash & Bank bal other than Bank - -
deposits - - -
Current Assets- Bank deposits - - -
Balance Current Assets - - -
Loans And Advances- Advance tax - - -
Loans And Advances- MAT Credit Entitlement - - -
Loans And advances- ICDs - - -
Other Loans And advances - - -
Misc Expenditure - - -
Total Assets - - - - - - - -
Total - -
A10B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
A10C
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '3A'
Consolidated Cash Flow Statement for the year ended 31st March, 2010
Instructions
1 Please do not delete any rows.
2 Insurance companies are required to prepare the cashflow in the indirect method.
3 If there is a need to insert additional rows for new items under any head (A, B or C) please insert rows
where highlighted in yellow.
4 In case of a new subsidiary company please prepare the cash flow statement from the date
of becoming a subsidiary (Profit and Loss items should be given proportionately in days
including the date of becoming a subsidiary)
5 In case of a company which ceases to be a subsidiary company, please prepare the cash flow
statement upto the date of cessation.
5 Please disclose any any non cash transactions as per para 40 of AS 3 by way of a note to the
cashflow
Rs. in crores
2010 2009 Remarks/Notes
A Cash flow from operating activities :
Profit before taxation, extraordinary items, exceptional and
prior period items
Adjustments for :
Depreciation / Amortisation of intangible assets
Impairment of assets
Miscellaneous expenditure written off
Deferred revenue expenditure
Provision / (write back) for doubtful debts and advances
Provision / (write back) for foreseeable losses
Provision / (write back) for slow moving capital assets
Provision / (write back) for irrecoverable and damaged assets
Provision / (write back) for damaged capital assets
Provision / (write back) for handset subsidy
Provision / (write back) for others/ contingencies
Provision / (write back) for diminution in the value of investments
Exploration costs written off
Provision for retirement benefits
Loss / (profit) on sale of fixed assets (net) / fixed assets written off
Loss/ (profit) on sale of investments (net)
Loss/ (profit) on sale of mutual funds and other current investments
(net) (profit) on sale of investment in TSL's subsidiaries (net)
Loss/
Loss/ (profit) on sale of investment in TSL's associates (net)
Loss/ (profit) on sale of investment in TSL's joint venture (net)
(Increase)/ Decrease of cost over the fair value of current
investments
Amortisation (net)
of forward cover premium
Unrealised (gains) / loss on foreign exchange
Exchange differences arising on consolidation net (gain) /loss
Interest expenses
Finance charges
Interest income
Dividend income
Unrealised (Gains)/Loss on Investment
Change in valuation of Policy liability
Funds for future appropriations
Transfer to Unit Linked Funds
Adjustments for:
Interest accrued on investments
Inventories
Unbilled revenues
Debtors
Other current assets
Loans & advances
Current liabilities
Provisions
Cash flow before extraordinary, exceptional and prior
period items
Extraordinary items
Exceptional items
Prior period items
A3A
Rs. in crores
2010 2009 Remarks/Notes
Relevant Notes :
(i) Figures in brackets represent outflows.
(ii) Interest paid is exclusive of, and purchase of Fixed Assets is inclusive of, interest capitalised Rs.------------
(iii) …..
(iv) ….
(v) Previous years figures have been recasted/restated wherever necessary.
A3A
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '3B'
Movement in CWIP
Opening Balance of CWIP as on 01.04.08
Add: Additions during the year
Less: Transferred to fixed asset
Add/Less: Any other adjustments (please specify)
Closing Balance of CWIP as on 31.03.09
Related party information in respect of capital creditors, capital debtors, CWIP and capital advances.
Rs. in crores
2009-2010 Party name --- Party name --- Party name --- Total
Capital creditors outstanding as at the year end
Capital advances made (outstanding as at the year end)
2008-2009 Party name --- Party name --- Party name --- Total
Capital creditors outstanding as at the year end
Capital advances made (outstanding as at the year end)
2007-2008 Party name --- Party name --- Party name --- Total
Capital creditors outstanding as at the year end
Capital advances made (outstanding as at the year end)
A3B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010 Associate
Subsidiary
Name of Subsidiary/Joint Venture Company: JV
Annexure 4 TSL
Dividend Information
All amounts are in Rupees.
Dividend Dividend
income expense
Particulars
received from paid to
Amount in Rs Rs
Final Dividend of FY 2008-09
Tata Sons Limted (TSL)
TSL Subsidiaries
TSL Associates
TSL Joint ventures
Other companies
Mutual funds
Sub-total (A) - -
Dividend Received by your Company from Tata Sons Limited / fellow subsidiary / joint venture / associate company of
TSL during the F.Y. 2009-10
Total -
Check -
Total -
Check -
Total
Dividend Paid by your Company to Tata Sons Limited / fellow subsidiary / joint venture / associate company of TSL during the
F.Y. 2009-10
Company
Rs. per receiving
Sr. No. Nature of Dividend No. of shares share Amount in Rs. Tax on Dividend Dividend Type
1 Final Dividend of FY 2008-09
Total - -
Check -
Total - -
Check -
A4
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010 Equity Share
Preference Share
Name of Subsidiary/Joint Venture Company: Debentures & Bonds
Mutual Funds
Annexure '5' Others
Purchase of Sale of
Investments Investments
Particulars
from to
Amount in Rs Amount in Rs
Tata Sons Limted (TSL)
TSL Subsidiaries
TSL Joint ventures
TSL Associates
Parties having significant Influence
Other companies / open market
Mutual funds
Total - -
Purchase of Investments from Tata Sons Limited / fellow subsidiaries / joint Ventures during the F.Y. 2009-10
Purchased
Name of the Company whose Type of from No.of
securities are purchased / Securities [Name of shares/units Date of Cost (in local
Sr. No. subscribed Purchased company] purchased Purchase currency) Cost in INR
Total - -
Check -
Purchase of Investments from TSL associates and Parties having Significant Influence during the F.Y. 2009-10
Purchased
Name of the Company whose Type of from No.of
securities are purchased / Securities [Name of shares/units Date of Cost (in local
Sr. No. subscribed Purchased company] purchased Purchase currency) Cost in INR
Total 0 0
Check -
Purchased
Name of the Company whose Type of from No.of
securities are purchased / Securities [Name of shares/units Date of Cost (in local
Sr. No. subscribed Purchased company] purchased Purchase currency) Cost in INR
Total 0 0
Check -
Sale of Investments to Tata Sons Limited / fellow subsidiaries / joint Ventures during the F.Y. 2009-10
Sale to No.of
Name of the Company whose Type of [Name of shares/units Consideration Profit/(Loss)
Sr. No. securities were sold Securities Sold company] sold Date of Sale (Rs.) Cost (Rs.) on sale
Total 0 0 0
Check -
Sale of Investments to TSL associates and Parties having Significant Influence during the F.Y. 2009-10
Sale to No.of
Name of the Company whose Type of [Name of shares/units Consideration Profit/(Loss)
Sr. No. securities were sold Securities Sold company] sold Date of Sale (Rs.) Cost (Rs.) on sale
Total 0 0 0
Check -
Sale to No.of
Name of the Company whose Type of [Name of shares/units Consideration Profit/(Loss)
Sr. No. securities were sold Securities Sold company] sold Date of Sale (Rs.) Cost (Rs.) on sale
Total 0 0 0
Check -
A5
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '6A'
Premiu Value
Date of No. of Face m/Disco Per Amoun
Particulars Issue shares Value unt Share t in Rs.
Opening Share Capital as on 01.04.09
Equity
Preference
Additions during the year
a) Rights Issue
b) Bonus
c) Pref.Allotment
d) Others (Please give details)
Annexure '6B'
A6
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '8A(i)'
Instructions:
1 Please enter all amounts in full figures (Rs.)
2 Please enter all amounts with respect to a related party with effect from the date of it becoming a related party (Refer
3 Please enter all transactions with respect to a related party upto the date it ceases to be a related party (Refer Annexu
A8A(i)
RELATED PARTIES AS PER LIST ATTACHED Account Line Item in Fit
Head in For
Annual Consolidation
Audited Accounts
R1 R2 etc TOTAL Accounts
21 Provision for Diminution in Value of Investments
Provision for Diminution in Value of Investments made
21A during the year
corresponding previous year figures
Provision for Diminution in Value of Investments made
21B in earlier years and Written Back during the year
corresponding previous year figures
Provision for Diminution in Value of Investments [year
21C end balance]
corresponding previous year figures
Reimbursements
Expenses Incurred by Related Party [along with
22 details]
corresponding previous year figures
Expenses Incurred on Behalf of Related Party [along
23 with details]
corresponding previous year figures
Debit /Credit Notes
24 Credit Note Issued
corresponding previous year figures
25 Debit Note Raised
corresponding previous year figures
Fixed Assets
26 Purchase of Fixed Assets [along with details]
corresponding previous year figures
27 Sale of Fixed Assets [along with details]
corresponding previous year figures
28 Profit/(Loss) on Sale of Fixed Assets
corresponding previous year figures
Investments/Issue/Subscription/Redemption
29 Bonus Shares Issued
corresponding previous year figures
30 Bonus Shares Received
corresponding previous year figures
31 Issue of Shares under ESPS/ESOP
corresponding previous year figures
32 Redemption of Securities [along with details]
corresponding previous year figures
33 Buyback of Shares [along with details]
corresponding previous year figures
Outstanding Balances
34 Outstanding Payables [year end balance]
corresponding previous year figures
35 Outstanding Receivables [year end balance]
corresponding previous year figures
Guarantees and Collaterals
35 Guarantees and Collaterals Received
35A Guarantees and Collaterals Received during the year
corresponding previous year figures
35B Guarantees and Collaterals Repaid during the year
Guarantees
corresponding andprevious
Collaterals
yearOutstanding
figures [year end
35C balance]
corresponding previous year figures
36 Guarantees and Collaterals Given
36A Guarantees and Collaterals Given during the year
corresponding previous year figures
36B Guarantees and Collaterals Recovered during the year
Guarantees
corresponding andprevious
Collaterals
yearOutstanding
figures [year end
36C balance]
corresponding previous year figures
Unbilled/Unearned Revenue
37 Unbilled Revenue
37A Unbilled Revenue made during the year
corresponding previous year figures
37B Unbilled Revenue reversed during the year
corresponding previous year figures
37C Unbilled Revenue Outstanding [year end balance]
corresponding previous year figures
38 Unearned Revenue
corresponding previous year figures
A8A(i)
RELATED PARTIES AS PER LIST ATTACHED Account Line Item in Fit
Head in For
Annual Consolidation
Audited Accounts
R1 R2 etc TOTAL Accounts
A8A(i)
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
A8A(ii)
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '8B'
List of Related Parties of Tata Sons Ltd. as on 31st March 2010
Subsidiaries
1 Computational Research Laboratories Limited
2 Ewart Investment Private Limited
3 Ewart Investments Limited
4 Infiniti Retail Limited
5 Tata AIG General Insurance Company Limited
6 Tata AIG Life Insurance Company Limited
7 Panatone Finvest Limited
8 Tata Investment Corporation Limited
9 Tata Limited
10 Tata Petrodyne Limited
11 Tata Trustee Company Limited (formerly Tata Trustee Company Private Limited)
12 e-Nxt Financials Limited
13 TS Investments Limited (w.e.f. 07.01.2010)
14 Tata Advanced Systems Limited (w.e.f. 26.09.2008)
15 Nova Integrated Systems Limited (w.e.f. 26.09.2008)
16 Tara Aerospace Systems Limited (w.e.f. 26.09.2008)
17 TRIF Constructions Private Limited (w.e.f.31.12.2008)
18 TRIF Erectors Private Limited (w.e.f.31.12.2008)
19 Tata Asset Management Limited
20 Tata Asset Management (Mauritius) Private Limited
21 Tata Pension Management Limited
22 Tata Business Support Services Limited
23 Good Health TPA Services Limited (w.e.f. 11.09.2008)
24 Tata Capital Limited
25 Tata Capital Housing Finance Limited (w.e.f. 15.10.2008)
26 Tata Capital Markets Limited
27 Tata Capital Pte. Limited (w.e.f. 17.07.2008)
28 TC Travel And Services Limited (w.e.f. 15.10.2008)
29 Tata Capital Markets Pte. Limited (w.e.f. 05.12.2008)
30 Tata Capital Advisors Pte. Limited (w.e.f. 05.12.2008)
31 Tata Capital Plc (w.e.f. 10.11.2009)
32 Tata Securities Limited
33 T Sec Commodities Broking Ltd (w.e.f. 26.10.2009)
34 Tata Housing Development Company Limited
35 Concept Marketing and Advertising Limited
36 Smart Value Homes Private Limited (w.e.f. 08.09.2009)
37 Tata International AG, Zug
38 Tata AG, Zug
39 TRIF Investment Management Limited
40 Tata Sky Limited
41 ACTVE Digital Services Private Limited (w.e.f. 21.04.2008)
42 Tata Teleservices Limited
43 Tata Internet Services Limited
44 Wireless - TT Info Services Limited
45 Tata Teleservices (Maharashtra) Limited
46 21st Century Infra Tele Limited (w.e.f. 01.07.2008)
47 Tata Consulting Engineers Limited (formerly TCE Consulting Engineers Limited)
48 TCE QSTP-LLC (w.e.f. 07.07.2008)
49 Tata Realty and Infrastructure Limited
50 Acme Living Solutions Private Limited (w.e.f. 27.01.2009)
51 Ahinsa Realtors Private Limited
52 Ardent Properties Private Limited (w.e.f.19.12.2008)
53 Arrow Infraestate Private Limited (w.e.f.30.09.2008)
54 Gurgaon Construct Well Private Limited (formerly Unitech Construct Well Private Limited) (w.e.f.30.09.2008)
55 Gurgaon Infratech Private Limited (formerly Unitech Infratech Private Limited) (w.e.f.30.09.2008)
56 Gurgaon Realtech Limited (formerly Unitech Real Tech Limited) (w.e.f. 30.09.2008)
57 Landscape Structures Private Limited (w.e.f.19.12.2008)
58 Pioneer Infratech Private Limited
59 TRIF Gandhinagar Projects Private Limited
60 TRIF Gurgaon Housing Projects Private Limited (w.e.f. 24.06.2009)
61 TRIF Hyderabad Projects Private Limited
62 TRIF Infrastructure Private Limited
63 TRIF Kochi Projects Private Limited (Ceased to be a subsidiary w.e.f.31.03.2010)
64 TRIF Kolkata Projects Private Limited
65 TRIF Mega Projects Private Ltd (w.e.f.31.12.2008)
66 TRIL Logistics Private Limited (formerly TRIF Modern Superstructures Private Limited) (w.e.f.31.12.2008)
A8B
67 TRIF Property Development Private Limited
68 TRIF Real Estate and Development Private Limited
69 TRIF Realty Projects Private Limited
70 TRIF Structures and Builders Private Limited (w.e.f.31.12.2008)
71 TRIF Trivandrum Projects Private Limited
72 TRIL Airport Developers Limited
73 TRIL Constructions Limited
74 TRIL Developers Limited
75 TRIL Roads Private Limited (formerly Navinya Buildcon Private Limited)
76 TRIF Amritsar Projects Private Limited (w.e.f.18.09.2008 and ceased to be a subsidiary w.e.f. 01.03.2009)
77 Tata Consultancy Services Limited
78 APONLINE Limited
79 C-Edge Technologies Limited
80 CMC Americas Inc
81 CMC Limited
82 Custodia De Documentos Interes Limitada
83 Diligenta Limited
84 ERI Holdings Corp.(w.e.f. 05.06.2009)
85 Exegenix Research Inc. (w.e.f. 05.06.2009)
86 Financial Network Services (Africa) (Pty) Ltd. (Ceased to be a subsidiary w.e.f. 05.03.2010)
87 Financial Network Services (Beijing) Co. Ltd.
88 Financial Network Services (Europe) Plc (Ceased to be a subsidiary w.e.f. 02.12.2008 )
89 Financial Network Services (H.K.) Limited
90 Financial Network Services Malaysia Sdn Bhd (Liquidated on 16.6.2009. Hence ceased to be a subsidiary)
91 MGDC S.C. (w.e.f. 01.01.2010)
92 MP Online Limited
93 PT Financial Network Services
94 PT Tata Consultancy Services Indonesia
95 Syscrom S.A.
96 Tata America International Corporation
97 Tata Consultancy Services (Africa) (PTY) Ltd.
98 Tata Consultancy Services (China) Co., Ltd.
99 Tata Consultancy Services (Philippines) Inc. (w.e.f. 19.09.2008 )
100 Tata Consultancy Services (South Africa) (PTY) Ltd.
101 Tata Consultancy Services (Thailand) Limited (w.e.f. 12.05.2008 )
102 Tata Consultancy Services Argentina S.A. (Formerly TCS Argentina S.A.)
103 Tata Consultancy Services Asia Pacific Pte Ltd.
104 Tata Consultancy Services Belgium SA
105 Tata Consultancy Services BPO Chile SA (Formerly Tata Consultancy Services Chile Limitada)
106 Tata Consultancy Services Canada Inc.(formerly Exegenix Canada Inc. )
107 Tata Consultancy Services Chile S.A.
108 Tata Consultancy Services De Espana S.A.
109 Tata Consultancy Services De Mexico S.A., De C.V.
110 Tata Consultancy Services Deutschland GmbH
111 Tata Consultancy Services Do Brasil Ltda (Formerly Tata Consultancy Services Do Brasil S.A.)
112 Tata Consultancy Services France SAS (Formerly TKS - Tecknosoft (France) SAS)
113 Tata Consultancy Services Japan Ltd.
114 Tata Consultancy Services Luxembourg S.A
115 Tata Consultancy Services Malaysia Sdn Bhd
116 Tata Consultancy Services Morocco SARL AU
117 Tata Consultancy Services Netherlands BV
118 Tata Consultancy Services Portugal Unipessoal Limitada
119 Tata Consultancy Services Sverige AB
120 Tata Consultancy Services Switzerland Ltd. (Formerly TKS - Tecknosoft S.A.)
121 Tata Information Technology (Shanghai) Company Limited
122 Tata Infotech (Singapore) Pte. Limited (Liquidated w.e.f. 24.03.2010)
123 Tata Infotech Deutschland GmbH (Ceased to be a subsidiary w.e.f. 22.10.2008 )
124 TATASOLUTION CENTER S.A
125 TCS e-Serve America, Inc (w.e.f.10.02.2009 )
126 TCS e-Serve International Limited (Formerly CGSL International Limited) (w.e.f. 31.12.2008 )
127 TCS e-Serve Limited (Formerly Citigroup Global Services Limited) (w.e.f. 31.12.2008 )
128 TCS Financial Management, LLC [Ceased to be a subsidiary w.e.f. 14.04.2009]
129 TCS Financial Solutions Australia Holdings Pty Limited (Formerly Financial Network Services (Holdings) Pty Limited)
130 TCS Financial Solutions Australia Pty Limited (Formerly Financial Network Services Pty Limited)
131 TCS FNS Pty Limited
132 TCS Iberoamerica SA
133 TCS Inversiones Chile Limitada
134 TCS Italia SRL
135 TCS Management Pty Ltd.
136 TCS Solution Center S.A.
137 TCS Uruguay S.A. (w.e.f. 01.01.2010)
A8B
138 WTI Advanced Technology Limited
Associates
1 Advinus Therapeutics Private Limited
2 Niskalp Energy Limited
3 Tata Communications Limited
4 Tata Elxsi Limited
5 Tata Industries Limited
6 Tata International Limited
7 Tata Motors Limited
8 Tata Steel Limited
9 Tata Tea Limited
10 The Tata Power Company Limited
11 Trent Limited
12 Vantech Investments Limited
13 Voltas Limited
14 Tata Chemicals Limited
15 Global Information Services Limited
16 Nagarjuna Oil Corporation Limited (w.e.f. 04.08.2008)
17 TRIL Infopark Limited (27.05.2008)
18 Miracle Entertainment Private Limited
19 Exegenix Research Inc. (Ceased to be an associate and became a subsidiary w.e.f. 05.06.2009)
20 Firstech Solutions Co. Limited (Ceased to be an associate w.e.f. 12.01.2009)
21 National Power Exchange Limited (w.e.f. 11.12.2008)
22 Hemisphere Properties India Limited
23 Precision Camshafts Limited (w.e.f. 29.08.2008)
24 Quikjet Cargo Airlines private Limited (w.e.f. 16.06.2008)
25 Tata Autocomp Systems Limited (w.e.f. 28.06.2008)
26 Speech & Software Technologies (India) Private Limited
27 The Associated Building Company Limited
28 Casa Décor Private Limited
29 Landmark Limited (w.e.f. 20.05.2008 and ceased to be an associate on 26.03.2009)
30 Amalgamated Plantations Private Limited (w.e.f 29.04.2009)
31 Rockbourne Holding B.V.
32 Tata Precision Industries Pte Limited
33 Tata Enterprises (Overseas) AG
34 Titan International Investments B.V
35 Piaggio Aero Industries S.p.A (w.e.f. 09.10.2008)
36 Titan International Marketing Limited
37 TKM Overseas Transport Limited
Joint Ventures
1 Technopolis Knowledge Park Limited
2 Virgin Mobile India Private Limited
3 Rentalbazaar (India) Limited
4 Strategic Energy Technolgy Systems Limited
5 Pune- Solapur Expressways Private Limited (w.e.f. 20.03.2009)
6 Adithya Automotives Private Limited (w.e.f 01.06.2009)
Investing Parties
1 Sir Dorabji Tata Trust
2 Sir Ratan Tata Trust
A8B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
% Holding
Date of as at % Holding as
Name of subsidiary acquisition/cessation 31.03.10 at 31.03.09
% Holding
Date of as at % Holding as
Name of Associate acquisition/cessation 31.03.10 at 31.03.09
% Holding
Date of as at % Holding as
Name of Associate acquisition/cessation 31.03.10 at 31.03.09
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '9C'
A9B-9C
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '11A'
Subtotal - -
Guarantees
Amount outstanding against above guarantees
4 Capital commitments
(Net of Advance)
A11
Annexure '11B'
Total -
Annexure '11C'
Contingent liabilities in the nature of Guarantees / Letter of credits or comforts in relation to related parties as per Annexure
'8B'
Guarantees
[Insert rows as required]
SN Particulars of guarantees given Amount of Guarantee Guarantee Details of Borrowings
guarantees given on given to the outstanding as at
given behalf of guarantee year end against
(Rs. in given the guarantee*
crores)
A Funded
B Unfunded
Total - -
Total - -
A11
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Operating Lease:
(b) Total lease payments charged to profit and loss account for the
year
(b) Total lease receipts recognised in profit and loss account for the
year
Finance Lease:
Line item in which operating lease income is grouped/shown in the FFC A/cs
Line item in which operating lease expense is grouped/shown in the FFC A/cs
Line item in which finance lease expense is grouped/shown in the FFC A/cs
Line item in which finance lease income is grouped/shown in the FFC A/cs
A12
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Please input the amounts in the table below even if the net deferred tax position is
zero or DTA is recognized to the extent of DTL
Please enter all amounts in full figures
(Rs.)
Note:
As per Indian GAAP, Deferred tax assets and liabilities can be set off only if they
1 are under the same jurisdiction
If Deferred Tax Assets & Deferred Tax Liabilities are under different tax
2 jurisdiction, then show the amount under each head separately
A13
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '14A'
Disclosure for AS -15
Defined benefit: Post employment employee benefit plans [ Unfunded ]
Instructions
1 Please do not fill the cells marked in grey & pink.
2 Please do not delete any rows.
3 If rows are inserted, then please highlight them.
Incase there is more than one type of benefit plan [for e.g. gratuity and pension], then please copy this worksheet and fill
4 separately
Kindly forthe
check each plan.
reconciliations table below and ensure that there are no differences. If there are any differences kindly
5 reconcile.
6 Kindly ensure there is no clubbing with other employee benefits and there is correct classification in FFCs.
Type of Plan :
Rs in Crores Rs in Crores
Current Year Previous year
Plans In Plans In respect Plans In Plans In respect
respect of of Foreign respect of of Foreign
Particulars Indian entities entities Indian entities entities
I Expenses recognized in the statement of Profit and Loss
Account for the year ended 31st March, 2010
1 Current service cost
2 Interest cost
3 Expected return on plan assets
4 Expected return on any reimbursement right recognised as an
asset in accordance with Para 103
5 Actuarial (gain)/loss recognized during the year
6 Past service cost
7 The effect of any Curtailment/ settlement
8 The effect of the limit in Para 59
9 Received from intra-group companies on transfer of employees
Expenses / (Income) recognised in Profit and Loss Account 0.00 0.00 0.00 0.00
A14A
Rs in Crores Rs in Crores
Current Year Previous year
Plans In Plans In respect Plans In Plans In respect
respect of of Foreign respect of of Foreign
Particulars Indian entities entities Indian entities entities
VIII The amounts included in the fair value of plan assets for:
Each category of the company’s own financial instruments
[ please insert rows accordingly ] 0.00 0.00 0.00 0.00
Any property or other assets used by, the company [ please
insert rows accordingly ] 0.00 0.00 0.00 0.00
Reconciliations Table
1 Actuarial Gains
Actuarial (gain)/loss on obligation 0.00 0.00 0.00 0.00
Actuarial gain/(loss) on plan assets 0.00 0.00 0.00 0.00
year 0.00 0.00 0.00 0.00
As per I.5 0.00 0.00 0.00 0.00
Difference 0.00 0.00 0.00 0.00
3 Interest Cost
Interest Cost as per profit and loss 0.00 0.00 0.00 0.00
Interest Cost as per DBO 0.00 0.00 0.00 0.00
Difference 0.00 0.00 0.00 0.00
A14A
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Instructions
1 Please do not fill the cells marked in grey & pink.
2 Please do not delete any rows.
3 If rows are inserted, then please highlight them.
Incase there is more than one type of benefit plan [for e.g. gratuity and pension], then please copy this worksheet and fill
4 separately
Kindly forthe
check each plan.
reconciliations table below and ensure that there are no differences. If there are any differences kindly
5 reconcile.
6 Kindly enter amounts and not percentages in the Major categories of plan assets.
7 Kindly ensure there is no clubbing with other employee benefits and there is correct classification in FFCs.
Type of Plan :
Rs in Crores Rs in Crores
Current Year Previous year
IV Present valueofofthe
Present value obligation as at 31st
Defined Benefit March,
obligation 2010
as at 1st April,
1 2009
2 Current service cost
3 Interest cost
4 Plan Participant's contributions
5 Actuarial (gain)/loss on obligation
6 Exchange Loss/ (gain)
7 Benefits Paid
8 Past Service Cost
9 Amalgamations/ Acquisitions
10 Curtailments
11 Settlements
12 Liabilities on transfer
Present value of obligation as at 31st March, 2010 - - - -
A14B
Rs in Crores Rs in Crores
Current Year Previous year
IX Actuarial assumptions
Discount rate
Expected rate of return on plan assets
Interest Rate
Mortality Rate
Reconciliations Table
1 Actuarial Gains
Actuarial (gain)/loss on obligation - - - -
Actuarial gain/(loss) on plan assets
recognized in the profit and loss during - - - -
the year - - - -
As per I.5 - - - -
Difference - - - -
3 Interest Cost
Interest Cost as per profit and loss - - - -
Interest Cost as per DBO - - - -
Difference - - - -
4 Expected Return
Expected Return as per Profit and Loss - - - -
Expected Return as per Plan assets - - - -
Difference - - - -
6 Benefits Paid
Benefits Paid as per DBO - - - -
Benefits Paid as per plan assets - - - -
Difference - - - -
A14B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '14C'
Disclosure for AS -15
Instructions
1 Please add lines as required
2 Kindly ensure there is no clubbing with other employee benefits and there is correct
classification in FFCs.
Rs in Crores
SnoName of the defined contribution plans Current Year Previous year
1 Provident Fund (including family pension)
2 Superannuation Fund
….
….
….
Total - -
A14C
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '15A'
Foreign Exchange Currency exposures not covered by derivative instruments as on 31st March, 2010
Instructions
1 Please insert rows if the currency is not in the worksheet and highlight the same
2 Please do not delete any rows.
3 Please ensure that foreign currency is in Millions and Indian equivalent is in Crores
Investments 2010
Pounds 2009
2010
CHF 2009
2010
USD 2009
A15A
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '15B'
Derivative instruments outstanding as at 31st March, 2010
Instructions
1 Please input currency details and No. of contracts for each Buy and Sell Position
2 Please ensure that foreign currency is in Millions and Indian equivalent is in Crores
Options Buy
USD/INR
Sell
Buy
Sell
Buy
Sell
Buy
Sell
Buy
Sell
Interest Swaps
Please mention the breakup of the fair values of the outstanding derivatives as they have been grouped in FFC A/cs:
Amount in crores
Line items
2010 2009
A15B
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '15C'
Cash flow hedges
Instructions
1 Please insert rows if the type of derivative instrument is not mentioned in the worksheet and highlight the
2 same
Please insert rows if the currency is not mentioned in the worksheet and highlight the same
3 Please do not delete any rows.
4 Please ensure that foreign currency is in Millions and Indian equivalent is in Crores
The following are the Outstanding Foreign exchange forward contracts and currency options which are
designated as Cash flow Hedges as on:
The movement in Hedging Reserve during year ended March 2010, for derivatives designated as Cash
Flow Hedges is as follows
A15C
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '16'
Provisions movement and reconciliations
1
2
3
4
A16
Reconciliations in relation to Provisions for doubtful debts, loans and advances and diminution in value of investments.
Previous year
Provision
Provision written Bad Differen
Balance s made back debts/Ad Balance ce, if
on 1st during during vances Balance as at as per any with
Sr April, the the written Exchange 31st March balance explana
No. Particulars 2008 period period off difference 2009 Sheet tions
(Rs. in crores)
1 Provision for doubtful debts - - - - -
2 Provision for loans and advances - - - - -
3 Provision for Diminution in value of Investments - - - -
Current year
Provision
Provision written Bad Differen
Balance s made back debts/Ad Balance ce, if
on 1st during during vances Balance as at as per any with
Sr April, the the written Exchange 31st March balance explana
No. Particulars 2009 period period off difference 2010 Sheet tions
(Rs. in crores)
1 Provision for doubtful debts - - - - - -
2 Provision for loans and advances - - - - - -
3 Provision for Diminution in value of Investments - - - - -
A16
A16
Line item in
which
provisions
written back
during the
period are
included in FFC
Line item in
which
provisions
written back
during the
period are
included in FFC
A16
TATA SONS LIMITED CONSOLIDATION FOR THE YEAR ENDED 31ST MARCH, 2010
Annexure '17'
31.03.2010 31.12.2009
Currency Closing Average Closing Average
Rate Rate Rate Rate
USD 44.9175 47.3533
GBP 68.2027 75.5429
CHF 42.6001 44.6867
QAR 12.8100 13.3054