its alot of information but its not all needed to answer the question. i know its a heavy one but please, i really need help.
3.12 CONSOLIDATED INCOME STATEMENT 51 34 tim Notes 2019 2018 Revenue 31 46.415 47.169 Cost of sales 3.1 (35 018) (36.037 Gross margin 11.397 11,132 Payroll expenses (5,816) (5.716) External expenses (2.638) (3.307 Depreciation provision and imporment 33 (1.932) 11.496) Other recurring operating income /exp) 33 31 (12) RECURRING OPERATING INCOME 1,042 601 Non-recurring income and expenses (179) (784) OPERATING INCOME 863 (183) Income from cash and cash equivalents 71 65 Gross cost of financial debt (130) (91) Net cost of financial debt 102 (59) (26) Other financial income 103 42 13 Other financial expenses 103 (321) (51) INCOME BEFORE TAX 524 (246) Share of net income (loss) of associates 7 (22) 3 Income tax expense 112 (229) (82) NET INCOME FROM CONTINUING OPERATIONS 274 (331) Net income from assets held for sale and discontinued operations 26 (1529) (614) NET INCOME (1.255) (946) of which attributable to owners of the parent (1463) of which attributable to non-controlling interests 208 200 EARNINGS PER SHARE FROM CONTINUING OPERATIONS ATTRIBUTABLE TO OWNERS OF THE PARENT basic 82 227 (1784 diluted 82 2.27 (17.84) NET EARNINGS PER SHARE ATTRIBUTABLE TO OWNERS OF THE PARENT basic 82 (5019) (38.49) diluted 82 (5019 (38.49) EBITDA 3.2 2.913 2,084 @ The Group applied IFRS 16-Leases for the first time on 1 January 2019, using the simplified retrospective approach According to this approach, comparative information is not restated and the net tax import of the standards initial application outlined in note 27 was reported under equity on 1 January 2019 a) Contribution of Oney Bank Auchan Rooittaly and Auchan Retail Vietnom - see note 26 to the consolidated financial statements In relation to the data published at 31 December 2018 the contnbutions of Oney Bank Auchan Retail Italy and Auchan Retol Vietnam were reclassified under net income from assets held for sale and discontinued operations (1.145 3.1.4 CONSOLIDATED STATEMENT OF CASH FLOWS inon Notes 2019 2018 (1,255) 22 (946) 3 (4) 37 70 318 256 2,801 2336 1 1 1.133 35 2,806 (326) (427) 109 2,161 (452) 114 1.997 (257) (153) 116 12 1.703 (74) (28) 12 Consolidated net income for the period (including non-controlling interests) Share of net income loss) of associates Dividends received (non-consolidated investments) Net cost of financial debt and lease interest Income tax expense including deferred taxes) Net depreciation provision and impairment expenses (other than on current assets Income and expenses on share-based payment plans Other non-cash items Capital gains/losses net of tax and negative goodwill Cash flows from operations before not cost of financial debt, leasing Interest and tax Income tax paid Interest paid and lease interest Other financial items Cash flows from operations after net cost of financial debt and tax Changes in working capital requirement Changes in terms relating to the credit activity Not cash generated by operating activities Acquisition of property, plant and equipment, intangible assets and Investment property Proceeds from sales of property, plant and equipment, intangible assets and investment property Acquisition of shares in non-consolidated companies including associates accounted for by the equity method Proceeds from sales of shares in non-consolidated companies including associates accounted for by the equity method Disbursements linked to business combinations net of cash acquired Cash flow from discountinued operation Dividends received (non-consolidated investments Changes in loans and advances granted Net cash from (used in) Investing activities Purchases and sales of treasury shares Dividends paid during the period Acquisitions and disposats of interests without change in control Payment of lease abilities Changes in net financial debt 1,824 1,601 (1.181) (1.999 218 82 (54) 352 4 (434) 11 12 (213) (1136) (196) (2.383) 07 790 22032 Notes 2018 (65) 1.431 35 12 12 582 in Em 2019 Net cash from (used in) financing activities Effect of changes in foreign exchange rates (40) Net increase (decrease) in cash and cash equivalents 582 683 Cash and cash equivalents at beginning of period 2.987 2304 Cash and cash equivalents at end of period 3.569 2.987 NET INCREASE (DECREASE IN CASH AND CASH EQUIVALENTS 683 The Group applied IFRS 16-Leases for the first time on 1 January 2019. using the simplified retrospective approach According to this approach comparative information is not restated and the net tax impact of the standard's initial application outlined in note 2.7 was reported under equity on 1 January 2018 2) Including 232 million in IFRS 16 financial interest Includes a 471 milion positive IFRS 36 impact 6) in 2019. mainly relates to the disposal of shares in Oney Bank by Auchan Holding (5) In 2018, mainly relates to the acquisitions of two shopping centres and a retail park through the full acquisition of five companies (Ceetrus Portugal16) This regards the reclassification of changes in the active cash flow of operations held for sale (see Significant event 12) 1) Including 98 million in cash reclassified as restricted cash balances - new regulation on prepaid cards in China (8) Mainly relates to the reduction in the capital of Auchan Holding through the cancellation of shares in the context of the employee share ownership plan a) Primonly the impact of the rouble amounting to 160) million 3.2 CONSOLIDATED EQUITY AND LIABILITIES Notes 2018 91 22 121 Equity and liabilities in Em 2017 Share capital 813 591 604 Share premiums 1.673 1.914 Reserves and net income attributable to owners of the parent 5.674 7.394 EQUITY ATTRIBUTABLE TO OWNERS OF THE PARENT 7.939 9.912 Non-controlling interests 8.1.7 3.509 3.369 TOTAL EQUITY 11,448 13,281 Provisions 265 282 Non-current borrowings and other financial abilities 10.6 4.198 3.728 Debts financing the credit activity 112 462 928 Non-current derivative financial instruments 10.4 17 Other non-current liabilties 106 458 341 Deferred tax liabilities 531 627 NON-CURRENT LIABILITIES 5.931 5.927 Provisions 91 284 247 Current borrowings and other financial liabilities 106 3,162 1.487 Debts financing the credit activity 399 1.387 Current derivative financial instruments 10.4 22 Trade payables 8.457 8.799 Current tax liabilities 119 140 Other current liabilities 106 4 325 Liabilities classified as held for sale 26 1.738 CURRENT LIABILITIES 18.557 16,436 TOTAL EQUITY AND LIABILITIES 35.935 35,645 The Group applied IFRS 9 - Financial Instruments for the first time on 1 January 2018 Given the transition method chosen the comparative data has not been restored and the impact (net of tax resulting from the first application of the standard as set out in note 2.2. has been recognised In equity of 1 January 2018 (see changes in equity 112 106 121 4.375 The Group applied IFRS 15 - Revenue from Contacts with customers as from January 2018 without restating comparative periods os authorised by the standard NOTE 8 EQUITY AND EARNINGS PER SHARE 8.1 EQUITY France (Valauchan Sopaneer International. Valauchanrus Sopaneer SCA Valespana SCA Valpoland SCA. Valhungary 8.1.1 Capital management International SCA Valportugal SCA and Valrussie SCA) Only Auchan Holding's policy is to maintain a solid capital base that the companies included in the employee share ownership inspires the confidence of its investors and creditors and allows plans outside of France are fully consolidated it to contribute to the development of its activities. The articles of association of Valauchan Sopaneer International. Valauchanrus Sopaneer SCA Valespaa SCA Valpoland SCA 8.1.2 Shareholders Valhungary International SCA. Valportugal SCA and Valrussie SCA set out the terms and conditions governing share At 31 December 2019. the majority of Auchan Holding's capital ownership Shares in these companies are purchased and sold was owned by Aumarch by affiliates throughout the year, based on a price that is Employees owned nearly 3% of the company's capital via the calculated annually according to a financial valuation method Valauchan and Valfrance mutual funds and via the companies defined by a recognised body of valuation experts and which is included in the employee share ownership plans outside of used consistently over time. 8.1.3 Number of shares comprising the share capital 2019 2018 29,565,168 30,194.690 At 1 January Issue of new shares for cash Capital reduction AT 31 DECEMBER (650.619) 28.914549 (629-522) 29.565,168 At 31 December 2019, the share capital amounted to 578.290.980 it was split into 28.914.549 fully paid-up shares with a par value of 20 each. The share capital amounted to 591303 360 at 31 December 2018, split into 29 565.168 shares with a nominal value of 20. of 2018). Auchan Holding SA owns 88.022 Auchan Holding SA shares for a transaction cost of 32 million of which 4,886 shares are allocated to cover the share option plans for Auchan Holding's management at an acquisition cost of 2 million), while 288,897 shares are owned by Valauchan AUCHAN HOLDING S.A. Bond 102.71 +0.07 (+0.07%) 11.12.2020 STU Indicators Intraday Mountain-Chart Tm Ytd 6m 34 sy Max 10250 0.3% -10% -20% 10000 -30% 4.DX 9750 -50% -6.0% -70% 95.00 -80% -90% 92.50 -100% -110X 90.00 -20% -13.0% 2019 2020 INFO Dividend History EX-DIVIDEND DATE 10/29/2020 DIVIDEND YIELD 0.75% ANNUAL DIVIDEND P/E RATIO $0.68 39.01 Ex/EFF DATE TYPE CASH AMOUNT DECLARATION RECORD DATE DATE PAYMENT DATE 10/29/2020 CASH $0.17 10/15/2020 10/30/2020 11/16/202 07/30/2020 CASH $0.17 07/14/2020 07/31/2020 08/14/20/ 04/29/2020 CASH $0.17 04/16/2020 04/30/2020 05/15/20 02/05/2020 CASH $0.17 01/17/2020 02/06/2020 02/14/20 han AUCHAN X B Francis Francis X execute/content/?cmd-view&content id-_818666, 18coutseid 29156,1 m) Based on the information above (from point a tot), what is your opinion in regards to the cash flow of your company? 2. Ch 3: Ratio Analysis Using the financial statements of your assigned company, calculate each of following ratios listed below for the last two years. Calculate: a) Current ratio b) Quick Ratio c) Total Assets Turnover d) Total Debt Ratio = TD/TA e) Debt-Equity Ratio f) Long-Term Debt Ratio = LTD/LTD + TE) b) Times Interest earned = EBIT/Interest h) Cash-coverage ratio = (EBIT + Dep) / Interest 1) Profit Margin = NI/S D) Return on Assets=NI/TA k) Price Earning Ration = Price per Share / Earning per Shares 1) Market to Book ration m) Calculate the Earning per shares? m) Calculate is the Dividend per share? o) Calculate the Du Pont Identity = NI/S X S/TAX A/E Explain p) What does the Du Pont identity (from point o) tell you about your company? 3.12 CONSOLIDATED INCOME STATEMENT 51 34 tim Notes 2019 2018 Revenue 31 46.415 47.169 Cost of sales 3.1 (35 018) (36.037 Gross margin 11.397 11,132 Payroll expenses (5,816) (5.716) External expenses (2.638) (3.307 Depreciation provision and imporment 33 (1.932) 11.496) Other recurring operating income /exp) 33 31 (12) RECURRING OPERATING INCOME 1,042 601 Non-recurring income and expenses (179) (784) OPERATING INCOME 863 (183) Income from cash and cash equivalents 71 65 Gross cost of financial debt (130) (91) Net cost of financial debt 102 (59) (26) Other financial income 103 42 13 Other financial expenses 103 (321) (51) INCOME BEFORE TAX 524 (246) Share of net income (loss) of associates 7 (22) 3 Income tax expense 112 (229) (82) NET INCOME FROM CONTINUING OPERATIONS 274 (331) Net income from assets held for sale and discontinued operations 26 (1529) (614) NET INCOME (1.255) (946) of which attributable to owners of the parent (1463) of which attributable to non-controlling interests 208 200 EARNINGS PER SHARE FROM CONTINUING OPERATIONS ATTRIBUTABLE TO OWNERS OF THE PARENT basic 82 227 (1784 diluted 82 2.27 (17.84) NET EARNINGS PER SHARE ATTRIBUTABLE TO OWNERS OF THE PARENT basic 82 (5019) (38.49) diluted 82 (5019 (38.49) EBITDA 3.2 2.913 2,084 @ The Group applied IFRS 16-Leases for the first time on 1 January 2019, using the simplified retrospective approach According to this approach, comparative information is not restated and the net tax import of the standards initial application outlined in note 27 was reported under equity on 1 January 2019 a) Contribution of Oney Bank Auchan Rooittaly and Auchan Retail Vietnom - see note 26 to the consolidated financial statements In relation to the data published at 31 December 2018 the contnbutions of Oney Bank Auchan Retail Italy and Auchan Retol Vietnam were reclassified under net income from assets held for sale and discontinued operations (1.145 3.1.4 CONSOLIDATED STATEMENT OF CASH FLOWS inon Notes 2019 2018 (1,255) 22 (946) 3 (4) 37 70 318 256 2,801 2336 1 1 1.133 35 2,806 (326) (427) 109 2,161 (452) 114 1.997 (257) (153) 116 12 1.703 (74) (28) 12 Consolidated net income for the period (including non-controlling interests) Share of net income loss) of associates Dividends received (non-consolidated investments) Net cost of financial debt and lease interest Income tax expense including deferred taxes) Net depreciation provision and impairment expenses (other than on current assets Income and expenses on share-based payment plans Other non-cash items Capital gains/losses net of tax and negative goodwill Cash flows from operations before not cost of financial debt, leasing Interest and tax Income tax paid Interest paid and lease interest Other financial items Cash flows from operations after net cost of financial debt and tax Changes in working capital requirement Changes in terms relating to the credit activity Not cash generated by operating activities Acquisition of property, plant and equipment, intangible assets and Investment property Proceeds from sales of property, plant and equipment, intangible assets and investment property Acquisition of shares in non-consolidated companies including associates accounted for by the equity method Proceeds from sales of shares in non-consolidated companies including associates accounted for by the equity method Disbursements linked to business combinations net of cash acquired Cash flow from discountinued operation Dividends received (non-consolidated investments Changes in loans and advances granted Net cash from (used in) Investing activities Purchases and sales of treasury shares Dividends paid during the period Acquisitions and disposats of interests without change in control Payment of lease abilities Changes in net financial debt 1,824 1,601 (1.181) (1.999 218 82 (54) 352 4 (434) 11 12 (213) (1136) (196) (2.383) 07 790 22032 Notes 2018 (65) 1.431 35 12 12 582 in Em 2019 Net cash from (used in) financing activities Effect of changes in foreign exchange rates (40) Net increase (decrease) in cash and cash equivalents 582 683 Cash and cash equivalents at beginning of period 2.987 2304 Cash and cash equivalents at end of period 3.569 2.987 NET INCREASE (DECREASE IN CASH AND CASH EQUIVALENTS 683 The Group applied IFRS 16-Leases for the first time on 1 January 2019. using the simplified retrospective approach According to this approach comparative information is not restated and the net tax impact of the standard's initial application outlined in note 2.7 was reported under equity on 1 January 2018 2) Including 232 million in IFRS 16 financial interest Includes a 471 milion positive IFRS 36 impact 6) in 2019. mainly relates to the disposal of shares in Oney Bank by Auchan Holding (5) In 2018, mainly relates to the acquisitions of two shopping centres and a retail park through the full acquisition of five companies (Ceetrus Portugal16) This regards the reclassification of changes in the active cash flow of operations held for sale (see Significant event 12) 1) Including 98 million in cash reclassified as restricted cash balances - new regulation on prepaid cards in China (8) Mainly relates to the reduction in the capital of Auchan Holding through the cancellation of shares in the context of the employee share ownership plan a) Primonly the impact of the rouble amounting to 160) million 3.2 CONSOLIDATED EQUITY AND LIABILITIES Notes 2018 91 22 121 Equity and liabilities in Em 2017 Share capital 813 591 604 Share premiums 1.673 1.914 Reserves and net income attributable to owners of the parent 5.674 7.394 EQUITY ATTRIBUTABLE TO OWNERS OF THE PARENT 7.939 9.912 Non-controlling interests 8.1.7 3.509 3.369 TOTAL EQUITY 11,448 13,281 Provisions 265 282 Non-current borrowings and other financial abilities 10.6 4.198 3.728 Debts financing the credit activity 112 462 928 Non-current derivative financial instruments 10.4 17 Other non-current liabilties 106 458 341 Deferred tax liabilities 531 627 NON-CURRENT LIABILITIES 5.931 5.927 Provisions 91 284 247 Current borrowings and other financial liabilities 106 3,162 1.487 Debts financing the credit activity 399 1.387 Current derivative financial instruments 10.4 22 Trade payables 8.457 8.799 Current tax liabilities 119 140 Other current liabilities 106 4 325 Liabilities classified as held for sale 26 1.738 CURRENT LIABILITIES 18.557 16,436 TOTAL EQUITY AND LIABILITIES 35.935 35,645 The Group applied IFRS 9 - Financial Instruments for the first time on 1 January 2018 Given the transition method chosen the comparative data has not been restored and the impact (net of tax resulting from the first application of the standard as set out in note 2.2. has been recognised In equity of 1 January 2018 (see changes in equity 112 106 121 4.375 The Group applied IFRS 15 - Revenue from Contacts with customers as from January 2018 without restating comparative periods os authorised by the standard NOTE 8 EQUITY AND EARNINGS PER SHARE 8.1 EQUITY France (Valauchan Sopaneer International. Valauchanrus Sopaneer SCA Valespana SCA Valpoland SCA. Valhungary 8.1.1 Capital management International SCA Valportugal SCA and Valrussie SCA) Only Auchan Holding's policy is to maintain a solid capital base that the companies included in the employee share ownership inspires the confidence of its investors and creditors and allows plans outside of France are fully consolidated it to contribute to the development of its activities. The articles of association of Valauchan Sopaneer International. Valauchanrus Sopaneer SCA Valespaa SCA Valpoland SCA 8.1.2 Shareholders Valhungary International SCA. Valportugal SCA and Valrussie SCA set out the terms and conditions governing share At 31 December 2019. the majority of Auchan Holding's capital ownership Shares in these companies are purchased and sold was owned by Aumarch by affiliates throughout the year, based on a price that is Employees owned nearly 3% of the company's capital via the calculated annually according to a financial valuation method Valauchan and Valfrance mutual funds and via the companies defined by a recognised body of valuation experts and which is included in the employee share ownership plans outside of used consistently over time. 8.1.3 Number of shares comprising the share capital 2019 2018 29,565,168 30,194.690 At 1 January Issue of new shares for cash Capital reduction AT 31 DECEMBER (650.619) 28.914549 (629-522) 29.565,168 At 31 December 2019, the share capital amounted to 578.290.980 it was split into 28.914.549 fully paid-up shares with a par value of 20 each. The share capital amounted to 591303 360 at 31 December 2018, split into 29 565.168 shares with a nominal value of 20. of 2018). Auchan Holding SA owns 88.022 Auchan Holding SA shares for a transaction cost of 32 million of which 4,886 shares are allocated to cover the share option plans for Auchan Holding's management at an acquisition cost of 2 million), while 288,897 shares are owned by Valauchan AUCHAN HOLDING S.A. Bond 102.71 +0.07 (+0.07%) 11.12.2020 STU Indicators Intraday Mountain-Chart Tm Ytd 6m 34 sy Max 10250 0.3% -10% -20% 10000 -30% 4.DX 9750 -50% -6.0% -70% 95.00 -80% -90% 92.50 -100% -110X 90.00 -20% -13.0% 2019 2020 INFO Dividend History EX-DIVIDEND DATE 10/29/2020 DIVIDEND YIELD 0.75% ANNUAL DIVIDEND P/E RATIO $0.68 39.01 Ex/EFF DATE TYPE CASH AMOUNT DECLARATION RECORD DATE DATE PAYMENT DATE 10/29/2020 CASH $0.17 10/15/2020 10/30/2020 11/16/202 07/30/2020 CASH $0.17 07/14/2020 07/31/2020 08/14/20/ 04/29/2020 CASH $0.17 04/16/2020 04/30/2020 05/15/20 02/05/2020 CASH $0.17 01/17/2020 02/06/2020 02/14/20 han AUCHAN X B Francis Francis X execute/content/?cmd-view&content id-_818666, 18coutseid 29156,1 m) Based on the information above (from point a tot), what is your opinion in regards to the cash flow of your company? 2. Ch 3: Ratio Analysis Using the financial statements of your assigned company, calculate each of following ratios listed below for the last two years. Calculate: a) Current ratio b) Quick Ratio c) Total Assets Turnover d) Total Debt Ratio = TD/TA e) Debt-Equity Ratio f) Long-Term Debt Ratio = LTD/LTD + TE) b) Times Interest earned = EBIT/Interest h) Cash-coverage ratio = (EBIT + Dep) / Interest 1) Profit Margin = NI/S D) Return on Assets=NI/TA k) Price Earning Ration = Price per Share / Earning per Shares 1) Market to Book ration m) Calculate the Earning per shares? m) Calculate is the Dividend per share? o) Calculate the Du Pont Identity = NI/S X S/TAX A/E Explain p) What does the Du Pont identity (from point o) tell you about your company
