Tutorials › VEE Accounting and Finance › Worked Case in Profitability and Efficiency Analysis

VEE Accounting and Finance · Profitability and Efficiency · Tutorial 272 of 996

Worked Case in Profitability and Efficiency Analysis

Learn to calculate a consistent set of margins, return ratios, and turnover measures from financial statements, and interpret what the results say about operating performance.

Intermediate 12 min read

What You'll Learn

  • Calculate gross, operating, and net profit margins from an income statement.
  • Match period earnings with average assets and average book equity.
  • Compute return on assets, return on equity, and total asset turnover.
  • Apply DuPont relationships to connect margins, turnover, and returns.
  • Calculate inventory, receivables, and fixed-asset turnover in context.
  • Explain how different operating drivers can produce similar returns.

Reading a Compact Set of Financial Statements

Profitability and efficiency ratios turn accounting statements into measures of performance. A margin describes earnings relative to sales; a return ratio relates earnings to the resources used to generate them; and a turnover ratio describes sales or activity relative to an asset balance. The ratios are most useful when they are calculated consistently and then interpreted together.

The worked cases use hypothetical companies and report amounts in thousands of dollars. For ratios that combine a period flow, such as annual sales or net income, with a balance-sheet amount, use the average of the beginning and ending balance when both are available. This aligns a full period of activity with the resources employed during that period.

Definitions: Gross profit margin is gross profit divided by net sales. Operating profit margin is operating income divided by net sales. Net profit margin is net income divided by net sales. Return on assets (ROA), as used here, is net income divided by average total assets. Return on equity (ROE) is net income divided by average book equity. Total asset turnover is net sales divided by average total assets.

These definitions use net income consistently for ROA and ROE. If a question specifies a different earnings numerator, such as operating income, use that stated measure and do not combine it with formulas that assume net income. A turnover ratio also needs an appropriate denominator: inventory turnover uses average inventory, receivables turnover uses average receivables, and fixed-asset turnover uses average net fixed assets.

Worked Case: Margins, Returns, and Turnover

The first case begins with the income statement, then uses balance-sheet averages to calculate returns and operating efficiency. The point is not just to produce ratios; it is to connect each one to the statements and interpret the pattern.

Worked Example: A Full-Year Operating Review

A hypothetical distributor reports the following results for 2025, with all amounts in thousands of dollars. Its beginning and ending total assets are $900 and $1,100, and its beginning and ending book equity are $400 and $500. Inventory is $120 at the beginning and $180 at the end. Receivables are $100 and $140, respectively. Net fixed assets are $500 and $600. Assume all sales are credit sales. Calculate the principal margins, ROA, ROE, total asset turnover, and selected operating turnover ratios.

Method. Calculate income-statement margins from 2025 flows. Next, average each beginning and ending balance used in a return or turnover ratio. This avoids comparing a full year’s earnings or sales with only one date’s balance.

Step 1: Reconcile the earnings measures. Net sales are $1,200. Cost of goods sold is $720, so gross profit is \(1{,}200-720=480\). Operating expenses are $300, so operating income is \(480-300=180\). After $30 of interest expense, pretax income is \(180-30=150\). Tax expense is $45, leaving net income of \(150-45=105\).

Step 2: Calculate margins. Gross profit margin is \(480/1{,}200=0.40\), or 40.00%. Operating profit margin is \(180/1{,}200=0.15\), or 15.00%. Net profit margin is \(105/1{,}200=0.0875\), or 8.75%. These measures use different earnings levels, so the gap between them reflects expenses deducted as the income statement moves from gross profit to net income.

Step 3: Average assets and equity. Average total assets are \((900+1{,}100)/2=1{,}000\). Average book equity is \((400+500)/2=450\). Thus ROA is \(105/1{,}000=0.105\), or 10.50%, and ROE is \(105/450=0.233333\ldots\), or 23.33% to two decimal places.

Step 4: Calculate turnover. Total asset turnover is \(1{,}200/1{,}000=\) 1.20 times. Average inventory is \((120+180)/2=150\), so inventory turnover is \(720/150=\) 4.80 times. Using 365 days, inventory days are \(365/4.80=76.0417\), or 76.04 days. Average receivables are \((100+140)/2=120\); because all sales are credit sales, receivables turnover is \(1{,}200/120=\) 10.00 times, and collection days are \(365/10=36.50\). Average net fixed assets are \((500+600)/2=550\), giving fixed-asset turnover of \(1{,}200/550=2.1818\), or 2.18 times.

Interpretation and check. The company earns $0.0875 of net income per dollar of sales and generates $1.20 of sales per dollar of average assets. The calculated ROA is 10.50%. Its ROE is higher, at 23.33%; the next section shows the identity connecting these measures. Turnover ratios are not self-explanatory grades: whether 4.80 inventory turns or 36.50 collection days are strong depends on the business and relevant comparisons.

Common mistake avoided. Dividing net income by ending assets would give \(105/1{,}100=9.55\%\), not the period ROA defined here. It mismatches a full year of earnings with a single year-end balance. The specified average-assets calculation is \(105/1{,}000=10.50\%\).

Why the DuPont Relationships Hold

DuPont analysis is useful because it expresses a return as a product of interpretable ratios. The identities follow by multiplying by a fraction equal to one; they are not additional assumptions about how a company operates. The calculations require consistent definitions, the same period, and nonzero sales and average balances.

$$ \text{ROA} = \frac{\text{Net income}}{\text{Average total assets}} = \left(\frac{\text{Net income}}{\text{Net sales}}\right) \left(\frac{\text{Net sales}}{\text{Average total assets}}\right) = \text{Net profit margin}\times\text{Total asset turnover}. $$

To verify the identity, cancel net sales in the product: the numerator remaining is net income and the denominator is average total assets. For ROE, multiply by average total assets divided by average total assets, then group the factors:

$$ \text{ROE} = \frac{\text{Net income}}{\text{Average book equity}} = \left(\frac{\text{Net income}}{\text{Net sales}}\right) \left(\frac{\text{Net sales}}{\text{Average total assets}}\right) \left(\frac{\text{Average total assets}}{\text{Average book equity}}\right). $$

The final factor, average total assets divided by average book equity, is the average equity multiplier. In the distributor case it is \(1{,}000/450=2.2222\ldots\). Using the exact, unrounded factors, the three-factor product is \((105/1{,}200)(1{,}200/1{,}000)(1{,}000/450)=105/450=23.3333\ldots\%\), matching ROE. The identity is an accounting decomposition, not by itself a judgment that a higher multiplier is desirable.

Comparing Operating Drivers

Two firms can reach similar returns through different combinations of margin and turnover. A firm with a larger profit per sales dollar may generate fewer sales per asset dollar; another may earn a smaller margin but use its assets to support more sales. A case analysis should calculate the components before making a claim about the overall result.

Worked Example: Two Firms With Different Operating Profiles

Two hypothetical retailers report the following annual figures, in thousands of dollars. Firm A has sales of $1,500, cost of goods sold of $1,050, operating expenses of $300, interest expense of $20, and tax expense of $40. Its average total assets are $1,000 and average book equity is $500. Firm B has sales of $900, cost of goods sold of $495, operating expenses of $270, interest expense of $15, and tax expense of $39. Its average total assets are $900 and average book equity is $450. Compare their margins, ROA, and ROE.

Firm A. Gross profit is \(1{,}500-1{,}050=450\), and operating income is \(450-300=150\). Pretax income is \(150-20=130\), so net income is \(130-40=90\). Gross profit margin is \(450/1{,}500=30.00\%\); operating profit margin is \(150/1{,}500=10.00\%\); and net profit margin is \(90/1{,}500=6.00\%\). Total asset turnover is \(1{,}500/1{,}000=1.50\) times. ROA is \(90/1{,}000=9.00\%\), and ROE is \(90/500=18.00\%\).

Firm B. Gross profit is \(900-495=405\), and operating income is \(405-270=135\). Pretax income is \(135-15=120\), so net income is \(120-39=81\). Gross profit margin is \(405/900=45.00\%\); operating profit margin is \(135/900=15.00\%\); and net profit margin is \(81/900=9.00\%\). Total asset turnover is \(900/900=1.00\) time. ROA is \(81/900=9.00\%\), and ROE is \(81/450=18.00\%\).

Interpretation and check. Firm B’s net profit margin is higher, but its asset turnover is lower. The ROA products are \(6.00\%\times1.50=9.00\%\) for A and \(9.00\%\times1.00=9.00\%\) for B. Both firms also have an average equity multiplier of 2.00, so their ROEs are \(9.00\%\times2.00=18.00\%\). The identities agree with the directly calculated returns. This comparison describes the arithmetic; it does not establish why the operating profiles differ or which business is preferable.

Common mistake avoided. Comparing only net profit margins would suggest B has the stronger return performance. But margin alone is not ROA: B’s 9.00% margin is paired with 1.00 asset turnover, while A’s 6.00% margin is paired with 1.50 turnover. The matching products explain why their ROAs are equal.

Interpreting Changes Over Time

A trend review should separate changes in scale from changes in ratios. Sales and net income can both increase while margins and returns remain unchanged. Conversely, a stable ROA can conceal movement in particular asset categories. Inventory, receivables, and fixed-asset turnover can help locate operating changes, but their numerators and denominators must match the activity being measured.

For inventory turnover, cost of goods sold is generally the relevant flow because inventory is carried at cost. For receivables turnover, use credit sales when available; using total sales is appropriate only when the stated assumption or available data supports it. A days measure based on a 365-day year is \(365\) divided by the corresponding turnover ratio.

Worked Example: Stable Returns With Improving Working-Capital Turnover

A hypothetical parts supplier reports these annual figures, in thousands. In Year 1, sales are $1,000, net income is $70, cost of goods sold is $600, average total assets are $700, average equity is $350, average inventory is $150, average receivables are $100, and average net fixed assets are $350. In Year 2, the corresponding figures are sales $1,200, net income $84, cost of goods sold $720, average total assets $840, average equity $420, average inventory $160, average receivables $100, and average net fixed assets $400. Assume all sales are credit sales and use 365 days. Determine what changed.

Step 1: Compare margins and overall returns. Net profit margin in Year 1 is \(70/1{,}000=7.00\%\); in Year 2 it is \(84/1{,}200=7.00\%\). Total asset turnover is \(1{,}000/700=1.428571\ldots\) in Year 1 and \(1{,}200/840=1.428571\ldots\) in Year 2. Therefore ROA is \(7.00\%\times1.428571\ldots=10.00\%\) in each year. Direct calculations confirm \(70/700=10.00\%\) and \(84/840=10.00\%\). ROE is \(70/350=20.00\%\) and \(84/420=20.00\%\), respectively.

Step 2: Compare inventory turnover. Year 1 inventory turnover is \(600/150=4.00\) times, or \(365/4=91.25\) inventory days. Year 2 turnover is \(720/160=4.50\) times, or \(365/4.5=81.1111\ldots\) days, which is 81.11 days to two decimal places.

Step 3: Compare receivables and fixed assets. Receivables turnover rises from \(1{,}000/100=10.00\) to \(1{,}200/100=12.00\) times. Collection days fall from \(365/10=36.50\) to \(365/12=30.4167\), or 30.42 days. Fixed-asset turnover increases from \(1{,}000/350=2.8571\ldots\) to \(1{,}200/400=3.00\) times.

Interpretation and check. Sales and net income each rise by 20%, while average total assets and average equity also rise by 20%; that proportional growth is consistent with unchanged total asset turnover, ROA, and ROE. At the same time, inventory and receivables turnover improve, and fixed-asset turnover increases. These measures identify changes in selected operating relationships without implying that every business driver, or the quality of performance, can be inferred from the ratios alone.

Common mistake avoided. A 20% increase in net income does not by itself mean ROA improved. The matching average-assets comparison shows \(70/700=84/840=10.00\%\). Looking at net income alone misses that the asset base grew at the same rate.

A Practical Review Sequence

When a set of statements is presented in a compact form, use a consistent sequence. It reduces arithmetic errors and makes the explanation easier to follow.

1
Establish the earnings figures.
Calculate gross profit, operating income, pretax income, and net income from the stated income-statement items.
2
Calculate margins.
Divide each earnings measure by net sales, and identify which profit level each margin uses.
3
Match period flows with balances.
Average beginning and ending assets, equity, or operating assets when those balances are supplied.
4
Calculate returns and turnover.
Use the stated numerator and matching denominator; retain units such as percent, times, or days.
5
Interpret the components together.
Use the margin-turnover relationships to explain the return, then distinguish measured changes from possible explanations.

Ratios are meaningful only when their definitions and periods are clear. State whether earnings are net income or operating income, whether balances are average or ending balances, and whether sales used for receivables turnover are credit sales. If a denominator is zero, the corresponding ratio is undefined; if earnings or sales are negative, the arithmetic may still be possible but the usual positive-performance interpretation may not apply. Consistent definitions make the calculations auditable and the conclusions more useful.

Check Your Understanding

Calculate each requested measure and check that your interpretation follows from the figures given.

  1. A hypothetical manufacturer has sales of $800, cost of goods sold of $480, and net income of $48. Average assets are $400 and average equity is $240. Find gross profit margin, net profit margin, total asset turnover, ROA, and ROE. (Answer: 40.00%; 6.00%; 2.00 times; 12.00%; 20.00%.)
  2. A service firm has sales of $1,500, operating income of $180, net income of $90, average assets of $1,200, and average equity of $600. Find operating and net profit margins, total asset turnover, ROA, and ROE. (Answer: 12.00%; 6.00%; 1.25 times; 7.50%; 15.00%.)
  3. A company’s beginning and ending assets are $700 and $900, and beginning and ending equity are $300 and $500. Its annual sales are $1,000 and net income is $72. Find average assets, average equity, total asset turnover, ROA, and ROE. (Answer: $800; $400; 1.25 times; 9.00%; 18.00%.)
  4. A distributor has cost of goods sold of $660, average inventory of $110, credit sales of $990, and average receivables of $90. Using 365 days, find inventory turnover and inventory days, then receivables turnover and collection days. (Answer: 6.00 times; 60.83 days; 11.00 times; 33.18 days.)
  5. Firm X has a net profit margin of 5%, total asset turnover of 2.00, and average equity multiplier of 1.50. Firm Y has corresponding factors of 8%, 1.25, and 1.50. Calculate each ROA and ROE, and state whether their ROEs differ. (Answer: Both ROAs are 10.00%; both ROEs are 15.00%, so the ROEs do not differ.)
Clinical Biostats