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

Financial Ratio of ABC Company Profitability ratio Gross Operating Retum on Net Profit Asset Return on Financial Return on Profit Return on Capital Year Margin Tumow 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 1169163 13.451284 Liquidity Ratios Cash to | Current Quick Current Year Ratio Ratio Liabilities 2013 25379686 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 1168916 1.13657896 Activity Ratios Inventory No. of Receivables No. of Days Payable No. of Working Cash Turnover Days in Tumover in Tumover Days in Capital Conversion Year Ratio Inventory Ratio Receivables Ratio Payable Turnover Cycle 2013 11635384 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 106593 22.426263 2015 14.750045 24.74569 37.957614 9.615989 26.0353 14.0194 1111081 20.342262 2016 23.872628 15.28948 52.9922021 6.8878059 14.9294 24.4485 1479644 -2.271193 2017 18.088527 20.17854 192.388881 1897199 25.9389 14.0715 2471969 8.004218 Valuation Ratios Market Price Dividend Cash Book Earnings Earnings Payout Dividend Value Year Share per Share Ratio Ratio per Share per 2013 120.45 16.01554 752081823 0.23 2.5 148_55 2014 87.96 13.74859 6.39774684 0.2545716 35 141.252 2015 142.77 17.92927 7.96295528 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 75 174.987 Price per Solvency Ratios Debut 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