jagomart
digital resources
picture1_Financial Spreadsheet 33741 | Tcs Data Sheet


 213x       Filetype XLSX       File size 0.28 MB       Source: www.tcs.com


File: Financial Spreadsheet 33741 | Tcs Data Sheet
sheet 1 index tcs consolidated unaudited key financial and operating metrics contents sheet income statement and balance sheet consolidated unaudited as per ifrs usd mn 1 income statement and balance ...

icon picture XLSX Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Index
TCS Consolidated
(unaudited)


KEY FINANCIAL AND OPERATING METRICS


Contents Sheet
Income Statement and Balance Sheet - Consolidated, Unaudited as per IFRS (USD Mn) 1
Income Statement and Balance Sheet - Consolidated, Unaudited as per IFRS (INR Mn) 2
Operating Metrics 3
Income Statement and Balance Sheet - Consolidated, Unaudited as per US GAAP (USD Mn) 4
Income Statement and Balance Sheet - Consolidated, Unaudited as per US GAAP (INR Mn) 5



Sheet 2: IFRS-PnL,BS-USD
TCS Consolidated Income Statement as per IFRS - USD Mn FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 1Q22 2Q22 3Q22 4Q22 FY22 1Q23





EX-ADJ **




EX-ADJ ***





Revenue
















Information Technology and Consultancy Services $7,907 $9,852 $11,244 $13,167 $15,137 $16,545 $17,576 $19,089 $20,913 $22,031 $22,174 $6,154 $6,333 $6,524 $6,696 $25,707 $6,780
Sale of Equipment and Software Licenses $280 $319 $325 $275 $317











Total Revenue $8,187 $10,171 $11,568 $13,442 $15,454 $16,545 $17,576 $19,089 $20,913 $22,031 $22,174 $6,154 $6,333 $6,524 $6,696 $25,707 $6,780


















Employee cost $3,185 $3,911 $4,377 $4,984 $ 6,243 incl one-off Employee Expense $5,926 $6,379 $6,884 $7,807 $8,647 $9,216 $9,714 $2,732 $2,787 $2,824 $2,937 $11,280 $3,044
Fees to External Consultants $309 $455 $638 $820 $998 $1,190 $1,243 $1,307 $1,525 $1,755 $1,709 $508 $546 $584 $613 $2,251 $655
Cost of Equipment and Software Licenses $235 $278 $281 $243 $303 $391 $418 $419 $325 $267 $198 $35 $29 $58 $34 $155 $28
Depreciation $108 $121 $123 $141 $208 $206 $217 $244 $236 $377 $417 $114 $118 $124 $122 $478 $120
Travel $126 $145 $163 $175 $238 $243 $268 $291 $333 $322 $119 $37 $41 $62 $33 $174 $55
Communication $90 $97 $98 $98 $123 $125 $115 $123 $140 $173 $194 $50 $50 $50 $55 $206 $46
Facility Expenses $209 $244 $247 $272 $354 $330 $343 $410 $426 $253 $189 $45 $43 $48 $46 $182 $50
Other Expenses $219 $259 $303 $347 $428 $410 $477 $453 $528 $599 $578 $149 $159 $165 $168 $640 $177
Total Cost of Revenues $4,481 $5,509 $6,229 $7,079 8,894 incl one-off Employee Expense $8,577 $9,274 $9,965 $11,054 $12,160 $12,962 $13,118 $3,670 $3,773 $3,915 $4,008 $15,366 $4,175


















Gross Profit $3,706 $4,661 $5,339 $6,363 6,560 incl one-off Employee Expense $6,877 $7,271 $7,611 $8,035 $8,753 $9,069 $9,056 $2,484 $2,560 $2,609 $2,688 $10,341 $2,605


















Operating Expenses
















Selling, General and Administrative Expenses
















Employee Cost $943 $1,236 $1,476 $1,677 $ 2,036 incl one-off Employee Expense $1,930 $2,051 $2,297 $2,488 $2,526 $2,849 $2,682 $744 $778 $801 $816 $3,140 $854
Fees to External Consultants $40 $53 $58 $63 $86 $90 $76 $87 $92 $62 $77 $21 $20 $19 $23 $83 $24
Provision for Doubtful Debts $(16) $5 $10 $16 $26 $21 $19 $32 $27 $19 $27 $6 $5 $6 $2 $18 $2
Depreciation $50 $67 $75 $77 $98 $82 $79 $68 $58 $119 $133 $32 $33 $35 $39 $139 $38
Facility Expenses $132 $158 $180 $185 $166 $189 $207 $200 $183 $127 $98 $25 $24 $28 $28 $105 $28
Travel $77 $105 $135 $161 $154 $162 $147 $146 $162 $142 $27 $9 $12 $7 $12 $39 $16
Communication $31 $38 $43 $46 $50 $44 $43 $42 $48 $50 $62 $17 $14 $18 $19 $69 $18
Other Expenses $151 $193 $238 $233 $217 $249 $225 $242 $310 $287 $209 $60 $52 $62 $78 $252 $59
Total Operating Expenses $1,408 $1,855 $2,216 $2,457 $ 2,833 incl one-off Employee Expense $2,727 $2,886 $3,093 $3,305 $3,406 $3,655 $3,315 $914 $938 $976 $1,017 $3,845 $1,039


















Operating Income $2,299 $2,806 $3,124 $3,906 $ 3,727 incl one-off Employee Expense $4,150 $4,385 $4,518 $4,730 $5,347 $5,414 $5,741 $1,570 $1,622 $1,633 $1,671 $6,496 $1,566


















Other Income/(Exp ) $118 $99 $199 $264 $513 $464 $624 $557 $589 $519 $338 $78 $131 $127 $98 $434 $76


















Income before Income Tax $2,416 $2,905 $3,323 $4,170 $4,240 incl one-off Employee Expense $4,663 $4,849 $5,142 $5,287 $5,936 $5,933 $6,079 $1,648 $1,753 $1,760 $1,769 $6,930 $1,642


















Income tax $475 $657 $741 $996 $ 994 incl one-off Employee Expense $1,087 $1,142 $1,215 $1,273 $1,428 $1,377 $1,549 $424 $448 $452 $451 $1,775 $419


















Income after income tax $1,941 $2,248 $2,582 $3,174 $ 3,246 incl one-off Employee Expense $3,576 $3,706 $3,927 $4,014 $4,508 $4,556 $4,530 $1,224 $1,305 $1,308 $1,318 $5,155 $1,223


















Non-controlling interests $(26) $(24) $(28) $(35) $ (34) incl one-off Employee Expense $(35) $(19) $(10) $(9) $(14) $(15) $(17) $(3) $(4) $(5) $(4) $(16) $(5)


















Net profit $1,915 $2,223 $2,554 $3,139 $ 3,212 incl one-off Employee Expense $3,541 $3,687 $3,917 $4,005 $4,494 $4,541 $4,513 $1,221 $1,301 $1,303 $1,314 $5,139 $1,218


















Basic and Diluted EPS (after adjusting for bonus shares) $0.97 $1.14 $1.31 $1.60 $1.64 incl one-off Employee Expense $1.81 $1.88 $1.99 $2.08 $1.19 $1.21 $1.21 $0.33 $0.35 $0.35 $0.36 $1.39 $0.33


















Weighted average no of shares used in computing Basic and Diluted EPS 1,957,220,996 1,957,220,996 1,957,220,996 1,958,100,069 1,958,727,979 1,966,040,455 1,970,427,941 1,924,592,806 3,789,749,350 3,752,384,706 3,740,110,733 3,699,051,373 3,699,051,373 3,699,051,373 3,698,162,484 3,698,832,195 3,659,051,373




































Back






































































TCS Consolidated Balance Sheet as per IFRS - USD Mn FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 1Q22 2Q22 3Q22 4Q22 FY22 1Q23
Period Ending FY11 FY12 FY13 31-Mar-14 31-Mar-15 31-Mar-16 31-Mar-17 31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 30-Jun-21 30-Sep-21 31-Dec-21 31-Mar-22 31-Mar-22 30-Jun-22


















ASSETS


































Current Assets
















Cash and Cash Equivalents $349 $391 $339 $245 $298 $950 $555 $751 $1,045 $1,146 $934 $901 $700 $808 $1,650 $1,650 $706
Bank Deposits $713 $752 $915 $2,160 $2,618 $8 $66 $316 $785 $107 $308 $757 $668 $940 $728 $728 $508
Trade Receivables $1,838 $2,258 $2,594 $3,035 $3,266 $3,634 $3,488 $3,835 $3,955 $4,047 $4,098 $4,118 $4,416 $4,596 $4,501 $4,501 $4,536
Investments $155 $158 $200 $194 $240 $3,393 $6,421 $5,490 $4,208 $3,465 $3,973 $4,019 $5,211 $6,122 $3,998 $3,998 $4,114
Other Current Financial Assets $164 $305 $900 $571 $434 $619 $695 $661 $1,446 $1,347 $1,781 $1,753 $1,623 $1,250 $1,065 $1,065 $1,489
Unbilled Receivables (PY: Unbilled Revenue) $303 $441 $578 $667 $612 $603 $803 $1,028 $746 $760 $897 $942 $906 $882 $1,022 $1,022 $1,050
Current Income Tax Assets $51 $- $1 $6 $12 $5 $4 $6 $268 $1 $3 $2 $2 $1 $1 $1 $1
Other Current Assets $256 $197 $270 $276 $335 $331 $354 $402 $877 $1,090 $1,532 $1,541 $1,349 $1,291 $1,344 $1,344 $1,269
Total Current Assets $3,827 $4,503 $5,798 $7,153 $7,815 $9,543 $12,386 $12,489 $13,330 $11,963 $13,526 $14,033 $14,875 $15,890 $14,309 $14,309 $13,673


















Non Current Assets
















Bank Deposits $606 $543 $446 $246 $80 $63 $- $- $- $46 $98 $98 $97 $87 $163 $163 $149
Investments $258 $132 $175 $383 $41 $52 $53 $46 $35 $29 $29 $29 $32 $32 $29 $29 $30
Trade Receivables





$10 $14 $14 $10 $8 $8 $9 $9 $19 $19 $7
Unbilled Receivables (PY: Unbilled Revenue)





$22 $35 $57 $43 $37 $35 $28 $13 $7 $7 $12
Other Non Current Financial Assets $129 $170 $117 $291 $370 $510 $129 $410 $115 $115 $120 $192 $212 $234 $176 $176 $173
Non Current Income Tax Assets $202 $291 $356 $511 $654 $674 $739 $635 $581 $326 $251 $255 $270 $285 $262 $262 $262
Deferred Income tax Assets $265 $346 $394 $384 $418 $435 $433 $527 $381 $372 $532 $467 $400 $389 $486 $486 $440
Property, plant and Equipment $1,166 $1,267 $1,508 $1,726 $1,849 $1,780 $1,811 $1,784 $1,685 $1,583 $1,653 $1,618 $1,606 $1,613 $1,596 $1,596 $1,518
Other Intangible Assets $43 $34 $26 $30 $35 $20 $7 $2 $26 $37 $65 $62 $65 $156 $145 $145 $126
Right-of-use assets








$1,060 $1,040 $1,067 $1,073 $1,056 $1,009 $1,009 $956
Goodwill $722 $652 $619 $663 $593 $575 $574 $597 $555 $510 $538 $537 $529 $525 $520 $520 $491
Other Non-Current Assets $101 $121 $122 $89 $145 $117 $84 $130 $157 $215 $206 $170 $255 $246 $251 $251 $232
Total Non Current Assets $3,491 $3,558 $3,764 $4,321 $4,184 $4,226 $3,862 $4,180 $3,606 $4,346 $4,577 $4,538 $4,576 $4,645 $4,663 $4,663 $4,396


















Total Assets $7,318 $8,061 $9,563 $11,473 $11,999 $13,769 $16,248 $16,669 $16,936 $16,309 $18,103 $18,571 $19,451 $20,535 $18,972 $18,972 $18,069


















LIABILITIES AND SHAREHOLDER'S EQUITY


































Current Liabilities
















Trade and Other Payables $579 $607 $786 $922 $1,411 $1,138 $756 $783 $910 $894 $1,071 $1,077 $1,101 $985 $1,063 $1,063 $1,286
Borrowings $8 $2 $19 $28 $39 $25 $34 $30 $3 $- $- $- $- $- $- $- $-
Mandatorily Redeemable Preference shares $22 $19 $18 $- $- $- $- $- $- $- $-



$-
Lease liabilities








$168 $176 $187 $190 $192 $192 $192 $183
Other current financial liabilities $186 $172 $203 $211 $190 $349 $448 $600 $706 $809 $838 $694 $817 $934 $1,015 $1,015 $860
Unearned and Deferred Revenue $173 $162 $178 $175 $170 $205 $216 $313 $346 $386 $497 $446 $460 $489 $480 $480 $466
Employee benefit obligations $118 $126 $148 $174 $217 $247 $287 $310 $341 $364 $476 $508 $520 $529 $503 $503 $488
Other provisions


$6 $17 $17 $10 $37 $35 $39 $189 $188 $187 $187 $186 $186 $45
Current Income Tax Liabilities $89 $80 $75 $112 $87 $122 $218 $219 $386 $492 $850 $978 $928 $970 $1,046 $1,046 $1,087
Other Current Liabilities $124 $144 $188 $216 $214 $247 $269 $450 $468 $435 $554 $710 $520 $537 $1,108 $1,108 $743
Total Current Liabilities $1,300 $1,312 $1,615 $1,844 $2,345 $2,350 $2,238 $2,742 $3,195 $3,587 $4,651 $4,788 $4,723 $4,823 $5,593 $5,593 $5,158


















Non Current Liabilities
















Borrowings $9 $23 $24 $21 $18 $12 $11 $8 $6 $- $- $- $- $- $- $- $-
Lease liabilities








$915 $886 $910 $915 $884 $841 $841 $798
Other non current financial liabilities $53 $68 $64 $73 $106 $74 $70 $77 $42 $39 $38 $38 $40 $77 $76 $76 $73
Unearned and deferred revenue






$77 $122 $92 $163 $140 $132 $164 $147 $147 $136
Employee benefit obligations $31 $43 $64 $46 $33 $36 $38 $45 $48 $55 $102 $104 $99 $101 $89 $89 $87
Other provisions


$18 $15 $6 $6 $4 $- $- $-



$-
Deferred Income Tax Liabilities $127 $85 $90 $93 $88 $122 $142 $180 $151 $103 $104 $111 $104 $102 $78 $78 $84
Other Non-Current Liabilities $25 $38 $49 $51 $65 $67 $67 $60 $60 $- $- $- $- $- $- $- $-
Total Non-Current Liabilities $245 $256 $290 $302 $325 $317 $334 $451 $429 $1,204 $1,293 $1,303 $1,290 $1,328 $1,231 $1,231 $1,178


















Total Liabilities $1,545 $1,569 $1,905 $2,146 $2,668 $2,667 $2,572 $3,193 $3,624 $4,791 $5,944 $6,091 $6,013 $6,151 $6,824 $6,824 $6,336


















Shareholders' Equity
















Share Capital $44 $44 $44 $44 $44 $44 $44 $43 $70 $70 $69 $69 $69 $69 $68 $68 $68
Share Premium $427 $427 $427 $428 $428 $911 $911 $- $- $- $- $- $- $- $- $- $-
Retained Earnings $5,155 $6,523 $8,025 $10,289 $10,670 $12,499 $14,738 $15,284 $15,973 $15,034 $15,144 $15,488 $16,308 $17,063 $14,943 $14,943 $15,025
Accumulated Other Comprehensive Income/(Loss) $76 $(605) $(959) $(1,548) $(1,956) $(2,406) $(2,074) $(1,914) $(2,800) $(3,671) $(3,148) $(3,169) $(3,031) $(2,843) $(2,958) $(2,958) $(3,445)
Total Shareholders' Equity attributable to TCS Ltd $5,702 $6,389 $7,537 $9,213 $9,185 $11,048 $13,619 $13,413 $13,243 $11,433 $12,065 $12,388 $13,346 $14,289 $12,053 $12,053 $11,648


















Non Controlling Interests $71 $104 $121 $115 $146 $54 $57 $63 $69 $85 $94 $92 $92 $95 $95 $95 $85


















Total Liabilities and Shareholders' Equity $7,318 $8,061 $9,563 $11,473 $11,999 $13,769 $16,248 $16,669 $16,936 $16,309 $18,103 $18,571 $19,451 $20,535 $18,972 $18,972 $18,069


















Notes:
















From 1QFY12, Consolidated Financial Statements are being prepared in accordance with the International Financial Reporting Standards (IFRS) as issued by the International Accounting Standards Board (IASB)


































On April 4, 2014, the Company announced that it has chosen to apply IFRS 9 w.e.f April 1, 2013, much ahead of its mandatory adoption, because we believe the new standard is better aligned with our risk management policy and practice than the earlier IAS 39 standard. In accordance with the transition provisions set out in IFRS 9, we have restated the Net Foreign Exchange Gains / Losses as reported under IAS 39 from 1Q FY12 till 3Q FY14. The cells impacted by this restatement are colored light blue. For more details, please refer to Notes to Accounts to our Financial Statements.


































* For Detailed schedules and Notes to Accounts, please visit www.tcs.com/investors/financial_info


































** Ex-Adj excludes One time Special Employee Rewards of $ 423 Mn in 4QFY15 and FY15. Numbers including the one time adjustment are mentioned in the impacted Cell Comments.


































***Ex Adj excludes legal claim provision; Impact on Operating Margin $165 Mn; Net Margin $ 129 Mn. Numbers including the one time adjustment are mentioned in the impacted Cell Comments.
















Back

















Sheet 3: IFRS-PnL,BS-INR
TCS Consolidated Income Statement as per IFRS - INR Mn FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 1Q22 2Q22 3Q22 4Q22 FY22 1Q23





EX-ADJ **




EX-ADJ ***





Revenue
















Information Technology and Consultancy Services 360,464 473,605 612,230 801,398 927,017 1,086,462 1,179,660 1,231,040 1,464,630 1,569,490 1,641,770 454,110 468,670 488,850 505,910 1,917,540 527,580
Sale of Equipment and Software Licenses 12,782 15,333 17,665 16,695 19,467











Total Revenue 373,245 488,938 629,895 818,094 946,484 1,086,462 1,179,660 1,231,040 1,464,630 1,569,490 1,641,770 454,110 468,670 488,850 505,910 1,917,540 527,580


















Cost of Revenues
















Cost of Services
















Employee Cost 145,234 187,710 238,361 303,182 382,553 incl one-off Employee Expense 362,844 418,829 462,020 503,500 605,530 656,520 719,460 201,570 206,230 211,620 221,930 841,350 236,850
Fees to External Consultants 14,133 21,912 34,720 49,970 61,165 78,228 83,450 84,310 106,860 125,000 126,480 37,470 40,390 43,770 46,320 167,950 51,000
Cost of Equipment and Software Licenses 10,338 13,403 15,267 14,701 18,601 25,711 28,080 27,000 22,700 19,050 14,620 2,580 2,130 4,320 2,600 11,630 2,170
Depreciation 4,909 5,807 6,688 8,581 12,719 13,507 14,570 15,730 16,490 26,870 30,850 8,400 8,740 9,310 9,230 35,680 9,360
Travel 5,762 6,916 8,868 10,642 14,567 15,999 17,990 18,760 23,340 22,910 8,830 2,760 3,050 4,610 2,520 12,940 4,290
Communication 4,108 4,666 5,340 5,925 7,515 8,173 7,750 7,910 9,840 12,320 14,340 3,720 3,720 3,750 4,180 15,370 3,550
Facility Expenses 9,510 11,673 13,431 16,518 21,662 21,658 23,010 26,460 29,840 17,980 14,010 3,340 3,150 3,610 3,440 13,540 3,880
Other Costs 10,286 12,475 16,514 21,126 26,210 26,892 32,000 29,210 36,980 42,570 42,790 10,960 11,810 12,330 12,650 47,750 13,790
Total Cost of Revenues 204,280 264,561 339,188 430,644 544,992 incl one-off Employee Expense 525,283 608,997 668,870 712,880 851,580 923,220 971,380 270,800 279,220 293,320 302,870 1,146,210 324,890


















Gross Profit 168,965 224,377 290,707 387,449 401,492 incl one-off Employee Expense 421,201 477,465 510,790 518,160 613,050 646,270 670,390 183,310 189,450 195,530 203,040 771,330 202,690


















Operating Expenses
















Selling, General and Administrative Expenses
















Employee Cost 43,264 59,454 80,353 101,909 124,734 incl one-off Employee Expense 118,164 134,666 154,200 160,460 176,920 203,000 198,680 54,920 57,610 60,060 61,600 234,190 66,410
Fees to External Consultants 1,841 2,529 3,161 3,827 5,280 5,899 5,090 5,590 6,440 4,370 5,690 1,530 1,510 1,420 1,690 6,150 1,840
Provision for Doubtful Debts -724 259 559 953 1,605 1,347 1,260 2,080 1,870 1,440 2,010 410 350 420 170 1,350 150
Depreciation 2,276 3,229 4,104 4,662 5,980 5,373 5,300 4,410 4,060 8,430 9,800 2,360 2,410 2,650 2,940 10,360 2,950
Facility Expenses 6,002 7,597 9,795 11,235 10,175 12,404 13,850 12,910 12,780 9,060 7,290 1,820 1,770 2,120 2,140 7,850 2,210
Travel 3,419 5,024 7,351 9,771 9,452 10,630 9,880 9,410 11,400 10,040 1,980 690 860 510 880 2,940 1,300
Communication 1,420 1,835 2,329 2,815 3,045 2,900 2,910 2,690 3,380 3,600 4,620 1,260 1,070 1,350 1,460 5,140 1,380
Other Costs 6,671 9,283 12,976 14,199 13,256 16,346 15,060 15,590 21,700 20,530 15,510 4,440 3,870 4,630 5,880 18,820 4,590
Total Operating Expenses 64,166 89,209 120,627 149,369 173,527 incl one-off Employee Expense 166,957 189,565 207,550 213,140 238,550 260,470 245,580 67,430 69,450 73,160 76,760 286,800 80,830


















Operating Income 104,799 135,168 170,080 238,080 227,965 incl one-off Employee Expense 254,244 287,901 303,240 305,020 374,500 385,800 424,810 115,880 120,000 122,370 126,280 484,530 121,860





173,527 incl one-off Employee Expense












Total Other Income/(Expense) 5,333 4,378 10,819 15,891 31,397 30,502 41,890 35,900 41,130 36,680 24,970 5,750 9,690 9,540 7,360 32,340 5,900


















Income Before Income Taxes 110,132 139,546 180,899 253,970 259,362 incl one-off Employee Expense 285,641 318,403 345,130 340,920 415,630 422,480 449,780 121,630 129,690 131,910 133,640 516,870 127,760


















Total Taxes 21,639 31,585 40,346 60,713 60,830 incl one-off Employee Expense 66,566 75,026 81,560 82,120 100,010 98,010 114,580 31,320 33,160 33,850 34,050 132,380 32,570


















Net Profit After Taxes 88,493 107,961 140,553 193,258 198,532 incl one-off Employee Expense 219,075 243,376 263,570 258,800 315,620 324,470 335,200 90,310 96,530 98,060 99,590 384,490 95,190


















Adjustments for Minority Interests
















Non-controlling interests (1,190) (1,111) (1,493) (2,090) (2,048) incl one-off Employee Expense (2,114) (1,227) (680) (540) (900) (1,070) (1,320) (230) (290) (370) (330) (1,220) (410)


















Net Income Before Extraordinary Items 87,303 106,850 139,060 191,168 196,484 incl one-off Employee Expense 216,961 242,149 262,890 258,260 314,720 323,400 333,880 90,080 96,240 97,690 99,260 383,270 94,780


















Net Income After Extraordinary Items 87,303 106,850 139,060 191,168 196,484 incl one-off Employee Expense 216,961 242,149 262,890 258,260 314,720 323,400 333,880 90,080 96,240 97,690 99,260 383,270 94,780




































Basic and Diluted EPS (after adjusting for bonus shares) 44.60 54.59 71.05 97.63 100.31 incl one-off Employee Expense 110.77 123.17 133.41 134.19 83.05 86.19 89.27 24.35 26.02 26.41 26.85 103.62 25.90


















Dividend Per share (INR) 14 25 22 32 79 44 47 50 30 73 38 7.0 7.0 7.0 22.0 43 8.0






















































Weighted average no of shares used in computing Basic and Diluted EPS 1,957,220,996 1,957,220,996 1,957,220,996 1,958,100,069 1,958,727,979 1,966,040,455 1,970,427,941 1,924,592,806 3,789,749,350 3,752,384,706 3,740,110,733 3,699,051,373 3,699,051,373 3,699,051,373 3,698,162,484 3,698,832,195 3,659,051,373






















































Back
























































































TCS Consolidated Balance Sheet as per IFRS - INR Mn FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 1Q22 2Q22 3Q22 4Q22 FY22 1Q23
Period Ending 31-Mar-11 31-Mar-12 FY13 31-Mar-14 31-Mar-15 31-Mar-16 31-Mar-17 31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 30-Jun-21 30-Sep-21 31-Dec-21 31-Mar-22 31-Mar-22 30-Jun-22


















ASSETS


































Current Assets
















Cash and Cash Equivalents 15,538 19,936 18,432 14,688 18,622 62,950 35,970 48,830 72,240 86,460 68,580 67,070 51,950 59,920 124,880 124,880 55,750
Bank Deposits 31,812 38,304 49,732 129,754 163,829 530 4,300 20,560 54,280 8,050 22,620 56,350 49,620 69,770 55,070 55,070 40,070
Trade Receivables 81,949 115,023 140,956 182,304 204,399 240,730 226,170 249,430 273,460 305,320 300,790 306,460 327,860 341,030 340,740 340,740 358,100
Investments 6,896 8,037 10,871 11,631 15,009 224,790 416,360 357,070 290,910 261,400 291,600 299,100 386,830 454,250 302,620 302,620 324,770
Other Current Financial Assets 7,313 15,541 48,895 34,273 27,142 40,990 45,050 43,020 99,940 101,630 130,750 130,470 120,520 92,740 80,610 80,610 117,520
Unbilled Receivables (PY: Unbilled Revenue) 13,489 22,478 31,410 40,056 38,271 39,920 52,080 66,860 51,570 57,320 65,830 70,070 67,250 65,470 77,360 77,360 82,890
Current Income Tax assets 2,264 - 49 338 749 320 260 370 18,530 80 190 170 150 50 110 110 100
Other Current Assets 11,394 10,049 14,677 16,568 20,990 21,900 22,970 26,100 60,380 82,110 112,440 114,370 99,810 95,740 101,710 101,710 100,440
Total Current Assets 170,655 229,368 315,022 429,613 489,011 632,130 803,160 812,240 921,310 902,370 992,800 1,044,060 1,103,990 1,178,970 1,083,100 1,083,100 1,079,640


















Non Current assets
















Bank Deposits 27,016 27,653 24,234 14,773 5,001 4,150 - - - 3,480 7,190 7,300 7,180 6,450 12,320 12,320 11,780
Other Non Current Financial Assets 5,733 8,681 6,374 17,475 23,156 33,820 8,340 26,670 7,980 8,650 8,830 14,290 15,750 17,350 13,320 13,320 13,660
Non Current Income Tax Assets 8,991 14,837 19,345 30,688 40,930 44,640 47,890 41,310 40,170 24,620 18,450 19,010 20,030 21,180 19,830 19,830 20,670
Deferred Income Tax Assets 11,803 17,645 21,422 23,060 26,150 28,820 28,050 34,230 26,320 28,020 39,030 34,770 29,680 28,870 36,800 36,800 34,700
Property, Plant and Equipment, net 51,996 64,548 81,944 103,644 115,716 117,900 117,410 116,000 116,500 119,380 121,350 120,410 119,230 119,650 120,800 120,800 119,860
Right-of-use assets








79,940 76,330 79,400 79,640 78,370 76,360 76,360 75,510
Goodwill, net 32,206 33,238 33,636 39,797 37,115 38,120 37,210 38,840 38,340 38,500 39,480 39,940 39,250 38,920 39,350 39,350 38,760
Other Intangible Assets, net 1,905 1,736 1,427 1,772 2,193 1,340 470 120 1,790 2,830 4,800 4,590 4,850 11,600 11,010 11,010 9,960
Investments 11,495 6,746 9,531 22,986 2,534 3,430 3,440 3,010 2,390 2,160 2,130 2,130 2,370 2,370 2,230 2,230 2,350
Trade Receivables





670 940 950 740 550 610 690 660 1,450 1,450 520
Unbilled Receivables (PY: Unbilled Revenue)





1,430 2,270 3,910 3,240 2,730 2,640 2,060 950 550 550 940
Other Non-Current Assets 4,511 6,171 6,610 5,320 9,064 7,770 5,460 8,460 10,870 16,200 15,140 12,670 19,180 17,990 19,220 19,220 18,330
Total Non-Current Assets 155,654 181,254 204,523 259,512 261,859 279,990 250,370 271,850 249,220 327,760 336,010 337,760 339,910 344,360 353,240 353,240 347,040


















Total Assets 326,309 410,623 519,545 689,125 750,868 912,120 1,053,530 1,084,090 1,170,530 1,230,130 1,328,810 1,381,820 1,443,900 1,523,330 1,436,340 1,436,340 1,426,680


















LIABILITIES AND SHAREHOLDER'S EQUITY


































Liabilities
















Current Liabilities
















Trade and Other Payables 25,818 30,941 42,706 55,365 88,318 75,410 49,050 50,940 62,920 67,400 78,600 80,100 81,770 73,110 80,450 80,450 101,530
Short-term Borrowings 368 112 1,013 1,696 2,434 1,620 2,180 1,930 180 - - - - - - - -
Mandatorily Redeemable Preference shares with Tata Sons Ltd 1,000 1,000 1,000 - - - -

- -



-
Lease liabilities








12,680 12,920 13,900 14,130 14,250 14,500 14,500 14,420
Other Current Financial Liabilities 8,281 8,758 11,027 12,663 11,878 23,150 29,060 39,010 48,850 61,000 61,500 51,670 60,600 69,260 76,870 76,870 67,960
Unearned and Deferred Revenue 7,720 8,230 9,663 10,507 10,623 13,590 13,980 20,320 23,920 29,150 36,500 33,220 34,160 36,270 36,350 36,350 36,780
Employee Benefit Obligations 5,273 6,415 8,042 10,469 13,561 16,350 18,620 20,180 23,560 27,490 34,980 37,790 38,610 39,210 38,100 38,100 38,520
Other provisions


376 1,030 1,150 660 2,400 2,390 2,930 13,940 13,980 13,880 13,830 14,110 14,110 3,560
Current Income Tax Liabilities 3,983 4,053 4,073 6,702 5,456 8,050 14,120 14,210 26,670 37,120 62,430 72,750 68,900 71,960 79,210 79,210 85,780
Accrued Expenses and Other Current Liabilities 5,537 7,346 10,205 12,973 13,415 16,370 17,450 29,290 32,350 32,830 40,680 52,820 38,600 39,820 83,920 83,920 58,680
Total Current Liabilities 57,980 66,854 87,729 110,752 146,716 155,690 145,120 178,280 220,840 270,600 341,550 356,230 350,650 357,710 423,510 423,510 407,230


















Non Current Liabilities
















Long-Term Debt / Borrowings 380 1,154 1,310 1,273 1,143 830 710 540 440 -






Lease liabilities








69,060 65,030 67,740 67,960 65,610 63,680 63,680 63,030
Other Non Current Financial Liabilities 2,383 3,443 3,459 4,380 6,618 4,930 4,540 5,030 2,870 2,910 2,800 2,830 2,960 5,680 5,720 5,720 5,730
Unearned and deferred revenue






5,030 8,440 6,970 11,970 10,430 9,820 12,180 11,100 11,100 10,780
Employee Benefit Obligation 1,392 2,177 3,489 2,749 2,034 2,370 2,450 2,900 3,300 4,170 7,490 7,760 7,330 7,480 6,770 6,770 6,870
Other provisions


1,107 945 400 390 260 - - -



-
Deferred Income Tax Liabilities 5,650 4,331 4,880 5,556 5,473 8,050 9,190 11,700 10,420 7,790 7,670 8,280 7,720 7,540 5,900 5,900 6,650
Other Non-Current Liabilities 1,112 1,942 2,636 3,052 4,037 4,420 4,320 3,920 4,130 - - - - - - - -
Total Non Current Liabilities 10,918 13,046 15,774 18,117 20,250 21,000 21,600 29,380 29,600 90,900 94,960 97,040 95,790 98,490 93,170 93,170 93,060


















Total Liabilities 68,898 79,900 103,503 128,869 166,966 176,690 166,720 207,660 250,440 361,500 436,510 453,270 446,440 456,200 516,680 516,680 500,290


















Shareholders' Equity
















Share Capital 1,957 1,957 1,957 1,959 1,959 1,970 1,970 1,910 3,750 3,750 3,700 3,700 3,700 3,700 3,660 3,660 3,660
Share premium 19,199 19,199 19,199 19,203 19,203 50,820 50,820 - - - - - - - - - -
Other reserves 1,413 5,358 9,086 14,759 10,824 14,140 15,490 27,960 25,660 39,330 54,400 64,800 73,220 85,740 98,440 98,440 99,300
Retained Earnings 231,696 298,933 379,239 517,434 542,782 664,960 814,870 842,540 886,150 819,320 827,450 853,370 913,850 970,770 810,490 810,490 816,860
Total Shareholders' Equity 254,265 325,447 409,481 553,355 574,767 731,890 883,150 872,410 915,560 862,400 885,550 921,870 990,770 1,060,210 912,590 912,590 919,820


















Non Controlling Interests 3,147 5,275 6,561 6,902 9,136 3,540 3,660 4,020 4,530 6,230 6,750 6,680 6,690 6,920 7,070 7,070 6,570




































Total Liabilities and Shareholders' Equity 326,309 410,623 519,545 689,125 750,868 912,120 1,053,530 1,084,090 1,170,530 1,230,130 1,328,810 1,381,820 1,443,900 1,523,330 1,436,340 1,436,340 1,426,680




































Notes :
















From 1QFY12, Consolidated Financial Statements are being prepared in accordance with the International Financial Reporting Standards (IFRS) as issued by the International Accounting Standards Board (IASB)


































On April 4, 2014, the Company announced that it has chosen to apply IFRS 9 w.e.f April 1, 2013, much ahead of its mandatory adoption, because we believe the new standard is better aligned with our risk management policy and practice than the earlier IAS 39 standard. In accordance with the transition provisions set out in IFRS 9, we have restated the Net Foreign Exchange Gains / Losses as reported under IAS 39 from 1Q FY12 till 3Q FY14. The cells impacted by this restatement are colored light blue. For more details, please refer to Notes to Accounts to our Financial Statements.


































* For Detailed schedules and Notes to Accounts, please visit www.tcs.com/investors/financial_info


































** Ex-Adj excludes One time Special Employee Rewards of ` 26,279 Mn in 4QFY15 and FY15 in the Consolidated Income Statement. Numbers including the one time adjustment are mentioned in the impacted Cell Comments.


































***Ex Adj excludes legal claim provision; Impact on Operating Margin INR 1,218 Crore; Net Margin INR 958 Crore. Numbers including the one time adjustment are mentioned in the impacted Cell Comments.
















Back

















The words contained in this file might help you see if this file matches what you are looking for:

...Sheet index tcs consolidated unaudited key financial and operating metrics contents income statement balance as per ifrs usd mn inr us gaap ifrspnl bsusd fy q exadj revenue information technology consultancy services sale of equipment software licenses total employee cost incl oneoff expense fees to external consultants depreciation travel communication facility expenses other revenues gross profit selling general administrative provision for doubtful debts exp before tax after noncontrolling interests net basic diluted eps adjusting bonus shares weighted average no used in computing back...

no reviews yet
Please Login to review.