Calculate the following ratios for 2014 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
Notes Parent Company 2014 2013 RO RO Consolidated 2014 2013 RO RO 29 30 66,988,731 (33,391,238) 33,597,493 67,342,941 (32,965,032) 34,377,909 94,292,989 (54,866,268) 39,426,721 93,290,315 (53,723,059) 39,567,256 31 (2,555,831) (3,915,944) 33 34 Revenue Cost of sales Gross profit General and administrative expenses Selling and distribution expenses Other income Profit from operations Finance cost - net Investment income Share of profit in an associate Fair value gain on financial assets at fair value through profit or loss Profit before tax Income tax Total profit and comprehensive income for the year Basic and diluted earnings per share: (6,429,310) 157,553 24,769,905 (1,945,406) 1,254,715 (2,462,668) (6,524,524) 167,988 25,558,705 (1,841,665) 1,163,172 (4,400,203) (4,871,926) 355,391 30,509,983 (1,943,423) 143,529 1,462,316 (5,301,671) 190.116 30,539,757 (1,887,443) 126,987 1.273,916 35 36 6 13 568,150 215,848 24,295,062 (2,962,086) 25,448,362 (3,095,454) 215,848 30,388,253 (2,962,086) 568,150 30,621,367 (3,095,454) 37 21,332,976 22,352,908 27,426,167 27,525,913 38 0.107 0.112 0.137 0.138 Notes Parent Company 2014 2013 RO RO Consolidated 2014 2013 RO RO 8 S 6 7 9 10 45,798,586 91,927,439 4,338,861 45,798,586 91,547,004 3,987,731 63,234,085 2,037,430 66,539,735 5,455,807 125,000 137,392,057 64,173,347 2,037,430 66,539,735 7,480,808 125,000 140,356,320 125,000 142,189,886 125,000 141,458,321 11 12 8,259,331 5,020,850 10,847,780 4,980,041 14,235,574 8,493,338 16,491,395 8,991,151 13 4,213,278 3,997,430 4,213,278 3,997,430 14 15 16 6,156,137 15,007,651 4,158,155 42,815,402 180,207,459 2,680,308 22,500,000 2,749,561 47,755,120 188,111,440 7,195,428 21,319,651 6,527,776 61,985,045 204,174,931 3,399,135 22,500,000 8,268,778 63,647,889 205,106,210 ASSETS Non-current assets Goodwill Property, plant and equipment Investment in associates Investment in subsidiaries Advances to subsidiaries Available-for-sale financial assets Total non-current assets Current assets Inventories Trade receivables Financial asset 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 Capital and reserves Share capital Share premium Legal reserve Asset replacement reserve Voluntary reserve Retained earnings Total equity 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 71,481,868 121,605,408 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 65,148,892 115,272,432 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 91,939,680 142,063,220 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 79,513,513 129,637,053 24 25 26 39,500,000 3,335,000 806,508 43,641,508 54,000,000 3,288,000 617,019 57,905,019 39,500,000 3,335,000 1,256,096 44,091,096 54,000,000 3,288,000 951,525 58,239,525 24 27 37 5,000,000 7,063,543 2,897,000 14,960,543 58,602,051 180,207,459 4,000,000 7,802,930 3,131,059 14,933,989 72,839,008 188,111,440 0.576 5,000,000 10,123,615 2,897,000 18,020,615 62,111,711 204,174,931 0.710 4,000,000 10,098,573 3,131,059 17,229,632 75,469,157 205,106,210 28 0.608 0.648
