Working Capital Template

Written by CFI Team

Published April 4, 2018

Read Time 1 minutes

Working Capital Template

This working capital template allows you to calculate working capital using the following formula:

Working Capital = Current Assets – Current Liabilities

Here is what the template looks like:

Working Capital Template Screenshot

Download the Free Working Capital Template

Click the button below to download our free Working Capital template!

Working capital is the difference between a company’s current assets and current liabilities. It is a financial measure that calculates whether a company has enough liquid assets to pay its bills that will be due in a year. When a company has excess current assets, that amount can then be used to spend on its day-to-day operations.

Current assets, such as cash and equivalents, inventory, accounts receivable, and marketable securities, are resources a company owns that can be used up or converted into cash within a year.

Current liabilities are the amount of money a company owes, such as accounts payable, short-term loans, and accrued expenses, which are due for payment within a year.

Connect what you just learned to a clear career path with CFI’s role‑based courses and certification programs.

Advance Your Career

Additional Resources

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

See all Excel resources

See all Financial Modeling resources