Investment Position of Woolworths Limited: A Ratio Analysis Study

The report focuses on the case study of Woolworths limited to identify the investment position of the company. The ratio analysis study has been done and it has been measured that the performance of the company is quite impressive. The investment into the company is better option for the investors to get higher return.

Running Head: Accounting for managers
1
Project Report: Accounting for managers

Accounting for managers
2
Executive summary:
The study on the final financial statement of the business is one of the easiest methods
to evaluate the overall performance of a business. The report focuses on the case study of
Woolworths limited. The report has been conducted to identify the investment position of the
company. In order to evaluate the investment position of the company, the ratio analysis
study has been done and it has been measured that the performance of the company is quite
impressive. The investment into the company is better option for the investors to get higher
return.

Accounting for managers
3
Contents
Introduction.......................................................................................................................4
Company background.......................................................................................................4
Analysis and discussion....................................................................................................4
Trend analysis...............................................................................................................8
Conclusion......................................................................................................................10
Recommendation............................................................................................................10
References.......................................................................................................................12
Appendix.........................................................................................................................13

Accounting for managers
4
Introduction:
Evaluation on the final financial statement and the annual report of an organization is
one of the major parts while making the decision about the investment in that particular
company. The final statement and other relevant information in the annual report of the
company makes it easier for the investors and the analyst to collect the information for the
purpose of making the decision about the investment in that company. The strategic direction,
director’s report, operating environment, financial items, stock price, strategically changes etc
are the few figures and information which makes a base for the investors and the analyst.
This information leads to the analyst and the potential investors of the business to reach over
the conclusion (Moyer, McGuigan, Rao and Kretlow, 2011).
In the report, the case study of Woolworths limited has been studied in order to
identify the investment position of the company and identify that whether the investment into
the company would be enough profitable for the investors or not. Various tools and
techniques of analysis have been applied on the annual report and financial statement of the
company to reach over the conclusion.
Company background:
Woolworths group limited is a retailing company which is based in the Australian
market mainly. The company offers various segment to its customers such as Australian food,
liquor, petrol, hotels services, supermarket services etc. the different segment of the company
is operated by the different subsidiaries of the company in order to meet the financial and non
financial objectives of the business such as to improve the turnover, profitability position and
the market base of the company (Reuters, 2018). The total market capital of the business is
36,116 million on the basis of the annual report (2017) of the company. Company has
diversified its market in the New Zealand and Indian market recently.
Analysis and discussion:
The analysis has been done on the annual report and the financial statement of
Woolworths limited to measure the investment position of the company in the market. Firstly,
the study of ratio analysis has been done on the company to identify the various financial
level of the business such as liquidity financial level, profitability financial level, solvency

Accounting for managers
5
financial level, and efficiency financial level and market ratios of the business (Baker and
English, 2011). The analysis on the ratios of the company is as follows:
Profitability ratios:
Profitability ratios are calculated by the analyst and the investors to measure the entire
capabilities of an entity to generate and make profits on the basis of the total equity funds,
available resources, total turnover and many others basis. The profitability ratio analysis
process makes it easier for the analyst and the investors to identify that how much profit
could be generated by the business and how much return could be got by the investors from
the company (Ahrendsen and Katchova, 2012). In case of Woolworths limited, return on
capital employed (ROCE), operating profit margin and gross profit margin of the business
has been calculated to identify the profit making level and capabilities of the business. The
calculations of profitability ratios analysis are as follows:
Return on capital employed:
Return on capital employed is a profitability identifying ratio which is used to
measure the total profit generated against the capital employed of the business (Brigham and
Ehrhardt, 2013). The ROCE of Woolworths limited has been lowered to 30.04% from
35.11% in 2013 which depicts improved and competitive position of the business.
Gross profit margin:
Gross profit margin is a profitability ratio which is used to identify the difference
among the total turnover and the cost of sales of the business. The gross profit margin level of
Woolworths limited has been improved by 28.6% in 2017 from 26.9% in 2013 which depicts
improved and competitive position of the business and a great management of profit level
(Annual report, 2017).
Operating profit margin:
Operating profit margin is a profitability identifying ratio which calculated the total
expenses deduction from the total sales amount of the business. The operating profit margin
of Woolworths limited has been reduced by from 5.48% to 3.83% in 2017 which depicts
lower position of the business.

Accounting for managers
6
The overall profitability analysis of the company explains that the company is trying
to manage the profitability level and it would lead to the better earnings to the investors of the
company.
Asset efficiency ratios:
Asset efficiency ratios are calculated by the analyst and the investors to measure the
efficiency level of an entity in order to manage their daily operations of the business and the
cash conversion cycle of the business through maintain the better cash position in the
business for daily operations and the activities. The efficiency ratio analysis process makes it
easier for the analyst to identify that how much cash is needed for the business to run the
activities (Madura, 2011). In case of Woolworths limited, trade payment turnover days,
receivable turnover days and inventory turnover days of the business has been calculated to
identify the cash conversion cycle and efficiency level of the business. The calculations of
asset efficiency ratios analysis are as follows:
Trade payable payment turnover:
Trade payable turnover days brief the efficiency position of the company in order to
manage the cash position and the credit policies of the business. The payment payable
turnover days of Woolworths limited has been improved to 46.55 days (annual report, 2017).
It explains better efficiency position of the company.
Receivable turnover:
Receivable turnover days brief the efficiency position of the company in order to
manage the total days in which the debtors would pay the credit amount. The receivable
turnover days of Woolworths limited has been changed from 35.77 days to 37.48 in last 5
years (yahoo finance, 2018). It explains that the debtors turnover days have been improved.
Inventory turnover:
Lastly, the inventory turnover days brief the total days in which the inventory of the
company would be ordered and replaced the old inventory of the business. The inventory
turnover days of Woolworths limited is higher and explains that more cash is required for the
business.
The overall efficiency analysis of the company explains that the efficient level of the
business is enough competitive.

Accounting for managers
7
Liquidity ratios:
Liquidity ratios are calculated by the analyst and the investors to measure the
capabilities of an entity to manage the enough funds from their daily activities to pay the
current debt of the business. The liquidity ratio analysis process makes it easier for the
analyst and the investors to identify the associated liquidity risk of the business as it measures
that whether the business is able to pay the entire debt at a single time through its current and
quick assets to the debt holders of the business. It calculates the short term solvency position
of the business (Koller, Goedhart and Wessels, 2010). In case of Woolworths limited, current
ratio and acid test ratio of the business has been calculated to identify the solvency position of
the business in short term. The calculations of liquidity ratios analysis are as follows:
Current ratio:
Current ratio is a liquidity ratio which is used to identify that whether the business is
able to replay the current debt against the current funds available to the company (Higgins,
2012). The current ratio of Woolworths limited has been reduced by 0.79 from 0.91 times in
2018. It explains higher liquidity risk of the business.
Quick ratio:
Further, the quick ratio is a liquidity ratio which is used to identify that whether the
business is able to replay the current debt against the quick funds which can be transferred
quickly into cash, available to the company. The quick ratio of Woolworths limited has been
almost similar in last 5 years (Annual report, 2017).
On the basis of the overall evaluation, it has been found that the liquidity risk of the
business has been higher in 2017.
Solvency ratios:
Solvency ratios are calculated by the analyst and the investors to measure the entire
capabilities of an entity to meet the long term obligations of the business on the basis of the
available assets and equity fund of the business. The solvency ratio analysis process makes it
easier for the analyst and the investors to identify the financial risk level through measuring
the debt level, equity level and assets level of the business (Hogarth and Makridakis, 2011).
In case of Woolworths limited, gearing ratio and interest coverage ratio of the business has

Accounting for managers
8
been calculated to identify the long term obligation management capabilities of the business.
The calculations of solvency ratios analysis are as follows:
Gearing ratio:
Gearing ratio is a long term solvency ratio defines the total long term liabilities
against the capital employed (total assets – current liabilities) of the business. The gearing
ratio of Woolworths limited has been reduced from 2013 to 2017 to 64.33%. It explains that
the level of long term liabilities and gearing position has been improved by the business.
Interest coverage ratio:
Further, the interest coverage ratio is a long term solvency ratio defines the EBIT
level against the finance cost of the business to measure that whether the business would be
able to pay the debt cost (Gibson, 2011). The interest coverage ratio of Woolworths limited
has been improved and explains the better position of the company.
It explains that the long term solvency position has been maintained by the company a
great level.
Stock market ratios:
Stock market performance ratios are calculated by the analyst and the investors to
measure the market position of the business on the basis of their earnings, dividend and the
stock price of the business. The stock market ratio analysis process makes it easier for the
analyst and the investors to identify the market position and attractiveness of the company
among the investors (Gibson, 2011). In case of Woolworths limited, earnings per share and
dividend coverage ratio of the business has been calculated to identify the market
attractiveness of the business. The calculations of stock market ratios analysis are as follows:
Earnings per share:
Earnings per share define total earnings which have been generated by the company
for each of the shareholders. The level of EPS has been improved and brief better investment
and marketing level of the business.
Dividend coverage ratio:
Dividend coverage ratio defines total time in which the dividend amount could be
paid the shareholders against the net profit of the business (Annual report, 2017). The level of

Accounting for managers
9
dividend coverage ratio has been improved and brief better investment and marketing level of
the business.
On the basis of the market ratio of the business, it has been found that the position has
been improved by the business to attract more customers towards the business.
Trend analysis:
The trend analysis study has been done on the sales and net profit of the business to
measure the changes into overall performance in last 3 years. On the basis of the evaluation,
it has been measured that the sales level of the business has been studied and on the basis of
the below graph, it has been found that the great improvement has taken place in the sales
position of the business from the year of 2015. the current sales level of the business brief
that the chnages into the activities of the business has helped the business to improve the
level.
Figure 1: sales
(Morningstar, 2018)
Further, the net income level of the business has been studied and on the basis of the
below graph, it has been found that the net income level of the company has been reduced in
the current yeear from 2013 becasue of the chnages in the sales position of the company. the
current net income level of the business brief that required chnages must be done by the
business. annual report, 2017 epxlain that managers are focusing on the issues and made few
chnages into the activities to improve the level (Kaplan and Atkinson, 2015).

Accounting for managers
10
Figure 2: Net income
(Morningstar, 2018)
Conclusion:
To conclude, the Woolworths limited and the managers of the business has made
various changes into the strategies and operations of the business in order to improve the
turnover, profitability position and the market base of the company. Through evaluation on
the profitability analysis of the company, it has been found that the company is enjoying great
profits and it would lead to the better earnings to the investors of the company.
Further, the efficiency analysis of the company explains that the company has managed
the cash conversion cycle at better level to reduce the requirement of extra cash in the
business. The liquidity risk level of the business has also been identified and it has been
found that the risk level is higher in 2018. The solvency level has been maintained by the
company at great level to manage the financial risk of the business. And lastly, the market
ratio of the business explains that the market position of the business has been improved to
attract more customers towards the business.
On the basis of the trend analysis, it has been measured the sales level of the company
is enough competitive. The changes done by the managers in the activities of the business
have helped it to improve. Though, the current net income level of the business brief that
required chnages must be done by the business.
Recommendation:

Accounting for managers
11
Through conducting the study on the financial ratios of the business, it has been found
that the company is required to focus on its operating expenses which have impacted on the
profitability ratio a lot. The director’s message has also depicted that few required changes
would be done by the business. The liquidity position must also be improved by the business
in order to manage the liquidity risk of the business. Further, the business is also
recommended to evaluate the turnover days and efficiency position to manage and lower the
cash conversion cycle of the business. The annual report (2017) of Woolworths limited has
described that the company has maintained proper strategies to manage the liquidity risk of
the business.
The proper strategies have been described by the business in the financial risk
management heading to describe the shareholders and other stakeholders of the business. So
that the attractiveness level of the business could be improved and it could offer a better base
to the investors of the company. annual report, 2017 epxlains that managers are focusing on
the issues and made few chnages into the activities to improve the net income level. On the
basis of the overall evaluation, it has been found that the investment into the stock of
Woolworths limited is better option for the business.

Accounting for managers
12
References:
Ahrendsen, B. L., & Katchova, A. L. 2012. Financial ratio analysis using ARMS
data. Agricultural Finance Review, 72(2), p.p. 262-272.
Annual report, 2017. Woolworths Limited. (Online). Available at:
https://www.woolworthsgroup.com.au/icms_docs/195396_annual-report-2017.pdf (accessed
20/09/2018).
Baker, H. K., & English, P. 2011. Capital budgeting valuation: Financial analysis for today's
investment projects (Vol. 13). John Wiley & Sons.
Brigham, E.F. and Ehrhardt, M.C., 2013. Financial management: Theory & practice.
Cengage Learning.
Gibson, C.H., 2011. Financial reporting and analysis. South-Western Cengage Learning.
Higgins, R.C., 2012. Analysis for financial management. McGraw-Hill/Irwin.
Hogarth, R.M. and Makridakis, S., 2011. Forecasting and planning: An
evaluation. Management science, 27(2), pp.115-138.
Kaplan, R.S. and Atkinson, A.A., 2015. Advanced management accounting. PHI Learning.
Koller, T., Goedhart, M. and Wessels, D., 2010. Valuation: measuring and managing the
value of companies (Vol. 499). john Wiley and sons.
Madura, J., 2011. International financial management. Cengage Learning.
Morningstar. 2018. Woolworths Limited. (Online). Available at:
http://financials.morningstar.com/cash-flow/cf.html?t=WOW&region=aus&culture=en-US
(accessed 20/09/2018).
Moyer, R. C., McGuigan, J., Rao, R., & Kretlow, W. 2011. Contemporary financial
management. Nelson Education.
Reuters. 2018. Woolworths Limited. (Online). Available at:,
https://www.reuters.com/finance/stocks/company-profile/WOW.AX (accessed 20/09/2018).
Yahoo Finance, 2018. Woolworths Limited. (Online). Available at:
https://au.finance.yahoo.com/quote/WOW.AX/ (accessed 20/09/2018).

Accounting for managers
13

Accounting for managers
14
Appendix:
WOOLWORTHS GROUP LTD (WOW) CashFlowFlag INCOME STATEMENT
Fiscal year ends in June. AUD in millions except per share
data. 2018-06 2017-06 2016-06
Revenue 56965000 55668600 58275500
Cost of revenue 40256000 39739700 42676700
Gross profit 16709000 15928900 15598800
Operating expenses
Sales, General and administrative 13804000 13134100 12964000
Other operating expenses 11957000 11685700 12033100
Total operating expenses 25761000 24819800 24997100
Operating income -9052000 -8890900 -9398300
Interest Expense 154000 193600 245600
Other income (expense) 11600000 11216900 11003500
Income before income taxes 2394000 2132400 1359600
Provision for income taxes 718000 650400 519500
Minority interest 71000 59900 -1113100
Other income 71000 59900 -1113100
Net income from continuing operations 1676000 1482000 840100
Net income from discontinuing ops 119000 111400 -3188000
Other -71000 -59900 1113100
Net income 1724000 1533500 -1234800
Net income available to common shareholders 1724000 1533500 -1234800
Earnings per share
Basic 1.33 1.19 -0.98
Diluted 1.32 1.19 -0.98
Weighted average shares outstanding
Basic 1300500 1283900 1263500
Diluted 1303099 1287573 1263500
EBITDA 3651000 3340300 2627600
WOOLWORTHS GROUP LTD (WOW) CashFlowFlag BALANCE SHEET
Fiscal year ends in June. AUD in thousands except per share
data. 2018-06 2017-06 2016-06
Assets
Current assets
Cash
Cash and cash equivalents 1273000 909400 948100
Total cash 1273000 909400 948100
Receivables 420000 410500 433500
Inventories 4233000 4080400 4558500

Accounting for managers
15
Prepaid expenses 381000 334200 330400
Other current assets 874000 1259700 1156500
Total current assets 7181000 6994200 7427000
Non-current assets
Property, plant and equipment
Land 1335000 1435400 1435500
Fixtures and equipment 9870000 14015400 13937000
Other properties 3540000 3654100 3627900
Property and equipment, at cost 14745000 19104900 19000400
Accumulated Depreciation -5719000
-
10667400
-
10737600
Property, plant and equipment, net 9026000 8437500 8262800
Equity and other investments 156000 118200 108500
Goodwill 4155000 4216400 3637300
Intangible assets 2310000 2316400 2341000
Deferred income taxes 271000 372300 1110000
Other long-term assets 459000 460800 615600
Total non-current assets 16377000 15921600 16075200
Total assets 23558000 22915800 23502200
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 604000 253400 490300
Capital leases 100 400
Accounts payable 5316000 5068200 4809100
Deferred income taxes 110000 80900 39500
Other current liabilities 3166000 3421600 3653400
Total current liabilities 9196000 8824200 8992700
Non-current liabilities
Long-term debt 2199000 2774700 3868000
Capital leases 2300 2900
Pensions and other benefits 100000 172400 165400
Minority interest 368000 350100 311300
Other long-term liabilities 1214000 1266100 1691300
Total non-current liabilities 3881000 4565600 6038900
Total liabilities 13077000 13389800 15031600
Stockholders' equity
Common stock 6055000 5615000 5252200
Other Equity 278000 -42000 -68800
Retained earnings 4073000 3797200 3124500
Accumulated other comprehensive income 75000 155800 162700
Total stockholders' equity 10481000 9526000 8470600
Total liabilities and stockholders' equity 23558000 22915800 23502200

Accounting for managers
16
WOOLWORTHS GROUP LTD (WOW) Statement of CASH FLOW
Fiscal year ends in June. AUD in thousands except per share
data. 2018-06 2017-06 2016-06
Cash Flows From Operating Activities
Cash Flows From Investing Activities
Investments in property, plant, and equipment
-
1848000
-
1886800
-
1938300
Property, plant, and equipment reductions 85000 279800 722000
Acquisitions, net 249000 195100 -7700
Purchases of investments -1300
Purchases of intangibles -23000 -44600
Other investing charges 4000 3500 3200
Net cash used for investing activities
-
1510000
-
1431400
-
1266700
Cash Flows From Financing Activities
Long-term debt issued 4000 184100 628500
Long-term debt repayment -284000
-
1406500 -994100
Common stock issued 55500 120000
Cash dividends paid -780000 -562400
-
1217200
Other financing activities -12100
Net cash provided by (used for) financing activities
-
1060000
-
1729300
-
1474900
Effect of exchange rate changes -600 6700
Net change in cash
-
2570000
-
3161300
-
2734900
Cash at beginning of period 917000 956000 1333400
Cash at end of period
-
1653000
-
2205300
-
1401500
Free Cash Flow
Capital expenditure
-
1848000
-
1909800
-
1982900
Free cash flow 1082000 1212200 374600
Supplemental schedule of cash flow data
Cash paid for income taxes 661000 668100 848500
Cash paid for interest 184000 234000 289300
Free cash flow 1212 375 1172
Supplemental schedule of cash flow data
Cash paid for income taxes -668 -848 -1056
Cash paid for interest -234 -289 -310

Accounting for managers
17
Ratio Calculations 2017 2016 2015 2014 2013

Accounting for managers
18
Profitability Ratios: 2017 2016 2015 2014 2013
Return on Capital employed
Operating profit / 2132400 1359600 3067700
351510
0 3215000
Capital employed (total assets
- current liabilities)
7,09
7,400
7,0
82,500
8,
507,300
9,472
,200
9,15
8,000
Answer: % 30.04% 19.20% 36.06% 37.11% 35.11%
Gross Profit Margin
Gross profit /
15,928,9
00
15,598,8
00 16,523,600
16,477,
600
15,762,0
00
Sales Revenue (note used
operating revenue)
55,668,6
00
58,275,5
00 60,868,400
60,952,
200
586,740,
000
Answer: 28.6% 26.8% 27.1% 27.0% 2.7%
Operating profit margin
Operating profit /
2,132,40
0
1,359,60
0 3,067,700
3,515,1
00
3,215,00
0
Sales Revenue %
55,668,6
00
58,275,5
00 60,868,400
60,952,
200
586,740,
000
Answer: 3.83% 2.33% 5.04% 5.77% 0.55%
Asset Efficiency Ratios 2017 2016 2015 2014 2013
Trade payable payment
period ratio
Accounts payable/
5,068,20
0
4,809,10
0 5,040,000
4,657,1
00
4,080,00
0
Cost of sales
39,739,7
00
42,676,7
00 44,344,800
44,474,
600
42,913,0
00
Answer: (note the above
needs to be x 365) 46.55 41.13 41.48 38.22 34.70
Inventory Turnover (days)
Average Inventory /
4,080,40
0
4,558,50
0 4,872,200
4,693,2
00
4,205,00
0
Cost of Sales
#
days
39,739,7
00
42,676,7
00 44,344,800
44,474,
600
42,913,0
00
Answer: (note the above needs to
be x 365) 37.48 38.99 40.10 38.52 35.77
Receivables Turnover
(days)
Average trade debtors /
41
0,500
4
33,500 584,000
616
,700
69
8,000
Sales revenue (note used
operating revenue)
#
days
55,6
68,600
58,2
75,500
60,
868,400
60,95
2,200
586,74
0,000
Answer: (note the above needs to
be x 365) 2.69 2.72 3.50 3.69 0.43

Accounting for managers
19
Liquidity Ratios 2017 2016 2015 2014 2013
Current Ratio
Current Assets /
6,994,20
0
7,427,00
0 7,660,900
7,174,8
00
6,226,00
0
Current liabilities
8,824,20
0
8,992,70
0 9,168,600
7,558,2
00
6,866,00
0
Answer: 0.79 0.83 0.84 0.95 0.91
Acid test ratio
Current Assets - Inventory /
2,913,80
0
2,868,50
0 2,788,700
2,481,6
00
2,021,00
0
Current Liabilities
8,824,20
0
8,992,70
0 9,168,600
7,558,2
00
6,866,00
0
Answer: 0.33 0.32 0.30 0.33 0.29
Solvency Ratios 2017 2016 2015 2014 2013
Gearing ratio
Long term liabilities /
4,565,60
0
6,038,90
0 5,334,000
6,394,5
00
6,084,00
0
Capital employed
7,097,40
0
7,082,50
0 8,507,300
9,472,2
00
9,158,00
0
Answer: % 64.33% 85.27% 62.70% 67.51% 66.43%
Interest Coverage Ratio
EBIT /
2,132,40
0
1,359,60
0 3,067,700
3,515,1
00
3,215,00
0
Net Finance Costs (used net
interest expense) 193,600 245,600 254,800 277,800 410,000
Answer:
times
p.a 11.01 5.54 12.04
1
2.65 7.84
Stock market ratios 2017 2016 2015 2014 2013
Earnings per share
Net income
1,533,50
0
-
1,234,80
0 2,146,000
2,451,7
00
2,259,00
0
Weighted average shares
outstanding
1,283,90
0
1,263,50
0 1,256,600
1,248,0
00
1,237,00
0
Answer: 1.194
-
0.977 1.708 1.965 1.826
Dividend coverage ratio
Net income /
1,533,50
0
-
1,234,80
0 2,146,000
2,451,7
00
2,259,00
0
Dividend paid to shareholders 562,400
1,217,20
0 1,567,400
1,523,1
00
1,417,00
0
Answer: - 0

Accounting for managers
20
0.367 1.014 1.369 .621 1.594