Project Mcom
Project Mcom
Project Mcom
UNIVERSITY, PRAYAGRAJ
Submitted By
SHASHWAT MISRA
ENROLLMENT NUMBER: - 242051214312743
CENTRE CODE: - S051
CENTRE NAME: - ISHWAR SHARAN DEGREE
COLLEGE, PRAYAGRAJ
SESSION: - 2024-2025
SEMESTER: - I ST
PAPER CODE: - M.COM 106
ACKNOWLEDGEMENT
SHASHWAT MISRA
ENROLL. NO. 242051214312743
Introduction to Financial Analysis
The significance of financial analysis lies in its ability to provide a clear picture
of how well a company is managing its resources and generating returns. It
offers a foundation for comparing performance across companies and industries,
and it enables predictions regarding a company’s future growth, profitability,
and risk. For investors, it provides data-driven insights, allowing them to gauge
the company’s potential and risk profile. For management, financial analysis
aids in refining strategies to achieve operational and financial objectives.
This analysis will focus on identifying both the strengths and weaknesses of
TCS’s financial performance, ultimately enabling a deeper understanding of the
company's market standing and its ability to maintain sustainable growth in the
competitive global IT landscape.
SCOPE OF THE ANALYSIS
The financial analysis will focus on TCS's performance over the last fiscal year,
covering the period from [Fiscal Year 2023-2024] in which the statements of
both the years are taken into consideration along with a basic trend followed for
last five years. This time frame will allow for a comprehensive understanding of
the company's financial trajectory, highlighting any significant changes, trends,
and reactions to market or economic conditions.
RESEARCH METHODOLOGY
The research methodology for this study on the financial analysis of Tata
Consultancy Services (TCS) involves a combination of descriptive,
comparative, and quantitative analysis. This approach will allow for an in-depth
understanding of the company’s financial health, performance, and its position
within the global IT industry.
1. Research Design
This study is exploratory and analytical in nature. The goal is to analyse the
financial performance of TCS using data from its published financial reports,
which will be examined using financial ratios and other tools to assess its
profitability, liquidity, efficiency, and solvency. Additionally, comparisons will
be made with key competitors in the IT services sector to benchmark TCS's
performance.
2. Data Collection
The data for this study will be primarily secondary data sourced from the
following:
(i) TCS’s Annual Reports: These reports will provide the financial statements
(income statement, balance sheet, and cash flow statement) for the selected
years, along with management commentary and notes on financial performance.
(ii) TCS's Investor Relations Website: This site will provide up-to-date
information on TCS's financial performance, quarterly results, and other
investor-related reports.
(iv) Industry Reports and Market Analysis: Reports from industry analysis
firms (e.g., Gartner, IDC, or McKinsey) and market research platforms will
provide insights into the broader trends in the IT services sector, as well as the
competitive landscape.
(v) Other Financial Databases: Information from financial platforms like
Bloomberg, Reuters, or Yahoo Finance may be used to gather additional
financial metrics, stock performance, and historical data for comparison
purposes.
3. Financial Tools and Techniques
The analysis will use various financial tools and techniques, including:
1. Ratio Analysis: To assess key financial indicators, such as profitability ratios
(e.g., Return on Equity, Return on Assets), liquidity ratios (e.g., Current Ratio,
Quick Ratio), efficiency ratios (e.g., Asset Turnover), and solvency ratios (e.g.,
Debt-to-Equity Ratio).
2. Trend Analysis: To identify and analyse significant patterns or changes in
TCS’s financial performance over the period of study (2018–2023).
3. Benchmarking: Comparing TCS’s financial ratios and performance metrics
against industry standards and key competitors (e.g., Infosys, Wipro) to gauge
its relative position in the market.
4. Cash Flow Analysis: Assessing the inflow and outflow of cash within the
company to understand its liquidity and operational efficiency.
Once the data is collected, the financial statements of TCS will be analysed to
derive key ratios and metrics. These ratios will be compared against industry
norms and competitors to interpret the company’s financial health and
performance over the study period. The analysis will also involve:
1. Trend analysis to highlight the company's growth trajectory and key financial
developments.
2. Ratio comparison to assess how TCS stands in comparison to other firms in
the IT services sector.
3. Financial forecasting where applicable, based on historical data, to provide
insights into potential future performance.
4. Interpretation of Key Findings After the data is analysed, the results will be
interpreted to draw conclusions about TCS’s overall financial health.
5. Limitations of the Study
Below is a graph showing the last five-year growth of TCS to get a basic
understanding of the financial performance of the company.
ANALYSIS OF THE COMPANY
Horizontal and Vertical Analysis are two important techniques used in financial
statement analysis to assess a company's performance and financial health. Both
of these methods involve comparing financial data over time and analysing the
structure of financial statements. Here's a detailed explanation of each:
1. Horizontal Analysis
Horizontal Analysis is a method that involves comparing financial data over a
series of periods. The main goal of horizontal analysis is to identify trends and
growth patterns in a company's financial performance over time.
Horizontal analysis examines the percentage change in financial figures over a
period of time (usually multiple years). It helps to analyse trends in revenue,
expenses, profits, and other financial metrics.
How it Works: In horizontal analysis, each line item in the financial statement
is compared with the same line item in previous years to determine the dollar
amount change and the percentage change.
Example: If TCS’s revenue was ₹50,000 crore in 2022 and ₹55,000 crore in
2023, the horizontal analysis would be:
55000 – 50000 ×100
50000
2. Vertical Analysis
Vertical Analysis is a method of analysing financial statements by expressing
each line item as a percentage of a base item. It provides insight into the relative
size of each financial component within the overall structure of the financial
statement.
In vertical analysis, every item on a financial statement (income statement or
balance sheet) is presented as a percentage of a base item (for the income
statement, this is usually total revenue; for the balance sheet, it is total assets).
How it Works: In the income statement, vertical analysis compares each line
item as a percentage of total revenue. In the balance sheet, each line item is
expressed as a percentage of total assets. This allows for easy comparison across
periods, companies, or industries.
Example: If TCS’s total revenue in 2023 is ₹60,000 crore and its cost of goods
sold (COGS) is ₹40,000 crore, the vertical analysis would be:
COGS Percentage = 40000 × 100 = 66.67%
60000
This indicates that the cost of goods sold accounts for 66.67% of TCS’s total
revenue.
Interpretation: Vertical analysis helps to understand:
Cost Structure: It provides insights into how much of the company's
revenue goes into various costs (e.g., COGS, operating expenses, taxes).
Profit Margins: By comparing net income as a percentage of total
revenue, it shows how much profit the company retains after all expenses.
Efficiency: It helps identify if certain expense categories are growing
disproportionately to revenue.
Comparison with Industry Norms: It allows for comparison with
industry averages or competitors, which can highlight strengths or areas
for improvement.
Both horizontal and vertical analysis are valuable for conducting a detailed
financial analysis of TCS:
31,481 36,897
44,434 41,049
9,143 8,905
9,016 7,123
4,270 3,909
491 1,325
1,703 1,319
151 8
12,267 9,707
1,12,984 1,10,270
1,46,449 1,43,651
362 366
90,127 90,058
90,489 90,424
830 782
91,206
6,516 6,203
365 353
686 536
977 792
482 1,003
9,026 8,887
1,505 1,485
9,981 10,515
8,362 9,068
3,640 3,843
6,524 4,892
140 345
4,519 4,065
11,433 9,345
46,104 43,558
1,46,449 1,43,651
ANALYSIS OF BALANCE SHEET
1. Total Assets Growth
- FY 2024: ₹1,46,449 crore
- FY 2023: ₹1,43,651 crore
- Increase: ₹2,798 crore (1.95%)
- Insight: The company’s total assets increased slightly, suggesting
controlled expansion.
2. Non-Current Assets
- FY 2024: ₹33,465 crore
- FY 2023: ₹33,381 crore
- Increase: ₹84 crore (0.25%)
- Property, Plant, and Equipment: Decreased from ₹10,230 crore in
FY 2023 to ₹9,376 crore in FY 2024, indicating potential asset sales
or reduced capital expenditure.
- Right-of-Use Assets: Increased from ₹7,560 crore to ₹7,886 crore,
reflecting new lease agreements or extensions.
3. Current Assets
- FY 2024: ₹1,12,984 crore
- FY 2023: ₹1,10,770 crore
- Increase: ₹2,214 crore (2.00%)
-Trade Receivables: Increased from ₹41,049 crore to ₹44,434 crore,
signalling higher sales on credit.
- Cash and Cash Equivalents: Increased slightly from ₹8,905 crore
to ₹9,143 crore, indicating a stable liquidity position.
4. Equity
- Share Capital: Reduced marginally from ₹366 crore in FY 2023 to
₹362 crore in FY 2024.
- Other Equity: Grew from ₹90,058 crore to ₹90,127 crore,
suggesting retained earnings and possibly a moderate increase in
reserves.
- Total Equity: Increased from ₹91,206 crore in FY 2023 to ₹91,319
crore in FY 2024, indicating a stable equity base.
5. Non-Current Liabilities
- FY 2024: ₹9,026 crore
- FY 2023: ₹8,887 crore
- Increase: ₹139 crore (1.56%)
- Lease Liabilities: Increased from ₹6,203 crore to ₹6,516 crore,
likely due to new long-term leases.
- Deferred Tax Liabilities (Net)*: Increased from ₹792 crore to
₹977 crore, which might be due to deferred tax provisions on future
tax obligations.
6. Current Liabilities
- FY 2024: ₹46,104 crore
- FY 2023: ₹43,558 crore
- Increase: ₹2,546 crore (5.84%)
- Trade Payables: Decreased from ₹10,515 crore to ₹9,981 crore,
indicating improved payment cycles or lower procurement.
- Other Financial Liabilities: Increased from ₹9,068 crore to ₹8,362
crore, showing a rise in current liabilities.
- Provisions: Increased from ₹4,405 crore to ₹4,519 crore, possibly
due to higher provision for employee benefits or other obligations.
This Profit and Loss statement reflects the company's strong financial health,
with sustained revenue growth, effective cost control, and higher profitability
for FY 2024.
ANALYSIS OF CASH FLOWS STATEMENT
1. Cash Flows from Operating Activities
- Profit for the Year:
- FY 2024: ₹46,099 crore
- FY 2023: ₹42,303 crore
- Increase of ₹3,796 crore (8.97%), reflecting strong profitability.
- Adjustments:
- Depreciation and Amortisation: ₹4,985 crore in FY 2024 vs. ₹5,022 crore in
FY 2023, showing consistency in non-cash expenses.
- Tax Expense: ₹15,898 crore in FY 2024, up from ₹14,604 crore in FY 2023,
indicating a higher tax outlay in line with increased profits.
- Interest Income: Reduced slightly to ₹3,781 crore from ₹3,248 crore,
potentially due to lower interest-yielding investments.
- Operating Profit Before Working Capital Changes:
- FY 2024: ₹63,709 crore
- FY 2023: ₹59,148 crore
- Increase of ₹4,561 crore (7.71%), indicating improved operational
efficiency.
- Net Change in Working Capital:
- Inventories: No significant change in FY 2024 (stable), suggesting consistent
inventory management.
- Trade Receivables: Decrease of ₹3,327 crore in FY 2024 compared to
₹6,501 crore in FY 2023, indicating improved collections.
- Trade Payables: Decreased by ₹632 crore in FY 2024, compared to an
increase of ₹2,036 crore in FY 2023, indicating better cash outflows to
suppliers.
- Net Cash Generated from Operating Activities:
- FY 2024: ₹44,338 crore
- FY 2023: ₹41,965 crore
- Increase of ₹2,373 crore (5.65%), reflecting a strong cash inflow from core
business activities.
2. Cash Flows from Investing Activities
- Bank Deposits Placed: ₹9,471 crore in FY 2024, up from ₹4,548 crore in
FY 2023, indicating higher funds set aside in deposits.
- Purchase of Investments: ₹1,41,011 crore in FY 2024, slightly up from
₹1,29,745 crore in FY 2023, showing a significant investment strategy.
- Proceeds from Disposal/Redemption of Investments:
- FY 2024: ₹1,47,204 crore
- FY 2023: ₹1,22,687 crore
- Increase of ₹24,517 crore (20%), suggesting a more aggressive approach to
liquidate investments for liquidity.
- Net Cash Generated from Investing Activities:
- FY 2024: ₹6,026 crore
- FY 2023: ₹39 crore
- Increase of ₹5,987 crore, showing a significant improvement in cash
inflow from investment activities, primarily due to proceeds from investment
redemptions.
3. Cash Flows from Financing Activities
- Dividend Paid: ₹25,137 crore in FY 2024, down from ₹41,347 crore in FY
2023, indicating a lower payout ratio or revised dividend policy.
- Buy-back of Equity Shares: ₹17,000 crore in FY 2024, with no buyback
activity in FY 2023, reflecting a return of capital to shareholders.
- Interest Paid: Slight decrease from ₹779 crore in FY 2023 to ₹699 crore in
FY 2024, showing reduced finance costs.
- Net Cash Used in Financing Activities:
- FY 2024: ₹ (48,536) crore
- FY 2023: ₹ (47,878) crore
- Increase of ₹658 crore in outflow, mainly due to the buy-back and dividend
payments, demonstrating substantial cash returns to shareholders.
4. Net Change in Cash and Cash Equivalents
- FY 2024: ₹1,828 crore inflow
- FY 2023: ₹ (5,874) crore outflow
- This significant positive change in FY 2024 reflects improved cash position
due to higher operating and investing cash inflows.
5. Cash and Cash Equivalents at Year-End
- FY 2024: ₹9,016 crore
- FY 2023: ₹7,123 crore
- Increase of ₹1,893 crore, showcasing a better liquidity position at the end of
FY 2024.
Summary
Operating Activities: Continued strong performance with consistent cash
inflow growth, indicating stable operations.
Investing Activities: Strategic investments and redemptions led to a substantial
positive cash flow, highlighting effective liquidity management.
Financing Activities: Major cash outflows due to dividends and share buy-
back, demonstrating the company's focus on shareholder returns.
Overall Liquidity: Increased cash and cash equivalents, showcasing improved
liquidity at year-end, which strengthens the financial stability of the company.
RATIO ANALYSIS
A. Liquidity Ratios: Liquidity ratios analyse the ability of a company to pay
off both its current liabilities as they become due as well as their long-term
liabilities as they become current. The liquidity ratio measures a company's
ability to cover its short-term obligations using its most liquid assets. A higher
liquidity ratio indicates better short-term financial health, suggesting the
company can easily meet its immediate debts.
Liquidity: The current and quick ratios indicate strong liquidity, showing that
TCS has sufficient short-term assets to cover its current liabilities. These ratios
are slightly lower in 2024 compared to 2023, but they are still comfortably
above 1, indicating good liquidity management.
1. Liquidity Ratios: Current Ratio and Quick Ratio both improved slightly
from 2023 to 2024, indicating an improvement in TCS's ability to cover its
short-term liabilities with its current assets. A current ratio above 1.0
suggests sufficient liquidity, with the quick ratio reflecting efficient
management of highly liquid assets.
4. Leverage Ratios: TCS maintained a stable Debt to Equity Ratio and Debt
Ratio, suggesting a balanced capital structure with limited reliance on debt
financing. The Interest Coverage Ratio increased, indicating an improved
ability to meet interest obligations, which reflects a healthy financial position
with ample earnings to cover interest expenses.
7. Strong Cash Flow Management: The company’s operating cash flows have
been consistently positive, indicating a stable cash generation capability
from core operations. This strong cash flow is critical for supporting TCS's
dividend policies, reinvestment in technology, and other capital expenditure
needs without relying on external financing.
Websites: -
on. https://www.tcs.com/content/dam/tcs/investor-relations/financial-
statements/2023-24/ar/annual-report-2023-2024.pdf
economictimes.indiatimes.com › Markets › Stocks
profit.ndtv.com/topic/tcs-annual-report
www.moneycontrol.com
www.tcs.com
Books: -
Taxmann’s Management Accounting by R. P. Rustagi