How Do I Calculate Current Liabilities in Excel?

Current liabilities are debt obligations due within one year. Some examples of current liabilities that appear on the balance sheet include accounts payable, payroll liabilities, accrued expenses, short-term notes payable, income taxes and interest payable, accrued interest, payroll taxes, utilities, rental fees, and other debts. They can be settled with current assets or by swapping one current liability for another one.

Calculating Current Liabilities in Excel

Say company ABC has current liabilities that include the following:

Accounts Payable $ 38 , 000 Accrued Wages $ 90 , 000 Accrued Expenses $ 67 , 000 Rental Fees $ 240 , 000 Loans $ 50 , 000 Other Debts $ 56 , 000 \begin{aligned} &\text{Accounts Payable}-\$38,000\\ &\text{Accrued Wages}-\$90,000\\ &\text{Accrued Expenses}-\$67,000\\ &\text{Rental Fees}-\$240,000\\ &\text{Loans}-\$50,000\\ &\text{Other Debts}-\$56,000 \end{aligned} Accounts Payable$38,000Accrued Wages$90,000Accrued Expenses$67,000Rental Fees$240,000Loans$50,000Other Debts$56,000

Type "Current Liabilities" in cell A1, then "Accounts Payable," "Accrued Wages," "Accrued Expenses," "Rental Fees," "Loans," and "Other Debts" in the cells A2-A7. In cell B1, enter the year for which you are calculating the total current liabilities. Enter the dollar amounts in column B next to their category (38,000 in B2, 90,000 in B3, etc.).

To calculate the amount of total current liabilities, label cell A8 as "Total Current Liabilities," select cell B8 and enter "=SUM(B2:B7)" into the formula bar. This will add up the current liabilities listed and give you the total amount for that year.

You can do this for multiple years and compare whether the company's liabilities have been increasing or decreasing.

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. Accounting Tools. "Current Liability Definition."

  2. Microsoft. "Microsoft 365 Support: Excel: Use Calculated Columns in an Excel Table."

Open a New Bank Account
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.