What is it: working capital is nothing more than the amount of money your business needs to keep running. But how to calculate this amount? Do not worry. There are management tools to facilitate the day to day life of small business owners.
How to: if you just do a working capital calculation from time to time (subtracting operating costs from profit), you will end up with results that are always different. By using a spreadsheet, you will know more clearly how much money you should continue as working capital so that your business stays healthy. The following calculation is called the operational cycle.
Basically, you should take into account every month of the year the company is operating and the average value of what you have in stock, if any.
Then you need to list all accounts receivable. Any and all payments must be included, month by month, including the number of installments in which it will be made.
The next step is to list all accounts payable. This calculation should include the total values and number of installments of any debt that the company has in the year to be calculated. In this list enter items such as:
- Rental of headquarters;
- Costs with raw material and labor (direct and indirect);
- Legal expenses;
- Office supplies and cleaning;
- Water, electricity, telephone (average), internet and insurance.
Anything that can withdraw money from the company should be listed. Lastly, what is missing from the money that comes in to cover expenses is the required working capital corresponding to the purple line in the example chart.
Most companies can not finance the operating cycle alone. In this case, working capital financing is required. This is because often companies need short-term working capital at some point in their operations. For example: make the stock of Christmas in September when sales are still low.
To find out if your company will be able to walk on its own legs or need working capital financing, it is essential to do the calculation that we show here. If you prefer, use the Sheet Cash Flow that LUZ has prepared and obtain this result faster and easier!