Calculate the following ratios for 2015 and show the steps involved:
a) Inventory turnover ratio
b) average days in inventory
c) receivables turnover ratio
d) average collection period
e) asset turnover ratio
f) profit margin on sales
g) return on assets
h) return on shareholders equity
i) equity multiplier
j) return on shareholders equity using the Du Port framework
Note: See attached balance sheet and income statement below as reference
AS AT 31 DECEMBER 2015 Notes Parent Company 2015 2014 RO RO Consolidated 2015 2014 RO RO 45,798,586 93,998,835 4,519,030 45,798,586 91,927,439 4,338,861 8 5 6 7 9 10 66,799,705 2,037,430 66,539,735 3,911,000 125,000 139,412,870 63,234,085 2,037,430 66,539,735 5,455,807 125,000 137,392,057 125,000 144,441,451 125,000 142,189,886 11 12 9,256,174 6,457,312 8,259,331 5,020,850 14,667,086 9,021,718 14,235,574 8,493,338 3,129,163 4.213,278 3,129,163 4,213,278 14 15 16 2,139,526 13,503,781 11,239,516 45,725,472 185,138,342 6,156,137 15,007,651 4,676,478 43,333,725 180,725,782 3,180,211 15,607,781 13,615,159 59,221,118 203,662,569 7,195,428 21,319,651 7,046,099 62,503,368 204,693,254 ASSETS Non-current assets Goodwill Property, plant and cquipment Investment in associates Investment in subsidiaries Advances to subsidiaries Available-for-sale financial assets Total non-current assets Current assets Inventories Trade receivables Financial assets at fair value through profit or loss Prepayments, advances and other receivables Short term deposits Cash and cash equivalents Total current assets Total assets EQUITY AND LIABILITIES EQUITY Capital and reserves Share capital Share premium Legal reserve Asset replacement reserve Voluntary reserve Retained earnings Total equity LIABILITIES Non-current liabilities Term loans-non-current portion Deferred taxation End of service benefits Total non-current liabilities Current liabilities Term loans - current portion Trade and other payables Taxation Total current liabilities Total liabilities Total equity and liabilities Net assets per share 17 19 20 21 22 23 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 83,867,074 133,990,614 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 71,481,868 121.605,408 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 97,893,593 148,017,133 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 91,939,680 142,063,220 24 25 29,187,500 3,277,000 820,506 33,285,006 39,500,000 3,335,000 806,508 43,641,508 29,187,500 3,498,390 1,331,369 34,017,259 39,500,000 3,335,000 1,256,096 44,091,096 26 24 27 37 5,875,000 8,054,814 3,932,908 17,862,722 51,147,728 185,138,342 0.670 5,000,000 7,581,866 2,897,000 15,478,866 59,120,374 180,725,782 0.608 5,875,000 11,794,069 3,959,108 21,628,177 55,645,436 203,662,569 0.740 5,000,000 10,641,938 2,897,000 18,538,938 62,630,034 204,693,254 0.710 28
