Financial Statement and Ratio Analysis

Introduction

Financial statements convert business activity into structured information about performance, financial position and cash generation. Financial analysis interprets that information for lending, investment, management, regulation and risk assessment. The analyst’s task is not merely to calculate ratios, but to identify economic relationships, investigate changes, compare performance appropriately and recognize uncertainty.

The principal statements are the statement of profit or loss, statement of financial position, statement of cash flows and statement of changes in equity. Notes provide accounting policies, disaggregation, commitments, contingencies and other information necessary for interpretation.

Learning Objectives

By the end of this chapter, you should be able to:

1. Apply horizontal, vertical, trend, common-size and benchmarking analysis.
2. Calculate and interpret liquidity, efficiency, leverage, profitability, market and coverage ratios.
3. Construct and explain a DuPont analysis.
4. Select appropriate denominators, averages, units and assumptions.
5. Recognize the limitations, ethical issues and governance risks of ratio-based conclusions.

1. Analytical Foundations

Horizontal analysis

Horizontal analysis compares an item across periods. The absolute change is:

The percentage change is:

The base amount must not be zero, and a negative or very small base can make the percentage misleading. A fall in an expense may be favorable, whereas a fall in revenue may be unfavorable; interpretation requires context.

Vertical and common-size analysis

Vertical analysis expresses each item as a percentage of a selected statement base. In a common-size income statement, each item is normally divided by revenue:

In a common-size statement of financial position, assets are commonly expressed as a percentage of total assets, while liabilities and equity are expressed as a percentage of total liabilities and equity. Common-size analysis supports comparison between firms of different scale, but accounting policies and business models must be comparable.

Trend analysis

Trend analysis assigns an index of 100 to a chosen base period:

An index of 125 means the amount is 25% above the base period, not that it increased by 125%. Trend analysis should cover several periods because one unusual year can distort conclusions.

Benchmarking

Benchmarking compares a firm with a target, competitor, industry median or internal historical standard. Peer comparison is meaningful only when firms have similar products, risk, accounting policies, geographic markets, financing structures and reporting dates. A ratio above an industry average is not automatically better: a very high current ratio may indicate idle resources, and a low leverage ratio may reflect underinvestment.

2. Ratio Analysis: Principles and Data Discipline

A ratio relates two economically connected quantities. Before calculating, the analyst should:

• define the decision question;
• use consistent periods and units;
• distinguish flow variables, such as sales, from stock variables, such as receivables;
• use averages for stock variables when activity occurs throughout the period;
• investigate material changes rather than relying on a mechanical threshold;
• compare with historical, peer and budget information.

For an annual ratio involving a balance-sheet item, an appropriate average is often:

This is an approximation. Monthly or daily averages are preferable when balances fluctuate materially or when a business is seasonal.

3. Liquidity Ratios

Liquidity concerns the ability to meet obligations as they fall due.

Current ratio

A ratio of 1.8 means current assets are 1.8 times current liabilities. Interpretation depends on the quality and timing of current assets. Inventory may be slow-moving, and receivables may be doubtful.

Quick ratio

A common quick ratio excludes inventory and prepayments:

Some analysts include other highly liquid assets; the chosen definition must be disclosed. The ratio does not prove that cash will be available on every due date because timing and credit facilities matter.

Cash ratio

A low cash ratio is not necessarily alarming if operating cash flows and committed facilities are reliable. Conversely, a high cash ratio may indicate caution, weak investment opportunities or restricted cash that is not genuinely available.

4. Efficiency and Working-Capital Ratios

Efficiency ratios examine how effectively resources generate activity.

Receivables turnover and collection period

Net credit sales, not total revenue, are the preferred numerator. If only total revenue is reported, the analyst must explicitly assume that all revenue is credit sales or obtain a credit-sales estimate. This distinction is especially important for businesses with substantial cash sales.

Inventory turnover and holding period

Cost of sales is used because inventory is recorded at cost. Using revenue can produce a distorted result when gross margins differ. Turnover can be low because of obsolete stock, deliberate safety inventories or weak demand; high turnover can indicate efficiency or insufficient stock.

Payables period

Credit purchases are often unavailable. If they are estimated from cost of sales and inventory movements, the assumption must be disclosed. A simplified estimate may use cost of sales as a proxy, but this is not conceptually identical.

Operating and cash-conversion cycles

A shorter cash-conversion cycle generally reduces financing pressure, but excessively aggressive collection or delayed payment may damage customer and supplier relationships.

Worked Example 1: Working capital

Assume a retailer reports net credit sales of $1,200,000, cost of sales of $720,000, opening receivables of $180,000, closing receivables of $220,000, opening inventory of $140,000 and closing inventory of $160,000. Assume a 365-day year.

Average receivables = ($180,000 + $220,000) ÷ 2 = $200,000.

Receivables turnover = $1,200,000 ÷ $200,000 = 6.0 times.

Collection period = 365 ÷ 6.0 = 60.8 days.

Average inventory = ($140,000 + $160,000) ÷ 2 = $150,000.

Inventory turnover = $720,000 ÷ $150,000 = 4.8 times.

Inventory holding period = 365 ÷ 4.8 = 76.0 days.

The business therefore has approximately 137 days in its operating cycle before considering supplier credit. These results should be compared with credit terms, product perishability and industry norms.

5. Leverage and Solvency Ratios

Leverage concerns the extent to which assets are financed by debt and the firm’s capacity to meet long-term obligations.

Debt ratio and debt-to-equity ratio

Definitions vary: some analysts include lease liabilities and other obligations, while others use total liabilities. State the definition. Higher leverage can increase returns to equity when operating returns exceed borrowing costs, but it also increases financial risk.

Equity ratio

When assets equal liabilities plus equity, debt and equity proportions provide complementary views, subject to definition consistency.

Interest coverage

EBIT means earnings before interest and tax. A ratio of 4.0 means operating earnings cover reported interest four times. Coverage can fall rapidly in a downturn, and EBIT may not equal cash available for debt service.

Cash-flow coverage

A cash-based measure may be expressed as:

The exact numerator varies by analytical purpose and reporting classification. Analysts should reconcile the selected measure to the cash-flow statement.

6. Profitability Ratios

Gross, operating and net margins

Margins reveal pricing, cost control, product mix and operating leverage. Net margin is affected by financing, tax and non-operating items, so it should not be interpreted as a pure operating measure.

Return on assets and equity

The numerator and denominator must match the capital claim being evaluated. For ROE, average equity is preferable when equity changes during the year.

Earnings per share

Basic EPS is:

The numerator is normally already after preference dividends because it is profit attributable to ordinary shareholders. If the analyst starts with profit after tax that includes a preference claim, the adjustment is:

Preference dividends must not be subtracted twice. Diluted EPS additionally reflects potential ordinary shares, such as options or convertible instruments, when their inclusion is dilutive under the applicable reporting rules.

7. Market Ratios

Market ratios combine accounting information with market prices and are most useful for listed firms.

A high price-earnings ratio may reflect expected growth, lower perceived risk or temporary earnings weakness. It does not by itself demonstrate overvaluation. Market ratios are affected by investor expectations and market conditions that financial statements cannot fully capture.

8. DuPont Analysis

The three-part DuPont model decomposes ROE into margin, asset turnover and financial leverage:

The revenue and assets terms cancel, leaving net profit ÷ average equity. The components are:

• net profit margin: profitability per unit of revenue;
• asset turnover: revenue generated per unit of assets;
• equity multiplier: assets supported by each unit of equity.

Worked Example 2: DuPont

Suppose net profit is $90,000, revenue is $900,000, average assets are $600,000 and average equity is $300,000.

Net margin = $90,000 ÷ $900,000 = 10%.

Asset turnover = $900,000 ÷ $600,000 = 1.5 times.

Equity multiplier = $600,000 ÷ $300,000 = 2.0 times.

ROE = 10% × 1.5 × 2.0 = 30%.

The same ROE can arise from very different combinations. A firm may improve ROE through stronger margins or asset utilization, but an increase caused mainly by leverage also increases financial risk.

9. Integrated Case: Meridian Office Systems

The following is an illustrative case. Meridian reports the following information ($000):

Horizontal analysis shows revenue increased by 15%, while EBIT decreased by 1.4% and profit after tax decreased by 14.3%. Operating margin fell from 14.0% to 12.0%, indicating cost or pricing pressure.

Inventory turnover fell from 600 ÷ 150 = 4.0 times to 724.5 ÷ 190 ≈ 3.81 times. The holding period increased from 91.3 to approximately 95.8 days. Receivables turnover fell from 800 ÷ 125 = 6.4 times to 920 ÷ 155 ≈ 5.94 times; the collection period increased from 57.0 to approximately 61.4 days.

ROA fell from 84 ÷ 800 = 10.5% to 72 ÷ 920 ≈ 7.8%. ROE fell from 84 ÷ 400 = 21.0% to 72 ÷ 410 ≈ 17.6%. Management should investigate discounting, procurement costs, obsolete inventory, customer credit quality and the financing of growth. The evidence does not justify claiming that growth itself caused the decline; it identifies areas for further inquiry.

10. Limitations, Ethics and Contemporary Practice

Ratio analysis is limited by:

• historical cost and inflation effects;
• different accounting policies and estimates;
• seasonality and year-end window dressing;
• unusual items and discontinued operations;
• off-balance-sheet commitments and lease classification;
• aggregation that hides product or geographic differences;
• denominator problems when amounts are negative, near zero or volatile;
• survivorship and selection bias in peer benchmarks;
• non-financial drivers such as customer loyalty, cyber risk and employee capability.

Analysts should not select only favorable ratios, manipulate periods or present estimates as facts. Governance requires documented definitions, reproducible calculations, source reconciliation and clear disclosure of assumptions. In lending, covenant ratios must follow the contractual definition, which may differ from a textbook ratio.

Spreadsheet and business-intelligence tools improve speed but do not remove judgment. A robust model separates inputs, calculations and outputs; uses checks for signs and units; preserves source data; documents overrides; and tests sensitivity. AI can assist with anomaly detection and narrative drafting, but analysts must verify source integrity, protect confidential information, test for biased training data and retain human accountability.

Best-Practice Analytical Workflow

1. Define the decision and relevant stakeholder.
2. Obtain audited statements, notes and market data.
3. Normalize definitions and identify exceptional items.
4. Calculate horizontal, vertical, trend and ratio measures.
5. Use appropriate averages and disclose assumptions.
6. Compare with history, budgets and suitable peers.
7. Link ratios into drivers such as the cash cycle and DuPont model.
8. Perform sensitivity and scenario analysis.
9. Investigate causes rather than treating ratios as conclusions.
10. Communicate uncertainty, limitations and recommended action.

Chapter Summary

Financial statement analysis uses horizontal, vertical, trend, common-size and benchmarking methods to convert reported amounts into comparable evidence. Liquidity ratios assess short-term capacity; efficiency ratios examine working-capital utilization; leverage and coverage ratios assess financial risk; profitability ratios evaluate margins and returns; and market ratios connect accounting outcomes with share prices. Correct numerator and denominator selection is essential, particularly the use of net credit sales for receivables turnover, cost of sales for inventory turnover and profit attributable to ordinary shareholders for basic EPS. DuPont analysis explains ROE through margin, asset turnover and leverage. Ratios are indicators, not proof: accounting choices, seasonality, inflation, exceptional items, peer differences and non-financial risks require disciplined interpretation and professional judgment.

Key Terms

Financial statement analysis: Systematic interpretation of financial reports.

Horizontal analysis: Comparison of an item across periods.

Vertical analysis: Expression of statement items as percentages of a same-period base.

Common-size statement: Statement presenting items as percentages of a common base.

Trend index: Period amount expressed relative to a base period of 100.

Benchmarking: Comparison with peers, targets or industry measures.

Liquidity: Ability to meet obligations as they fall due.

Current ratio: Current assets divided by current liabilities.

Quick ratio: Liquid current assets divided by current liabilities.

Receivables turnover: Net credit sales divided by average receivables.

Inventory turnover: Cost of sales divided by average inventory.

Cash-conversion cycle: Operating cycle less the payables payment period.

Leverage: Use of debt or other fixed claims to finance assets.

Interest coverage: EBIT divided by interest expense.

Profit margin: Profit measured as a percentage of revenue.

ROA: Profit after tax divided by average assets.

ROE: Profit attributable to ordinary shareholders divided by average ordinary equity.

Basic EPS: Profit attributable to ordinary shareholders divided by weighted-average ordinary shares.

DuPont analysis: Decomposition of ROE into margin, turnover and leverage.

Window dressing: Actions that temporarily improve reported period-end figures.

Review Questions

Short Answer Questions

1. Distinguish horizontal analysis from vertical analysis.
2. Why is average inventory commonly used in inventory turnover?
3. State the formula for the quick ratio and identify one limitation.
4. What does interest coverage measure?
5. Why must preference dividends not be deducted twice in basic EPS?

Long Answer Questions

1. Explain how common-size and trend analysis complement each other.
2. Discuss the meaning and limitations of receivables, inventory and payables periods.
3. Explain leverage, debt-to-equity and interest coverage as measures of financial risk.
4. Derive the three-part DuPont model and discuss how ROE can rise while risk worsens.
5. Evaluate the ethical and practical limitations of benchmarking financial ratios.

Analytical / Application Questions

1. A wholesaler has net credit sales of $1,500,000, cost of sales of $900,000, opening and closing receivables of $240,000 and $260,000, and opening and closing inventory of $180,000 and $220,000. Calculate receivables turnover, collection period, inventory turnover and inventory holding period using 365 days.
2. A company reports revenue of $2,000,000, EBIT of $240,000, net profit of $120,000, average assets of $1,500,000 and average equity of $600,000. Calculate operating margin, net margin, asset turnover, equity multiplier and DuPont ROE.
3. A firm’s revenue rises 20%, but its operating margin falls from 15% to 11%, receivables collection period rises by 12 days and inventory holding period rises by 18 days. Assess two possible causes and recommend three additional pieces of information required before concluding that performance deteriorated.

Multiple Choice Questions with Answers

Question 1

A company has current assets of $360,000 and current liabilities of $240,000. What is its current ratio?

A. 0.67:1

B. 1.20:1

C. 1.50:1

D. 2.00:1

Correct Answer: C. 1.50:1

Question 2

Which numerator is conceptually preferred for receivables turnover?

A. Net credit sales

B. Cost of sales

C. Net profit

D. Total assets

Correct Answer: A. Net credit sales

Question 3

Which formula correctly calculates inventory turnover?

A. Revenue ÷ Average inventory

B. Cost of sales ÷ Average inventory

C. Average inventory ÷ Cost of sales

D. Gross profit ÷ Closing inventory

Correct Answer: B. Cost of sales ÷ Average inventory

Question 4

Net credit sales are $900,000 and average receivables are $150,000. What is receivables turnover?

A. 4.0 times

B. 5.0 times

C. 6.0 times

D. 7.5 times

Correct Answer: C. 6.0 times

Question 5

A firm has EBIT of $300,000 and interest expense of $75,000. Its interest coverage is:

A. 0.25 times

B. 2.0 times

C. 3.0 times

D. 4.0 times

Correct Answer: D. 4.0 times

Question 6

Profit attributable to ordinary shareholders is $240,000 and weighted-average ordinary shares are 120,000. Basic EPS is:

A. $0.50

B. $1.00

C. $2.00

D. $3.00

Correct Answer: C. $2.00

Question 7

Which item is a component of the three-part DuPont model?

A. Net profit margin

B. Current liabilities

C. Tax payable turnover

D. Dividend yield only

Correct Answer: A. Net profit margin

Question 8

Revenue is $1,000,000 and cost of sales is $650,000. What is the gross profit margin?

A. 35%

B. 65%

C. 150%

D. 185.7%

Correct Answer: A. 35%

Question 9

A trend index of 125 means that the current amount is:

A. 125% below the base amount

B. 25% above the base amount

C. 125 percentage points below the base amount

D. Equal to the base amount

Correct Answer: B. 25% above the base amount

Question 10

Which circumstance most directly weakens comparability between two firms’ ratios?

A. Both firms use the same reporting date

B. Both firms operate in the same industry

C. They use materially different accounting policies

D. Both firms disclose audited statements

Correct Answer: C. They use materially different accounting policies