Tata Motors Financial Analysis
Tata Motors Financial Analysis
MOTORS”
UNIVERSITY OF CALICUT
Submitted by
ALTHAF E A
(CCASBCP023)
DEPARTMENT OF COMMERCE
MARCH 2021
CHRIST COLLEGE (AUTONOMOUS), IRINJALAKUDA
CALICUT UNIVERSITY
DEPARTMENT OF COMMERCE
CERTIFICATE
The information and data given in the report is authentic to the best of my
knowledge. The report has not been previously submitted for the award of any
Degree, Diploma, Associateship or other similar title of any other university or
institute.
Date: CCASBCP023
ACKNOWLEDGEMENT
Above all, I express my eternal gratitude to the Lord Almighty under whose
divine guidance; I have been able to complete this work successfully.
I am thankful to Ms. Teena Thomas, Class teacher for her cordial support,
valuable information and guidance, which helped me in completing this task
through various stages.
I would like to express my gratitude to all the faculties of the Department for
their interest and cooperation in this regard.
LIST OF TABLES
LIST OF FIGURES
FINDINGS, SUGGESTIONS
CHAPTER 5 38 – 40
& CONCLUSION
BIBLIOGRAPHY
ANNEXURE
LIST OF TABLES
TABLE
TITLE PAGE NO:
NO:
FIGURE
TITLE PAGE NO:
NO:
Liquidity ratio:
Liquidity ratios are used to measure the liquidity position or short term
financial position of a firm. These ratios are used to assess the short term
debt paying ability of a firm. These ratios are highly useful to creditors and
commercial banks that provide short term credit. Liquidity ratios are divided
into current ratio, quick ratio.
Current ratio:
It is the ratio of current assets to current liabilities. It shows the relationship
between total current assets and total current liabilities. Current ratio is also
called working capital ratio or banker’s ratio. The objective of calculating
this ratio is to measure the ability of a firm to pay off its obligations in time.
Generally 2:1 is considered as satisfactory ratio.
Quick ratio:
This shows the relationship between quick assets and current liabilities. It is
also called acid test ratio. The objective of computing this ratio is to measure
the ability of the firm to meet its short term liabilities and when due without
depending upon the sale of stock. The ideal ratio is 1:1.
Solvency ratio:
This ratio shows the relationship between total assets and total liabilities of a
business. It measures the solvency of the business. The term solvency means
the ability of a firm to pay the outside liabilities out of total assets. This is
also known as total asset to total debt ratio. The standard ratio is not fixed.
Proprietary ratio:
This ratio shows the relationship between shareholders or proprietor’s fund
and total asset. This ratio shows how much funds have been contributed by
the shareholder’s in the total assets of the firm. The ideal ratio is 0.5:1.
Fixed asset ratio:
It is an efficiency ratio that indicates how well or efficiently a business uses
fixed assets to generate sales. This ratio divides net sales by net fixed assets,
calculated over an annual period. The standard fixed asset ratio should not
exceed 1:1.
CREDITORS:
Anyone who has advanced assets to an association is excited about its
capability to pay back the commitment, in this manner will effort on a couple
of pay measures
MANAGEMENT:
The association controller makes an on-going examination of the
association's budgetary outcomes, particularly in association with different
operational estimations that are not seen by outside components.
REGULATORY BODIES:
If an association is transparently held, its spending rundowns are inspected
by the Securities and Exchange Commission to check whether its
declarations conform to the numerous accounting measures & the principles
of the SEC.
INVESTORS:
Both present and inevitable theorists look at spending outlines to get some
answers regarding an association's ability to keep issuing benefits, or to
make salary, or to continue creating at its past rate.
TATA MOTORS
0.
7
0.
6
0.
5
0.
4
0.
3
0.
2 2015- 2016- 2017- 2018- 2019-
2016 2017 2018 2019 2020
[Source: Compiled from annual report]
Table 4.2 showing quick ratio from 2015-2020
Quick ratio = quick asset/current liability
Quick asset = current asset-inventory
Year Quick asset Current liability Ratio
2015-2016 51558.08 18701.74 2.75
2016-2017 7204.06 21538.35 0.33
2017-2018 9301.53 24218.95 0.38
2018-2019 8567.3 22940.81 0.37
2019-2020 9736.84 25810.82 0.37
[Source: Compiled from annual report]
Generally Quick ratio of 1:1 is considered as satisfactory. From the table 4.2
it is clear that quick ratio is only grater the 1 in the financial year 2015-2016
during the following year it is less than 1 which means financial position of
the company is unsound. So company needs to increase the liquid asset to
attain standard ratio.
Figure 4.2 showing quick ratio from 2015-2016
2.
5
1.
5
0.
5
2015- 2016- 2017- 2018- 2019-
2016 2017 2018 2019 2020
[Source: Compiled from annual report]
Table 4.3 showing super quick ratio from 2014-2019
Super quick ratio = absolute liquid asset/current liability
Super quick asset = cash + short term investment
Year Super quick asset Current liability Ratio
2015-2016 2534.26 18701.74 0.13:1
2016-2017 2764.03 21538.35 0.12:1
2017-2018 3298.2 24218.95 0.13:1
2018-2019 2739.79 22940.81 0.11:1
2019-2020 4417.5 25810.82 0.17:1
[Source: Compiled from annual report]]
Generally super quick ratio of 0.5:1 is considered as ideal. From table 4.3 it
is clear that company is not met the ideal ratio in any of the years from 2015-
16 to 2019-20. The ratio shows fluctuating trend. Company does not keep
much of super quick asset to pay off its super quick liabilities.
Figure 4.3 showing super quick ratio from 2015-2020
0.1
8
0.1
6
0.1
4
0.1
2
0.1
0.0
8
0.0
6
2015- 2016- 2017- 2018- 2019-
2016 2017 2018 2019 2020
[Source: Compiled from annual report]
Table 4.4 showing debt equity ratio from 2015-2020
Debt equity ratio = Total debt/equity
Year Debt Equity Ratio
2015-2016 14712.15 23262.11 0.63:1
2016-2017 16177.32 21162.61 0.76:1
2017-2018 14822.37 20170.98 0.73:1
2018-2019 15806.30 22162.52 0.71:1
2019-2020 18391.40 18387.65 1.00:1
[Source: Compiled from annual report]
Debt equity ratio indicates the relative proportion of debt and equity in
financing the assets of a firm. Generally, debt equity ratio of 1:1 is
considered as standard. From the table 4.4 it is clear that the company had
not reached the standard ratio from the year 2015-2016 to 2018-2019 and in
2019-2020 it has reached the standard. It shows that the company tends to
use more of borrowed fund than the owner’s fund. The ratio shows
fluctuating trend.
Figure 4.4 showing debt equity ratio from 2015-2020
1.
2
0.
8
0.
6
0.
4 2015- 2016- 2017- 2018- 2019-
[Source: Compiled from annual report]
Table 4.5 showing proprietary ratio from 2015-2020
Proprietary ratio=shareholders fund/total asset
Year Share holders Total asset Ratio
fund
2015-2016 23262.11 56676.00 0.41:1
2016-2017 21162.61 58878.28 0.35:1
2017-2018 20170.98 59121.30 0.34:1
2018-2019 22162.52 60909.63 0.36:1
2019-2020 18387.65 62589.87 0.29:1
[Source: Compiled from annual report]
Proprietary ratio shows how much funds been contributed by the
shareholder’s in the total assets of the firm. Generally proprietary ratio of
0.5:1 or above [or 50% or more] considered as ideal .Table 4.5 shows that
the company’s proprietary ratio is less than the standard. This means high
risk to the creditors of the company. Proprietary ratio from 2015-2016 to
2019-2020 is decreasing year by year.
Figure 4.5 showing proprietary ratio from 2015-2020
0.4
5
0.4
0.3
5
0.3
0.2
5
0.2
0.1
5
2015- 2016- 2017- 2018- 2019-
0
2015- 2016- 2017- 2018- 2019-
-1 2016 2017 2018 2019 2020
-2
-3
-4
-5
-6
-7
-8
[Source: Compiled from annual report]
Table 4.7 showing fixed asset turnover ratio
Fixed asset turnover ratio = net sales/fixed asset
Year Net sale Fixed asset Ratio
2015-2016 42845.47 26762.34 1.60
2016-2017 44363.60 28043.92 1.58
2017-2018 58831.41 26800.35 2.19
2018-2019 68764.88 28573.42 2.40
2019-2020 43485.76 29702.78 1.46
[Source: compiled from annual report]
Fixed asset turnover ratio shows the relationship between fixed assets and
net sales. A higher ratio indicates better utilization of fixed assets. Generally
fixed asset turnover ratio of 4 times is considered as satisfactory. Table 4.8
shows that the fixed asset turnover ratio is below the standard. A low fixed
asset turnover ratio generally indicates that a firm does not use its asset
effectively or its full potential to generate revenue.
Figure 4.7 showing fixed asset turnover ratio from 2015-2020
1.
2
0.
8
0.
6
0.
4
0.
2015- 2016- 2017- 2018- 2019-
2016 2017 2018 2019 2020
[Source: Compiled from annual report]
Table 4.9 showing net profit ratio from 2015-2020
Year Net profit Net sale Ratio
2015-2016 -62.30 42845.47 -0.14
2016-2017 -2479.99 44363.60 -5.5
2017-2018 -1034.85 58831.41 -1.75
2018-2019 -2020.60 68764.88 -2.93
2019-2020 -7289.63 43485.76 -16.7
[Source: Compiled from annual report]
Net profit ratio is the ratio of net profit earned by a business and its net sales.
Generally Ideal form of net profit ratio is 10%. From table 4.12 shows that
the company is fail to attain the standard ratio. Which means the company is
under pricing. Also shows lower profitability and lower return to the
shareholders of the company.net profit ratio from 2015-16 to 2019-2020 is
fluctuating year by year.
0
2015- 2016- 2017- 2018- 2019-
2016 2017 2018 2019 2020
-
5
-
10
-
15
-
20
[Source: Compiled from annual report]
Table 4.10 showing return on investment ratio from 2015-2020
Return on investment=profit before interest and tax/capital employed*100
Capital employed = fixed asset + current asset – current liability
15
10
0
2015- 2016- 2017- 2018- 2019-
-5
-10
-15
-20
-
[Source: Compiled from annual report]
Table 4.11 showing return on shareholder’s fund from 2015-2020
Generally ideal from of return on share holder’s fund is 15%. From table 4.11 it is
clear that company’s return on share holder’s fund is less than the standard and it
goes to negative except the year 2018-2019. It shows that the company’s share
holders are losing, rather than gaining value. This is usually a very bad sign for
investors and managers trying to avoid a negative return as aggressively as
possible.
Figure 4.11 showing return on shareholders fund from 2015-2020
5.1SUGGESTIONS:
1. The company needs to work on its working capital by maintaining
sufficient current assets and decreasing current liabilities.
2. By taking adequate measures to increase the sale, the company can
increase its profit.
3. The company should maintain a good debt equity ratio. The current
debt equity ratio of the company is ideal. So that the company should
continue with the debt equity ratio.
4. The company’s profit is diminishing therefore they can take
immediate actions for improving profitability.
5. Fluctuations in the ratio may be because there are some kinds of
management problems or under utilization of products. The top
authorities should take necessary steps to improve the management
and production.
6. It is advisable to take more efforts to increase the overall efficiency of
the business.
5.4 CONCLUSIONS:
The study was conducted with the main objective of analyzing the financial
performance of TATA MOTORS. The study is to analyze the financial
performance of the company in terms of solvency, liquidity and profitability.
The study is carried out with the help of published annual report of the
company during 2015 to 2020. The study highlights that the financial
performance of TATA MOTORS Private limited is not satisfactory. The
profitability of the company is not wealthy, it was found to be in a gradual
decreasing manner regarding the net sales and the net profits of the company
since 2015 onwards, which can be modified by implementing proper
financial management concept. Thus it can be concluded that inner strength
of the company is remarkable. Company can further improve its profitability
through optimum capital gearing and reduction in administration and
financial expenses.
BIBLIOGRAPHY
BIBLIOGRAPHY
WEBSITES
www.google.com
www.moneycontrol.com
www.wikipedia.com
www.tatamotors.com
BOOKS
Management accounting
Financial management “SP JAIN AND NARANG”
Accounting for management “A Vinod-2013”
ANNEXURE
Corporate Overview Statutory Reports Financial Statements
(Standalone)
BALANCE SHEET
AS AT MARCH 31, 2016
(R in crores)
As at As at
Note Page
March 31, 2016 March 31, 2015
I. EQUITY AND LIABILITIES
1. SHAREHOLDERS’ FUNDS
(a) Share capital 2 F-15 679.18 643.78
(b) Reserves and surplus 3 F-17 21,688.90 14,218.81
22,368.08 14,862.59
2. NON-CURRENT LIABILITIES
(a) Long-term borrowings 4 F-18 10,687.94 12,318.96
(b) Other long-term liabilities 7 F-20 210.12 286.80
(c) Long-term provisions 9 F-21 1,409.05 2,104.19
12,307.11 14,709.95
3. CURRENT LIABILITIES
(a) Short-term borrowings 5 F-18 3,351.74 7,762.01
(b) Trade payables 11 F-21 8,916.60 8,852.65
[includes dues of micro and small enterprises R127.39 crores
(March 31, 2015 : R139.28 crores)]
(c) Other current liabilities 8 F-20 4,267.23 3,142.88
(d) Short-term provisions 10 F-21 1,215.49 613.09
17,751.06 20,370.63
TOTAL 52,426.25 49,943.17
II. ASSETS
1. NON-CURRENT ASSETS
(a) Fixed assets
(i) Tangible assets 12 F-22 12,252.78 12,260.50
(ii) Intangible assets 13 F-22 3,511.19 3,522.73
(iii) Capital work-in-progress 1,469.71 1,349.95
(iv) Intangible assets under development 5,011.18 4,690.84
22,244.86 21,824.02
(b) Non-current investments 14 F-23 16,975.46 16,966.95
(c) Long-term loans and advances 16 F-26 2,363.22 2,403.56
(d) Other non-current assets 18 F-27 136.80 175.67
41,720.34 41,370.20
2. CURRENT ASSETS
(a) Current investments 15 F-25 1,736.00 20.22
(b) Inventories 20 F-28 4,902.20 4,802.08
(c) Trade receivables 21 F-28 1,568.46 1,114.48
(d) Cash and bank balances 22 F-28 452.08 944.75
(e) Short-term loans and advances 17 F-26 1,794.32 1,574.41
(f ) Other current assets 19 F-27 252.85 117.03
10,705.91 8,572.97
TOTAL 52,426.25 49,943.17
III. NOTES FORMING PART OF FINANCIAL STATEMENTS
For DELOITTE HASKINS & SELLS LLP CYRUS P MISTRY [DIN: 00010178] N N WADIA [DIN: 00015731] GUENTER BUTSCHEK [DIN: 07427375]
Chartered Accountants Chairman CEO & Managing Director
R A MASHELKAR [DIN: 00074119]
R PISHARODY [DIN: 01875848]
S BHARGAVA [DIN: 00035672] Executive Director
B P SHROFF S B BORWANKAR [DIN: 01793948]
N MUNJEE [DIN: 00010180] Executive Director
Partner
V K JAIRATH [DIN: 00391684] C RAMAKRISHNAN
Group Chief Financial Officer
R SPETH [DIN: 03318908]
Directors H K SETHNA [FCS: 3507]
Company Secretary
Mumbai, May 30, 2016
Mumbai, May 30, 2016
(R in crores)
For DELOITTE HASKINS & SELLS LLP CYRUS P MISTRY [DIN: 00010178] N N WADIA [DIN: 00015731] GUENTER BUTSCHEK [DIN: 07427375]
Chartered Accountants Chairman CEO & Managing Director
R A MASHELKAR [DIN: 00074119]
R PISHARODY [DIN: 01875848]
S BHARGAVA [DIN: 00035672] Executive Director
B P SHROFF S B BORWANKAR [DIN: 01793948]
N MUNJEE [DIN: 00010180] Executive Director
Partner
V K JAIRATH [DIN: 00391684] C RAMAKRISHNAN
Group Chief Financial Officer
R SPETH [DIN: 03318908]
Directors H K SETHNA [FCS: 3507]
Company Secretary
Mumbai, May 30, 2016
Mumbai, May 30, 2016
F-9
Balance Sheet
(` in crores)
Notes As at As at
March 31, 2018 March 31, 2017
I. ASSETS
(1) NON-CURRENT ASSETS
(a) Property, plant and equipment 3 18,192.52 17,897.12
(b) Capital work-in-progress 1,371.45 1,902.61
( c) Goodwill 99.09 99.09
(d) Other intangible assets 5 (a) 3,312.14 2,776.71
(e) Intangible assets under development 5 (b) 3,825.15 5,368.38
(f) Investments in subsidiaries, joint ventures and associates 6 13,950.60 14,330.02
(g) Financial assets
(i) Investments 8 310.19 528.37
(ii) Loans and advances 10 143.96 391.46
(iii) Other financial assets 12 793.40 196.32
(h) Non-current tax assets (net) 695.75 772.67
(i) Other non-current assets 14 1,546.39 1,858.45
44,240.64 46,121.20
(2) CURRENT ASSETS
(a) Inventories 16 5,670.13 5,553.01
(b) Investments in subsidiaries and associate (held-for-sale) 7 681.91 -
( c) Financial assets
(i) Investments 9 1,820.87 2,437.42
(ii) Trade receivables 17 3,479.81 2,128.00
(iii) Cash and cash equivalents 19 546.82 228.94
(iv) Bank balances other than (iii) above 20 248.60 97.67
(v) Loans and advances 11 140.27 215.96
(vi) Other financial assets 13 646.31 141.54
(d) Current tax assets (net) 73.88 129.49
(e) Assets classified as held-for-sale 47(iv) 223.33 -
(f) Other current assets 15 1,439.73 1,825.05
14,971.66 12,757.08
TOTAL ASSETS 59,212.30 58,878.28
II. EQUITY AND LIABILITIES
EQUITY
(a) Equity share capital 21 679.22 679.22
(b) Other equity 19,491.76 20,483.39
20,170.98 21,162.61
LIABILITIES
(1) NON-CURRENT LIABILITIES
(a) Financial liabilities
(i) Borrowings 23 13,155.91 13,686.09
(ii) Other financial liabilities 25 211.28 1,130.23
(b) Provisions 27 1,009.48 892.18
( c) Deferred tax liabilities (net) 154.61 147.58
(d) Other non-current liabilities 30 291.09 321.24
14,822.37 16,177.32
(2) CURRENT LIABILITIES
(a) Financial liabilities
(i) Borrowings 24 3,099.87 5,158.52
(ii) Trade payables [includes dues of micro and small enterprises ` 141.59 crores 9,411.05 7,082.95
(as at March 31, 2017 ` 125.11 crores)]
(iii) Acceptances 4,814.58 4,379.29
(iv) Other financial liabilities 26 4,091.16 2,485.94
(b) Provisions 28 862.92 477.17
( c) Current tax liabilities (net) 21.77 83.68
(d) Other current liabilities 31 1,917.60 1,870.80
24,218.95 21,538.35
TOTAL EQUITY AND LIABILITIES 59,212.30 58,878.28
See accompanying notes to financial statements
As per our report of even date attached For and on behalf of the Board
For B S R & Co. LLP N CHANDRASEKARAN [DIN: 00121863] N MUNJEE [DIN:00010180] GUENTER BUTSCHEK [DIN: 07427375]
Chartered Accountants Chairman CEO and Managing Director
Firm’s Registration No: 101248W/W-100022 V K JAIRATH [DIN:00391684]
S B BORWANKAR [DIN: 01793948]
F S NAYAR [DIN:00003633] ED and Chief Operating Officer
P B BALAJI
YEZDI NAGPOREWALLA O P BHATT [DIN:00548091] Group Chief Financial Officer
Partner
H K SETHNA [FCS: 3507]
Membership No. 049265 R SPETH [DIN:03318908]
Company Secretary
Mumbai, May 23, 2018
Directors Mumbai, May 23, 2018
192
INTEGRATED REPORT 1-65 STATUTORY REPORTS 66-184 FINANCIAL STATEMENTS 185-353
As per our report of even date attached For and on behalf of the Board
For B S R & Co. LLP N CHANDRASEKARAN [DIN: 00121863] N MUNJEE [DIN:00010180] GUENTER BUTSCHEK [DIN: 07427375]
Chartered Accountants Chairman CEO and Managing Director
Firm’s Registration No: 101248W/W-100022 V K JAIRATH [DIN:00391684]
S B BORWANKAR [DIN: 01793948]
F S NAYAR [DIN:00003633] ED and Chief Operating Officer
P B BALAJI
YEZDI NAGPOREWALLA O P BHATT [DIN:00548091] Group Chief Financial Officer
Partner
H K SETHNA [FCS: 3507]
Membership No. 049265 R SPETH [DIN:03318908]
Company Secretary
Mumbai, May 23, 2018
Directors Mumbai, May 23, 2018
20
Abridged Standalone Statement of Profit and Loss
21
184 75th Integrated Annual Report 2019-20
Balance Sheet
(` in crores)
As at As at
Notes
March 31, 2020 March 31, 2019
I. ASSETS
(1) Non-current assets
(a) Property, plant and equipment 3 18,870.67 18,316.61
(b) Capital work-in-progress 1,755.51 2,146.96
( c) Right of use assets 4 (a) 669.58 -
(d) Goodwill 99.09 99.09
(e) Other intangible assets 5 (a) 5,568.64 3,871.13
(f) Intangible assets under development 5 (b) 2,739.29 4,139.63
(g) Investments in subsidiaries, joint ventures and associates 7 15,182.29 14,770.81
(h) Financial assets
(i) Investments 9 548.57 663.38
(ii) Loans and advances 11 138.46 143.13
(iii) Other financial assets 13 1,512.96 994.39
(i) Non-current tax assets (net) 727.97 715.30
(j) Other non-current assets 15 1,208.08 1,819.90
49,021.11 47,680.33
(2) Current assets
(a) Inventories 17 3,831.92 4,662.00
(b) Investments in subsidiaries and associate (held for sale) 8 - 257.81
( c) Financial assets
(i) Investments 10 885.31 1,175.37
(ii) Trade receivables 18 1,978.06 3,250.64
(iii) Cash and cash equivalents 20 2,145.30 487.40
(iv) Bank balances other than (iii) above 21 1,386.89 819.21
(v) Loans and advances 12 232.14 200.08
(vi) Other financial assets 14 1,546.56 1,279.68
(d) Assets classified as held for sale 50 (iv) 191.07 162.24
(e) Other current assets 16 1,371.51 934.87
13,568.76 13,229.30
Total assets 62,589.87 60,909.63
II. EQUITY AND LIABILITIES
Equity
(a) Equity share capital 22 719.54 679.22
(b) Other equity 17,668.11 21,483.30
18,387.65 22,162.52
Liabilities
(1) Non-current liabilities
(a) Financial liabilities
(i) Borrowings 24 14,776.51 13,914.74
(ii) Lease liabilities 522.24 5.07
(iii) Other financial liabilities 26 854.74 180.80
(b) Provisions 28 1,769.74 1,281.59
( c) Deferred tax liabilities (net) 198.59 205.86
(d) Other non-current liabilities 31 269.58 218.24
18,391.40 15,806.30
(2) Current Liabilities
(a) Financial liabilities
(i) Borrowings 25 6,121.36 3,617.72
(ii) Lease liabilities 83.30 3.64
(iii) Trade payables
(a) Total outstanding dues of micro and small enterprises 101.56 134.12
(b) Total outstanding dues of creditors other than micro and small enterprises 8,000.69 10,274.71
(iv) Acceptances 2,741.69 3,093.28
(v) Other financial liabilities 27 5,976.35 2,234.34
(b) Provisions 29 1,406.75 1,148.69
( c) Current tax liabilities (net) 31.49 78.30
(d) Other current liabilities 32 1,347.63 2,356.01
25,810.82 22,940.81
Total equity and liabilities 62,589.87 60,909.63
See accompanying notes to financial statements