Hi! i came upon this question and i'm not entirely sure how to answer this
Mainly part a)
Hey!
So basically part a) is asking you to identity when the business falls into debt.
We start in January where we need to find the closing cash balance for that month. This means we need to identity the opening cash balance, cash inflows and cash outflows. Once we have identified this we can use the formula
Opening balance + cash inflows - cash outflows = closing balanceSo for January, the
opening cash balance is
$4000.
The cash inflows are
cash sales and receipts from debtors which add to
$30000The cash outflows
include wages, cash purchases, payment to creditors, electricity and annual insurance which add to
$22000(Note: where electricity and insurance are blank it means there were no payments for that month)
We can now sub these figures into the formula
$4000 + $30000 - $22000 = $12000
Therefore the
closing cash balance for January is $12000Remember that the closing cash balance for one month is the opening cash balance for the next month, so
the closing balance for January is the opening balance for FebruaryNow, similarly with February we sub in the figures to the above formula.
$12000 + $31000 - $47000 = -$4000
Therefore the
closing balance for February is -$4000 Which is a negative balance.
This means
March will open with a negative balance. This question is worded a bit odd but I assume they mean which is the first month with a negative opening balance, so
I would answer March, but I may be wrong though.
For part b) they are just asking you to make a judgement on the effectiveness of cash flow management strategies in this situation. You could choose to explore:
distribution of payments, discounts for early payments or factoring. I hope this helped a bit!