Comment on the results of the shown cash budget prepared below, and suggest possible strategies the company must put in place to improve its cash position in the light of the plans to source a loan. Cash Budget Particular January February March April May June Opening Balance of Cash 1500000 1000000 -1250000 -15000000 -19237500 -3300000 Add: Receipt from Customer 15000000 15000000 16500000 20250000 25500000 29400000 Add: Sale of Freehold Premises 25000000 Total Cash available (A) 16500000 16000000 15250000 5250000 31262500 26100000 Less: Outflow of cash Material 5000000 6250000 7500000 10000000 9500000 11000000 Labor 8000000 8000000 8750000 10687500 9562500 9000000 Overhead 2500000 3000000 4000000 3800000 5500000 4400000 Purchase of new printing press 0 0 0 0 10000000 0 Corporation Tax due for Payment 0 0 10000000 0 0 0 Total Outflow of Cash (B) 15500000 17250000 30250000 24487500 34562500 24400000 Closing Cash (A-B) 1000000 -1250000 -15000000 -19237500 -3300000 1700000
Comment on the results of the shown
Cash Budget
Particular |
January |
February |
March |
April |
May |
June |
Opening Balance of Cash |
1500000 |
1000000 |
-1250000 |
-15000000 |
-19237500 |
-3300000 |
Add: Receipt from Customer |
15000000 |
15000000 |
16500000 |
20250000 |
25500000 |
29400000 |
Add: Sale of Freehold Premises |
|
|
|
|
25000000 |
|
Total Cash available (A) |
16500000 |
16000000 |
15250000 |
5250000 |
31262500 |
26100000 |
Less: Outflow of cash |
|
|
|
|
|
|
Material |
5000000 |
6250000 |
7500000 |
10000000 |
9500000 |
11000000 |
Labor |
8000000 |
8000000 |
8750000 |
10687500 |
9562500 |
9000000 |
Overhead |
2500000 |
3000000 |
4000000 |
3800000 |
5500000 |
4400000 |
Purchase of new printing press |
0 |
0 |
0 |
0 |
10000000 |
0 |
Corporation Tax due for Payment |
0 |
0 |
10000000 |
0 |
0 |
0 |
Total Outflow of Cash (B) |
15500000 |
17250000 |
30250000 |
24487500 |
34562500 |
24400000 |
Closing Cash (A-B) |
1000000 |
-1250000 |
-15000000 |
-19237500 |
-3300000 |
1700000 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps