Calculate every ratios for Year 2018 and Year 2017.

*Please provide solutions with formulas (in excel).

ZXY, Inc. Balance Sheet Financial Year 2018 RM'000 2017 RM'000 Non-Current Assets Property, plant and equipment 2,400,846 1,817,864 Investment in associates 663 2,159 Investment in joint ventures 2,044 2,156 Other investments 4,085 Receivables 136,036 300,162 Derivative financial instruments 116,901 272,453 Deferred tax assets 106,957 119,544 Intangible assets 2.039.303 2.044,571 4,806,835 4,558,909 Current Assets Inventories 19,678 20,366 Receivables 1,011,530 858,488 Contract assets Derivative financial instruments 45,682 175,415 Other investments 728,447 275,415 Tax recoverable 2,167 1,010 Deposits, cash and bank balances 233,608 376,255 2,041,112 1,706,949 Current Liabilities Payables 1,652,490 1,626,491 Contract liabilities Derivative financial instruments 88,618 4,308 Borrowings 645,728 629,324 Tax liabilities 16,809 19.949 Net Current Liabilities 2,403,645 (362,533) 2,280,072 (573,123) Non-Current Liabilities Payables 389,519 490,040 Derivative financial instruments 2,737 8,149 Borrowings 3,319,454 2,776,323 Deferred tax liabilities 79.263 81,462 NET ASSETS 3,790,973 653,329 3,355,974 629,812 Capital and reserves attributable to equity holders of the Company Share capital 6,726,845 6,715,704 Share premium Exchange reserve 13,051 3,650 Capital reorganisation reserve (5,470,197) (5,470,197) Hedging reserve (49,182) 54,193 Fair value reserve (369) (5) Share scheme reserve 10,362 25,051 Accumulated losses (576,918) (704,981) 653,592 623,415 Non-controlling interests (263) 653,329 6,397 629,812 TOTAL EQUITY ZXY, Inc. Income Statements Year 2018 2017 RM'000 RM'000 Revenue 5,530,753 5,612,647 Cost of sales (3,269,886) (3,461,144) Gross profit 2,260,867 2,151,503 Other operating income 20,377 17,589 Marketing and distribution costs (507,468) (493,503) Administrative expenses (633,767) (580,382) Finance income 171,522 35,266 Finance costs (236,772) (271,584) (1,608) 1,770 Share of post-tax results from investments accounted for using the equity method Impairment of investments accounted for using the equity (15,146) method Profit before tax 1,073,151 845,513 Tax expense (309,175) (228,521) 763,976 616,992 Profit for the financial year Attributable to: Equity holders of the Company 770,636 623,683 Non-controlling interests 16.660 16,691) 763,976 616,992 Earnings per share attributable to equity holders of the Company (RM): - Basic 0.15 0.120 - Diluted 0.15 0.120 ZXY, Inc. Operational And Financial Highlights Year 2018 2017 Operational Results TV households ('000) 4,818 5,121 TV household penetration 67% 71% ARPU (RM) 99.3 100.4 Share of TV viewership 76% 77% Connected boxes ('000) 312 507 Weekly radio listernership (m) 12.8 15.6 Average monthly unique visitors (m) 4.1 5.5 Adex (RM m) 640 705 Go Shop registered customers (m) 0.6 1.0 Go Shop revenue (RM m) 189 261 Financial Results (RM m) Revenue 5,475 5,613 EBITDA 1,941 1.817 EBIT 1.115 1,095 PBT 829 846 PAT 608 617 PATAMI 615 624 FCF 1,276 1,317 Financial Ratios Return on invested capital 24% 24% Net debt/EBITDA (times) 1.5 1.5 Revenue growth 5% 2% EBITDA margin 35% 32% PATAMI margin 11% 11% Earnings per share (sen) 11.8 12.0 Dividend per share (sen) 12.0 12.5 Financial Position (RM m) Equity attributable to equity holders of the Company 601 623 Total assets 6,901 6,266 Total borrowings 3,805 3,406 Net debt 2,826 2,759 Calculate the following financial ratios for Year 2018 and Year 2017: 1. Liquidity ratios a. Current ratio b. Quick ratio 2. Asset management ratios a. Average collection period b. Receivable turnover c. Inventory turnover d. Total asset turnover e. Fixed asset turnover 3. Leverage ratios a. Debt ratio b. Debt equity ratio c. Time interest earned 4. Profitability ratios a. Gross profit margin b. Operating profit margin c. Net profit margin d. Return on asset e. Return on equity 5. Market value ratio a. Earnings per share (EPS)