Financial Statement Analysis and Business Analytics

Introduction

Financial statements convert business activity into structured information about performance, financial position, cash generation and changes in owners’ claims. Analysis transforms that information into judgments: Is profitability improving? Can obligations be paid? Are assets being used efficiently? Is reported profit supported by cash? How does the business compare with competitors?

Financial statement analysis is not a mechanical exercise. Ratios are signals rather than final conclusions. They must be interpreted in relation to accounting policies, industry economics, business size, inflation, seasonality, financing structure and the quality of the underlying data. Business analytics extends traditional analysis by combining financial and non-financial data, visualising trends and supporting evidence-based decisions.

Learning Objectives

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

1. Prepare and interpret horizontal, vertical, trend and common-size analyses.
2. Calculate and explain profitability, liquidity, efficiency, solvency and investor-return ratios.
3. Interpret operating, investing and financing cash flows.
4. Reconcile ratio conclusions with cash-flow evidence.
5. Benchmark performance responsibly and identify earnings-quality concerns.
6. Use dashboards and analytics to communicate defensible conclusions.
7. Recognise the limitations, ethical risks and governance requirements of financial analysis.

1. Analytical Foundations

1.1 The analytical question

A sound analysis normally follows this sequence:

Question → reliable data → measurement → comparison → interpretation → decision → monitoring.

The analyst should first define the decision. A lender may prioritise liquidity and solvency; a manager may focus on margins and working-capital efficiency; an investor may emphasise sustainable earnings, risk and returns.

1.2 Information sources

The principal sources are the statement of profit or loss, statement of financial position, statement of cash flows, statement of changes in equity, notes to the accounts and management commentary. Useful supplementary information includes budgets, segment data, operational metrics, market prices and industry statistics.

Analysts must distinguish audited historical information from forecasts and management estimates. Notes may reveal revenue-recognition policies, leases, impairments, provisions, related-party transactions, contingent liabilities and discontinued operations that materially affect interpretation.

2. Comparative and Structural Analysis

2.1 Horizontal analysis

Horizontal analysis measures change between periods. For an item X:

Here, X₀ is the base-period amount and Xₜ is the later-period amount. The percentage calculation is meaningful when X₀ is non-zero and its sign is interpreted carefully. A movement from a small loss to a small profit may produce an unusual percentage and should also be described in absolute terms.

Example. Revenue increases from $800,000 to $920,000. The absolute increase is $120,000 and the percentage increase is ($120,000 ÷ $800,000) × 100 = 15%.

2.2 Trend analysis

Trend analysis selects a base period and expresses later values as an index:

A base-period value therefore equals 100. If operating expenses rise from $300,000 to $390,000 while revenue rises from $800,000 to $920,000, the indices are 130 and 115 respectively. Expenses have grown faster than revenue, a warning about operating leverage or cost control.

Trend analysis is especially useful over several years, but it can be distorted by acquisitions, disposals, inflation, changes in accounting policy or an abnormal base year.

2.3 Vertical and common-size analysis

Vertical analysis expresses each item as a percentage of a relevant total. In a common-size income statement, each item is generally divided by revenue:

In a common-size statement of financial position, assets are divided by total assets, while liabilities and equity are commonly divided by total liabilities and equity. The analyst should state the denominator because different denominators answer different questions.

Example. Cost of sales of $552,000 on revenue of $920,000 equals 60%; gross profit of $368,000 equals 40%. If gross margin falls from 42% to 40%, possible explanations include price pressure, input-cost inflation or product-mix change.

Horizontal analysis describes movement; vertical analysis describes structure. Used together, they distinguish growth from changing composition.

3. Ratio Analysis

Ratios make relationships visible, but a ratio is meaningful only when its numerator, denominator, period and accounting basis are understood. Average balances are generally preferable when a flow over a period is compared with a balance-sheet stock.

3.1 Profitability ratios

Gross profit margin measures the proportion of revenue remaining after cost of sales:

Operating profit margin measures operating profit generated per unit of revenue:

Net profit margin is:

If analysing returns available to ordinary shareholders, consistency requires a different numerator in related measures. Define profit attributable to ordinary shareholders as profit after tax less preference dividends, after any required adjustments. It may be used in an ordinary-shareholder margin, but it must not be mixed with profit after tax in a DuPont identity.

Return on assets (ROA) has more than one convention. A simple owner-oriented convention is:

This asks how much accounting profit the asset base generated. If the purpose is to measure returns attributable only to ordinary shareholders, an analyst may instead use profit attributable to ordinary shareholders, but must label the measure clearly because preference claims and financing structure make it conceptually different. For comparing operating performance across financing structures, operating profit after tax or another tax-adjusted operating numerator may be more appropriate. There is no universally correct numerator independent of purpose.

Return on equity (ROE) should identify the equity claim being evaluated. For ordinary shareholders:

The numerator must be the same profit measure used in any decomposition of this ROE.

3.2 The DuPont framework

A three-part DuPont identity decomposes ordinary ROE as follows, provided all figures use the same period, profit definition and equity definition:

The components are the ordinary-shareholder profit margin, total-asset turnover and equity multiplier. Algebraically, revenue and average total assets cancel, leaving profit attributable to ordinary shareholders divided by average ordinary equity. This decomposition highlights whether ROE is driven by margin, asset utilisation or leverage. It does not prove that leverage is beneficial: debt can raise ROE while increasing interest, refinancing and default risk.

3.3 Liquidity ratios

Current ratio:

Quick ratio excludes inventories and, depending on policy, may exclude other less-liquid current assets:

The ratio’s usefulness depends on receivable collectability, inventory turnover, supplier terms and the timing of cash flows. A high current ratio may reflect idle cash or obsolete inventory rather than strength.

Operating cash-flow ratio assesses current liabilities against cash generated by operations:

This is a period-based measure and should not be compared uncritically with a point-in-time current ratio.

3.4 Efficiency and working capital

When credit purchases are unavailable, cost of sales may be used as an approximation, but that limitation must be disclosed.

The cash conversion cycle is:

A shorter cycle can release cash, but excessively aggressive supplier payment or insufficient inventory may damage resilience and relationships.

3.5 Solvency and coverage

The definition of debt and equity must be stated; analysts may include or exclude leases and preference shares differently.

EBIT means earnings before interest and tax. Interest coverage is not meaningful when EBIT or finance costs are zero or negative, and a high historical ratio does not guarantee future repayment capacity.

3.6 Investor-return measures

Basic earnings per share (EPS) must not double-count preference dividends. Let P be profit after tax and Dp be preference dividends attributable to the period. Then:

Equivalently, if profit attributable to ordinary shareholders is already given as Po, then:

Use one form or the other, not both. The denominator is weighted by the time ordinary shares were outstanding; bonus issues and share splits require appropriate retrospective adjustment under the applicable reporting framework.

These measures are affected by market expectations, capital structure, accounting estimates and cyclical earnings.

Worked EPS example. Profit after tax is $240,000, preference dividends are $20,000 and the weighted-average ordinary shares are 100,000. Basic EPS = ($240,000 − $20,000) ÷ 100,000 = $2.20. If profit attributable to ordinary shareholders is stated directly as $220,000, the result remains $2.20; subtracting preference dividends again would be incorrect.

4. Cash-Flow Interpretation

Profit and cash are not identical because accrual accounting recognises revenue and expenses when earned or incurred, whereas cash flow records cash movements. The statement of cash flows classifies movements into:

• Operating activities: cash from the principal revenue-producing activities.
• Investing activities: acquisition and disposal of long-term assets and investments.
• Financing activities: changes in borrowings, equity and distributions.

A growing business may report negative investing cash flow because it is expanding capacity. Negative operating cash flow, however, requires careful investigation, especially when reported profit is positive.

The indirect reconciliation usually begins with profit and adjusts for non-cash items and working-capital movements. An increase in receivables generally reduces operating cash relative to profit; an increase in trade payables generally increases it. Analysts should examine whether operating cash flow is consistently positive, whether it covers capital expenditure and whether financing inflows are masking weak operations.

A useful supplementary measure is free cash flow, but definitions vary. One common definition is:

The analyst must specify whether capital expenditure is gross purchases or net of disposals and should not present the measure as an IFRS-defined subtotal.

5. Benchmarking and Earnings Quality

5.1 Benchmarking

Internal benchmarking compares periods, divisions or products. External benchmarking compares competitors, industry quartiles or published standards. Comparisons should control for:

• accounting policies and fiscal year-ends;
• business mix, scale and geography;
• inflation and exchange rates;
• seasonality and business cycle;
• lease classification and capital intensity;
• exceptional items and discontinued operations.

A ratio above an industry average is not automatically superior. For example, low inventory days may indicate efficiency or dangerous understocking.

5.2 Earnings quality

Earnings quality concerns the sustainability, cash support and transparency of reported profit. Warning signs include:

• profit growth accompanied by persistent operating cash deficits;
• receivables growing faster than revenue;
• unusual end-of-period sales or generous credit terms;
• repeated “one-off” gains or frequent restructuring adjustments;
• capitalisation of costs that competitors expense;
• large, subjective provisions or reversals;
• substantial related-party transactions;
• changes in accounting estimates that improve results;
• dependence on asset disposals or fair-value gains.

A warning sign is not proof of manipulation. The appropriate response is to inspect notes, obtain supporting schedules, compare cash and accrual measures, and ask focused questions.

Common analytical tools include accrual comparisons and the operating cash-flow-to-profit ratio:

Interpretation requires caution because working capital, growth and timing can cause legitimate short-term divergence.

6. Business Analytics and Dashboards

Business analytics may be descriptive (what happened), diagnostic (why it happened), predictive (what may happen) or prescriptive (what action is recommended). A finance dashboard should connect financial outcomes to operational drivers.

A useful dashboard may contain:

Dashboard design principles include a clear purpose, consistent definitions, visible period comparisons, drill-down capability, exception flags and documented data lineage. A traffic-light indicator should be based on a stated threshold, not visual preference. Ratios should be accompanied by absolute amounts and explanatory context.

AI can assist with anomaly detection, forecasting and natural-language summaries, but it does not remove professional responsibility. Models may reproduce biased data, confuse correlation with causation or generate plausible but unsupported explanations. Human review, access controls, audit trails, privacy safeguards and model validation are essential.

7. Integrated Illustrative Case

The following is a fictional illustrative case.

Background

Nova Homeware Ltd reports the following information ($000):

Problem

Management claims that Year 2 was highly successful because revenue increased by 20%. The finance committee asks whether profitability, liquidity and cash generation support that claim.

Analysis

Revenue growth is 20%, but profit growth is only ($168 − $160) ÷ $160 = 5%. Net margin falls from 8.0% to 7.0%: Year 1 is $160 ÷ $2,000; Year 2 is $168 ÷ $2,400.

ROA using profit after tax is 10.0% in Year 1 and 8.4% in Year 2, calculated using average assets of $1,600 and $2,000. The decline suggests that the expanded asset base has not yet generated proportionate profit.

The current ratio falls from 1.40 to 1.20. The quick ratio falls from (700 − 300) ÷ 500 = 0.80 to (900 − 450) ÷ 750 = 0.60, assuming inventory is the only excluded item. Liquidity has weakened, while inventory has increased 50% against revenue growth of 20%.

Operating cash flow falls from $190,000 to $95,000. Free cash flow changes from $90,000 ($190,000 − $100,000) to negative $145,000 ($95,000 − $240,000). The expansion therefore appears to require financing or accumulated cash. The cash evidence does not prove poor performance, but it demands investigation of inventory build-up, receivables, payment terms and the timing of capital expenditure.

For ordinary shareholders, Year 2 profit attributable to ordinary shareholders is $160,000 ($168,000 − $8,000). If average ordinary equity is $900,000, ordinary ROE is 17.8%. A consistent DuPont calculation uses ordinary profit margin of 6.67% ($160 ÷ $2,400), asset turnover of 1.20 ($2,400 ÷ $2,000), and equity multiplier of 2.22 ($2,000 ÷ $900). Their product is approximately 17.8%. Using the $168,000 profit-after-tax margin instead would produce an inconsistent decomposition of ordinary ROE.

Approach and outcome

The committee should not reject expansion solely because free cash flow is negative. It should require a working-capital recovery plan, a project return analysis, inventory ageing, a receivables forecast and financing stress tests. Dashboard thresholds might flag quick ratio below 0.75, operating cash flow below profit and inventory growth materially above revenue growth.

Learning points

Growth in revenue is not equivalent to growth in value. A conclusion is stronger when horizontal trends, common-size margins, ratios and cash flows point in the same direction. Where they conflict, the conflict is itself an analytical finding.

8. Limitations, Ethics and Governance

Financial analysis is constrained by historical cost, estimates, aggregation, inflation, exchange-rate movements and differing accounting policies. Ratios can be manipulated through year-end transactions, classification choices or denominator changes. Small denominators can produce extreme percentages, and averages can conceal severe year-end liquidity pressure.

Ethically, analysts should avoid selective benchmarking, unsupported accusations and misleading visualisation. Material assumptions, non-GAAP measures and data exclusions should be disclosed. Confidential information must be protected, and analysts must comply with applicable securities, company, data-protection and financial-reporting requirements. Management dashboards should preserve an audit trail so that a reported metric can be traced to source data and transformation rules.

Best-Practice Analytical Workflow

1. Define the decision and stakeholder.
2. Verify period, currency, units and accounting policies.
3. Reconcile statements and inspect notes.
4. Calculate changes, trends, common-size measures and relevant ratios.
5. Use average balances where a period flow is compared with a balance.
6. Compare with budgets, prior periods and carefully selected peers.
7. Reconcile profit with operating cash flow and working-capital movements.
8. Investigate exceptions rather than treating them as proof of misconduct.
9. Present causes, uncertainty, implications and recommended actions.
10. Monitor results through controlled dashboards and revise assumptions when evidence changes.

Chapter Summary

Financial statement analysis uses horizontal, vertical, trend and common-size methods to reveal change and structure. Ratio analysis assesses profitability, liquidity, efficiency, solvency and investor returns, but definitions and denominators must be made explicit. ROA can be defined using profit after tax for an overall asset-return perspective, while an ordinary-shareholder ROE must use profit attributable to ordinary shareholders and ordinary equity. The DuPont identity reconciles only when the same profit numerator is used throughout. Basic EPS equals profit attributable to ordinary shareholders divided by weighted-average ordinary shares, or equivalently profit after tax less preference dividends divided by those shares—not both adjustments. Cash-flow analysis tests whether accrual profit is supported by operations. Benchmarking, earnings-quality review and dashboard analytics improve decisions, provided limitations, ethics, governance and data lineage are addressed.

Key Terms

Financial statement analysis: Systematic interpretation of financial reports for decision-making.

Horizontal analysis: Measurement of absolute and percentage changes across periods.

Vertical analysis: Expression of statement items as percentages of a selected total.

Trend analysis: Index-based comparison using a chosen base period.

Common-size statement: A statement in which items are expressed as percentages of a common denominator.

Profit margin: Profit expressed as a percentage of revenue.

ROA: Return generated by assets under a stated numerator convention.

ROE: Return generated for a defined equity claim.

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

Liquidity: Ability to meet short-term obligations.

Efficiency: Effectiveness in using assets and managing working capital.

Solvency: Ability to meet long-term obligations.

Cash conversion cycle: Time between cash paid for inputs and cash collected from customers.

Basic EPS: Profit attributable to ordinary shareholders per weighted-average ordinary share.

Benchmarking: Comparison with internal targets or external reference groups.

Earnings quality: Sustainability, transparency and cash support of reported earnings.

Free cash flow: A specified measure of operating cash flow less specified capital expenditure.

Dashboard: Visual, controlled presentation of key performance indicators.

Data lineage: Traceable history from source data to reported metric.

Review Questions

Short Answer Questions

1. Distinguish horizontal analysis from vertical analysis.
2. Why are average balance-sheet amounts often used with income-statement flows?
3. State two limitations of the current ratio.
4. Why can profit differ from operating cash flow?
5. What is the purpose of a common-size income statement?

Long Answer Questions

1. Explain the DuPont framework and the conditions required for its internal consistency.
2. Discuss how liquidity, efficiency and cash-flow measures should be interpreted together.
3. Explain the calculation and correct interpretation of basic EPS when preference dividends exist.
4. Evaluate the benefits and limitations of external benchmarking.
5. Discuss ethical and governance controls for financial dashboards and AI-supported analytics.

Analytical / Application Questions

1. A company’s revenue rises 12%, profit rises 3%, receivables rise 30% and operating cash flow falls 20%. Identify possible explanations and propose further evidence to obtain.
2. Profit after tax is $500,000, preference dividends are $50,000 and weighted-average ordinary shares are 225,000. Calculate basic EPS and explain why subtracting preference dividends twice is incorrect.
3. A business has revenue of $3,000,000, profit attributable to ordinary shareholders of $180,000, average assets of $1,500,000 and average ordinary equity of $750,000. Calculate the ordinary profit margin, asset turnover, equity multiplier and ordinary ROE, and verify the DuPont relationship.

Multiple Choice Questions with Answers

Question 1

Revenue increases from $800,000 to $920,000. What is the percentage increase?

A. 12%

B. 15%

C. 18%

D. 20%

Correct Answer: B. 15%

Question 2

Which formula correctly calculates basic EPS when profit after tax and preference dividends are given?

A. Profit after tax ÷ total assets

B. (Profit after tax + preference dividends) ÷ ordinary shares

C. (Profit after tax − preference dividends) ÷ weighted-average ordinary shares

D. Preference dividends ÷ ordinary shares

Correct Answer: C. (Profit after tax − preference dividends) ÷ weighted-average ordinary shares

Question 3

For an ordinary-shareholder DuPont analysis, which profit numerator should be used consistently in the margin and ROE?

A. Revenue

B. Profit attributable to ordinary shareholders

C. Total assets

D. EBITDA only

Correct Answer: B. Profit attributable to ordinary shareholders

Question 4

A company has current assets of $900,000 and current liabilities of $750,000. Its current ratio is:

A. 0.60:1

B. 0.83:1

C. 1.20:1

D. 1.65:1

Correct Answer: C. 1.20:1

Question 5

If inventory is $450,000, current assets are $900,000 and current liabilities are $750,000, the quick ratio, excluding inventory, is:

A. 0.40:1

B. 0.60:1

C. 1.20:1

D. 1.80:1

Correct Answer: B. 0.60:1

Question 6

Which cash-flow category normally includes the purchase of production equipment?

A. Operating activities

B. Investing activities

C. Financing activities

D. Equity activities only

Correct Answer: B. Investing activities

Question 7

A company has net operating cash flow of $95,000 and capital expenditure of $240,000. Using the chapter’s stated definition, free cash flow is:

A. $145,000

B. $335,000

C. −$145,000

D. −$335,000

Correct Answer: C. −$145,000

Question 8

Which finding is most directly a potential earnings-quality warning sign?

A. Revenue and operating cash flow grow together

B. Receivables grow substantially faster than revenue

C. Debt decreases while interest coverage improves

D. Inventory decreases with stable sales

Correct Answer: B. Receivables grow substantially faster than revenue

Question 9

In trend analysis, the selected base-period amount is normally represented by:

A. 0

B. 1

C. 100

D. 1,000

Correct Answer: C. 100

Question 10

Which measure is most directly associated with the time between paying suppliers and collecting customer cash?

A. Gross margin

B. Cash conversion cycle

C. Debt ratio

D. Price–earnings ratio

Correct Answer: B. Cash conversion cycle