A:

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

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 A7 as "Total Current Liabilities," select cell B7 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.

(For related reading, see "Current Liability Basics.")

RELATED FAQS
  1. What are some examples of current liabilities?

    Look at some common examples of current liabilities a company may owe within a year or less in order to accurately assess ... Read Answer >>
  2. Are accounts payable an expense?

    Learn about how to differentiate between liability accounts and expense accounts, and see why accounts payable is considered ... Read Answer >>
  3. Can working capital be negative?

    Negative working capital can arise under certain circumstances. Working capital can be negative if a company's current assets ... Read Answer >>
  4. Do banks have working capital?

    Learn the reasons why banks do not have working capital due to the lack of typical current assets and liabilities accounts, ... Read Answer >>
  5. What items on the balance sheet are most important in fundamental analysis?

    Read about which balance sheet items are considered most important for fundamental analysis, including cash, current liabilities ... Read Answer >>
  6. What are working capital costs?

    Discover the costs included in working capital, and learn how to use working capital as an indicator of a company's ability ... Read Answer >>
Related Articles
  1. Investing

    How to calculate the current ratio in Excel

    Understand the basics of the current ratio, including its use in assessing a company's liquidity and learn how it is calculated in Microsoft Excel.
  2. Investing

    Examples Of Asset/Liability Management

    In its simplest form, asset/liability management entails managing assets and cash inflows to satisfy various obligations; however, it's rarely that simple.
  3. Investing

    Understanding Coca-Cola's Capital Structure (KO)

    Since the crisis of 2008 and the implementation of an accommodative monetary policy by the Fed, Coca-Cola's capital structure has significantly shifted.
  4. Investing

    Liquidity Measurement Ratios

    Learn about the current ratio, quick ratio, cash ratio and cash conversion cycle.
  5. Insurance

    An Advisor's Guide to Prof. Liability Insurance

    A guide to what financial advisors need to know about professional liability insurance.
  6. Investing

    Understanding The Federal Reserve Balance Sheet

    We are all connected to the Fed's balance sheet, and the currency notes that we hold are its liabilities.
  7. Investing

    Evaluating a Company's Capital Structure

    Learn to use the composition of debt and equity to evaluate balance sheet strength.
RELATED TERMS
  1. Liability

    A liability is defined as a company's legal financial debts or ...
  2. Total Liabilities

    Total liabilities are the aggregate of all debts an individual ...
  3. Accrued Liability

    An accrued liability is an accounting term for an expense that ...
  4. Long-Term Liabilities

    In accounting, long-term liabilities are financial obligations ...
  5. Other Long-Term Liabilities

    Other long-term liabilities are a balance sheet item that lumps ...
  6. Balance Sheet

    A balance sheet reports a company's assets, liabilities and shareholders' ...
Trading Center