Financial Analysis : The Tesco Company

FINANCE

Table of Contents
INTRODUCTION...........................................................................................................................3
2.1 Financial analysis:.................................................................................................................3
2.2 Valuation of company:........................................................................................................13
2.3 Capital structure..................................................................................................................17
CONCLUSION..............................................................................................................................20
REFERENCES..............................................................................................................................21

INTRODUCTION
The term finance is very crucial for organisations because, it is not only essential but also
in the absence of this companies can not even survive (Swift and Piff, 2014). In general, those
companies are considered strong who have enough fund. So, the availability of fund is the key to
success of organisations. For effective management of fund, companies prepare various kind of
financial statements such as income statement, balance sheet, cash flow, ratio calculation etc. In
the project report, detailed analysis of financial statements of both companies is included. As
well as the valuation of company is done with the help of financial reports. Along with in the
end part of project report, various kind of calculation is done on the basis of capital structure.
2.1 Financial analysis:
(a) Financial analysis- The Tesco company's financial statements are analysed below which are
as follows:
Income statement of Tesco plc for year ending 2018

Analysis- On the basis of income statement of Tesco plc, it can be analysed that their financial
position is strong because of higher gross profit and net profit. The net profit of above company
is of £1320 GBP million as well as gross profit is of £4144 GBP million (About financial
statement of Tesco, 2019). It shows that company's financial position is strong enough for
making payment of their shareholders pension. Apart from it, availability of net income for
payment of their shareholders is of £1322 GBP million. So it can be interpreted that above
organisation's stakeholders' issue will be resolved by availability of enough fund.
Balance sheet of Tesco plc for year ending 2018

Analysis- As per the above balance sheet of company, this can be analysed that their current
assets are of £12668 GBP million as well as in compare their current liabilities are of £20680.
This situation of Tesco plc indicates to shareholder that they do not have current-assets to pay
short term debts or to fulfil the working capital requirement. Further, their total non current-
assets are of £36379 GBP million as well as non-current liabilities are of £13509 GBP million.
It interprets that company's long term assets value is high. As well as in compare they do not
have too much non current-liabilities which is good thing. Along with this stats that they are not
depended on the long term loans. Overall, after analysing the balance sheet of above company

this can be said that they have enough assets to pay their shareholders in the case if they fail to
produce enough profits.
Cash flow of Tesco plc for year ending 2018
TESCO PLC CASH FLOW
2018-19
Cash Flows From Operating Activities
Investments losses (gains) 127
Stock based compensation 77
Inventory 9
Other working capital -705
Other non-cash items 2458
Net cash provided by operating activities 1966
Cash Flows From Investing Activities
Investments in property, plant, and equipment -1101
Property, plant, and equipment reductions 286
Acquisitions, net -718
Purchases of intangibles -191
Other investing charges 581
Net cash used for investing activities -1143
Cash Flows From Financing Activities
Long-term debt issued 975
Long-term debt repayment -2471
Common stock issued 60
Repurchases of treasury stock -206
Cash dividends paid -357
Other financing activities 18
Net cash provided by (used for) financing activities -1981
Effect of exchange rate changes 15
Net change in cash -1143
Cash at beginning of period 4059
Cash at end of period 2916
Free Cash Flow
Operating cash flow 1966
Capital expenditure -1292
Free cash flow 674
Analysis- On the basis of cash flow above Tesco plc, this can be analysed that there are both
kind of cash inflow and outflow activities. In the inflow activity, there is only one which is
operating activity of £1966 GBP million. Apart from it, in the rest of activities such as financing
and investing there is outflow of cash of ( £1143) GBP million and ( £1981) GBP million
respectively. It shows that company do not have cash inflow activities as well as this is
interpreting that there is wide amount of cash which is going out from organisation. Though, it

can not be stated that they don't have enough fund to pay their stakeholders. This is so because
cash is required only for day to day activities and shareholders are being paid by net profits
which above company has in enough volume.
Ratio analysis
Gross profit ratio of Tesco company:
Analysis- On the basis of above table of gross profit of Tesco, this can be stated that their gross
profits are of £63911 GBP million and its ratio is of 6.48%. It shows that their financial position
is strong because of availability of enough fund as gross profit. This overall leads to ensuring the
payment of shareholders' dividend.
Net profit of Tesco company:

Analysis- On the basis of net profit ratio analysis of above company, this can be stated that their
net profit is of £1320 GBP million as well as ratio is of 2.06%. It means company have enough
funds to pay their shareholders. Basically, the net profit is the key aspect which decide the
capability of a firm for paying to shareholders. The above company's net profit is in huge volume
that can resolve issue of pension of their shareholders.
Return on equity ratio of Tesco company:
Particular 2018-19
TESCO:
Return on equity ratio 10.43%
Analysis- On the basis of return on equity ratio of above company, this can be evaluated that
their average return on their equity is of 10.43%. It means if investors make invest of their equity
in the above company then they will get return with an average of 10.43%. This is a good rate in
compare of other companies. This shows that their ability to pay the shareholders is well enough
because of this higher return rate.
Return on capital ratio of Tesco company:
Particular 2018-19
TESCO:
Return on capital ratio 7.45%
Analysis- As per the above return on equity ratio analysis of company, this can be assessed that
return on invested capital is of 7.45%. It means if shareholders will invest their capital in above

company then they will get return by rate of 7.45%. This condition reflects positive impact on
company because this higher rate of return is beneficial for the investors to pay return. As well as
their shareholders issue regarding to the shareholders profit can be resolved by this higher return
rate.
Tesco's financial position's comparison with Morrison's company:
Comparison of income statement of Tesco and Morrison's company:
Analysis- On the basis of comparison of net income of both companies, this can be stated that
both companies have different amount of net income and EBITDA (earning before interest tax
dividend and amortization). Tesco company's net income is of £1320 GBP million which is
much more in compare to Morrison company and difference is of £1009 GBP million. Apart
from it, the EBITDA of both companies is also variant from each other. Tesco's earning is
74.21% more in compare to the Morrison plc (About financial statement of Morrisons, 2019).
Comparison of balance sheet of Tesco and Morrison's company:

Analysis- As per the comparison of balance sheet of both companies, this can be evaluated that
there is huge amount of difference in assets and liabilities. The difference in current assets of
both companies is of £11286 GBP million as well as in non current-assets is of £27845 GBP
million. It is a huge difference in the assets of both companies and same as in the aspect of total
assets, there is big difference. Overall, as per above comparison Tesco company seems to be
more stronger.
Comparison of cash flow of Tesco and Morrison's company:
Analysis- The cash flow of both companies is almost similar, this is so because there is only one
activity by which cash generating in both companies and that is operating activity. Though, there
is difference of amount which is of £1254 GBP million. Apart from it, in both the activities like
financing and investing there is outflow of cash which is (£1981 and 1143 GBP million) for
Tesco. So overall, both companies are in same position in the aspect of cash flow.
Comparison of gross profit ratio of Tesco and Morrison's company:

Analysis- As per the gross profit ratio analysis of both companies, this can be assessed that
Tesco company seems to be more competitive in compare to Morrison plc. There is difference of
3.06% in the gross profit ratio of both companies. The main reason behind this, is different sales
and gross profit of companies. So it can be interpreted that Tesco company is better then to
Morrison company.
Comparison of net profit ratio of Tesco and Morrison's company:
Analysis- Same as the gross profit ratio of above companies, net profit ratio is also different of
both companies and Tesco company is in command position. In the Tesco company, the net
profit is of £1320 GBP million which is more then to Morrison plc because their net profit is of
£311 GBP million. As well as ratio is also different of both the organisations, like Morrison's

ratio is of 1.79% and tesco's is of 2.06%. This situation indicates that in comparison, Tesco is
better then Morrison.
Comparison of return on equity ratio of Tesco and Morrison's company:
Analysis- As per the comparison of both company's return on equity ratio, this can be analysed
that Tesco's return on equity is of 10.43% while Morrison's is of 5.32%. It is almost half of
Tesco' s ratio. So overall, Tesco company is in better position to pay the dividend to their
shareholders.
Comparison of return on capital ratio of Tesco and Morrison's company:
Analysis- As per the return on capital ratio of both companies, this can be assessed that there is
not so much difference in the ratios. This is so because, Tesco's ratio is of 7.45% while
Morrison's is of 4.74%. Though, Tesco's ratio is better then to Morrison's because shareholders
can get higher return on their invested capital.
(b) Four possible limitation of financial analysis: The financial analysis is based on the various
kind of financial statements such as balance sheet, income statement, cash flows and ratios.

During this analysis, there can be issues which can impact overall result. Herein, below
limitations regarding to the financial analysis by ratios is mentioned:
 Under the ratio analysis, variation in level of price is ignored completely which is a key
issue.
 Along with in this analysis, only quantitative aspect considered while qualitative aspect is
ignored that leads to a major issue for financial comparison (Qun, Yongle and Siqi,
2015).
 In the ratio analysis, users can apply formula and methodologies as per own suitability
which brings to variation of result of financial analysis.
 In the end, there is no any specific definition of ratios which leads to lack of dependency
on produced results by ratio analysis (Dionne and Harrington, 2013).
2.2 Valuation of company:
As per the above mentioned financial statements of Tesco company, the actual valuation
is done with help of different models such as:
 Assets based valuation- This can be defined as a kind of method of business valuation in
which fair value of total assets is computed by excluding from total liabilities (Tatewaki,
2012). If there are less number of liabilities then it is considered that company's financial
position is in better condition. On the other hand, if amount of net assets is less then to
liabilities then it is considered that financial position is weak. Below, the assets based
valuation of Absolute plc is done that is as follows:
Asset Based Valuation of Tesco Plc
2018-19
Amount in
Assets
GBP in Million except per
share data
Current assets
Cash
Cash and cash equivalents 2916
Short-term investments 457

Total cash 3373
Inventories 2617
Other current assets 6678
Total current assets 12668
Non-current assets
Property, plant and equipment
Fixtures and equipment 7063
Other properties 24949
Property and equipment, at cost 32012
Accumulated Depreciation -12989
Property, plant and equipment, net 19023
Goodwill 4909
Intangible assets 1355
Deferred income taxes 132
Other long-term assets 10960
Total non-current assets 36379
Total assets 49047
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 1563
Capital leases 36
Accounts payable 9354
Taxes payable 325
Other current liabilities 9402
Total current liabilities 20680
Non-current liabilities
Long-term debt 5580
Capital leases 93
Deferred taxes liabilities 236
Pensions and other benefits 2808

Minority interest -24
Other long-term liabilities 4816
Total non-current liabilities 13509
Total liabilities 34189
Net Assets of Company 14858
So Company's value as per assets based valuation is GPB
14858 millions
Cross Check:
Stockholders' equity
Common stock 490
Additional paid-in capital 5165
Retained earnings 5405
Accumulated other comprehensive income 3798
Total stockholders' equity 14858
 Dividend valuation model- It can be defined as a kind of model for valuation of an entity
by valuing an organisation's stock price (Mazanai and Fatoki, 2012). Under this, the
valuation is done on an assumption that current price of stock is well enough to pay
company's future dividends.

 Price earning ratio- This can be defined as a kind of ratio which stats the relation between
an organisation's stock price and earning for each share (Denk and Cournède, 2015). On
the basis of this ratio, investors can assess value of company and make investment
accordingly. So overall, with the help of this ratio companies can assess the value of own
business. Herein, below valuation of Absolute plc is done with help of given capital
structure:

So the price earning ratio of above company is :
= Market price of share/ earning per share.
= 214.10/0.41
= 522.19
Valuation of company: P/E ratio* Net profit.
= 522.19 x 1320
= £689290.8 GBP million.
(b) Critically valuation of above mentioned methodologies:
As per the above used valuation methodologies, this can be assessed that above
company's value is variant from all three methods. Like in the assets based valuation model, the

Absolute company's value is of £ 14858 GBP million while from dividend valuation model, it is
of £635083.19 GBP million. Apart from it, by price earning ratio model, the total valuation
amount of above company is of £689290.8 GBP million. In the comparative evaluation, this can
be seen that highest value of above company is valued by price earning ratio model which is of
£689290.8 GBP million.
The expected value which may be worth of Tesco company is of £700000 GBP million.
2.3 Capital structure
(a) Cost of debt of the convertible bonds for Absolute plc:
COD(Cost of debt)- This has been defined as an interest rate that is being paid by a company for
its loans, borrowings or any other long or short term debts (Marlow and Swail, 2014). Below
cost of debt of Absolute plc is computed:
(b) Cost of equity- This has been defined as an amount of interest or rate of interest that is paid
by a company to their investors who make investment (Garcia, 2013). The companies pay this
interest amount to their investors because they make investment in company by taking risk.
Herein, below cost of equity of above company is calculated:

(c)Weighted average cost of capital (WACC)- This may be defined as a rate of return that is
being expected by a company for making payment to their security holders when they finance
the assets (Cumming, 2012). Herein, WACC of Absolute plc is computed:

(d) Difficulties during calculation of WACC:
 Due to implication of different types of model rate can be computed different and it
becomes a difficulty.
 As well as in this, users need to include the lease amount in the debt amount which
becomes cause of an issue.
 Under it, calculations are done as per the required return while historical return is ignored
(Navias, 2017).
 Along with, last difficulty in calculation of WACC is regarding to capital structure of
companies. If capital structure is difficult then calculation will also tough.
CONCLUSION
As per the above project report, this can be concluded that for effective management of
finance, it is essential for companies to make proper analysis of financial statements. The project

report concludes about financial analysis of both Tesco and Morrison plc to evaluate the
efficiency of company regarding to making payment of shareholders. Additionally, in the report
different types of valuation models are discussed such as assets based valuation, dividend
valuation and P/E ratio model in order to assess the value of business of Tesco company Further,
as per the capital structure of Absolute plc various kind of calculation such as cost of debt,
equity, WACC is calculated