Calculate the following ratios for 2012 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
Parent Company 2012 RO Consolidated 2012 Notes 2011 2011 RO RO RO 8 6 45,798,586 95,233,015 3,750,000 66,554,403 2,037,430 74,020,543 45,798,586 100,614,173 2,632,513 7 8 70,696,303 2,632,513 74,020,543 175,000 147,524,359 9 125,000 125,000 144,906,601 175,000 149,220,272 142,737,376 10 11 12 13 11,338,112 4,844,527 3,429.280 2,585,307 15,000,000 1,959.891 39,157,117 181,894,493 11,104,665 5,695,005 4,243,351 2.974,057 3,500,000 3.821.239 31,338,317 178,862,676 15,373,384 8,998,813 3,429,280 3,423,822 15,000,000 4,160,981 50,386,280 195,292,881 15,843,951 8,472,561 4,243,351 3,861,895 3,500,000 3,932,346 39,854,104 189,074,376 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 - non current 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 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 50,524,731 100,648,271 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 66,987,600 117,111,140 20,000,000 13,456,873 6,666,667 3,647,566 6,352,434 52,284,187 102,407,727 20 21 22 23 58,000,000 3,190,546 61,190,546 47,102,167 3,248,546 50,350,713 58,000,000 3,190,546 61,190,546 47,102,167 3,248,546 50,350,713 22 4,000,000 17,111,833 18,191,607 2,926,068 15,198,261 36,315,936 24 8,784,423 12,784,423 181,894,493 4,000,000 223,426 12,767,769 16,991,195 195,292,881 10,751,859 27.863,692 178.862.676 189,074,376 25 0.539 0.503 0.585 0.512 Parent Company Consolidated Notes 2012 2011 2012 2011 RO RO RO RO Revenue 26 27 63,397,110 (39,967,637) 23,429,473 59,542,204 (40,462,714) 19,079,490 92,802,705 (62,885,189) 29,917,516 83,813,141 (61.858,019) 21,955,122 28 29 (783,507) 54,867 22,700,833 (2,056,283) 498,857 (1,027,926) 64,132 18,115,696 (2,296,185) 87,482 240,000 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 Fair value gain on investments held for trading Profit before tax Income tax Total comprehensive income and profit for the year Earnings per share: basic and diluted (1,424,915) 60,598 28,553,199 (2,189,059) 46,713 1,400,033 (1,687,607) 104,200 20,371,715 (2,792,748) 87,482 240.000 30 29 7 12 (814,071) 20,329,336 (2,463,000) (864,706) 15,282,287 (2,092,760) (814,071) 26,996,815 (2,463,000) (864,706 17,041,743 (2,092,760) 31 17,866,336 13,189,527 24,533,815 14,948,983 32 0.089 0.066 0.123 0.075
