What Is the Formula for Calculating Working Capital in Excel?

Working capital is used in fundamental analysis to determine a company's short-term financial health and efficiency. A company's working capital is calculated by subtracting its current liabilities from its current assets.

Example Illustrating the Working Capital Formula in Excel

To compare the efficiency and short-term financial health of Meta Platforms Inc. (formerly Facebook) and Twitter Inc., look at the respective companies' balance sheets. For the period ending Dec. 31, 2017, Facebook had total current assets of $48.56 billion and total current liabilities of $3.76 billion. For that same period, Twitter had total current assets of $5.32 billion and total current liabilities of $583.28 million.

In Excel, right-click on columns A, B and C, and left-click on Column Width. Change the value to 28 for each respective column. Then, click OK. Enter "Meta" into cell B1 and "Twitter" into cell C1.

Next, enter "Total Current Assets" into cell A2, "Total Current Liabilities" into cell A3 and "Working Capital" into cell A4.

Enter "=48.56" into cell B2 and "=3.76" into cell B3. The working capital of Meta is calculated by entering the formula "=B2-B3" into cell B4. Meta's resulting working capital is $44.8 billion.

Next, enter "=5.32" into cell C2 and "=.583" into cell C3. Twitter's working capital is calculated by entering the formula "=C2-C3" into cell C4. Twitter's resulting working capital is $4.74 billion.

Since the current assets of Meta exceed its current liabilities, it is unlikely that Meta will have trouble paying back its creditors in the short-term. Similarly, Twitter is likely to pay back its creditors in the short-term.

Article Sources
Investopedia requires writers to use primary sources to support their work. These include white papers, government data, original reporting, and interviews with industry experts. We also reference original research from other reputable publishers where appropriate. You can learn more about the standards we follow in producing accurate, unbiased content in our editorial policy.
  1. U.S. Securities and Exchange Commission. "Facebook Inc. 2017 Form 10-K," Page 58. Accessed Dec. 8, 2021.

  2. U.S. Securities and Exchange Commission. "Twitter Inc. 2017 Form 10-K," Page 72. Accessed Dec. 8, 2021.

Take the Next Step to Invest
×
The offers that appear in this table are from partnerships from which Investopedia receives compensation. This compensation may impact how and where listings appear. Investopedia does not include all offers available in the marketplace.
Service
Name
Description