a report of around (around two pages of word document) on ABC company as a new junior analyst keeping in mind all areas that you studied in your Financial Management subject at undergraduate level. You can take assumptions with valid logical reasoning. All relevant ratios of five years are given with broad category, read carefully and write based on various performance areas given in these financial highlights. You can discuss all ratios based on the broader category given in this question.
cal Gross Operating Return on Net Profit Asset Return on Financial Return on Profit Return on Capital Year Margin Tumov Assets leverage Margin Assets 27 204311 0.39599 11976797 Employed 2013 12 17 2234 35 39 12.2 14 858744 2014 21 707263 0.396281 8.60217081 1 2713841 10.9367 34.4259 12.41374 14.163817 2015 27 833978 0.368/13 10.2627588 1 2095523 12 4133 34 2846 12 93982 14.279002 2016 26 235569 0 38841 10 1901551 1 2423426 12 6597 38 9151 14.54331 16.328471 2017 24 182998 0.329092 7 95843722 1 36676 10.8773 37.3425 11 69163 13.451284 Liquidity Ratios Cash to Current Quick Current Year Ratio Ratio Liabilities 2013 2.5379686 1793695 3.45 2014 4 8291736 3.844546 3.78282211 2015 4.3604403 3.380666 3.32363512 2016 3.0708846 2 434411 2 38405767 2017 1 853497 1.168916 1 13657896 Activity Ratios Inventory No. of Receivables No. of Days |Payable No. of Working Cash Tumover Days in Turnover in Turnover Days in Capital Conversion Year Ratio Inventory Ratio Receivables Ratio Payable Tumover Cycle 2013 11.635384 20.45 45.75 8 36 34.54 10.9 20.45 2014 14 201233 25 70199 54 734196 6.6685916 36 7044 9 94432 1 06593 22 426263 2015 14.750045 24 74569 37.957614 9 615989 26 0353 14 0194 1 111081 20.342262 2016 23.872628 15.28948 52.9922021 6.8878059 14 9294 24 4485 1 479644 -2 271193 2017 18.088527 20.17854 192 388981 1.897199 25.9389 14.0715 2.471969 8 004218 Valuation Ratios Market Price Dividend Cash Book Price per Earnings Earnings Payout Dividend Value Year Share per Share Radio Ratio per Share | per 2013 120.45 16.01554 7.52081823 0.23 2.5 149 55 2014 87.96 13 74859 6.39774684 0 2545716 3 141252 2015 142 77 17 92927 7.96295528 0.2788735 5 147.619 2016 190.49 19.13036 9.95747087 0 3136376 6 154607 2017 213.16 17 92541 11 8915 0.4184005 75 174,987Solvency Ratios Debt to Debt to Debt Equity Assets Capital Interest Year Ratio Ratio Ratio Cover Ratio 2013 0.3512274 0.21 0.17 7.6335585 2014 0.2091102 0 184808 0.19022915 12.221825 2015 0 2099753 0.177424 0.19209065 30.067903 2016 0 2732471 0 22503 0 24411703 82.993964 2017 0.4493816 0.349124 0.35990622 31 541006 Instructions: Write a report of around 500 words (around two pages of word document) on ABC company as a new junior analyst keeping in mind all areas that you studied in your Financial Management subject at undergraduate level. You can take assumptions with valid logical reasoning. All relevant ratios of five years are given with broad category, read carefully and write based on various performance areas given in these financial highlights. You can discuss all ratios based on the broader category given in this question. Marks (08) Q No. 2 Osama Co. is a listed company operating in the textile industry. Osama Co's board of directors