In corporate valuation as in corporate accounting, numerous metrics are used to assess the worth of a business and its ability to generate profit while meeting its financial obligations. One of the simplest ways to evaluate the financial fitness of a company is to calculate its net debt. Net debt is calculated by adding up all of a company's short- and long-term liabilities and subtracting its current assets. This figure reflects a company's ability to meet all of its obligations simultaneously using only those assets that are easily liquidated.

Short-term liabilities are those debts that must be paid within one year. Typically, these consist of items such as accounts payable and bills for supplies and operating costs. Long-term liabilities are repaid over the course of a longer period, such as mortgages, loans and capital leases. Current assets refers to the amount of money a company has readily available to pay off debts. Therefore, current assets include only cash or cash equivalents, such as stocks, marketable securities, accounts receivable and other liquid assets. All the information necessary to calculate net debt is readily available on a company's balance sheet.

To calculate net debt using Microsoft Excel, examine the balance sheet to find the following information: total short-term liabilities, total long-term liabilities and total current assets. Enter these three items into cells A1 through A3. In cell A4, enter the formula "=A1+A2-A3" to render the net debt.

For example, assume company ABC has short-term liabilities consisting of $10,000 in operating costs and $30,000 in accounts payable. Its long-term liabilities consist of a $100,000 bank loan and a lease for a $25,000 piece of equipment. Its current assets consist of $75,000 in cash and $150,000 in marketable assets. The balance sheet lists the subtotals for these three categories as $40,000, $125,000 and $225,000, respectively. Using Excel, the business accountant determines that the net debt is $40,000 + $125,000 - $225,000, or -$60,000, indicating that the business has more than enough funds to pay off all its liabilities if they all became due concurrently.

  1. How do you calculate working capital?

    The formula for calculating working capital is straightforward, but lends great insight into the short-term financial health ... Read Answer >>
  2. Does the balance sheet always balance?

    Yes, a balance sheet should always balance. The name "balance sheet" is based on the fact that total assets will equal the ... Read Answer >>
  3. What is the formula for calculating the current ratio?

    Find out what makes up the current ratio, how to calculate it, and what the result can tell you about a potential investment. Read Answer >>
  4. What does high working capital say about a company's financial prospects?

    Learn about net working capital and what a high figure indicates about a company's financial prospects, including the importance ... Read Answer >>
  5. What is the Short/Current Long-Term Debt Account?

    A balance sheet account showing short/current long-term debt can cause a lot of confusion. Read Answer >>
Related Articles
  1. Personal Finance

    How To Improve Net Worth By Decreasing Liabilities

    Here's an analysis of how to adjust liabilities and assets to improve net worth.
  2. Investing

    Evaluating a Company's Capital Structure

    Learn to use the composition of debt and equity to evaluate balance sheet strength.
  3. Investing

    Breaking Down The Balance Sheet

    Knowing what the company's financial statements mean will help you to analyze your investments.
  4. Investing

    Evaluating Your Personal Financial Statement

    Determine your net worth by making your own cash flow statement and balance sheet.
  5. Investing

    Financial Analysis: Solvency vs. Liquidity Ratios

    Solvency and liquidity are equally important for a company's financial health.
  1. Net Debt

    Net debt is a metric that shows a company's overall debt situation ...
  2. Balance Sheet

    A balance sheet reports a company's assets, liabilities and shareholders' ...
  3. Current Liabilities

    Current liabilities are a company's debts or obligations that ...
  4. Other Current Liabilities

    Other current liabilities are obligations coming due in the next ...
  5. Current Assets

    Current assets is a balance sheet item that represents the value ...
  6. Adjusted Liabilities

    Adjusted liabilities are used in the insurance industry to show ...
Hot Definitions
  1. Yield Curve

    A yield curve is a line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but ...
  2. Portfolio

    A portfolio is a grouping of financial assets such as stocks, bonds and cash equivalents, also their mutual, exchange-traded ...
  3. Gross Profit

    Gross profit is the profit a company makes after deducting the costs of making and selling its products, or the costs of ...
  4. Diversification

    Diversification is the strategy of investing in a variety of securities in order to lower the risk involved with putting ...
  5. Intrinsic Value

    Intrinsic value is the perceived or calculated value of a company, including tangible and intangible factors, and may differ ...
  6. Current Assets

    Current assets is a balance sheet item that represents the value of all assets that can reasonably expected to be converted ...
Trading Center