Financial Analytics

Chapter 4
Financial Statements and Performance Analytics

Bachelors Program in Banking Finance and Insurance
Financial Analytics   •   Bachelor

Financial Statements and Performance Analytics

Introduction

Financial statements convert the activities of an organisation into structured economic information. For banks, insurers, investors, regulators, managers and lenders, these statements provide the starting point for evaluating profitability, liquidity, solvency, efficiency and earnings quality. Financial analytics extends beyond reading reported totals: it examines relationships, trends, comparability, cash generation and the sustainability of performance.

The principal statements are the income statement, balance sheet, statement of cash flows, statement of changes in equity and accompanying notes. They should be interpreted together. A profitable firm may face cash shortages; a firm with strong liquidity may be inefficient; and reported earnings may be temporarily inflated by accounting estimates or one-time gains.

Learning Objectives

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

  1. Explain the purpose and relationships of the major financial statements.
  2. Calculate and interpret ratio, trend, common-size, DuPont, peer and cash-flow measures.
  3. Assess profitability, liquidity, solvency, operating efficiency and earnings quality.
  4. Identify limitations caused by accounting policies, industry differences and data quality.
  5. Apply financial-statement analysis to lending, investment, management and regulatory decisions.

1. The Financial Statement System

1.1 The income statement

The income statement reports revenues, expenses and profit over a specified period. A simplified structure is:

\text{Net income} = \text{Revenue} - \text{Operating expenses} - \text{Interest expense} - \text{Tax expense} + \text{Other gains or losses}

Revenue is recognised according to the applicable accounting framework, not necessarily when cash is received. Expenses may likewise be recognised before or after payment. Consequently, net income is an accrual measure rather than a direct measure of cash generation.

Important subtotals include gross profit, operating profit or earnings before interest and tax (EBIT), earnings before interest, tax, depreciation and amortisation (EBITDA), and net income. EBITDA can assist comparison of operating performance, but it is not a recognised substitute for cash flow because it excludes working-capital investment, capital expenditure, interest and taxes.

For financial institutions, interest income, interest expense, net interest income, provisions for credit losses, fee income and operating costs are especially important. Analysts should distinguish between recurring operating income and volatile trading, fair-value or revaluation gains.

1.2 The balance sheet

The balance sheet reports financial position at a particular date:

\text{Assets} = \text{Liabilities} + \text{Equity}

Assets are resources controlled by the entity; liabilities are present obligations; equity is the residual interest. The identity must balance under double-entry accounting, but a balanced statement does not guarantee financial health.

Assets and liabilities are commonly classified as current or non-current. Classification depends on the reporting framework and the operating cycle. Banks have distinctive balance sheets: loans and securities dominate assets, while deposits and wholesale funding dominate liabilities. Insurance companies report investments and insurance contract liabilities, whose measurement depends heavily on assumptions about claims, discount rates and policyholder behaviour.

1.3 The statement of cash flows

The statement of cash flows explains changes in cash and cash equivalents through three categories:

  • Operating activities: cash generated or consumed by core operations.
  • Investing activities: purchases and sales of long-term assets and investments.
  • Financing activities: borrowing, repayment of debt, share issuance, dividends and repurchases.

The fundamental reconciliation is:

\text{Closing cash} = \text{Opening cash} + \text{Net operating cash flow} + \text{Net investing cash flow} + \text{Net financing cash flow} + \text{Effect of exchange-rate changes}

Under the indirect method, operating cash flow begins with net income and adjusts for non-cash items and changes in operating working capital. An increase in receivables normally reduces cash flow relative to revenue; an increase in payables normally increases cash flow because the firm has not yet paid suppliers.

1.4 Connections among statements

Net income generally contributes to retained earnings, while cash-flow adjustments explain why net income differs from operating cash flow. Asset purchases reduce cash and increase property, plant and equipment; depreciation subsequently reduces accounting profit without a current cash payment. Borrowing increases both cash and liabilities, while repayment reduces both.

The notes are essential. They describe accounting policies, debt maturities, leases, contingent liabilities, segment information, related-party transactions, fair values, impairment assumptions and subsequent events. Ratio analysis based only on headline figures can therefore be misleading.

2. Preparing Data for Analysis

Before calculating indicators, an analyst should establish:

  1. Whether statements are consolidated or standalone.
  2. The reporting period and whether figures are annual, quarterly or trailing twelve-month.
  3. The accounting framework and policy changes.
  4. Whether averages or year-end balances are appropriate.
  5. Currency, inflation, exchange-rate and unit consistency.
  6. Whether unusual or non-recurring items require separate treatment.

Average balances are generally preferable for return ratios because income is earned throughout a period while the balance sheet is measured at a point in time. For example:

\text{Average assets} = \frac{\text{Beginning assets} + \text{Ending assets}}{2}

This simple average is appropriate when changes are reasonably even. If balances fluctuate substantially, monthly or quarterly averages are more representative.

3. Horizontal, Trend and Common-Size Analysis

3.1 Horizontal analysis

Horizontal analysis measures change over time:

\text{Percentage change} = \frac{\text{Current amount} - \text{Base amount}}{\text{Base amount}} × 100

The denominator must not be zero, and interpretation requires attention to inflation, acquisitions, divestitures and changes in business scale.

3.2 Trend analysis

A trend index sets a base period equal to 100:

\text{Trend index}t = \frac{\text{Amount}t}{\text{Amount}base} × 100

If revenue rises from 80 million to 104 million, the index is 130, indicating a 30% increase. Trends are more informative when several related items are examined. Revenue rising 30% while receivables rise 75% may indicate weakening collections or aggressive recognition.

3.3 Common-size analysis

Common-size statements express each item as a percentage of a relevant total. On an income statement:

\text{Common-size percentage} = \frac{\text{Statement item}}{\text{Revenue}} × 100

On a balance sheet, assets are commonly divided by total assets, while liabilities and equity may also be expressed as percentages of total assets. Common-size analysis supports comparison between differently sized firms, but it does not eliminate differences in business models, accounting methods or risk.

4. Ratio Analysis

Ratios are analytical signals, not conclusions. A ratio should be compared with the firm’s history, budget, peers, sector norms and strategic circumstances.

4.1 Profitability ratios

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

\text{Gross margin} = \frac{\text{Gross profit}}{\text{Revenue}} × 100

Operating margin measures operating profit relative to revenue:

\text{Operating margin} = \frac{\text{EBIT}}{\text{Revenue}} × 100

Net profit margin includes financing, tax and other effects:

\text{Net margin} = \frac{\text{Net income}}{\text{Revenue}} × 100

Return on assets (ROA) evaluates profit generated by assets:

\text{ROA} = \frac{\text{Net income}}{\text{Average total assets}} × 100

Return on equity (ROE) measures profit attributable to ordinary shareholders relative to average equity:

\text{ROE} = \frac{\text{Net income available to ordinary shareholders}}{\text{Average ordinary equity}} × 100

If preferred dividends exist, they should be deducted from net income for ordinary-shareholder ROE. ROE may increase because of genuine operating improvement or because leverage has increased; the analyst must separate these effects.

4.2 The DuPont framework

The three-part DuPont identity decomposes ROE:

\text{ROE} = \frac{\text{Net income}}{\text{Revenue}} × \frac{\text{Revenue}}{\text{Average assets}} × \frac{\text{Average assets}}{\text{Average equity}}

Thus:

\text{ROE} = \text{Net margin} × \text{Asset turnover} × \text{Equity multiplier}

The components represent profitability, asset efficiency and financial leverage. The identity assumes consistent definitions and average balance-sheet amounts. A high ROE produced mainly by leverage may carry greater solvency risk than a similar ROE produced by stronger margins and turnover.

4.3 Liquidity ratios

Current ratio measures current assets relative to current liabilities:

\text{Current ratio} = \frac{\text{Current assets}}{\text{Current liabilities}}

Quick ratio excludes less liquid inventories and, depending on convention, prepaid expenses:

\text{Quick ratio} = \frac{\text{Cash and equivalents} + \text{Marketable securities} + \text{Receivables}}{\text{Current liabilities}}

Operating cash-flow ratio assesses current-liability coverage by operating cash:

\text{Operating cash-flow ratio} = \frac{\text{Net cash from operating activities}}{\text{Average or ending current liabilities}}

The numerator and denominator should be selected consistently. Liquidity ratios are less meaningful for banks, where deposits and liquid assets require specialised measures such as regulatory liquidity coverage and stable-funding metrics.

4.4 Solvency and capital structure

Debt-to-equity ratio is:

\text{Debt-to-equity} = \frac{\text{Interest-bearing debt}}{\text{Equity}}

The analyst must state whether leases, convertible debt and other financing obligations are included.

Debt ratio is:

\text{Debt ratio} = \frac{\text{Total liabilities}}{\text{Total assets}}

Interest coverage evaluates the ability to meet interest charges:

\text{Interest coverage} = \frac{\text{EBIT}}{\text{Interest expense}}

This measure is meaningful when EBIT and interest expense are positive and comparable. It may be unstable for firms with variable-rate debt or capitalised interest. Banks require sector-specific capital, asset-quality and stress measures rather than relying on industrial-company ratios.

4.5 Efficiency ratios

Receivables turnover and days sales outstanding (DSO) are:

\text{Receivables turnover} = \frac{\text{Credit sales}}{\text{Average receivables}}
\text{DSO} = \frac{\text{Average receivables}}{\text{Credit sales}} × 365

Inventory turnover and days inventory outstanding (DIO) are:

\text{Inventory turnover} = \frac{\text{Cost of goods sold}}{\text{Average inventory}}
\text{DIO} = \frac{\text{Average inventory}}{\text{Cost of goods sold}} × 365

Payables days are:

\text{Payables days} = \frac{\text{Average trade payables}}{\text{Purchases}} × 365

If purchases are unavailable, cost of sales is sometimes used as an approximation, but this should be disclosed. The cash conversion cycle is:

\text{CCC} = \text{DSO} + \text{DIO} - \text{Payables days}

A shorter cycle can reduce financing needs, but excessively long supplier payment periods may damage relationships or signal financial stress.

5. Cash-Flow and Earnings-Quality Analysis

Earnings quality concerns the extent to which reported earnings reflect sustainable operating performance and are supported by cash generation. Relevant indicators include:

\text{Cash conversion ratio} = \frac{\text{Net cash from operating activities}}{\text{Net income}}

This ratio is informative when net income is positive and the periods are comparable. It can be distorted by timing, working-capital growth and business-cycle effects.

Free cash flow is commonly defined as:

\text{Free cash flow} = \text{Net cash from operating activities} - \text{Capital expenditure}

The definition varies. Some analysts subtract acquisitions, lease payments or dividends; therefore, the chosen definition must be stated. Positive free cash flow does not automatically mean that assets are being maintained adequately, because capital expenditure may be temporarily deferred.

Warning signs of weak earnings quality include:

  • Receivables growing much faster than revenue.
  • Persistent profit growth without operating cash growth.
  • Repeated “one-time” gains or restructuring adjustments.
  • Large changes in provisions, depreciation lives or impairment assumptions.
  • Capitalisation of costs that competitors expense.
  • Frequent related-party transactions.
  • Dependence on asset sales to fund dividends.
  • Rising debt used to maintain distributions.

Cash-flow analysis must also consider classification choices. Some interest and dividend flows may be classified differently under different standards. Comparability therefore requires policy review.

6. Worked Example: Integrated Analysis

The following figures are an illustrative manufacturing-company dataset in millions of currency units.

ItemYear 1Year 2
Revenue1,0001,200
Cost of sales600720
EBIT180192
Interest expense3040
Tax expense3030
Net income120122
Total assets1,0001,200
Equity500540
Current assets300360
Current liabilities200300
Operating cash flow150100
Capital expenditure80140

Assume balances at the beginning of Year 1 were assets of 900 and equity of 460. For simplicity, Year 2 average assets are (1,000 + 1,200) ÷ 2 = 1,100, and average equity is (500 + 540) ÷ 2 = 520.

Revenue increased by:

\frac{1,200 - 1,000}{1,000} × 100 = 20\%

Net income increased only by:

\frac{122 - 120}{120} × 100 ≈ 1.7\%

Year 2 operating margin is:

\frac{192}{1,200} × 100 = 16\%

Year 1 operating margin was 18%, so operating profitability declined. Year 2 ROA is:

\frac{122}{1,100} × 100 ≈ 11.1\%

Year 2 ROE is:

\frac{122}{520} × 100 ≈ 23.5\%

The DuPont components are net margin = 10.17%, asset turnover = 1.09 and equity multiplier = 2.12. Their product is approximately 23.5%, confirming the identity.

Year 2 current ratio is 360 ÷ 300 = 1.20, down from 1.50 in Year 1. Operating cash flow fell from 150 to 100 despite revenue growth. The cash conversion ratio is 100 ÷ 122 ≈ 0.82, and free cash flow is 100 − 140 = −40. The integrated conclusion is not that the company is immediately insolvent, but that growth has consumed liquidity, capital expenditure has increased, leverage or working-capital demands may be rising, and earnings require closer investigation.

7. Peer and Benchmark Analysis

Peer analysis compares a firm with organisations having similar products, scale, geography, risk and accounting policies. A good peer group is economically comparable, not merely convenient. Analysts may use:

  • Direct competitors.
  • Sector medians and quartiles.
  • Historical internal benchmarks.
  • Budget and management targets.
  • Credit-rating or regulatory benchmarks.

Median comparisons are often more robust than averages because extreme observations can distort averages. Differences should be decomposed rather than labelled simply as good or bad. A lower margin may reflect a deliberate low-price strategy; a higher leverage ratio may reflect stable regulated cash flows; a lower current ratio may be normal in a rapid-cash retail model.

8. Applied Case: Meridian Consumer Finance Ltd.

This is an illustrative case.

Background

Meridian Consumer Finance reported rapid loan growth, a 22% increase in revenue and a 15% increase in net income. Its ROE rose from 14% to 19%, attracting investor interest. However, operating cash flow declined and provisions for expected credit losses fell as a percentage of loans.

Problem

The board needed to determine whether performance reflected sustainable operating improvement or increased credit and liquidity risk.

Analysis

An analyst first normalised the statements, separating continuing operations from a gain on the sale of a subsidiary. The common-size income statement showed that the reported margin improvement disappeared after removing the gain. The balance sheet showed loans growing faster than customer deposits, increasing reliance on wholesale funding. The cash-flow statement showed weaker cash generation, while receivables and past-due loans increased.

DuPont analysis showed that the higher ROE came mainly from a greater equity multiplier, not improved net margin or asset turnover. Peer analysis revealed that Meridian’s loss allowance coverage was below the sector median. Stress testing considered higher unemployment, lower collateral values and increased refinancing costs.

Approach and outcome

Management introduced tighter underwriting for high-risk borrowers, lengthened funding maturities, increased loss allowances and enhanced monthly monitoring of delinquency, liquidity and cash conversion. Reported short-term profit fell, but the firm’s risk-adjusted performance and funding resilience improved.

Learning points

  1. Growth does not necessarily create value if risk-adjusted returns decline.
  2. ROE must be decomposed to identify leverage-driven performance.
  3. Cash flow, asset quality and funding structure are essential in financial institutions.
  4. Provisions and fair-value estimates require challenge, sensitivity analysis and governance.

9. Limitations, Governance and Contemporary Practice

Financial-statement analysis is constrained by historical cost, estimates, inflation, exchange rates, seasonality, aggregation and differences in accounting standards. Ratios can be manipulated through year-end transactions, classification choices, aggressive revenue recognition or delayed expense recognition. Analysts should read audit reports and investigate qualified opinions, key audit matters and material uncertainties.

Ethically, analysts must avoid selective use of metrics, disclose assumptions and distinguish fact from inference. Boards and audit committees should oversee internal controls, model risk, related-party transactions and whistle-blower mechanisms. Regulators expect accurate reporting, adequate capital, liquidity management and timely recognition of impairment.

Technology improves analysis through automated data extraction, anomaly detection, continuous monitoring and scenario modelling. AI can identify unusual relationships, but it cannot replace accounting judgement. Models may reproduce biased historical decisions, misread changing economic conditions or generate unsupported explanations. Human review, data lineage, access controls, explainability and validation are therefore necessary.

Best practice is to combine statement analysis with industry knowledge, management discussion, non-financial indicators, stress testing and sensitivity analysis. A sound conclusion should state the evidence, assumptions, uncertainty and decision relevance.

Chapter Summary

Financial statements provide complementary views of performance and position. The income statement measures accrual-based profitability, the balance sheet reports resources and claims, and the cash-flow statement explains changes in cash. Horizontal, trend and common-size analysis reveal direction and structure. Profitability, liquidity, solvency and efficiency ratios convert statements into comparable indicators, but they require consistent definitions and suitable benchmarks.

The DuPont framework explains ROE through margin, asset turnover and leverage. Cash-flow and earnings-quality analysis tests whether reported profit is sustainable and supported by operating cash. Peer analysis must account for business-model and accounting differences. Finally, professional analysis requires attention to notes, estimates, governance, regulation, technology and ethical use of information.

Key Terms

Financial statements: Formal reports describing an entity’s financial performance and position.

Income statement: Statement reporting revenue, expenses and profit over a period.

Balance sheet: Statement reporting assets, liabilities and equity at a date.

Cash flow: Movement of cash and cash equivalents during a period.

Accrual accounting: Recognition of income and expenses when earned or incurred rather than only when cash moves.

Common-size analysis: Expressing statement items as percentages of a common base.

Trend analysis: Comparing values across periods using an indexed base period.

Ratio analysis: Evaluating relationships among financial statement amounts.

ROA: Net income relative to average total assets.

ROE: Profit attributable to ordinary shareholders relative to average ordinary equity.

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

Liquidity: Ability to meet obligations as they fall due.

Solvency: Ability to meet long-term obligations and absorb losses.

Asset turnover: Revenue generated per unit of average assets.

Equity multiplier: Average assets divided by average equity.

Cash conversion ratio: Operating cash flow divided by net income.

Free cash flow: Operating cash flow less a stated measure of capital expenditure.

Earnings quality: Sustainability and cash support underlying reported earnings.

Common-size statement: Statement in which items are expressed as percentages of a selected total.

Peer analysis: Comparison with economically similar organisations or benchmarks.

Review Questions

Short Answer Questions

  1. What is the accounting identity linking assets, liabilities and equity?
  2. Why may net income differ from operating cash flow?
  3. Define the current ratio.
  4. What three components make up the three-part DuPont identity?
  5. State two warning signs of weak earnings quality.

Long Answer Questions

  1. Explain how the income statement, balance sheet and cash-flow statement are interconnected.
  2. Discuss the usefulness and limitations of common-size and trend analysis.
  3. Explain how ROE can rise even when operating performance deteriorates.
  4. Compare liquidity analysis for a manufacturing company and a commercial bank.
  5. Discuss the governance and ethical risks involved in financial-statement analysis.

Analytical / Application Questions

  1. A firm’s revenue rises 25%, receivables rise 60%, net income rises 8% and operating cash flow falls 10%. Analyse what these changes may imply and identify further evidence required.
  2. A company has net margin of 6%, asset turnover of 1.5 and an equity multiplier of 2.0. Calculate ROE using the DuPont identity and explain the role of each component.
  3. A lender observes rising ROE, falling current ratio, increasing debt and declining cash conversion. Prepare a reasoned lending recommendation, including additional information and stress tests you would request.

Multiple Choice Questions with Answers

Question 1

Which statement is the fundamental balance-sheet identity?

A. Assets = Liabilities + Equity

B. Assets = Revenue − Expenses

C. Cash flow = Profit + Dividends

D. Equity = Assets + Liabilities

Correct Answer: A. Assets = Liabilities + Equity

Question 2

A company has revenue of 1,000 and EBIT of 150. What is its operating margin?

A. 6.7%

B. 15%

C. 66.7%

D. 850%

Correct Answer: B. 15%

Question 3

Which DuPont component measures revenue generated per unit of average assets?

A. Net margin

B. Equity multiplier

C. Asset turnover

D. Debt ratio

Correct Answer: C. Asset turnover

Question 4

If operating cash flow is 90 and net income is 120, the cash conversion ratio is:

A. 0.75

B. 1.33

C. 30

D. 210

Correct Answer: A. 0.75

Question 5

Which item is normally classified as an investing cash flow?

A. Cash paid to suppliers

B. Cash received from customers

C. Purchase of property, plant and equipment

D. Repayment of trade payables

Correct Answer: C. Purchase of property, plant and equipment

Question 6

If current assets are 480 and current liabilities are 320, the current ratio is:

A. 0.67

B. 1.00

C. 1.50

D. 2.00

Correct Answer: C. 1.50

Question 7

A rise in receivables substantially faster than revenue may indicate:

A. Improved cash collection with certainty

B. Potential collection or revenue-recognition concerns

C. Lower working-capital investment

D. Reduced credit exposure

Correct Answer: B. Potential collection or revenue-recognition concerns

Question 8

Free cash flow is commonly calculated as:

A. Net income + dividends

B. Operating cash flow − capital expenditure

C. Revenue − total assets

D. EBIT − equity

Correct Answer: B. Operating cash flow − capital expenditure

Question 9

If net margin is 5%, asset turnover is 2 and the equity multiplier is 1.5, DuPont ROE is:

A. 3.5%

B. 7.5%

C. 15%

D. 150%

Correct Answer: C. 15%

Question 10

Why should peer analysis use economically comparable firms?

A. To eliminate the need to read financial statements

B. Because ratios have identical meanings in every industry

C. Because business models, risks and accounting practices affect ratios

D. To ensure the largest firm is always the benchmark

Correct Answer: C. Because business models, risks and accounting practices affect ratios

Financial Analytics
Chapter 4 of 15