4:20 Not Secure files.igra.edu.pk O No. 1 Financial Hatio of A Company Frohtability rabo GOS operang Reum OTT Net Prott Asset Retuman Financial Return on Profit Retum on Capital Yeer Margin Tumour Ansats Leverage Equity Margin Assets Employed 2013 27204311 03900 11976797 12 1722341 369 122 14 858744 2014 21.707263 0.396291 8.60217081 1.2713941 10.5067 34 4259 1241374 14.163617 | 2015 27 833978 0.366713 10.2627588 1.2095523 12.4133 34 2846 1293982 14 279002 2016 26.236560 0.38841 10.1901551 1.2423426 12.6597 32.9151 1454331 16.328471 2017 24.162998 0.329092795843722 1.38676 10.8773 37.3425 11.69163 13.451284 quity Hits Cash to Current Quick Current Year Ratio Ratio Liabilities 2015 2.53790831.703775 5445 2014 4.8291738 3.844546 3.76282211 2015 4.3504403 3.380658 3.32353512 2016 3.0708846 2434411 23B405767 2017 1253497 1.166916 1.13657296 Aclivily Falics Inventory No. of Receivables No. of Days Payable No.of Working Cash Tumover Derys in Tumover in Turnover Days in Capital Conversion Year Ratio Inventory Ratio Receivables Ratio Payable Turnover lode 2013 11.835384 20.45 45.75 8.38 34.54 10.9 1.09 20.45 2014 14201233 25.70199 54734198 6.6685916 36.7044 9.94432 1.06693 22426263 2015 14.750045 24.74509 37957614 9.615080 26.0053 140194 1.11108120342262 2016 23.872628 15269-18 52.9922021 6.8878059 14.9294 294485 1.479644 -2271193 2017 18.068527 20.17854 192388981 1.897199 26.9389 140715 2.471969 8004218 VEUT Rats Market Price Dividend Cash BOOK Price per Eamings Eamngs Payout Dividend Value Year Shure per Share Ratio Ratio per Share per 2013 120.45 16.01554 752061823 25 148.55 2014 87.95 13.74859 6.39774684 0.2515716 3.5 141.242 20151 14277 1792927 7.96296628 0.2788736 5 147.619 20161 190.49 19.13036 9.95747067 0.3136376 6 154.607 20171 213.16 1792641 11.8915 0.4184006 75 174.987 Solvency Hatos Debt to Dublo Debt Equity Assets Capital Interest Year Ratio Ratio Ratio Cover Ratio 2013 0.3512274 0.21 0.17 7.6335545 2014 0.2091102 0.181808 0.19022915 12 221625 2015 0.2098753 0.177424 0.19209065 30.067903 2016 0.2732471 0.22500 0.24411703 82.990964 2017 0.4490816 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) 4:20 Not Secure files.igra.edu.pk O No. 1 Financial Hatio of A Company Frohtability rabo GOS operang Reum OTT Net Prott Asset Retuman Financial Return on Profit Retum on Capital Yeer Margin Tumour Ansats Leverage Equity Margin Assets Employed 2013 27204311 03900 11976797 12 1722341 369 122 14 858744 2014 21.707263 0.396291 8.60217081 1.2713941 10.5067 34 4259 1241374 14.163617 | 2015 27 833978 0.366713 10.2627588 1.2095523 12.4133 34 2846 1293982 14 279002 2016 26.236560 0.38841 10.1901551 1.2423426 12.6597 32.9151 1454331 16.328471 2017 24.162998 0.329092795843722 1.38676 10.8773 37.3425 11.69163 13.451284 quity Hits Cash to Current Quick Current Year Ratio Ratio Liabilities 2015 2.53790831.703775 5445 2014 4.8291738 3.844546 3.76282211 2015 4.3504403 3.380658 3.32353512 2016 3.0708846 2434411 23B405767 2017 1253497 1.166916 1.13657296 Aclivily Falics Inventory No. of Receivables No. of Days Payable No.of Working Cash Tumover Derys in Tumover in Turnover Days in Capital Conversion Year Ratio Inventory Ratio Receivables Ratio Payable Turnover lode 2013 11.835384 20.45 45.75 8.38 34.54 10.9 1.09 20.45 2014 14201233 25.70199 54734198 6.6685916 36.7044 9.94432 1.06693 22426263 2015 14.750045 24.74509 37957614 9.615080 26.0053 140194 1.11108120342262 2016 23.872628 15269-18 52.9922021 6.8878059 14.9294 294485 1.479644 -2271193 2017 18.068527 20.17854 192388981 1.897199 26.9389 140715 2.471969 8004218 VEUT Rats Market Price Dividend Cash BOOK Price per Eamings Eamngs Payout Dividend Value Year Shure per Share Ratio Ratio per Share per 2013 120.45 16.01554 752061823 25 148.55 2014 87.95 13.74859 6.39774684 0.2515716 3.5 141.242 20151 14277 1792927 7.96296628 0.2788736 5 147.619 20161 190.49 19.13036 9.95747067 0.3136376 6 154.607 20171 213.16 1792641 11.8915 0.4184006 75 174.987 Solvency Hatos Debt to Dublo Debt Equity Assets Capital Interest Year Ratio Ratio Ratio Cover Ratio 2013 0.3512274 0.21 0.17 7.6335545 2014 0.2091102 0.181808 0.19022915 12 221625 2015 0.2098753 0.177424 0.19209065 30.067903 2016 0.2732471 0.22500 0.24411703 82.990964 2017 0.4490816 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)
