# What is Working Capital and How to Calculate

3
8358

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. This list includes items such as:

• Costs with raw material and labor (direct and indirect);
• Marketing;
• Equipments;
• Loans;
• 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 lacks the cash you get 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 often because 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 a 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 in a faster and easier way!

previous articleHow to Conduct an Organizational Climate Survey
Administrator and turismologist, passionate about the possibilities that Excel gives to managers, entrepreneurs and students. He is the managing partner of the spreadsheet department at LUZ - Spreadsheets (luz.vc) and is responsible for the development of spreadsheets with business and personal focus commercialized in its website. He also teaches online Excel courses (cursos.luz.vc) and likes to help thousands of planners through the LUZ Forum and Blog.