In Millions of INR except Per Share FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 12 Months Ending 03 31 2018 03 31 2019 03 31 2020 03 31 2021 03 31 2022 Total Assets Cash, Cash Equivalents STI 85919 7 122421 8 98831 2 264084 9 249767 3 Cash Cash Equivalents 42469 9 75353 3 38239 7 41755 4 64985 1 ST Investments 43449 8 47068 5 60591 5 222329 5 184782 2 Accounts Notes Received 229174 5 282125 5 279129 6 333316 363473 5 Accounts Receivable, Net 229174 5 282125 5 279129 6 333316 363473 5 Notes Receivable, Net 0 0 0 0 0 Unbilled Revenues 365251 6 402649 449889 4 443930 5 487833 3 Inventories 25000 5 33492 4 27699 28775 7 31325 1 Raw Materials 6677 4 7732 9 5078 2 4567 5 5547 3 Work In Process 3339 6 4898 7 3674 8 2122 3 2721 5 Finished Goods 4394 4 6166 8 3264 8 1204 2113 1 Other Inventory 10589 1 14694 15681 2 20881 9 20943 2 Other ST Assets 88677 6 69903 100801 9 82346 2 87779 4 Prepaid Expenses 31432 5 14247 7 13630 5 14932 4 13548 2 Derivative Hedging Assets 0 0 0 0 Assets Held for Sale 3880 417 2 27803 7 Taxes Receivable Misc ST Assets 53365 1 55238 1 59367 7 67413 8 74231 2 Total Current Assets 794023 9 910591 7 956351 1 1152453 3 1220178 6 Property, Plant Equip, Net 67245 6 85493 2 80628 88773 2 89004 6 Property, Plant Equip 97553 6 127377 5 125918 4 145705 4 154333 9 Accumulated Depreciation 30308 41884 3 45290 4 56932 2 65329 3 LT Investments Receivables 234692 4 185785 6 284656 8 259488 8 234579 9 LT Investments 234692 4 185785 6 284656 8 259488 8 234579 9 Other LT Assets 60104 9 64726 8 93930 98440 9 141259 7 Total Intangible Assets 3938 6 4004 1 843 8 1661 3 2058 4 Goodwill 0 0 0 472 9 472 9 Other Intangible Assets 3938 6 4004 1 843 8 1188 4 1585 5 Prepaid Expense 316 3 1082 9 Deferred Tax Assets 4006 2 8418 6 14282 7542 7 11403 Derivative Hedging Assets 0 0 0 Investments in Affiliates 0 0 16401 25419 8 Misc LT Assets 52160 1 52304 1 78804 2 72519 6 101295 6 Total Noncurrent Assets 362042 9 336005 6 459214 8 446702 9 464844 2 Total Assets 1156066 8 1246597 3 1415565 9 1599156 2 1685022 8 Liabilities Shareholders' Equity Payables Accruals 335914 4 381669 5 388208 443399 6 486293 2 Accounts Payable 310950 362250 3 366293 9 407697 8 453853 4 Accrued Taxes 3679 7 3209 1 6289 2 4167 4 6598 7 Interest Dividends Payable 636 9 846 4 1142 7 1277 8 1293 5 Other Payables Accruals 20647 8 15363 7 14482 2 30256 6 24547 6 ST Debt 50658 4 82176 2 187318 6 79414 9 74543 2 ST Borrowings 41295 7 40861 6 150441 1 68279 20973 9 ST Lease Liabilities 0 1322 7 1140 3 1244 4 ST Finance Leases 0 Current Portion of LT Debt 9362 7 41314 6 35554 8 9995 6 52324 9 Other ST Liabilities 216972 1 238747 8 238276 2 284232 3 314838 4 Deferred Revenue 194167 9 212724 5 200572 5 251797 8 265710 6 Derivatives Hedging 0 0 0 3469 Misc ST Liabilities 22804 2 26023 3 37703 7 32434 5 45658 8 Total Current Liabilities 603544 9 702593 5 813802 8 807046 8 875674 8 LT Debt 54951 6 37720 7 72098 9 167229 7 130223 9 LT Borrowings 54949 6 37720 1 71857 1 166467 3 129684 1 LT Lease Liabilities 2 0 6 241 8 762 4 539 8 LT Finance Leases 2 0 6 Other LT Liabilities 5827 8 5798 9 7910 7 7501 5 7983 6 Accrued Liabilities 0 0 0 0 Pension Liabilities 6112 3 6559 6452 7 Deferred Compensation Deferred Revenue 0 0 0 0 Deferred Tax Liabilities Derivatives Hedging 0 0 0 153 7 Misc LT Liabilities 5827 8 5798 9 1798 4 942 5 1377 2 Total Noncurrent Liabilities 60779 4 43519 6 80009 6 174731 2 138207 5 Total Liabilities 664324 3 746113 1 893812 4 981778 1013882 3 Preferred Equity and Hybrid Capital 0 0 0 0 0 Share Capital APIC 86432 9 87525 4 88803 8 89485 6 89997 5 Common Stock 2802 7 2805 5 2807 8 2809 1 2810 1 Additional Paid in Capital 83630 2 84719 9 85996 86676 5 87187 4 Treasury Stock 0 0 0 0 0 Retained Earnings 142500 1 150469 9 169571 7 257220 5 311311 4 Other Equity 262809 5 262488 9 263378 270672 1 269831 6 Equity Before Minority Interest 491742 5 500484 2 521753 5 617378 2 671140 5 Minority Non Controlling Interest 0 0 0 0 0 Total Equity 491742 5 500484 2 521753 5 617378 2 671140 5 Total Liabilities Equity 1156066 8 1246597 3 1415565 9 1599156 2 1685022 8 Reference Items Accounting Standard IN GAAP IN GAAP IN GAAP IN GAAP IN GAAP Shares Outstanding 1401 3695 1402 7294 1403 892 1404 5553 1405 0291 Number of Treasury Shares 0 0 0 0 0 Pension Obligations 4728 7 4976 2 6112 3 6559 6452 7 Future Minimum Operating Lease Obligations 588 8 323 Capital Leases Total 2 0 6 Percent Of Foreign Ownership 18 42 18 7 16 69 22 78 22 13 Number Of Shareholders 899902 1021275 1251569 1371535 1492124 Options Granted During Period 0 6691 0 6651 0 6976 0 104 0 5508 Options Outstanding at Period End 4 2656 2 8852 2 5214 1 7816 1 7184 Net Debt 19690 3 2524 9 160586 3 17440 3 45000 2 Net Debt to Equity 4 0042 0 5045 30 7782 2 8249 6 705 Tangible Common Equity Ratio 42 3394 39 9552 36 8206 38 5427 39 7562 Current Ratio 1 3156 1 296 1 1752 1 428 1 3934 Cash Conversion Cycle 181 3967 187 4331 229 2387 228 6545 195 6249 Number of Employees 42924 44761 45467 40527 50267 Do financial statements analysis and interpretation to understand financial health of selected organization(s) using tools (ratios) and techniques (costing) Analyze and interpret financial health of an organization i e how organization has been doing for last 5 years (trend analysis), how organization is doing vis a vis its competitors in last 5 years (comparative analysis) and how organization is doing vis a vis its industry average in last 5 years (industry comparative analysis) Analyze and interpret financial health in terms of its Riskiness arising out of its cost structure (Do CPV Analysis) Liquidity position i e organization(s) ability to meet current liabilities from current assets and ability to convert current assets into cash (Assets Utilization), Leverage position Both Operating leverage (how EBIT is sensitive due to change in revenue) and financial leverage (how EPS in sensitive due to change in EBIT), Organizations ability to meet financial obligations (Interest on loan), etc Profitability Position Economic Profitability (profit generating capacity from effective utilization of its assets or capacity), Commercial Profitability (profit generating capacity from revenue) and Owners Profitability (contribution of profit to owners)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 17, 2024

In Millions of INR except Per Share FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 12 Months Ending 03/31/2018 03/31/2019 03/31/2020 03/31/2021 03/31/2022

In Millions of INR except Per Share	FY 2018	FY 2019	FY 2020	FY 2021	FY 2022
12 Months Ending	03/31/2018	03/31/2019	03/31/2020	03/31/2021	03/31/2022
Total Assets
+ Cash, Cash Equivalents & STI	85919.7	122421.8	98831.2	264084.9	249767.3
+ Cash & Cash Equivalents	42469.9	75353.3	38239.7	41755.4	64985.1
+ ST Investments	43449.8	47068.5	60591.5	222329.5	184782.2
+ Accounts & Notes Received	229174.5	282125.5	279129.6	333316	363473.5
+ Accounts Receivable, Net	229174.5	282125.5	279129.6	333316	363473.5
+ Notes Receivable, Net	0	0	0	0	0
+ Unbilled Revenues	365251.6	402649	449889.4	443930.5	487833.3
+ Inventories	25000.5	33492.4	27699	28775.7	31325.1
+ Raw Materials	6677.4	7732.9	5078.2	4567.5	5547.3
+ Work In Process	3339.6	4898.7	3674.8	2122.3	2721.5
+ Finished Goods	4394.4	6166.8	3264.8	1204	2113.1
+ Other Inventory	10589.1	14694	15681.2	20881.9	20943.2
+ Other ST Assets	88677.6	69903	100801.9	82346.2	87779.4
+ Prepaid Expenses	31432.5	14247.7	13630.5	14932.4	13548.2
+ Derivative & Hedging Assets	0	0	0		0
+ Assets Held-for-Sale	3880	417.2	27803.7
+ Taxes Receivable
+ Misc ST Assets	53365.1	55238.1	59367.7	67413.8	74231.2
Total Current Assets	794023.9	910591.7	956351.1	1152453.3	1220178.6
+ Property, Plant & Equip, Net	67245.6	85493.2	80628	88773.2	89004.6
+ Property, Plant & Equip	97553.6	127377.5	125918.4	145705.4	154333.9
- Accumulated Depreciation	30308	41884.3	45290.4	56932.2	65329.3
+ LT Investments & Receivables	234692.4	185785.6	284656.8	259488.8	234579.9
+ LT Investments	234692.4	185785.6	284656.8	259488.8	234579.9
+ Other LT Assets	60104.9	64726.8	93930	98440.9	141259.7
+ Total Intangible Assets	3938.6	4004.1	843.8	1661.3	2058.4
+ Goodwill	0	0	0	472.9	472.9
+ Other Intangible Assets	3938.6	4004.1	843.8	1188.4	1585.5
+ Prepaid Expense				316.3	1082.9
+ Deferred Tax Assets	4006.2	8418.6	14282	7542.7	11403
+ Derivative & Hedging Assets	0	0	0
+ Investments in Affiliates		0	0	16401	25419.8
+ Misc LT Assets	52160.1	52304.1	78804.2	72519.6	101295.6
Total Noncurrent Assets	362042.9	336005.6	459214.8	446702.9	464844.2
Total Assets	1156066.8	1246597.3	1415565.9	1599156.2	1685022.8

Liabilities & Shareholders' Equity
+ Payables & Accruals	335914.4	381669.5	388208	443399.6	486293.2
+ Accounts Payable	310950	362250.3	366293.9	407697.8	453853.4
+ Accrued Taxes	3679.7	3209.1	6289.2	4167.4	6598.7
+ Interest & Dividends Payable	636.9	846.4	1142.7	1277.8	1293.5
+ Other Payables & Accruals	20647.8	15363.7	14482.2	30256.6	24547.6
+ ST Debt	50658.4	82176.2	187318.6	79414.9	74543.2
+ ST Borrowings	41295.7	40861.6	150441.1	68279	20973.9
+ ST Lease Liabilities	0		1322.7	1140.3	1244.4
+ ST Finance Leases	0
+ Current Portion of LT Debt	9362.7	41314.6	35554.8	9995.6	52324.9
+ Other ST Liabilities	216972.1	238747.8	238276.2	284232.3	314838.4
+ Deferred Revenue	194167.9	212724.5	200572.5	251797.8	265710.6
+ Derivatives & Hedging	0	0	0		3469
+ Misc ST Liabilities	22804.2	26023.3	37703.7	32434.5	45658.8
Total Current Liabilities	603544.9	702593.5	813802.8	807046.8	875674.8
+ LT Debt	54951.6	37720.7	72098.9	167229.7	130223.9
+ LT Borrowings	54949.6	37720.1	71857.1	166467.3	129684.1
+ LT Lease Liabilities	2	0.6	241.8	762.4	539.8
+ LT Finance Leases	2	0.6
+ Other LT Liabilities	5827.8	5798.9	7910.7	7501.5	7983.6
+ Accrued Liabilities	0	0	0	0
+ Pension Liabilities			6112.3	6559	6452.7
+ Deferred Compensation
+ Deferred Revenue	0	0	0	0
+ Deferred Tax Liabilities
+ Derivatives & Hedging	0	0	0		153.7
+ Misc LT Liabilities	5827.8	5798.9	1798.4	942.5	1377.2
Total Noncurrent Liabilities	60779.4	43519.6	80009.6	174731.2	138207.5
Total Liabilities	664324.3	746113.1	893812.4	981778	1013882.3
+ Preferred Equity and Hybrid Capital	0	0	0	0	0
+ Share Capital & APIC	86432.9	87525.4	88803.8	89485.6	89997.5
+ Common Stock	2802.7	2805.5	2807.8	2809.1	2810.1
+ Additional Paid in Capital	83630.2	84719.9	85996	86676.5	87187.4
- Treasury Stock	0	0	0	0	0
+ Retained Earnings	142500.1	150469.9	169571.7	257220.5	311311.4
+ Other Equity	262809.5	262488.9	263378	270672.1	269831.6
Equity Before Minority Interest	491742.5	500484.2	521753.5	617378.2	671140.5
+ Minority/Non Controlling Interest	0	0	0	0	0
Total Equity	491742.5	500484.2	521753.5	617378.2	671140.5
Total Liabilities & Equity	1156066.8	1246597.3	1415565.9	1599156.2	1685022.8

Reference Items
Accounting Standard	IN GAAP	IN GAAP	IN GAAP	IN GAAP	IN GAAP
Shares Outstanding	1401.3695	1402.7294	1403.892	1404.5553	1405.0291
Number of Treasury Shares	0	0	0	0	0
Pension Obligations	4728.7	4976.2	6112.3	6559	6452.7
Future Minimum Operating Lease Obligations	588.8	323
Capital Leases - Total	2	0.6
Percent Of Foreign Ownership	18.42	18.7	16.69	22.78	22.13
Number Of Shareholders	899902	1021275	1251569	1371535	1492124
Options Granted During Period	0.6691	0.6651	0.6976	0.104	0.5508
Options Outstanding at Period End	4.2656	2.8852	2.5214	1.7816	1.7184
Net Debt	19690.3	-2524.9	160586.3	-17440.3	-45000.2
Net Debt to Equity	4.0042	-0.5045	30.7782	-2.8249	-6.705
Tangible Common Equity Ratio	42.3394	39.9552	36.8206	38.5427	39.7562
Current Ratio	1.3156	1.296	1.1752	1.428	1.3934
Cash Conversion Cycle	-181.3967	-187.4331	-229.2387	-228.6545	-195.6249
Number of Employees	42924	44761	45467	40527	50267

Do financial statements analysis and interpretation to understand financial health of selected organization(s) using tools (ratios) and techniques (costing)
Analyze and interpret financial health of an organization i.e.
- how organization has been doing for last 5 years (trend analysis),
- how organization is doing vis-a-vis its competitors in last 5 years (comparative analysis) and
- how organization is doing vis-a-vis its industry average in last 5 years (industry comparative analysis).

Analyze and interpret financial health in terms of its:

Riskiness arising out of its cost structure (Do CPV Analysis)
Liquidity position i.e. organization(s) ability to meet current liabilities from current assets and ability to convert current assets into cash (Assets Utilization),
Leverage position Both Operating leverage (how EBIT is sensitive due to change in revenue) and financial leverage (how EPS in sensitive due to change in EBIT), Organizations ability to meet financial obligations (Interest on loan), etc.
Profitability Position Economic Profitability (profit generating capacity from effective utilization of its assets or capacity), Commercial Profitability (profit generating capacity from revenue) and Owners Profitability (contribution of profit to owners)