Hi,
Please solve all parts of my question with full working on EXCEL and show FORMULA. All the data required have been written on Excel
Thanks
For Questions 3 and 6 Please compare the ratios solved to these benchmark ratios for Company X
Marks 5 5 5 5 5 5 5 5 1. Describe profitability ratios 2. Describe solvency ratios 3. Using the annual report allocated to you, analyse the profitability performance of the company allocated to you for 2020 by calculating the ratios below: a. Profit margin b. Assets turn-over c. Return on assets d. Return on common stock (ordinary share) equity e. Earnings per share f. Price earnings ratio g. Payout ratio 4. Compare the ratios that you find to the industry average of the same business line as benchmark and give comments on the profitability performance of your company that indicated by each ratio. Download the industry average ratio from https://readyratios.com/sec/industry. 5. Using the annual report allocated to you, analyse the solvency performance of the company allocated to you for 2020 by calculating the ratios below: a. Debt to assets ratio b. Times interest earned 6. Compare the ratios that you find to the industry average of the same business line as benchmark and give comments on the solvency performance of your company that indicated by each ratio. Download the industry average ratio from https://readyratios.com/sec/industry. 5 30 5 5 15 100 Income Statement COST OF SALES = $9,137 Year Ended 30 June 2019 2020 $m Note $m Income Statement Revenue (excluding Finance income) Other Income $ 23,710.00 $ 25,259.00 $ 2,451.00 $ 2,548.00 $ 26,161.00 $ 27,807.00 Expenses Labour Goods and Services purchased Net Impairment losses on financial assets Other expenses $ 4,058.00 $ 5,279.00 $ 9,107.00 $ 9,138.00 $ 202.00 $ 184.00 $ 3,584.00 $ 5,234.00 $ 16,951.00 $ 19,835.00 Share of net loss)/profit from joint ventures and associated entities $ (305.00) $ 12.00 $ 17,256.00 $ 19,823.00 Sharing before interest, income tax expenses, depreciation and amortisation (EBITDA) $ 8,905.00 $ 3,702.00 Depreciation and amortisation Earnings before interest and income tax expense (EBIT) $ 5,338.00 $ 4,282.00 $ 3,567.00 $ 3,702.00 Finance income Finance costs Net finance costs Profit before income tax expense Income tax expense Profit for the year Profit/(loss) for the year attributable to: Equity holders of entity Non-controlling interests $ 274.00 $ 238.00 $ 1,045.00 $ 868.00 $ 771.00 $ 630.00 $ 2,796.00 $ 3,072.00 $ 957.00 $ 923.00 $ 1,839.00 $ 2,149.00 $ 1,819.00 $ 2,154.00 $ 20.00 $ (5.00) $ 1,839.00 $ 2,149.00 Cents Cents $ 15.30 $ 18.10 $ 15.30 $ 18.10 Earning per share (cents per share) Basic Diluted Statement of Comprehensive Income Profit/(loss) for the year attributable to: Equity holders entity Non-controlling interests $ 1,819.00 $ 2,154.00 $ 20.00 $ (5.00) $ 1,839.00 $ 2,149.00 Items that will not be reclassified to the income statement Retained profits Actuarial loss on defined benefit plans attributable to equity holders of Entity $ (82.00) $ (10.00) Income tax on actuarial loss on defined benefit plans $ 25.00 $ 3.00 Fair value of equity instruments reserve Gain from investments in equity instruments designated at fair value through other comprehensive income $ 3.00 Share of other comprehensive income of equity accounted entities $ 16.00 $ 66.00 Income tax on fair value movements for investments in equity instruments $ (2.00) $ (22.00) $ (43.00) $ 40.00 Items that may be subsequently reclassified to the income statement Foreign currency translation reserve Translation differences of foreign operations attributable to equity holders of Entity $ 21.00 $ 39.00 Cash flow hedging reserve Changes in cash flow hedging reserve $ 54.00 $ 3.00 Share of other comprehensive income of equity accounted entities $ (6.00) Income tax on movements in the cash flow hedging reserve $ (16.00) $ (1.00) Foreign currency basis spread reserve Changes in the value of the foreign currency basis spread $ (6.00) $ (22.00) Income tax on movements in the foreign currency basis spread reserve $ 2.00 $ 7.00 $ 49.00 $ 26.00 income $ 6.00 $ 66.00 Total comprehensive income for the year $ 1,845.00 $ 2,215.00 Total comprehensive income for the year attributable to: Equity holders of Entity $ 1,825.00 $ 2,220.00 Non-controlling interests $ 20.00 $ (5.00) Statement of Financial Position Current assets Cash and cash equivalents Trade and other receivables and contract assest Deferred contract costs Inventories Derivate financial assets Current tax receivables Prepatments Assets Classified as held for sale Total Current Assets $ 499.00 $ 604.00 $ 5,121.00 $ 5,392.00 $ 82.00 $ 95.00 $ 418.00 $ 448.00 $ 147.00 $ 179.00 $ 2.00 $ 7.00 $ 265.00 $ 457.00 $ 121.00 $ 6,534.00 $ 7,303.00 Non-Current Assets Trade and other receivables and contract assets Deferred contract costs Inventories Investments - accounted for using the equity method Investments - other Property, plant and equipment Right-of-use assets Intangible assets Derivate financial assets Deferred tax assets Defined benefit assets Total Non-Current Assets Total Assets $ 1,428.00 $ 780.00 $ 1,354.00 $ 1,232.00 $ 28.00 $ 35.00 $ 897.00 $ 1,298.00 $ 21.00 $ 25.00 $ 21,499.00 $ 21,836.00 $ 3,030.00 $ 7,412.00 $ 7,706.00 $ 2,011.00 $ 2,083.00 $ 66.00 $ 59.00 $ 123.00 $ 232.00 $ 37,869.00 $ 35,286.00 $ 44,403.00 $ 42,589.00 Current Liabilities Trade and other payables Employee benefits Other provisions Lease liabilities Borrowings Dervivative financial liabilities Current tax payables Contract Liabilities and other revenue received in advance Liabilities classified as held for sale Total Current Liabilities $ 3,980.00 $ 4,528.00 $ 727.00 $ 804.00 $ 124.00 $ 103.00 $ 611.00 $ 2,763.00 $ 2,222.00 $ 54.00 $ 57.00 $ 224.00 $ 103.00 $ 1,611.00 $ 1,657.00 $ 79.00 $ 10,094.00 $ 9,553.00 Non-Current Liabilities Other payable Employee benefits Other provisions Lease liabilities Borrowing Derivative financial liabilities Deferred tax liabilities Defined benefit liability Contract Liabilities and other revenue received in advance Total Non-current liabilities Total Liabilities Net Assets $ 4.00 $ 68.00 $ 127.00 $ 158.00 $ 143.00 $ 158.00 $ 2,687.00 $ 13,066.00 $ 15,031.00 $ 320.00 $ 283.00 $ 1,605.00 $ 1,529.00 $ 8.00 $ 8.00 $ 1,202.00 $ 1,271.00 $ 19,162.00 $ 18,506.00 $ 29,256.00 $ 28,059.00 $ 15,147.00 $ 14,530.00 Equity Share capital Reserves Retained profits Equity available to Entity shareholders Non-controlling interest Total Equity $ 4,451.00 $ 4,447.00 $ 5.00 $ (58.00) $ 10,017.00 $ 10,160.00 $ 14,473.00 $ 14,549.00 $ 674.00 $ (19.00) $ 15,147.00 $ 14,530.00 $ 29,506.00 $ 30,231.00 $ (21,895.00) $ (22,748.00) $ 153.00 $ 156.00 $ 7,764.00 $ 7,639.00 $ (754.00) $ (956.00) $ 7,010.00 $ 6,683.00 Statement of Cash Flow Cash flows from operating activities Receipts from customers (Inclusive of goods and services tax (GST)) Payments to suppliers and employees (Inclusive of GST) Government grants received Net cash generated by operations income taxes paid Net cash provided by operating activities Cash flows from investing activities Payments for property, plant and equipment Payments for intangible assests Capital expenditure (before investments) Payments for shares in controlled entities (net of cash acquired) Payments for equity accounted investments Payments for other investments Total capital expenditure (including investments) Proceeds from sales of property, plant and equipment Proceeds from sales of business and shares in controlled entities (net of cash disposed) Proceeds from sales of equity accounted and other investments Distributions received from equitt accounted investments Receipts for the principal portion of finace lease receiveables Government grants received Interest received Net cash used in investing activities Operating cash flow less investing cash flows cash flows from financing activities Proceeds from borrowing Repayment for borrowing Payment for the principal portion of lease liabilties Payment for the principal portion of finace lease liabilities Purchase of shares for employee share plans Finance cost paid Dividends paid to non-controlling interests Dividends paid to equirt holder of entity Proceeds from the sale of units in a controlled trust Other Net cash used in financing activities Net decrease in cash and cash equivalents Cash and cash equivalents at the beginning of the year Effects of exchange rate changes on cash and cash equivalents Cash and cash equivalents at the end of the year $ (2,341.00) $ (3,207.00) $ (1,101.00) $ (1,163.00) $ (3,442.00) $ (4,370.00) $ (115.00) $ (33.00) $ (21.00) $ (122.00) $ (26.00) $ (3,597.00) $ (4,532.00) $ 276.00 $ 646.00 $ 58.00 $ 42.00 $ 15.00 $ 6.00 $ 83.00 $ 33.00 $ 135.00 $ 104.00 $ 28.00 $ 53.00 $ 26.00 $ 33.00 $ (2,976.00) $ (3,615.00) $ 4,034.00 $ 3,068.00 (2.00) $ 5,476.00 $ 4,669.00 $ (6,562.00) $ (4,637.00) $ (993.00) $ (79.00) $ (22.00) $ (812.00) $ (781.00) $ (23.00) $ $ (1,903.00) $ (2,259.00) $ 698.00 $ 3.00 $ 1.00 $ (4,138.00) $ (3,088.00) $ (104.00) $ (20.00) $ 604.00 $ 620.00 $ (1.00) $ 4.00 $ 499.00 $ 604.00 Statement of Changes in Equity Non-Control- Balance at 1 July 2018 Profit/(loss) for the year Other comprehensive income Total comprehensive income for the year Dividends Non-controlling interests on disposals Transactions with non-controlling interests Amounts repaid on share loans provided to employees Share-based payments Balance at 30 June 2019 Change in accounting policy arising from AASB 16: 'Leases' Restated balance at 1 July 2019 Profit for the year Other comprehensive income Total comprehensive income for the year Dividends Non-controlling interests from the sale of units in a controlled trust Transactions with non-controlling interests Amounts repaid on share loans provided to employees Additional shares purchased Share-based payments Balance at 30 June 2020 Share Capital Reserves Retained Profits Total $m $m $m $m $m $ 4,428.00 $ (131.00) $ 10,272.00 $ 14,569.00 $ $ 2,154.00 $ 2,154.00 $ $ 73.00 $ (7.00) $ 66.00 $ 73.00 $ 2,147.00 $ 2,220.00 $ $ (2,259.00) $ (2,259.00) $ $ $ $ 1.00 $ 1.00 $ 18.00 $ 18.00 $ $ 4,447.00 $ (58.00) $ 10,160.00 $ 14,549.00 $ $ (2.00) $ (2.00) $ 4,447.00 $ (58.00) $ 10,158.00 $ 14,547.00 $ $ 1,819.00 $ 1,819.00 $ $ 63.00 $ (57.00) $ 6.00 $ 63.00 $ 1,762.00 $ 1,825.00 $ $ (1,903.00) $ (1,903.00) $ $ $ $ 3.00 $ 3.00 $ (22.00) $ (22.00) $ 23.00 $ 23.00 $ 4,451.00 $ 5.00 $ 10,017.00 $ 14,473.00 $ ling interest Total Equity $m (13.00) $ 14,556.00 (5.00) $ 2,149.00 $ 66.00 (5.00) $ 2,215.00 (2.00) $ (2,261.00) 1.00 $ 1.00 (1.00) $ (1.00) $ 1.00 1.00 $ 19.00 (19.00) $ 14,530.00 $ (2.00) (19.00) $ 14,528.00 20.00 $ 1,839.00 $ 6.00 20.00 $ 1,845.00 (26.00) $ (1,929.00) 698.00 $ 698.00 1.00 $ 1.00 $ 3.00 $ (22.00) $ 23.00 674.00 $ 15,147.00 Year Financial ratio 2020 2019 2018 2017 2016 2015 Solvency Ratios Debt ratio 0.69 0.72 0.70 0.75 0.81 0.81 Debt-to-equity ratio 1.28 1.43 1.09 1.08 0.80 0.76 Interest coverage ratio 1.17 1.92 1.61 0.51 1.18 0.94 Liquidity Ratios Current Ratio 1.25 1.23 1.00 1.05 0.99 1.22 Quick Ratio 1.01 0.87 0.79 0.91 1.00 1.04 Cash Ratio 0.52 0.30 0.22 0.26 0.31 0.34 Profitability Ratios Profit margin 1.2% 2.2% 2.1% -1.3% 1% 0.3% ROE (Return on equity), after tax -1.2% -1.9% -4.3% -34.5% -40.1% -11% ROA (Return on assets) 0.6% 0.3% 0.5% -1.8% -0.1% -0.8% Gross margin 54.1% 52.1% 44.7% 44.6% 49.8% 46.7% Operating margin (Return on sales) 8.4% 7.4% 9.3% 5.1% 10.3% 12% Activity Ratios Asset turnover (days) 894 906 770 743 770 699 Receivables turnover (days) 64 50 49 51 52 50 Inventory turnover (days) 28 26 23 21 22 20 Price Ratios Dividend Payout Ratio 0.13 0.20 0.21 0.15 0.21 0.03 Marks 5 5 5 5 5 5 5 5 1. Describe profitability ratios 2. Describe solvency ratios 3. Using the annual report allocated to you, analyse the profitability performance of the company allocated to you for 2020 by calculating the ratios below: a. Profit margin b. Assets turn-over c. Return on assets d. Return on common stock (ordinary share) equity e. Earnings per share f. Price earnings ratio g. Payout ratio 4. Compare the ratios that you find to the industry average of the same business line as benchmark and give comments on the profitability performance of your company that indicated by each ratio. Download the industry average ratio from https://readyratios.com/sec/industry. 5. Using the annual report allocated to you, analyse the solvency performance of the company allocated to you for 2020 by calculating the ratios below: a. Debt to assets ratio b. Times interest earned 6. Compare the ratios that you find to the industry average of the same business line as benchmark and give comments on the solvency performance of your company that indicated by each ratio. Download the industry average ratio from https://readyratios.com/sec/industry. 5 30 5 5 15 100 Income Statement COST OF SALES = $9,137 Year Ended 30 June 2019 2020 $m Note $m Income Statement Revenue (excluding Finance income) Other Income $ 23,710.00 $ 25,259.00 $ 2,451.00 $ 2,548.00 $ 26,161.00 $ 27,807.00 Expenses Labour Goods and Services purchased Net Impairment losses on financial assets Other expenses $ 4,058.00 $ 5,279.00 $ 9,107.00 $ 9,138.00 $ 202.00 $ 184.00 $ 3,584.00 $ 5,234.00 $ 16,951.00 $ 19,835.00 Share of net loss)/profit from joint ventures and associated entities $ (305.00) $ 12.00 $ 17,256.00 $ 19,823.00 Sharing before interest, income tax expenses, depreciation and amortisation (EBITDA) $ 8,905.00 $ 3,702.00 Depreciation and amortisation Earnings before interest and income tax expense (EBIT) $ 5,338.00 $ 4,282.00 $ 3,567.00 $ 3,702.00 Finance income Finance costs Net finance costs Profit before income tax expense Income tax expense Profit for the year Profit/(loss) for the year attributable to: Equity holders of entity Non-controlling interests $ 274.00 $ 238.00 $ 1,045.00 $ 868.00 $ 771.00 $ 630.00 $ 2,796.00 $ 3,072.00 $ 957.00 $ 923.00 $ 1,839.00 $ 2,149.00 $ 1,819.00 $ 2,154.00 $ 20.00 $ (5.00) $ 1,839.00 $ 2,149.00 Cents Cents $ 15.30 $ 18.10 $ 15.30 $ 18.10 Earning per share (cents per share) Basic Diluted Statement of Comprehensive Income Profit/(loss) for the year attributable to: Equity holders entity Non-controlling interests $ 1,819.00 $ 2,154.00 $ 20.00 $ (5.00) $ 1,839.00 $ 2,149.00 Items that will not be reclassified to the income statement Retained profits Actuarial loss on defined benefit plans attributable to equity holders of Entity $ (82.00) $ (10.00) Income tax on actuarial loss on defined benefit plans $ 25.00 $ 3.00 Fair value of equity instruments reserve Gain from investments in equity instruments designated at fair value through other comprehensive income $ 3.00 Share of other comprehensive income of equity accounted entities $ 16.00 $ 66.00 Income tax on fair value movements for investments in equity instruments $ (2.00) $ (22.00) $ (43.00) $ 40.00 Items that may be subsequently reclassified to the income statement Foreign currency translation reserve Translation differences of foreign operations attributable to equity holders of Entity $ 21.00 $ 39.00 Cash flow hedging reserve Changes in cash flow hedging reserve $ 54.00 $ 3.00 Share of other comprehensive income of equity accounted entities $ (6.00) Income tax on movements in the cash flow hedging reserve $ (16.00) $ (1.00) Foreign currency basis spread reserve Changes in the value of the foreign currency basis spread $ (6.00) $ (22.00) Income tax on movements in the foreign currency basis spread reserve $ 2.00 $ 7.00 $ 49.00 $ 26.00 income $ 6.00 $ 66.00 Total comprehensive income for the year $ 1,845.00 $ 2,215.00 Total comprehensive income for the year attributable to: Equity holders of Entity $ 1,825.00 $ 2,220.00 Non-controlling interests $ 20.00 $ (5.00) Statement of Financial Position Current assets Cash and cash equivalents Trade and other receivables and contract assest Deferred contract costs Inventories Derivate financial assets Current tax receivables Prepatments Assets Classified as held for sale Total Current Assets $ 499.00 $ 604.00 $ 5,121.00 $ 5,392.00 $ 82.00 $ 95.00 $ 418.00 $ 448.00 $ 147.00 $ 179.00 $ 2.00 $ 7.00 $ 265.00 $ 457.00 $ 121.00 $ 6,534.00 $ 7,303.00 Non-Current Assets Trade and other receivables and contract assets Deferred contract costs Inventories Investments - accounted for using the equity method Investments - other Property, plant and equipment Right-of-use assets Intangible assets Derivate financial assets Deferred tax assets Defined benefit assets Total Non-Current Assets Total Assets $ 1,428.00 $ 780.00 $ 1,354.00 $ 1,232.00 $ 28.00 $ 35.00 $ 897.00 $ 1,298.00 $ 21.00 $ 25.00 $ 21,499.00 $ 21,836.00 $ 3,030.00 $ 7,412.00 $ 7,706.00 $ 2,011.00 $ 2,083.00 $ 66.00 $ 59.00 $ 123.00 $ 232.00 $ 37,869.00 $ 35,286.00 $ 44,403.00 $ 42,589.00 Current Liabilities Trade and other payables Employee benefits Other provisions Lease liabilities Borrowings Dervivative financial liabilities Current tax payables Contract Liabilities and other revenue received in advance Liabilities classified as held for sale Total Current Liabilities $ 3,980.00 $ 4,528.00 $ 727.00 $ 804.00 $ 124.00 $ 103.00 $ 611.00 $ 2,763.00 $ 2,222.00 $ 54.00 $ 57.00 $ 224.00 $ 103.00 $ 1,611.00 $ 1,657.00 $ 79.00 $ 10,094.00 $ 9,553.00 Non-Current Liabilities Other payable Employee benefits Other provisions Lease liabilities Borrowing Derivative financial liabilities Deferred tax liabilities Defined benefit liability Contract Liabilities and other revenue received in advance Total Non-current liabilities Total Liabilities Net Assets $ 4.00 $ 68.00 $ 127.00 $ 158.00 $ 143.00 $ 158.00 $ 2,687.00 $ 13,066.00 $ 15,031.00 $ 320.00 $ 283.00 $ 1,605.00 $ 1,529.00 $ 8.00 $ 8.00 $ 1,202.00 $ 1,271.00 $ 19,162.00 $ 18,506.00 $ 29,256.00 $ 28,059.00 $ 15,147.00 $ 14,530.00 Equity Share capital Reserves Retained profits Equity available to Entity shareholders Non-controlling interest Total Equity $ 4,451.00 $ 4,447.00 $ 5.00 $ (58.00) $ 10,017.00 $ 10,160.00 $ 14,473.00 $ 14,549.00 $ 674.00 $ (19.00) $ 15,147.00 $ 14,530.00 $ 29,506.00 $ 30,231.00 $ (21,895.00) $ (22,748.00) $ 153.00 $ 156.00 $ 7,764.00 $ 7,639.00 $ (754.00) $ (956.00) $ 7,010.00 $ 6,683.00 Statement of Cash Flow Cash flows from operating activities Receipts from customers (Inclusive of goods and services tax (GST)) Payments to suppliers and employees (Inclusive of GST) Government grants received Net cash generated by operations income taxes paid Net cash provided by operating activities Cash flows from investing activities Payments for property, plant and equipment Payments for intangible assests Capital expenditure (before investments) Payments for shares in controlled entities (net of cash acquired) Payments for equity accounted investments Payments for other investments Total capital expenditure (including investments) Proceeds from sales of property, plant and equipment Proceeds from sales of business and shares in controlled entities (net of cash disposed) Proceeds from sales of equity accounted and other investments Distributions received from equitt accounted investments Receipts for the principal portion of finace lease receiveables Government grants received Interest received Net cash used in investing activities Operating cash flow less investing cash flows cash flows from financing activities Proceeds from borrowing Repayment for borrowing Payment for the principal portion of lease liabilties Payment for the principal portion of finace lease liabilities Purchase of shares for employee share plans Finance cost paid Dividends paid to non-controlling interests Dividends paid to equirt holder of entity Proceeds from the sale of units in a controlled trust Other Net cash used in financing activities Net decrease in cash and cash equivalents Cash and cash equivalents at the beginning of the year Effects of exchange rate changes on cash and cash equivalents Cash and cash equivalents at the end of the year $ (2,341.00) $ (3,207.00) $ (1,101.00) $ (1,163.00) $ (3,442.00) $ (4,370.00) $ (115.00) $ (33.00) $ (21.00) $ (122.00) $ (26.00) $ (3,597.00) $ (4,532.00) $ 276.00 $ 646.00 $ 58.00 $ 42.00 $ 15.00 $ 6.00 $ 83.00 $ 33.00 $ 135.00 $ 104.00 $ 28.00 $ 53.00 $ 26.00 $ 33.00 $ (2,976.00) $ (3,615.00) $ 4,034.00 $ 3,068.00 (2.00) $ 5,476.00 $ 4,669.00 $ (6,562.00) $ (4,637.00) $ (993.00) $ (79.00) $ (22.00) $ (812.00) $ (781.00) $ (23.00) $ $ (1,903.00) $ (2,259.00) $ 698.00 $ 3.00 $ 1.00 $ (4,138.00) $ (3,088.00) $ (104.00) $ (20.00) $ 604.00 $ 620.00 $ (1.00) $ 4.00 $ 499.00 $ 604.00 Statement of Changes in Equity Non-Control- Balance at 1 July 2018 Profit/(loss) for the year Other comprehensive income Total comprehensive income for the year Dividends Non-controlling interests on disposals Transactions with non-controlling interests Amounts repaid on share loans provided to employees Share-based payments Balance at 30 June 2019 Change in accounting policy arising from AASB 16: 'Leases' Restated balance at 1 July 2019 Profit for the year Other comprehensive income Total comprehensive income for the year Dividends Non-controlling interests from the sale of units in a controlled trust Transactions with non-controlling interests Amounts repaid on share loans provided to employees Additional shares purchased Share-based payments Balance at 30 June 2020 Share Capital Reserves Retained Profits Total $m $m $m $m $m $ 4,428.00 $ (131.00) $ 10,272.00 $ 14,569.00 $ $ 2,154.00 $ 2,154.00 $ $ 73.00 $ (7.00) $ 66.00 $ 73.00 $ 2,147.00 $ 2,220.00 $ $ (2,259.00) $ (2,259.00) $ $ $ $ 1.00 $ 1.00 $ 18.00 $ 18.00 $ $ 4,447.00 $ (58.00) $ 10,160.00 $ 14,549.00 $ $ (2.00) $ (2.00) $ 4,447.00 $ (58.00) $ 10,158.00 $ 14,547.00 $ $ 1,819.00 $ 1,819.00 $ $ 63.00 $ (57.00) $ 6.00 $ 63.00 $ 1,762.00 $ 1,825.00 $ $ (1,903.00) $ (1,903.00) $ $ $ $ 3.00 $ 3.00 $ (22.00) $ (22.00) $ 23.00 $ 23.00 $ 4,451.00 $ 5.00 $ 10,017.00 $ 14,473.00 $ ling interest Total Equity $m (13.00) $ 14,556.00 (5.00) $ 2,149.00 $ 66.00 (5.00) $ 2,215.00 (2.00) $ (2,261.00) 1.00 $ 1.00 (1.00) $ (1.00) $ 1.00 1.00 $ 19.00 (19.00) $ 14,530.00 $ (2.00) (19.00) $ 14,528.00 20.00 $ 1,839.00 $ 6.00 20.00 $ 1,845.00 (26.00) $ (1,929.00) 698.00 $ 698.00 1.00 $ 1.00 $ 3.00 $ (22.00) $ 23.00 674.00 $ 15,147.00 Year Financial ratio 2020 2019 2018 2017 2016 2015 Solvency Ratios Debt ratio 0.69 0.72 0.70 0.75 0.81 0.81 Debt-to-equity ratio 1.28 1.43 1.09 1.08 0.80 0.76 Interest coverage ratio 1.17 1.92 1.61 0.51 1.18 0.94 Liquidity Ratios Current Ratio 1.25 1.23 1.00 1.05 0.99 1.22 Quick Ratio 1.01 0.87 0.79 0.91 1.00 1.04 Cash Ratio 0.52 0.30 0.22 0.26 0.31 0.34 Profitability Ratios Profit margin 1.2% 2.2% 2.1% -1.3% 1% 0.3% ROE (Return on equity), after tax -1.2% -1.9% -4.3% -34.5% -40.1% -11% ROA (Return on assets) 0.6% 0.3% 0.5% -1.8% -0.1% -0.8% Gross margin 54.1% 52.1% 44.7% 44.6% 49.8% 46.7% Operating margin (Return on sales) 8.4% 7.4% 9.3% 5.1% 10.3% 12% Activity Ratios Asset turnover (days) 894 906 770 743 770 699 Receivables turnover (days) 64 50 49 51 52 50 Inventory turnover (days) 28 26 23 21 22 20 Price Ratios Dividend Payout Ratio 0.13 0.20 0.21 0.15 0.21 0.03
