Calculate the ratios of Coles group of Australia for the year 2019: Ratios to calculate: Profitability (ROSF, ROCE, Gross margin, Operating profit margin, Cash flow to Sales*) Efficiency (Inventory turnover period, Average settlement period, Sales revenue to capital employed) Liquidity (Current ratio, Acid test (quick) ratio, Cash flow ratio*). Stability/Capital Structure (Gearing ratio, Interest cover ratio, Debt coverage ratio*) Investment/Market Performance (Earnings per share, Price earnings ratio, Operating cash flow per sha

Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter17: Financial Statement Analysis
Section17.1: Vertical Analysis Of An Income Statement
Problem 1OYO
icon
Related questions
Question

Calculate the ratios of Coles group of Australia for the year 2019:

Ratios to calculate:

Profitability (ROSF, ROCE, Gross margin, Operating profit margin, Cash flow to Sales*)

Efficiency (Inventory turnover period, Average settlement period, Sales revenue to capital employed)

Liquidity (Current ratio, Acid test (quick) ratio, Cash flow ratio*).

Stability/Capital Structure (Gearing ratio, Interest cover ratio, Debt coverage ratio*)

Investment/Market Performance (Earnings per share, Price earnings ratio, Operating cash flow per share*)

Assets
Current assets
Cash and cash equivalents
Trade and other receivables
Inventories
Non-current assets held for sale
Other assets
Total current assets
Non-current assets
Property, plant and equipment
Intangible assets
Deferred tax assets
Equity accounted investments
Other assets
Total non-current assets
Total assets
Liabilities
Current liabilities
Trade and other payables
Income tax payable/ (receivable)
Provisions
Other
Total current liabilities
Non-current liabilities
Interest-bearing liabilities
Provisions
Other
Total non-current liabilities
Total liabilities
Net assets
Equity
Contributed equity
Reserves
Retained earnings
Total equitv
Statement of
Financial Position
as at 30 June 2019.
Notes
41
4.2
72
4.3
45
46
3.6
71
4.3
47
4.8
5.1
4.8
5.2
Consolidated
30 JUNE 2019
SM
940.4
359.7
1,964.7
94.1
47.0
3,405.9
4,119.2
1,540.6
364.9
212.3
134.1
6,371.1
9,777.0
3,379.9
0.1
742.9
167.6
4,290.5
1,460.0
598.4
710
2,129.4
6,419.9
3,357.1
1,627.8
42.0
1,687.3
3.357.1
30 JUNE 2018
SM
686.1
497.2
3,442.3
99.5
4,725.1
5,223.0
1,965.7
540.3
90.6
7,819.6
12,544.7
8,008.5
(25.3)
819.3
178.4
8,980.9
272.4
41.8
314.2
9,295.1
3,249.6
2,192.6
38.8
1,018.2
3.249.6
Transcribed Image Text:Assets Current assets Cash and cash equivalents Trade and other receivables Inventories Non-current assets held for sale Other assets Total current assets Non-current assets Property, plant and equipment Intangible assets Deferred tax assets Equity accounted investments Other assets Total non-current assets Total assets Liabilities Current liabilities Trade and other payables Income tax payable/ (receivable) Provisions Other Total current liabilities Non-current liabilities Interest-bearing liabilities Provisions Other Total non-current liabilities Total liabilities Net assets Equity Contributed equity Reserves Retained earnings Total equitv Statement of Financial Position as at 30 June 2019. Notes 41 4.2 72 4.3 45 46 3.6 71 4.3 47 4.8 5.1 4.8 5.2 Consolidated 30 JUNE 2019 SM 940.4 359.7 1,964.7 94.1 47.0 3,405.9 4,119.2 1,540.6 364.9 212.3 134.1 6,371.1 9,777.0 3,379.9 0.1 742.9 167.6 4,290.5 1,460.0 598.4 710 2,129.4 6,419.9 3,357.1 1,627.8 42.0 1,687.3 3.357.1 30 JUNE 2018 SM 686.1 497.2 3,442.3 99.5 4,725.1 5,223.0 1,965.7 540.3 90.6 7,819.6 12,544.7 8,008.5 (25.3) 819.3 178.4 8,980.9 272.4 41.8 314.2 9,295.1 3,249.6 2,192.6 38.8 1,018.2 3.249.6
Continuing operations
Sales revenue
Other operating revenue
Total operating revenue
Cost of sales
Gross profit
Other income
Administration expenses
Other expenses
Share of net profit of equity accounted investments
Earnings before interest and tax (EBIT)
Financing costs
Profit before income tax
Income tax expense
Profit for the year from continuing operations
Discontinued operations
Profit from discontinued operations after tax
Profit for the year
Statement of
Profit or LosS
for the year ended 30 June 2019.
Profit attributable to:
Equity holders of the parent entity
Earnings per share (EPS) attributable to equity holders of the Company
Basic and diluted EPS (cents)
EPS attributable to equity holders of the Company from continuing operations
Basic and diluted EPS (cents)
Notes
3.3
3.4
7.1
3.5
3.6
7.3
3.2
Consolidated
YEAR ENDED
30 JUNE 2019
SM
38,175.8
288.4
38,464.2
(29,253.4)
9,210.8
427.7
(8,0310)
(145.8)
5.0
1,466.7
(41.5)
1,425.2
(347.0)
1,078.2
356.5
1,434.7
1,434.7
107.6
80.8
YEAR ENDED
30 JUNE 2018
SM
38,934.4
211.0
39,145.4
(30,119.3)
9,026.1
168.7
(7,731.7)
16.3
1,479.4
(0.1)
1,479.3
(456.1)
1,023.2
555.6
1,578.8
1,578.8
118.4
76.7
Transcribed Image Text:Continuing operations Sales revenue Other operating revenue Total operating revenue Cost of sales Gross profit Other income Administration expenses Other expenses Share of net profit of equity accounted investments Earnings before interest and tax (EBIT) Financing costs Profit before income tax Income tax expense Profit for the year from continuing operations Discontinued operations Profit from discontinued operations after tax Profit for the year Statement of Profit or LosS for the year ended 30 June 2019. Profit attributable to: Equity holders of the parent entity Earnings per share (EPS) attributable to equity holders of the Company Basic and diluted EPS (cents) EPS attributable to equity holders of the Company from continuing operations Basic and diluted EPS (cents) Notes 3.3 3.4 7.1 3.5 3.6 7.3 3.2 Consolidated YEAR ENDED 30 JUNE 2019 SM 38,175.8 288.4 38,464.2 (29,253.4) 9,210.8 427.7 (8,0310) (145.8) 5.0 1,466.7 (41.5) 1,425.2 (347.0) 1,078.2 356.5 1,434.7 1,434.7 107.6 80.8 YEAR ENDED 30 JUNE 2018 SM 38,934.4 211.0 39,145.4 (30,119.3) 9,026.1 168.7 (7,731.7) 16.3 1,479.4 (0.1) 1,479.3 (456.1) 1,023.2 555.6 1,578.8 1,578.8 118.4 76.7
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning