Calculate the following ratios for 2016 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 2016 2015 RO RO Consolidated 2016 2015 RO RO 29 30 65,797,306 (38,810,948) 26,986,358 65,533,689 (36,984,020) 28,549,669 92,587,547 (61,222,271) 31,365,276 94,676,398 (59,181,749) 35,494,649 31 (3,126,108) (2,835,584) (5,902,694) (4,892,747) 33 34 (5,356,613) 50,593 18,554,230 (397,294) (5,497,091) 34,533 20,251,527 (1,470,753) (3,189,771) 134,891 22,407,702 (323,697) (4,302,837) 129,256 26,428,321 (1,435,194) 35 36 36 6 12,576,225 958,322 168,948 168,948 158,903 61,637 1,076,854 Revenue Cost of sales Gross profit General and administrative expenses Selling and distribution expenses Other income Profit from operations Finance cost - net Dividend income from subsidiary Dividend income Share of profits of associates Fair value profit/(loss) on financial assets at fair value through profit or loss Profit before tax Income tax Total profit and comprehensive income for the year Total profit and comprehensive income attributable to: Owners of the Parent Company Non-controlling interest 13 484,348 18,810,232 (2,171,652) (1,084,115) 31,231,206 (3.846,000) 484,348 22,896,204 (2,185,896) (1,084,115) 25,047,503 (4,093,590) 37 16,638,580 27,385,206 20,710,308 20,953,913 16,638,580 27,385,206 20,953,913 20,734,014 (23,706) 20,710,308 16,638,580 27,385,206 20,953,913 Basic and diluted earnings per share 38 0.083 0.137 0.104 0.105 ER 2016 Nates Parent Company 2016 2015 RO RO Consolidated 2016 2015 RO RO 8 5 6 7 9 10 45,798,586 96,207,892 4,677,933 45,798,586 93,998,835 4,519,030 66,305,169 2,037,430 66,641,735 3,911,000 125,000 27,000 7,000,000 146,047,334 66,799,705 2,037,430 66,539.735 3.911,000 125.000 125,000 15 125,000 185,979 7.000,000 153.995,390 139,412,870 144.441.451 11 12 12,838,427 7,053,962 9,256,174 6,457,312 20,226,002 8,610,739 14,667,086 9,021.718 13 3,905,167 3,129,163 3,905, 167 3,129,163 14 15 16 1,982,715 7,000,000 6,530,676 39,310,947 185.358,281 2,139,526 13,503,781 11,239,516 45.725.472 185.138.342 2,411,315 10,892,400 8,412,113 54,457,736 208.453,126 3,180,211 15,607,781 13.615.159 59.221,118 203.662.569 ASSETS Non-current assets Goodwill Property. plant and equipment Investment in associates Investment in subsidiaries Advances to subsidiaries Available-for-sale financial assets Long term deferred expenses Long term deposits 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 casti 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 Equity attributable to parent Compuny shareholders Non-controlling interest Total equity LIABILITIES Non-current liabilities Term loans-non-currunt 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 90,505,654 20,000,000 13,456,873 6,666.667 3,647,566 6,352,434 83.867.074 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 108,626,825 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 97.893.593 140,629,194 133.990,614 148,017.133 158,750,365 74,847 158.825,212 140.629,194 133.990,614 148.017.133 24 25 26 22,437,500 3,279,000 837,071 26.553.571 29.187.500 3,277,000 820,506 33.285.006 22,437,500 3,514,640 1.371.053 27,323,193 29,187,500 3,498,390 1.331.369 34,017.259 24 27 37 5,875,000 10,092,516 2.208,000 18,175,516 44,729,087 185,358,281 0.703 5,875,000 8,054,814 3,932,908 17,862.722 51,147,728 185.138.342 0.670 5,875,000 14,221,721 2.208,000 22.304,721 49.627.914 208,453.126 0.794 5,875,000 11,794,069 3,959,108 21,628,177 55.645,436 203.662,569 0.740 28
