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.

Financial Ratio of ABC Company Profitability ratio Gross Operating Return on Net Profit Asset Return on Financial Return on Profit Return on Capital Year Margin Tumovr Assets Leverage Equity Margin Assets Employed 2013 27.204311 0.39599 11.976797 1.2 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.368713 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 1.793695 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 Turnover Days in Turnover Turnover Days in Capital Conversion Year Ratio Inventory Ratio Receivables Ratio Payable Turnover Cycle 2013 11.635384 20.45) 45.75 8.36) 34.54 10.9 1.09 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.388881 1.897199 25.9389 14.0715 2.471969 8.004218 Valuation Ratios Market Price Dividend Cash Book Price per Eamings Earnings Payout Dividend Value Year Share per Share Ratio Ratio per Share per 2013 120.45 16.01554 7.52081823 0.23 2.5 148.55 2014 87.96 13.74859 6.39774684 0.2545716 3.5 141.252 2015 142.77| 17.92927] 7.962955281 0.2788735 5| 147.619 2016 190.49| 19.13036 9.95747087 0.3136376 6 154.607 2017 213.16 17.92541 11.8915 0.4184005 7.5 174.987 lin Solvency 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