Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Fundamental analysisOthers

Change In Working Capital (How To Interpret And Calculate) In Excel With Marketxls

Written by admin
Sat Jul 29 2017
working capital multiple companies
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
working capital multiple companies

What is working Capital and how to calculate it in Excel with MarketXLS

Analysts and investors will frequently refer to something called the net working capital. Or a lot of times they will just call it working capital for short. So working capital is very simple it’s like the current assets minus the current liabilities of a firm. When valuing the companies the “change in working capital” is more useful.

Working capital is not mandatory to be put inside the financial statements. It is the measure of the liquidity of the firm and it gives us ideas about how well a company can meet its current obligations.

Let’s take a real life example of a company and see how we would calculate working capital with the inbuilt functions provided by MarketXLS. MarketXLS has functions available for both current assets and current liabilities. So all that you will need to do is use the current assets and current liabilities functions and subtract them like shown below.

The current liabilities are some kind of gauge that we have to understand the firms near future obligations and if with the current assets the company will be able to meet those obligations. Essentially, working capital gives us an indication of how liquid is a firm.

Current assets are elements like the cash, accounts receivables, inventory. The current liabilities are the element like accounts payable, accrued income taxes etc. Now with market XLS because you already have the current assets and the current liabilities functions, you do not need to worry about the individual components of those elements.

Let’s use MarketXLS to calculate working capital of Apple Inc. from 2011 to 2016. And to do that we will have that year number in one column and we will simply refer to that column when calculating the current assets and the current liabilities.

Instead of using the current assets and the current liabilities functions you can also use the working capital function instead.

working capital function

With working capital functions of MarketXLS you can quickly calculate working capital of multiple companies in an easy way. So, you can get to the analysis and interpretation of the numbers. Below, I have calculated the working capital of various companies using this formula.

working capital multiple companies

Now that we have the numbers let’s try and see what do they mean.

How to interpret working CapitalIf the working capital is increasing we can conclude that the company is getting more and more liquid. Which could mean a lot of things, mainly, it could mean that the company is able to utilize its existing resources in a better way to generate more revenue and accumulate more cash flow from operations.

You might be wondering why some companies have negative working capital and some positive. A simple explanation for this is that the companies who buy inventory before they sell products have negative working capital. So, Walmart, needs to buy inventory before they sell the products in stores. What it means is that Walmart would have more current liabilities and less current assets because they would pay their vendors much earlier than when they can charge their customers.

So, in general, you would see that software companies would have positive working capital because they don’t have to buy the inventory before they could sell the product to the end customer. Which means that they immediately get revenue without accumulating current liabilities.

So what does it mean when a company has negative working capital? And how do you calculate the change in working capitalIf a company have the consistent negative working capital numbers it may mean that this company may need external funding to grow. Their working capital is not contributing to the immediate cash flow so if they were to invest in growth they would need some money from outside the company to invest.

We should also look at what percent of revenue is the working capital. If working capital is a very small proportion of revenue, then our conclusion above may not hold.

In the case of Walmart, working capital is less than 1% of their revenue. So our interpretation above may not hold true for Walmart.

working capital walmart

Almost all the time working capital is an indication of its daily operations. But sometimes it also suggests financial problems especially when working capital is a large proportion of the revenue.Change in working capitalJust looking at working capital numbers does not give us a complete picture of the operational health of a company. To get a real understanding of the company’s operational efficiency we need to look at “change in working capital”.

change in working capital

Changing working capital does mean actual change in value year over year. But it means the change current assets minus the change current liabilities. The change in working capital value gives a real indication on why the working capital has increased or decreased. If current assets have remained same but the current liabilities have increased it means a negative change in working capital.

When valuing companies the change in working capital value is a more telling figure than the working capital itself. The change in the working capital will have a direct impact on the cash flow from operations. And the cash-flow is the main factor we consider when valuing a company.

Any increase in revenue will also generally show an increase in working capital. This is specifically true for the companies where the working capital is a big proportion of the revenue, unlike Walmart.

With MarketXLS you can do all these calculations and ratios very easily with the historical fundamental functions as described. If you have done any analysis on working capital and would like to share your knowledge please contact us.

Sources :WikipediaInvestopedia

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

Optionable: Yes
Market Cap: 451 M
Industry: Capital Markets
52 week range    
Midland States Bancorp Inc. logo

Midland States Bancorp Inc.

Optionable: No
Market Cap: 589 M
Industry: Banks - Regional - US
52 week range    
Kroger Company (The) logo

Kroger Company (The)

Optionable: Yes
Market Cap: 35,325 M
Industry: Grocery Stores
52 week range    
Ingles Markets Incorporated Class A Common Stock logo

Ingles Markets Incorporated Class A Common Stock

Optionable: Yes
Market Cap: 1,910 M
Industry: Grocery Stores
52 week range    
Amdocs Limited logo

Amdocs Limited

Optionable: Yes
Market Cap: 10,525 M
Industry: Software - Infrastructure
52 week range    
Tecnoglass Inc. logo

Tecnoglass Inc.

Optionable: Yes
Market Cap: 1,349 M
Industry: Building Materials
52 week range    
Interpublic Group of Companies Inc. (The) logo

Interpublic Group of Companies Inc. (The)

Optionable: Yes
Market Cap: 13,330 M
Industry: Advertising Agencies
52 week range    
Guess? Inc. logo

Guess? Inc.

Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
Bristol-Myers Squibb Company logo

Bristol-Myers Squibb Company

Optionable: Yes
Market Cap: 168,030 M
Industry: Drug Manufacturers - Major
52 week range    
Best Buy Co. Inc. logo

Best Buy Co. Inc.

Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    

More Features