Financial ratio analysis and the DuPont framework

Key takeaways

• Margins measure how much of each sales dollar survives each layer of cost; returns measure profit against the capital used to produce it.
• Return ratios should use average balances over the period, because profit is earned over the period while balance sheets are snapshots.
• ROIC uses after-tax operating profit (NOPAT) over debt plus equity less cash, so it measures the business independently of how it is financed.
• Liquidity ratios test short-term obligations, leverage ratios test the size of debt, and coverage ratios test whether earnings can service it.
• Three-step DuPont splits ROE into net margin, asset turnover and the equity multiplier; five-step further separates tax burden, interest burden and operating margin.
• Two companies with the same ROE can have opposite risk profiles, one earning it on margin and the other on leverage, which only the decomposition reveals.

Ground rules and the example company

Three rules make ratios useful rather than misleading. First, compare like with like: the same definition across years and across companies, and the same accounting framework where possible. Second, when a ratio divides a flow from the income statement by a stock from the balance sheet, use the average of the opening and closing balances, because the profit was earned across the whole year. Analysts often use year-end balances for speed; that is acceptable if it is done consistently and the balance sheet did not change sharply. Third, a ratio is a question, not an answer. A falling current ratio could mean a liquidity problem or a deliberate reduction in idle cash.

Every ratio in this topic is computed for Granite Tools, a hypothetical maker of industrial hand tools, from the statements below. Figures are in $m, the tax rate is 25 percent, and cash taxes equal tax expense. Granite pays $30m a year in operating lease cost, included in SG&A under ASC 842. It spent $50m on capex, and $30m of its debt is scheduled for repayment within the year, shown as current debt.

Profitability: margins

Margins express each level of profit as a share of revenue. Gross margin reflects pricing power and production cost. EBITDA margin adds the cost of running the organization, excluding D&A. Operating margin includes D&A, so it reflects the cost of the asset base. Net margin includes financing cost and tax, so it is affected by capital structure and jurisdiction as well as operations.

Read the margins as a cascade. If gross margin is stable but operating margin falls, the pressure is in overhead or depreciation, not in pricing. If net margin falls while operating margin holds, look at interest and tax. For cross-company comparison, gross and EBITDA margins are the most comparable in principle, but only if both companies classify costs the same way between COGS and SG&A, which they often do not.

Returns: ROA, ROE and ROIC

Return on assets (ROA) compares net income with the total assets used to earn it. It is a broad measure, but it mixes an after-financing profit with a pre-financing asset base. Some analysts add after-tax interest back to the numerator for that reason; state the definition used.

Return on equity (ROE) compares net income with shareholders' equity. It is the return shareholders earn on the book value of their investment, and it rises with leverage: borrowing replaces equity in the denominator, so as long as the business earns more on its assets than the after-tax cost of debt, ROE goes up. That is why a high ROE is not in itself evidence of a good business.

Return on invested capital (ROIC) removes the financing effect. The numerator is NOPAT, net operating profit after tax, which is EBIT taxed as if the company had no debt. The denominator is invested capital, the debt and equity funding the operating business, less cash that is not needed to run it. Comparing ROIC with the weighted average cost of capital is the most direct test of whether a business creates value. Definitions vary: some deduct only excess cash, some include lease liabilities, and European reports often use return on capital employed (ROCE), EBIT divided by total assets less current liabilities.

Liquidity

Liquidity ratios test whether a company can meet obligations falling due within a year from assets that will turn into cash within a year. The current ratio uses all current assets. The quick ratio, also called the acid test, excludes inventory and prepaid expenses, which cannot quickly be turned into cash to pay a bill. The cash ratio keeps only cash and marketable securities.

No single level is right. A grocer that sells inventory for cash before it pays suppliers can run safely with a current ratio below 1.0, because its working capital cycle generates cash. A manufacturer with slow-moving inventory may need a much higher ratio. Lenders look at the trend and at the composition: a current ratio that holds steady while cash falls and receivables rise is weaker than it looks.

Leverage and coverage

Leverage ratios measure how much debt the company carries. Debt to equity compares debt with book equity, which is simple but depends on historical accounting values; in a buyout, book equity can be small or negative after large dividends. Net debt to EBITDA compares debt, less cash, with annual earnings capacity, and it is the ratio lenders and sponsors use most. It is read as the number of years of EBITDA needed to repay net debt, ignoring every other use of cash.

Coverage ratios measure whether earnings can service the obligations. Interest coverage divides EBIT, or EBITDA, by interest expense. Fixed charge coverage widens the obligations to include other fixed commitments. The textbook version adds lease payments to both sides. Credit agreements usually define a cash-based version instead: EBITDA less capex and cash taxes, divided by interest plus scheduled principal repayments. The two can differ by a wide margin, so always state which one is meant.

Efficiency

Efficiency ratios, also called activity ratios, measure how hard the company works its assets. Asset turnover is revenue divided by average total assets: how many dollars of sales each dollar of assets generates. Capital-light businesses such as distributors turn their assets many times a year; utilities and infrastructure turn them slowly.

Inventory turnover divides cost of goods sold by average inventory. COGS is used rather than revenue because inventory is carried at cost. Dividing 365 by the turnover gives days inventory outstanding, the average number of days goods sit before being sold. Receivables and payables turnover work the same way and together form the cash conversion cycle, covered in the working capital topic.

Three-step DuPont

The DuPont framework, named after the company whose finance staff popularized it, rewrites ROE as a product of three ratios. Net margin measures how much profit each dollar of sales produces. Asset turnover measures how many dollars of sales each dollar of assets produces. The equity multiplier, average assets divided by average equity, measures how many dollars of assets each dollar of equity supports, which is a measure of leverage. Multiplying the three cancels revenue and assets and leaves net income over equity.

The value is diagnostic. If ROE rises, the decomposition shows whether the business became more profitable, used its assets more intensively, or simply borrowed more. Only the first two are operating improvements.

Five-step DuPont and comparing companies

The five-step version splits net margin into three parts. The tax burden, net income over pretax income, is the share of pretax profit the company keeps after tax. The interest burden, pretax income over EBIT, is the share of operating profit left after interest. The operating margin, EBIT over revenue, is profitability before financing and tax. Multiplying the three gives back net margin.

The finer split matters because leverage now appears twice with opposite effects. More debt raises the equity multiplier but lowers the interest burden ratio, as interest consumes more of EBIT. The five-step view shows whether added leverage is still accretive to ROE, and it isolates operating margin, the part management controls most directly.