Calculate the following ratios for 2013 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
Statement of financial position at 31 December 2013 Consolidated Notes Parent Company 2013 RO 2012 2012 RO 2013 RO RO 8 6 45,798,586 91,547,004 3,987,731 45,798,586 95,233,015 3,750,000 7 8 64,173,347 2,037,430 74,020,543 125,000 140,356,320 66,554,403 2,037,430 74,020,543 125.000 142,737,376 9 125,000 141,458,321 125.000 144,906,601 10 11,338,112 12 13 10,847,780 4,980,041 3,997,430 2,680,308 22,500,000 2.749,561 47,755,120 188,111,440 4,844,527 3.429.280 2,585,307 15,000,000 1.959,891 39,157,117 181,894,493 16,491,395 8,991,151 3,997,430 3,399,135 22,500,000 8,268,778 63,647,889 205,106,210 15,373,384 8.998,813 3.429.280 3,423,822 15,000,000 4,160,981 50,386,280 195.292,881 14 ASSETS Non-current assets Goodwill Property, plant and equipment Investment in associates Investment in subsidiaries Investments available for sale Total non-current assets Current assets Inventories Trade receivables Investments held for trading Prepayments and other receivables Bank 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 - noncurrent portion Deferred tax liability Total non-current liabilities Current liabilities Term loans - current portion Short term borrowings Trade and other payables Total current liabilities Total equity and liabilities Net assets per share 15 17 18 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 19 20,000,000 13.456.873 6,666,667 3.647,566 6.352.434 57.795,984 107,919,524 20,000,000 13.456,873 6,666,667 3,647,566 6,352,434 66.987,600 117,111,140 20 21 6,352,434 79,513,513 129,637,053 22 23 54,000,000 3.288,000 57,288,000 58,000,000 3.190,546 61,190,546 54,000,000 3,288,000 57,288,000 58,000,000 3.190,546 61,190,546 22 4,000,000 4,000,000 4,000,000 22 4,000,000 223,426 12.767,769 16,991,195 24 11,551,008 15,551,008 188,111,440 8.784.423 12,784,423 181.894.493 14,181,157 18,181,157 205,106,210 195,292.881 25 0.576 0.539 0.648 0.585 Consolidated Parent Company 2013 Notes 2012 2013 2012 RO RO RO RO 26 67,342,941 27 63,397,110 (39,967,637) 23,429,473 92,802,705 (62,885,189) (41,299,968) 26,042,973 93,290,315 (61,728,620) 31,561,695 29,917,516 28 Revenue Cost of sales Gross profit General and administrative expenses Other income Profit from operations Net financing costs Investment income Share of profit in an associate 29 (652,256) 167,988 25,558,705 (1,841,665) 1,163,172 (783,507) 54,867 22,700,833 (2,056,283) 498,857 (1,212,054) 190,116 30,539,757 (1,887,443) 126,987 (1,424,915) 60,598 28,553,199 (2,189,059) 46,713 1,400,033 30 29 7 1,273,916 Fair value gain (loss) on investments held for trading 12 568,150 Profit before tax 25,448,362 (3,095,454) (814,071) 20,329,336 (2,463,000) 568,150 30,621,367 (3,095,454) (814,071) 26,996.815 (2,463,000) 31 Income tax Total profit and comprehensive income for the year Basic and diluted earnings per share: 22,352,908 17,866,336 27,525,913 24,533,815 32 0.112 0.089 0.138 0.123
