You are presented with the following forecasted cash flow data for your organisation for the period November 2020 to June 2021. 2020 Nov GH¢ 2020 Dec GH¢ 2021 Jan GH¢ 2021 Feb GH¢ 2021 Mar GH¢ 2021 Apr GH¢ 2021 May GH¢ 2021 June GH¢ Sales 80,000 100,000 110,000 130,000 140,000 150,000 160,000 180,000 Purchases 40,000 60,000 80,000 90,000 110,000 130,000 140,000 150,000 Wages 10,000 12,000 6,000 20,000 24,000 28,000 32,000 36,000 Overheads 10,000 10,000 15,000 15,000 15,000 20,000 20,000 20,000 Dividends Capital expenditure 20,000 30,000 40,000 You are also told the following: 1. Sales are 40% cash 60% credit. Credit sales are paid two months after the month of sale. 2. Purchases are paid the month following purchase. 3. 75% of wages are paid the month after they are declared. 4. Overhead are paid the month after they are incurred. 5. Dividends are paid three months after they are declared. 6. Capital expenditure is paid two months after it is incurred. 7. The opening cash balance is GH¢ 15,000. The managing director is pleased with the above figures as they show sales will have increased by more than 100% in the period under review. In order to achieve this he has arranged a bank overdraft with a ceiling of GH¢50,000 to accommodate the increased inventory levels and wage bill for overtime worked. Required a) Prepare a cash flow forecast for the six-month period January to June b) Comment on your results in the light of the managing director’s comments and offer advice.
You are presented with the following forecasted
|
2020 Nov GH¢ |
2020 Dec GH¢ |
2021 Jan GH¢ |
2021 Feb GH¢ |
2021 Mar GH¢ |
2021 Apr GH¢ |
2021 May GH¢ |
2021 June GH¢ |
|
|
Sales |
80,000 |
100,000 |
110,000 |
130,000 |
140,000 |
150,000 |
160,000 |
180,000 |
|
Purchases |
40,000 |
60,000 |
80,000 |
90,000 |
110,000 |
130,000 |
140,000 |
150,000 |
|
Wages |
10,000 |
12,000 |
6,000 |
20,000 |
24,000 |
28,000 |
32,000 |
36,000 |
|
|
10,000 |
10,000 |
15,000 |
15,000 |
15,000 |
20,000 |
20,000 |
20,000 |
|
Dividends Capital expenditure |
|
20,000 |
|
30,000 |
|
|
|
40,000 |
You are also told the following:
1. Sales are 40% cash 60% credit. Credit sales are paid two months after the month of sale.
2. Purchases are paid the month following purchase.
3. 75% of wages are paid the month after they are declared.
4. Overhead are paid the month after they are incurred.
5. Dividends are paid three months after they are declared.
6. Capital expenditure is paid two months after it is incurred.
7. The opening cash balance is GH¢ 15,000.
The managing director is pleased with the above figures as they show sales will have increased by more than 100% in the period under review. In order to achieve this he has arranged a bank overdraft with a ceiling of GH¢50,000 to accommodate the increased inventory levels and wage bill for overtime worked.
Required
a) Prepare a cash flow
b) Comment on your results in the light of the managing director’s comments and offer advice.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
