Unit: Financial Management
Sign in to download the full Topic PDF and enable offline revision mode.
Login to Access| Turnover | Sh.3,000,000 |
| Costs as percentages of sales | (%) |
| Direct materials | 30 |
| Direct labour | 25 |
| Variable overheads | 10 |
| Fixed overheads | 15 |
| Selling and distribution | 5 |
| 1. | Accounts receivables take 2.5 months before payment. |
| 2. | Raw materials are in inventory for 3 months. |
| 3. | Work-in-progress represents two months of half produced goods. |
| 4. | Finished goods represent one-month production. |
| 5. | Credit is taken as follows:
|
| Note: | Assume that all direct materials are allocated to work-in-progress when production starts, that is, work-in-progress and finished goods are valued at materials, labour and variable expense cost. |
| 1. | Projected sales and production units information is provided as follows: |
| 1. | 2024 | ||||||
| Details | July | August | September | October | November | December | |
| Sales (units) | 130,000 | 150,000 | 170,000 | 190,000 | 180,000 | 180,000 | |
| Production (units) | 140,000 | 150,000 | 180,000 | 200,000 | 220,000 | 220,000 |
| 2. | Variable overheads are paid in the month that they are incurred. |
| 3. | Fixed overheads are budgeted at Sh.700,000 per month which includes depreciation of Sh.100,000. |
| 4. | Wages are paid 75% during the month in which they are earned and 25% in the following month. |
| 5. | Material costs are paid 2 months in arrears. |
| 6. | A tax liability of Sh.1,400,000 to be settled in the month of October 2024. |
| 7. | A new van will be purchased in the month of September 2024 for Sh.2,000,000. The current motor vehicle shall be sold in the month of November 2024 and it is expected to fetch Sh.300,000 from a prospective buyer. |
| 8. | The cash balance at the end of the month of August 2024 is expected to be Sh.1,000,000. |
| 9. | The business makes a monthly cash sale of 5% of total sales in a specific month while the remainder is on credit which is settled one month after the month of sale. |
| Sh."000" | |
| Trade receivables | 2,466 |
| Trade payables | 2,220 |
| Bank overdraft | 3,000 |
| Month | Total working capital requirement |
| Sh."000" | |
| January | 3,000 |
| February | 2,500 |
| March | 2,000 |
| April | 1,500 |
| May | 1,500 |
| June | 1,700 |
| July | 1,800 |
| August | 2,800 |
| September | 3,200 |
| October | 3,500 |
| November | 3,600 |
| December | 3,800 |
| Sh.“000” | |
| Inventory - Opening balance | 4,000 |
| Inventory - Ending balance | 4,600 |
| Trade receivables | 5,000 |
| Trade payables | 3,400 |
| Credit sales | 50,000 |
| Cost of goods sold | 40,000 |
| Summary Statement of profit and loss | |
| Sh.“000” | |
| Sales (150,000 units) | 15,000 |
| Variables costs | (13,500) |
| Fixed costs | (600) |
| Profit | 900 |
| Statement of financial position | ||
| Sh.“000” | Sh.“000” | |
| Non-current assets | 22,500 | |
| Current assets: | ||
| Trade receivables | 3,000 | |
| Inventory | 1,200 | |
| Bank | 360 | |
| Trade payables | (900) | 3,660 |
| 26,160 | ||
| Financed by: | ||
| Equity capital | 15,000 | |
| 12% long- term debt | 3,840 | |
| 6% preference share capital | 7,320 | |
| 26,160 | ||
| Present Policy | Option A | |
| Additional sales (%) | - | 25% |
| Average collection period | 1 month | 2 month |
| Bad debts (% of sales) | 1% | 3% |
| Turnover for the year | Sh.15,000,000 |
| Costs as percentages of sales | (%) |
| Direct materials | 30 |
| Direct labour | 25 |
| Variable overheads | 10 |
| Fixed overheads | 15 |
| Selling and distribution | 5 |
| Month | Working capital required (Sh."000") |
| January February March April May June July August September October November December | 35,000 35,000 52,500 70,000 105,000 157,500 210,000 242,500 157,500 87,500 70,000 52,500 |
| Sh."Million" | ||
| Sales: | September | 60 |
| October | 60 | |
| November | 70 | |
| December | 90 |
| Raw materials purchases | Sh."Million" |
| September | 20 |
| October | 40 |
| November | 40 |
| December | 30 |
| Wages and salaries: | Sh."Million" |
| September | 12 |
| October | 15 |
| November | 17 |
| December | 13 |
| Sh. | |
| Average total debtors outstanding | 48,000 |
| Raw materials consumption | 440,000 |
| Total production cost | 1,000,000 |
| Total cost of sales | 1,050,000 |
| Sales for the year | 1,600,000 |
| Value of average stock maintained: | |
| Raw material | 32,000 |
| Work in progress | 35,000 |
| Finished goods | 26,000 |
| Number of days in a year | 365 |
| Average period of credit allowed to suppliers | 16 days |
| Statement of financial position | ||
| 2014 | 2013 | |
| Assets: | Sh.million" | Sh.million" |
| Non-current assets | 1,850 | 1,650 |
| Depreciation | (350) | (225) |
| Net non-current assets | 1,500 | 1,425 |
| Intangible assets | 150 | 150 |
| Current assets | ||
| Inventory | 330 | 230 |
| Accounts receivable | 220 | 170 |
| Cash | 100 | 90 |
| Total current assets | 650 | 490 |
| Total assets | 2,300 | 2,065 |
| Equity and liabilities: | ||
| Ordinary share capital (Sh.2 par value 100 million shares issued) | 200 | 200 |
| Additional paid in ordinary share capital | 325 | 325 |
| Retained earnings | 550 | 470 |
| Ordinary shareholders' equity | 1,075 | 995 |
| Preference share capital (10%, Sh.100 par value) | 150 | 150 |
| Long-term liabilities: | ||
| Long-term debt | 625 | 540 |
| Deferred tax | 100 | 80 |
| Total long-term liabilities | 725 | 620 |
| Current liabilities: | ||
| Accounts payable | 85 | 105 |
| Accruals | 65 | 85 |
| Current portion of long-term debt | 75 | - |
| Short-term bank notes | 125 | 110 |
| Total current liabilities | 250 | 300 |
| Total equity and liabilities | 2,300 | 2,065 |
| Statement of comprehensive income | ||
| 2014 Sh."million" | 2013 Sh."million" | |
| Net sales | 3,500 | 2.990 |
| Cost of goods sold | 2,135 | 1,823 |
| Selling. general and administrative expenses | 1,107 | 974 |
| Operating profit | 258 | 193 |
| Net interest expense | 74 | 64 |
| Income from operations | 184 | 129 |
| Income taxes | 55 | 38 |
| Net income | 129 | 91 |
| Preference dividends | 15 | 15 |
| Net income available for ordinary shareholders | 114 | 76 |
| Dividends deciared | 40 | 30 |