Project of Accounting Section 9
Project of Accounting Section 9
Project of Accounting Section 9
PROFESSOR
SUBMITTED BY:-
1
TABLE OF CONTENTS
Serial CONTENTS
No. PAGE
NO:
1 INTRODUCTION 3–5
INDUSTRY AND
2 6–7
COMPANY PROFILE
4 30 – 31
SWOT ANALYSIS
5 FINDINGS, 32– 34
SUGGESTIONS &
CONCLUSION
2
1. INTRODUCTION:-
Introduction
The study on financial performance of the company is by using ratio analysis, trend
analysis and comparative statements to assess the solvency, liquidity, and
profitability of the selected company. Ratio analysis is a quantitative method of
gaining insight into a company's liquidity, operational efficiency, and profitability by
studying its financial statements such as the balance sheet and income statement. A
comparative statement is a document used to compare a particular financial
statement with prior period statements. Previous financials are presented alongside
the latest figures in side-by-side columns, enabling investors to identify trends, track
a company's progress and compare it with industry rivals.
1.1Statement of the problem
1
profitability, solvency and liquidity position and to check whether the
organization is in a position to meet their obligations in properly and timely
manner. Here the problem is to study about the financial performance of Tata
Motors Ltd.
1.2Scope of study
The study was conducted in Tata Motors Ltd to analyze the effectiveness of the
financial performance of the company during the last five years ranging from
2015-2016 to 2019-2020 to have a clear and a proper outline regarding the
financial aspects of the organization by using various analysis tools.
1.3Significance of study
Secondary data is used in the study, as the study mainly depended on secondary
2
data.
The study is based on the current year and past four years. That is 2016-2020.
The sample size is limited to one company. The company selected is TATA
Motors ltd.
For analysis, the data collected through secondary source especially the financial
statements of the company, statistical tools such as ratio analysis and
comparative balance sheet are used and the results are interpreted using tables,
graphs and bar diagrams.
3
Company profile
Tata Motors limited, is an Indian multinational automotive manufacturing
company headquartered in Mumbai, Maharashtra, India. It is a part of Tata
group, an Indian conglomerate. Its products include passenger cars, trucks, vans,
coaches, buses, sports cars, construction equipments and military vehicles.
4
manufacturer Daewoo commercial vehicle company in 2004 and purchased
Jaguar Land Rover from Ford in 2008.Tata Motors is listed on the BSE
(Bombay Stock Exchange), where it is a constituent of the BSE SENSEX index,
the National Stock Exchange of India, and the New York Stock Exchange. The
company is ranked 265th on the Fortune Global 500 list of the world’s biggest
corporations as of 2019.On 17 January 2017, Natarajan Chandrasekaran was
appointed chairman of the company Tata Group. Tata Motors increases its
utility vehicle market share to over 8% in FY2019.
Mission
Tata Motors ltd innovate mobility solutions with passion to enhance the quality of
life.
Vision
By FY 2024, the company will become the most aspirational Indian auto
brand, consistently winning, by
5
3. Data analysis and interpretation
As on 31 March, 2016-2020
(Rs. In crore)
particulars 2015- 2016- 20172018 2018- 2019-
2016 2017 2019 2020
Equity and
liabilities
Equityshare 679.18 679.22 679.22 679.22 719.54
Capital
Reserves and 22582.93 20483.39 19491.76 21483.30 16800.61
surplus
6
Total share 23262.11 21162.61 20170.98 22162.52 18387.65
holders funs
Non- current
liabilities
Current
liabilities
7
Total capital 56676.00 58878.28 59212.30 60909.63 62589.87
and
liabilities
Assets
Non-current
Assets
Current assts
8
Trade 2045.58 2128.00 3479.81 3250.64 1978.06
receivable
Assets
Total current 11861.69 12757.07 14971.66 13229.30 13568.76
assets
9
Liquidity Ratio (short term solvency ratio)
3) Super quick ratio = super quick assets/current liabilities Table 3.3 showing
10
Figure 3.3 showing super quick ratio
11
Proprietary ratio = share holders’ fund/total assets
Figure 3.5 showing proprietary ratio
12
Fixed assets to net worth ratio = fixed assets/total share holders’ fund
Table 3.7 showing fixed assets to net worth ratio
YE FIXED ASSETS TO NET WORTH
AR RATIO
2016 26762.34/23262.11 = 1.15:1
2017 28043.92/21162.61 = 1.32 :1
2018 26800.35/20170.98 = 1.33:1
2019 28573.42/22162.52 = 1.29:1
2020 29702.78/18387.65 = 1.62:1
The following table shows fixed assets to net worth ratio. The standard rate of
the fixed assets to net worth ratio is one. The company shows higher ratio for
the past five years, when compared to the standard ratio. A higher ratio
indicates that the outsiders’ funds have been used to acquire a part of fixed
assets.
13
7) Fixed assets ratio = (fixed assets/long term funds)*100
Long term funds = share capital + reserves and surpluses + long term
liabilities
14
8) Capital gearing ratio = fixed income bearing funds/equity share holders’
funds
15
Income statement
As on 31 march 2016-2017
(Rs in crore)
particulars 2015-2016 2016- 2017- 2018- 2019-2020
2017 2018 2019
Income
16
Changes 10.05 -252.14 842.05 144.69 722.68
in
inventory
of FG,
WIP,
Stock-In
- Trade
Employee 3188.97 3764.65 3966.73 4273.10 4384.31
benefit
expenses
Finance 1592.00 1569.01 1744.43 1793.57 1973.00
costs
Depreciation 2329.22 3037.12 3101.89 3098.64 3375.29
and
amortization
expenses
17
Other 6790.29 8802.57 8396.33 7141.52 7182.25
expenses
43820.13 47311.96 60369.27 69155.42 49927.64
Total
expenses
operation)*100
10) Net profit ratio = (net profit after tax/revenue from operation)*100
Figure 3.11 showing net profit ratio
19
AR
2016 (29279.14/42845.47)*100 = 68.34%
2017 (30866.95/44316.34)*100 = 69.65%
2018 (42486.60/58831.41)*100 = 72.22%
2019 (51109.47/69202.76)*100 = 73.85%
2020 (26143.74/43928.17)*100 = 59.47%
The following table shows operating profit ratio. An operating profit ratio
higher than 15% is considered good. The company has higher ratio for the past
five years. So it indicates that the company is earning enough money from
business operations to pay for all of the associated costs involved in
maintaining the business.
20
Long term 10599.96 13686.09 3086.13 29.11%
borrowings
liabilities
liabilities
21
current assets
44814.31 46121.21 1306.9 2.92%
Totalnoncurrent
assets
Inventories 5117.92 5553.01 435.09 8.50%
788.42 326.61 -461.81 -58.57%
Cash and
equivalents
Other current 5955.35 6877.45 922.1 15.48%
Assets
11861.69 12757.07 895.38 7.55%
Total current
assets
Total assets 56676.00 58878.28 2202.28 3.89%
Table 3.15 showing Comparative balance sheet from 2016-17 to 2017-18
particulars 2016- 2017- Increase/ Increase/
Decrease decrease in
2017 2018
in percentage
amount
Share capital 679.22 679.22 0 0%
Reserves and 20483.39 19491.76 -991.63 -4.84%
surplus
liabilities
LT 892.18 1009.48 117.3 13.15%
provisions
liabilities
22
Other ST 15902.6 20256.1 4353.5 27.38%
6 6
liabilities
ST 477.17 862.92 385.75 80.84%
provisions
Total current 21538.3 24218.9 2680.6 12.45%
liabilities 5 5
23
Table 3.16 showing Comparative balance sheet from 2017-18 to 2018-19
particulars 2017- 2018- Increase/decrea Increase/decrea
2018 2019 se se
in amount in percentage
Share capital 679.22 679.22 0 0%
Reserves 19491.76 21483.30 1991.54 10.22%
and surplus
Long term 13155.91 13914.74 758.83 5.77%
borrowings
OtherLT 656.98 609.94 -47.04 -7.16%
liabilities
LT 1009.48 1281.59 272.11 26.96%
provisions
Total 14822.37 15806.30 983.93 6.64%
noncurrent
liabilitie
s
Short term 3099.87 3617.72 517.85 16.71%
borrowings
Other ST 20256.16 18174.4 -208.76 -10.28%
liabilities
ST 862.92 1148.69 285.77 33.12%
provisions
Total 24218.95 22940.81 -1278.14 -5.28%
current
liabilities
Total 59212.30 60909.63 1697.33 2.87%
liabilitie
s
Capital WIP 1371.45 2146.96 775.51 56.55%
Fixed assets 26800.35 28573.42 1773.07 6.62%
Other 39044.04 41393.74 2349.7 6.02%
noncurrent
assets
Total non- 44240.64 47680.33 3439.69 7.77%
current
assets
24
Cash and 795.42 1306.61 511.19 64.27%
equivalents
Assets
Total current 14971.6 13229.3 -1742.36 -11.64%
assets 6 0
Total assets 59212.3 60909.6 1697.33 2.87%
0 3
Table 3.17 showing Comparative balance sheet from 2018-19 to 2019-20
particulars 2018- 2019- Increase/ Increase/
decrease decrease in
2019 2020 in percentage
amount
Share 679.22 719.54 40.32 5.94%
capital
Reserves 21483.30 16800.61 -4682.69 21.80%
and
surplus
liabilities
ST 1148.69 1406.75 258.06 22.47%
provisions
25
Total 22940.81 25810.82 2870.01 12.51%
current
liabilities
liabilities
Capital 2146.96 1755.51 -391.45 -18.23%
WIP
Fixed assets 28573.42 29702.78 1129.36 3.95%
Other 41393.74 44526.39 2132.65 5.15%
noncurrent
assets
Assets
Total 13229.30 13568.76 339.46 2.57%
current
Assets
Interpretation:
In comparative balance sheet, it shows the changes in the items on it on the basis
of just previous year. In case of current assets and current liabilities, the
comparative balance sheet from 2016-17 to 2017-18 shows that current assets
increased to 17.36% and current liabilities to 12.45%. But in case of other three
comparative balance sheets, the current liabilities show higher percentage than
26
the current assets. When we analyze the comparative balance sheet from 201718
to 2018-19, it shows negative value in case of current assets and liabilities. Thus
it results that, the short term financial position of the company is not satisfied.
In case of liquid assets (cash and equivalents), shows an increase in the current
year of the comparative balance sheet except that of 2015-16 to 2016-17. This
means that, there is an improvement in the liquidity position of the company.
If we analyze the fixed assets, long term liabilities and capital, the share capital
of the company is increased only in the comparative balance sheet of 2018-19
to 2019-20 to 5.94%. The share capital is constant for the others. It also shows
increasing fixed assets and long term liabilities except 2016-17 to 2017-18. If
we compare the increasing fixed assets and long term liabilities in the
comparative balance sheets, we can see that long term liabilities are
comparatively more than the fixed assets. That means, the fixed assets and part
of working capital has also been financed from the long term sources. So, this
indicates that the company’s long term financial position is satisfied.
27
4.SWOT ANALYSIS:-
4.1 Strengths:
1. Diverse Product Portfolio: Tata Motors had a diverse range of
vehicles, including passenger cars, utility vehicles, and commercial
vehicles.
2. Global Presence: The company had a global footprint, with operations
and sales in various international markets.
3. Innovation and Technology: Tata Motors focused on innovation and
adopted advanced technologies in their vehicles, enhancing their
competitiveness.
4.2 Weaknesses:
1. Quality Concerns: Tata Motors faced challenges with product quality,
especially in some of their passenger cars, which affected their reputation.
2. Dependence on Commercial Vehicles: The heavy reliance on
commercial vehicles made Tata Motors vulnerable to economic downturns
in the commercial sector.
4.3 Opportunities:
1. Electric Vehicles (EVs): The increasing interest in electric vehicles
presented an opportunity for Tata Motors to expand their presence in the
EV market.
2. Global Market Expansion: There was room for Tata Motors to further
penetrate and expand in emerging markets and strengthen their position in
established ones.
28
4.4 Threats:
5.1Findings
● The company’s short term assets are not sufficient to meet the short term
liabilities.
● The company is highly dependent on creditors for the working capital and its
outsiders’ funds are not sufficient to manage their earnings.
● The company’s solvency position is strong as they have sufficient total assets to
meet their debts.
● The company use share holders’ funds and short term funds to finance the fixed
assets
● The company’s equity share capital is less than fixed income bearing funds,
which is a satisfactory element to the share holders.
29
● The company is in loss for the past five years except 2019, which means that
the company is not able to pay the returns to share holders. The company has to
improve its net profit.
● The company shows lower ratio in operating cost ratio, which is a satisfactory.
● Operating profit ratio shows higher value indicating that it is a good sign.
● In comparative balance sheet, the company’s long term financial position,
liquidity position and profitability are satisfactory.
5.3 Conclusions
The study highlights, the financial performance of Tata Motors Ltd is
satisfactory. To conclude, Tata Motors company has shown its impact on
industry. We can see the downfall of the company, but it is expected, as it is
such a big company. Looking at all the five years, 2019 is considered the best
financial year out of all the five years, as it has improved its profitability in the
year 2019. If the company manages its revenue from sales and assets, it is
expected to recover from the loss.
30