Strategic Financial Analysis 2022

Running Head: Strategic Financial Analysis
Strategic Financial
Analysis

Strategic Financial Analysis
Contents
2.0 Ratio Calculation............................................................................................... 1
2.0 Introduction to Financial Analysis...........................................................................1
2.1 Profitability....................................................................................................... 1
2.1.1 Gross Profit Margin (GPM).............................................................................. 4
2.1.2 Net Profit Margin.......................................................................................... 5
2.1.3 Return on Capital Employed (ROCE)..................................................................6
2.2 Liquidity........................................................................................................... 7
2.2.1 Current Ratio................................................................................................ 7
2.2.2 Quick Ratio.................................................................................................. 8
2.3 Efficiency......................................................................................................... 8
2.3.1 Days of Sales Outstanding (DSO)......................................................................9
2.3.2 Days of Inventory on Hand (DOI)......................................................................9
2.3.3 Days of Payables (DOP)................................................................................ 10
2.3.4 Cash Conversion Cycle (CCC)........................................................................10
2.4 Leverage......................................................................................................... 11
2.4.1 Debt-to-Equity Ratio.................................................................................... 11
2.4.2 Gearing..................................................................................................... 12
2.5 Cash Flow Ratios.............................................................................................. 12
2.5.1 Operating Cash Flow to Sales.........................................................................13
2.5.2 Operating Cash Flow to Net Income.................................................................13
2.5.3 Cash Flow to Total Debt................................................................................14
2.6 Investor’s Ratio................................................................................................ 14
2.6.1 Earnings per Share (EPS)............................................................................... 15
2.6.2 Dividend Pay-out......................................................................................... 15
2.6.3 Price- Earnings Ratio (P/E Ratio).....................................................................16
2.7 Common Size................................................................................................... 16
2.7.1 Vertical Analysis......................................................................................... 17
2.7.2 Horizontal Analysis...................................................................................... 21
2.8 DuPont Analysis............................................................................................... 25
2.8.1 DuPont - 3 factor ROE.................................................................................. 25
2.8.1 DuPont - 2 factor ROA.................................................................................. 26
2.9 Segmental Analysis........................................................................................... 27
References.............................................................................................................. 28
1

Strategic Financial Analysis
2.0 Ratio Calculation
2.0 Introduction to Financial Analysis
Financial analyses are done for measuring the companies’ performance over a specific time
period. It is the process through which financial position are assessed by doing analysis on
stability, profitability and viability of the companies. Various financial statements like
Balance Sheet, Income Statement and Cash flow statements are used for the purpose of
analysis. Income statement of the company talks about its operational efficiency and balance
sheet talks about its net worth (Sultan, 2014).
The measures like financial ratios give the idea about the organisation’s profitability,
efficiency, liquidity, leverage etc. There are other analysis like vertical analysis and
horizontal analysis which are done over financial statements of the company.
We would study the financial performance and position of Booker and Tate and Lyle using
ratio analysis, horizontal analysis, vertical analysis, DuPont analysis and segmental analysis.
2.1 Profitability
2
Profitability ratios are preferred for measuring the ability of a company to generate
revenue in relation to the balance sheet, cost of operations, revenue and shareholders’
equity during the given financial year. These ratios are able to reflect on number of
business conditions. These ratios even depict the efficiency level of an entity. The sales
profitability and investments profitability can also be accessed through these ratios
(Fardiansyah, Achsani and Juanda, 2016).

Strategic Financial Analysis
Table 1: Explanations to Important Ratios
Ratio Analysis
Profitability
Gross
Profit
Margin
(GPM)
This ratio shows the relationship established between the gross profit and net
sales wherein both cash and credit sales are considered. This ratio is often
referred as gross profit Ratio. Higher the ratio better is the management of the
company in managing the cost of sales (Tulsian, 2014).
Net Profit
Margin
(NPM)
The ratio tells about those earnings which the company has generated after
meeting its all types of expenses such as cost of sales, operational cost, taxes
etc. it gives us the idea about the company's profitability (The Motley Fool,
n.d.).
Return on
Capital
Employed
(ROCE)
This ratio helps to know the ability of the company to effectively allocate the
capital and indicates the profitability of the company. Thisratio carries out the
comparison between the the operational earnings and the capital invested in the
business. Overall, it shows the corporate performance (Das, 2017).
Liquidity
Current
Ratio
This ratio shows the level of current assets as compared to the current
liabilities of the company. The company with higher current ratio is in a better
liquidity position as compared to the ones with lower current ratio. This ratio
considers inventories and account receivables as liquid assets (Warrad, 2014).
Quick Ratio This ratio displays the level of highly liquid assets as compared to the current
liabilities of the company. This ratio does not consider inventory as the current
assets (Atieh, 2014).
Efficiency
3

Strategic Financial Analysis
Days of
Sales
Outstandin
g (DSO)
It helps to calculate the average days the company is taking for the cash
collection on the credit sales. It is estimated on a monthly, quarterly or yearly
basis (The Business Professor, n.d.).
Days of
Inventory
on Hand
(DOI)
The ratio speaks about average days taken by the business to convert the
inventory into sales. Also, it tells us about the inventory management of
company (bdc, n.d.).
Days of
Payables
(DOP)
This ratio tells about the average number of days taken by the company to
make payments on their account payables which includes, vendors, suppliers,
creditors etc. (WallstreetMojo, n.d.).
Cash
Conversion
Cycle
(CCC)
This tells us about how much days are taken by the company to collect cash
from the accounts receivables and how much days is it taking to convert raw
material into finished goods after subtracting the number of days taken by the
company to pay its short-term obligations (Yasir, Majid and Yousaf, 2014).
Leverage
Debt-to-
Equity
Ratio (D/E)
It displays how much of company's operations are being financed using debt
over equity (Morningstar, n.d.).
Gearing Gearing ratio measures the level of debt company has used in its capital
structure which includes both debt and equity (Thompson, 2018).
Cash Flow Ratios
Operating
Cash flow
to Sales
Operating cash flow to sales depicts that sales amount which has been
converted to cash flow from operating activities.
Operating
Cash Flow
to Net
This ratio represents the amount of net income converted to the cash flow from
operations
4

Strategic Financial Analysis
Income
Cash Flow
to Total
Debt
This ratio shows the cash flow generated by the organisation through its
operations for each dollar of debt it used. It is an important measure solvency
and liquidity (Garcia, 2017).
Investor's Ratio
Earnings
Per Share
(EPS)
EPS is an important indicator of risk, company's success and its performance.
It is even used to forecast the future price of company's shares because the
change in the value of EPS often impacts the share price of that company
(Robbetze, Villiers and Harmse, 2017).
Dividend
Pay-out
(DPO)
Dividend pay-out refers to that portion of company's net income which is
distributed as dividend to the shareholders. Higher dividend pay-out ratio of a
company reflects its liberal dividend policy and low dividend pay-out reflects
the conservative dividend policy (Nwabuisi, Aseoluwa and Tolulope, 2017).
Price-
Earnings
Ratio (P/E)
This ratio is used to calculate the value of a firm for which it considers the
current price of the company's shares and earnings received on per share of the
company (Ghaeli, 2016).
2.1.1 Gross Profit Margin (GPM)
2 0 1 2 2 0 1 3 2 0 1 4 2 0 1 5 2 0 1 6
3.78%
3.99%
4.40%
4.80%
5.08%
30.21%
29.94%
30.03%
35.28%
37.54%
Gr os s P r o fi t M a r gin
BK T&L
5

Strategic Financial Analysis
The gross profit margin of Booker is showing an upward trend over five year period. The
gross profit margin has gone up because of increased revenue over the five years period. Over
the five years, the major part of the Booker’s revenue is coming from the non-tobacco
segment whose revenue increased by 44% (£2.39bn in 2012; £3.43bn in 2016), however the
revenue from the tobacco segment has just increased by 6.12% (£1.47bn in 2012; £1.56bn in
2016) (Booker Annual Report, 2016).
Gross profit margin of Tate & Lyle came down during 2013 as compared to 2012 therefore;
the gross profit margin of the company did not show a constant increasing trend. In 2014,
T&L acquired the assets and complete business of Winway Biotechnology Nantong Co. This
acquisition was done with the plan to enhance the capacity of Winway Biotechnology
Nantong for increasing the sale of speciality fibre products food. This increased the revenue
of T&L and also the improved capacity reduced T&L’s cost of production. As a result, the
gross profit margin increased by 7.5% from 2014(30%) to 2016 (37.5%) (Tate and Lyle,
2014).
2.1.2 Net Profit Margin
2 0 1 2 2 0 1 3 2 0 1 4 2 0 1 5 2 0 1 6
2.28%
2.38%
2.64%
2.95%
3.06%
13.08%
10.26%
9.11%
1.41%
5.39%
Ne t P rofi t M a rgin
BK T&L
Booker has witnessed a growing net profit margin over the five year period because of
improved sales in India, increased Internet sales which grew by 12% to £874m, better
structure of group contributing efficiently towards price, choice and services to all the
customers of Booker etc. (Booker Annual Report, 2015).
Conversely, the net profit margin of T&L has remained inconsistent for the years because of
its operational inefficiency. The net profit of Tate & Lyle decreased during 2014 because
bulk ingredients plants were running much below their capacity, changes introduced in
production mix, lower demand of carbonated soft drinks due to unusual cold weather (Tate
6

Strategic Financial Analysis
and Lyle Annual Report, 2014). The major factor which impacted the net profit of T&L
during the year were the extended shutdown of SPLENDA Sucralose facility in Singapore
because of industrial accident, unusual and prolonged winter in US during 2013/14 caused
operations related difficulties in US plant and made the company enter with little inventory
during the year 2015 (Tate and Lyle Final Results, 2015).
No doubt, in most of the years out of five, net profit margin of Tate & Lyle has always been
more than that of Booker. It is because the production cost incurred by Tate & Lyle is much
lower as compared with that of Bookers’. The higher cost of production lowers the net profit
margin of Booker in spite of witnessing higher sales than T&L.
2.1.3 Return on Capital Employed (ROCE)
2 0 1 2 2 0 1 3 2 0 1 4 2 0 1 5 2 0 1 6
20.64%
18.07%
19.74%
21.20%
22.53%
18.26%
15.14%
12.68%
1.90%
7.01%
RO C E
BK T&L
Over the five years, ROCE of Booker has shown somewhat stable trend from where we can
interpret that the business is healthy and operating well. However, in 2013 the Return on
capital employed has come down because of acquiring Makro for which the company had
issued 9.99% of the equity to Metro AG and paid £15.8m in cash (Booker Annual Report,
2013). In rest of the years the company has always generated a good amount of return on the
employed capital.
T&L has not generated enough returns on the capital employed as a result of which it has
fallen from 2012 to 2015. The reasons behind this fall include the declining gross profit
margin and net profit margin. However, in 2016 ROCE of T&L has improved which may be
because of re-aligning Eaststarch corn wet milling joint venture (Tate and Lyle, 2015).
Overall, Booker seems to be in much better state than T&Y in generating returns on the
employed capital.
7