NS 2009 Assignment 2 Question 1 (34 marks) The new managing director (MD) of Laser & Tiger Lad has asked you to analyse and give your views on the relative profitability and liquidity. The following summarised financial statements have been prepared for two years. Laser & Tiger Ltd Statement of financial position as at 30 June 2010 NS 2010 ASSETS Non-current assets PPE 150,000.00 120,000.00 Investments in properties 5,000,000.00 4,500,000.00 Investments in subsidiaries 48,000.00 54,000.00 Loan receivable 250,000.00 300,000.00 Goodwill 120,000.00 100,000.00 Total non-current assets 5,568,000.00 5,074,000.00 Current assets Inventory 76,000.00 35,000.00 Trade receivables 42,000.00 11,000.00 Cash and cash equivalents 1,200,000.00 1,300,000.00 Total current assets 1,318,000.00 1,346,000.00 TOTAL ASSETS 6,886,000.00 6,420,000.00 EQUTY AND LIABILITIES Equity Stated capital Retained earnings Total equity 3,000,000.00 2,685,000.00 5,685,000.00 3,000,000.00 2,430,000.00 5,430,000.00 Non-current liabilities Loans from shareholders Long-term debt Total non-current liabilities 120,000.00 950,000.00 1,070,000.00 100,000.00 750,000.00 850,000.00 Current liabilities Trade payables Provisions Taxation payables 79,000.00 41,000.00 11,000.00 54,000.00 63,000.00 23,000.00 Total current liabilities TOTAL EQUITY AND LIABILITIES Additional information: 131,000.00 6,886,000.00 140,000.00 6,420,000.00 1. Included in other income is interest income of NS 34 000 (2009: NS 40 000). 2. 20% of all sales (revenue) were made on credit. 3. Purchases on N$ 150 000 and NS 120 000 were made on credit in 2010 and 2009 respectively. All other purchases were for cash. You are required to: 1. Use the information in respect of Laser & Tiger Ltd 2010 and 2009 financial year, to write a report to the MD analysing the results. (NB: calculate the ratios I.R.O working capital and formulas are crucial) 1.1 Report format (3 marks) 1.2 Gross profit percentage (2 marks) 1.3 Net profit percentage (2 marks) 1.4 ROABT (2 marks) 1.5 ROCE (2 marks) 1.6 Days inventory on hand (2 marks) 1.7 Debtors collection period (2 marks) 1.8 Creditors collection period (2 marks) 2. Discuss what each of the above seven ratios tells you about the efficiency and the profitability of Laser & Tiger Ltd in 2010. (17 marks) NS 2009 Assignment 2 Question 1 (34 marks) The new managing director (MD) of Laser & Tiger Lad has asked you to analyse and give your views on the relative profitability and liquidity. The following summarised financial statements have been prepared for two years. Laser & Tiger Ltd Statement of financial position as at 30 June 2010 NS 2010 ASSETS Non-current assets PPE 150,000.00 120,000.00 Investments in properties 5,000,000.00 4,500,000.00 Investments in subsidiaries 48,000.00 54,000.00 Loan receivable 250,000.00 300,000.00 Goodwill 120,000.00 100,000.00 Total non-current assets 5,568,000.00 5,074,000.00 Current assets Inventory 76,000.00 35,000.00 Trade receivables 42,000.00 11,000.00 Cash and cash equivalents 1,200,000.00 1,300,000.00 Total current assets 1,318,000.00 1,346,000.00 TOTAL ASSETS 6,886,000.00 6,420,000.00 EQUTY AND LIABILITIES Equity Stated capital Retained earnings Total equity 3,000,000.00 2,685,000.00 5,685,000.00 3,000,000.00 2,430,000.00 5,430,000.00 Non-current liabilities Loans from shareholders Long-term debt Total non-current liabilities 120,000.00 950,000.00 1,070,000.00 100,000.00 750,000.00 850,000.00 Current liabilities Trade payables Provisions Taxation payables 79,000.00 41,000.00 11,000.00 54,000.00 63,000.00 23,000.00 Total current liabilities TOTAL EQUITY AND LIABILITIES Additional information: 131,000.00 6,886,000.00 140,000.00 6,420,000.00 1. Included in other income is interest income of NS 34 000 (2009: NS 40 000). 2. 20% of all sales (revenue) were made on credit. 3. Purchases on N$ 150 000 and NS 120 000 were made on credit in 2010 and 2009 respectively. All other purchases were for cash. You are required to: 1. Use the information in respect of Laser & Tiger Ltd 2010 and 2009 financial year, to write a report to the MD analysing the results. (NB: calculate the ratios I.R.O working capital and formulas are crucial) 1.1 Report format (3 marks) 1.2 Gross profit percentage (2 marks) 1.3 Net profit percentage (2 marks) 1.4 ROABT (2 marks) 1.5 ROCE (2 marks) 1.6 Days inventory on hand (2 marks) 1.7 Debtors collection period (2 marks) 1.8 Creditors collection period (2 marks) 2. Discuss what each of the above seven ratios tells you about the efficiency and the profitability of Laser & Tiger Ltd in 2010. (17 marks)