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 澳洲幸运5官方开奖结果体彩网:current assets or by swapping one 🎀current liabilit🍌y for another one.

Calculating Current Liabilities in Excel

Say company ABC has cu🦹rrent liabilities that include the following:

$\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," "澳洲幸运5官方开奖结果体彩网: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 m🎉ultiple yea✤rs and compare whether the company's liabilities have been increasing or decreasing.