Financial Statement Analysis and Decision Support

Introduction and context

Financial statements are not merely historical records. Properly analysed, they provide evidence about profitability, liquidity, operating efficiency, financial risk, cash-generation capacity and the economic resources available to management and capital providers. Financial statement analysis converts reported accounting numbers into information that supports investment, lending, managerial and strategic decisions.

Analysis is necessarily interpretive. A ratio is not a conclusion; it is an indicator whose meaning depends on the entity’s business model, accounting policies, industry, economic conditions and reporting quality. A post-graduate analyst must therefore combine quantitative techniques with professional scepticism, business understanding and awareness of measurement limitations.

Learning objectives

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

1. Apply horizontal, vertical, ratio, cash-flow, profitability, liquidity, solvency and working-capital analysis.
2. Interpret performance using the DuPont framework.
3. Assess earnings quality and identify warning signs of aggressive reporting.
4. Prepare simple forecasts and derive valuation inputs from financial statements.
5. Use sensitivity and scenario analysis to support investment, lending, managerial and strategic decisions.
6. Communicate analytical conclusions while recognising uncertainty, accounting-policy effects and ethical constraints.

1. The analytical architecture

A sound analysis normally follows five stages:

1. Define the decision. An equity investor may focus on sustainable earnings and growth; a lender may focus on debt service and collateral; management may focus on margins, capacity and working capital.
2. Understand the business. Identify products, customers, suppliers, competitive forces, regulation, seasonality and the operating cycle.
3. Standardise and analyse the statements. Adjust for comparability, then apply trend, common-size, ratio and cash-flow techniques.
4. Challenge the evidence. Reconcile profit with cash, investigate unusual movements and assess accounting policies.
5. Translate analysis into action. State the implications, assumptions, risks and recommended decision.

The principal statements are interdependent. The statement of profit or loss explains performance during a period; the statement of financial position reports resources and claims at a date; the cash-flow statement explains changes in cash; and the notes reveal policies, estimates, commitments and risks. Analysis that ignores this interdependence is incomplete.

Comparative bases

Useful comparisons include:

2. Horizontal and vertical analysis

Horizontal analysis

Horizontal analysis measures change across periods. For an item with current value X_t and base-period value X₀, the percentage change is:

The formula assumes X₀ ≠ 0 and uses consistent classification and currency units. A negative base value can make the percentage difficult to interpret; in such cases, the absolute movement and narrative explanation are more informative.

For example, revenue rising from CU10 million to CU12 million represents a CU2 million increase and a 20% increase. If operating expenses rise from CU6 million to CU7.5 million, they increase by 25%; this may explain margin compression even though revenue growth is strong.

Trend analysis may use an index:

The base year is assigned 100. Indexes are especially useful when comparing items of different scale.

Vertical analysis

Vertical analysis expresses each statement item as a percentage of a relevant base. For the income statement, revenue is normally the base; for the statement of financial position, total assets or total equity and liabilities may be used.

A cost of CU42 million on revenue of CU100 million is a 42% revenue percentage. Common-size analysis helps identify structural changes, such as increasing distribution costs, declining gross margins or a rising proportion of intangible assets. It does not, by itself, establish causation.

3. Ratio analysis

Ratios condense relationships, but their usefulness depends on numerator and denominator consistency. Analysts should use average assets or average equity when a flow measure is compared with a balance accumulated over time, particularly where balances change materially during the year.

Profitability ratios

Margins are generally percentages. Returns are meaningful only when the profit measure and capital base are conceptually aligned. For example, using profit after tax with equity is appropriate for a shareholder perspective, while operating profit with operating assets may better measure operating performance before financing effects.

Liquidity ratios

The quick ratio excludes inventories and usually excludes prepaid expenses because they may not be readily convertible into cash. A high current ratio is not automatically favourable: obsolete inventory, overdue receivables or restricted cash may inflate it.

The cash ratio is:

Liquidity should also be assessed through the timing and reliability of operating cash flows, available credit facilities, covenant headroom and refinancing requirements.

Efficiency and working capital

If a 365-day convention is used:

The denominators should reflect the economic relationship: receivables arise from sales, while inventory and trade payables are more closely related to cost of sales. The cash conversion cycle is:

A shorter cycle generally reduces financing needs, but excessively low inventory or delayed supplier payments may damage customer service or supplier relationships. Working-capital analysis should therefore combine efficiency with operational resilience.

Solvency and leverage

Here EBIT means earnings before interest and tax. Interest cover is meaningful when finance costs are recurring and EBIT is not distorted by exceptional items. A cash-based alternative is:

The appropriate leverage measure depends on the lender’s claim, lease accounting, cash balances, guarantees and covenant definitions. Analysts should never assume that a published ratio uses the same definitions as a loan agreement.

4. Cash-flow analysis

Profit is affected by accruals, estimates and non-cash items. Cash-flow analysis tests whether reported performance is converted into liquidity.

The principal categories are operating, investing and financing cash flows. Operating cash flow indicates cash generated by the business’s main activities; investing cash flow includes purchases and disposals of long-term assets and investments; financing cash flow includes borrowings, repayments, equity transactions and dividends.

A useful reconciliation is:

This is an analytical measure, not a universally defined accounting subtotal. The analyst must specify whether capital expenditure includes acquisitions, capitalised development costs or leased assets.

Cash-flow quality indicators include:

The accrual ratio is a screening indicator. A persistently high positive value may indicate that earnings are not converting into cash, although growth, seasonal working capital and legitimate long-term contracts can explain temporary differences.

Worked example: integrated interpretation

Illustrative Company A reports revenue of CU50 million, operating profit of CU6 million, profit after tax of CU3.6 million, average assets of CU30 million, average equity of CU15 million, operating cash flow of CU2.4 million and capital expenditure of CU1.5 million.

Operating margin is CU6m ÷ CU50m = 12%. Return on assets is CU3.6m ÷ CU30m = 12%. Return on equity is CU3.6m ÷ CU15m = 24%. Free cash flow is CU2.4m − CU1.5m = CU0.9m. Cash conversion relative to net profit is CU2.4m ÷ CU3.6m = 66.7%.

The company appears profitable, but only two-thirds of accounting profit converted into operating cash. The conclusion is not automatically negative: the analyst should investigate receivables growth, inventory investment, contract timing, tax payments and whether capital expenditure is sufficient to maintain productive capacity.

5. DuPont analysis

DuPont analysis decomposes return on equity into profitability, asset utilisation and financial leverage. Under the conventional three-part model:

The terms are, respectively, net profit margin, total asset turnover and the equity multiplier. Algebraically, revenue and assets cancel, leaving net income divided by average equity. The model assumes consistent period definitions and avoids mixing year-end assets with a full-year income measure where average balances are available.

Suppose net margin is 6%, asset turnover is 1.5 times and the equity multiplier is 2.0. ROE equals 0.06 × 1.5 × 2.0 = 18%. Management can improve ROE through better margins, more efficient asset use or greater leverage. Only the first two necessarily improve economic performance; leverage can increase both return and financial risk.

An extended version may separate operating performance, tax burden, interest burden and leverage. Such decomposition is useful for diagnosing whether a change in ROE arises from operations, financing or taxation rather than treating ROE as a single undifferentiated outcome.

6. Earnings quality and reporting risk

Earnings quality concerns the sustainability, cash support and economic relevance of reported profit. High-quality earnings generally arise from recurring operations, are supported by cash generation and depend on reasonable, transparent estimates. Low-quality earnings may be volatile, heavily dependent on one-off gains, aggressive estimates or transactions that shift costs between periods.

Important diagnostic questions include:

• Are revenue growth and receivables growth consistent?
• Are non-GAAP adjustments recurring despite being labelled exceptional?
• Are provisions, impairment losses and useful lives changing without persuasive economic reasons?
• Does operating cash flow lag profit over several periods?
• Are related-party transactions material or opaque?
• Are inventory levels and returns consistent with reported sales?
• Is capitalised expenditure replacing expenses that would normally be recognised immediately?
• Do covenant pressures create incentives for optimistic classification or estimation?

Analysts should distinguish fraud risk from ordinary estimation uncertainty. A loss allowance, warranty provision or fair-value estimate may be uncertain without being improper. The appropriate response is corroboration: inspect note disclosures, compare assumptions with historical outcomes, examine post-year-end cash receipts and challenge management’s sensitivity analysis.

Professional ethics require faithful representation, independence, confidentiality and avoidance of confirmation bias. Analysts must not present a favourable conclusion merely because it is commercially convenient.

7. Forecasting and valuation inputs

Forecasting converts historical relationships and strategic assumptions into expected future performance. A simple revenue forecast is:

where g is the assumed growth rate. If current revenue is CU80 million and expected growth is 7%, forecast revenue is CU85.6 million.

A margin-based operating-profit forecast is:

Working-capital forecasts can use days assumptions. For example:

These formulas assume a reasonably stable relationship between activity and balance levels. They are less reliable for seasonal businesses, rapidly changing payment terms or businesses experiencing structural disruption.

For a discounted cash-flow model, enterprise value may be represented as:

where FCF_t is forecast free cash flow in period t, WACC is the weighted average cost of capital, TV is terminal value, and n is the number of explicit forecast periods. Under a perpetual-growth terminal model:

where FCF_n+1 = FCF_n × (1 + g) and the essential condition is WACC > g. The model is highly sensitive to terminal assumptions; terminal value should therefore be tested rather than presented as a precise fact.

Valuation inputs derived from financial statements include margins, tax rates, reinvestment, depreciation, capital expenditure, working-capital investment and leverage. Historical averages should not be adopted mechanically: strategic plans, competitive conditions and industry economics determine whether they are sustainable.

8. Sensitivity and scenario analysis

Sensitivity analysis changes one assumption while holding others constant. For example, an analyst may measure valuation under revenue growth rates of 3%, 5% and 7%. It identifies variables to which the decision is most exposed but does not represent a complete future state.

Scenario analysis changes several logically connected assumptions. A downside scenario might combine lower volume, margin compression, slower collections and higher interest rates. An upside scenario might combine successful product adoption, stable pricing and improved working capital.

A compact decision table may be structured as follows:

Scenario analysis should identify trigger points, such as minimum interest cover or maximum cash burn. It is most useful when linked to management actions: reduce discretionary capital expenditure, renegotiate facilities, revise prices or delay expansion.

9. Applied case: Meridian Components Ltd

Background

The following is an illustrative case. Meridian Components Ltd manufactures industrial parts and is seeking a CU12 million loan to expand capacity. The lender is concerned that profit growth may not translate into repayment capacity.

Evidence

Revenue increased from CU40 million to CU50 million. Operating profit increased from CU4.4 million to CU5 million, so the operating margin declined from 11% to 10%. Average receivables increased from CU6 million to CU9 million, while average inventory increased from CU7 million to CU10 million. Revenue-based receivables days rose from 54.8 days to 65.7 days. If cost of sales is CU35 million in the current year, inventory days are approximately 104.3 days, calculated as CU10m ÷ CU35m × 365. Operating cash flow was CU1.8 million against profit after tax of CU3.1 million; capital expenditure was CU2.6 million.

Analysis

Growth is positive, but margin compression suggests that additional sales are less profitable. The increase in receivables days may reflect weaker customer quality or relaxed credit terms. Inventory days are high and require explanation by production lead times and order visibility. Operating cash flow is below profit, and free cash flow is negative: CU1.8m − CU2.6m = −CU0.8m.

The lender should not rely on the current ratio alone. It should examine an aged receivables schedule, inventory obsolescence, confirmed orders, customer concentration, borrowing-base eligibility, forecast covenant ratios and the maturity profile of existing debt.

Approach and solution

Management proposes tighter credit approval, a staged inventory-purchasing system and a price review for customised products. The lender could approve the facility in tranches, require monthly cash-flow reporting and set covenants based on minimum interest cover and maximum leverage. The forecast should include a downside case in which revenue growth falls to 2%, receivables days rise to 70 and the operating margin falls to 8%.

Outcome

The decision should be conditional rather than based solely on reported profit. If the downside case produces adequate liquidity and covenant headroom, the loan may be supportable with controls. If it produces a cash deficit or covenant breach, expansion should be delayed or funded with additional equity.

Learning points

The case demonstrates that revenue growth can coexist with weaker margins, slower cash collection and negative free cash flow. Integrated analysis is more decision-useful than any isolated ratio.

10. Technology, governance and contemporary practice

Spreadsheet models remain common, but version control, locked formulas, documented assumptions and independent review are essential. Business-intelligence systems can automate trend analysis and anomaly detection, while machine-learning tools may identify unusual journal entries or relationships between sales and returns. Such tools do not replace professional judgement. Their outputs may reflect biased data, unstable relationships or opaque algorithms.

Governance practice increasingly connects financial analysis with climate, supply-chain, cyber and human-capital risks. These risks may affect impairment, provisions, useful lives, revenue forecasts, financing costs and going-concern assessments. Analysts should read relevant sustainability and risk disclosures alongside the financial statements, while distinguishing audited information from management estimates.

Best practice includes reconciling all analytical inputs to published statements, documenting definitions, using average balances where appropriate, testing material assumptions, investigating unusual movements, separating fact from forecast and communicating uncertainty explicitly.

Challenges and limitations

Financial statement analysis is limited by historical cost, estimation, aggregation, inflation, seasonality and differences in accounting policy. Ratios may be distorted by acquisitions, disposals, restructuring, lease classification, foreign exchange movements or denominator effects. A declining ratio can result from a strong denominator rather than worsening operations. Cross-company comparisons can be misleading when entities pursue different strategies.

No analytical model eliminates uncertainty. The appropriate objective is not false precision but a disciplined range of plausible outcomes, supported by evidence and subject to revision as new information arrives.

Chapter Summary

Financial statement analysis transforms reported accounting information into decision support. Horizontal analysis identifies changes over time, while vertical analysis reveals structural relationships. Profitability, liquidity, efficiency, working-capital and solvency ratios provide focused indicators, but they must be interpreted in context and reconciled with cash flows. The cash conversion cycle links receivables, inventory and payables to financing needs.

DuPont analysis decomposes return on equity into margin, asset turnover and leverage, allowing analysts to distinguish operating improvement from riskier financial gearing. Earnings-quality assessment examines sustainability, cash support, estimation risk and unusual transactions. Forecasting uses activity drivers, margins and working-capital assumptions; valuation requires disciplined free-cash-flow and discount-rate assumptions. Sensitivity and scenario analysis expose decision vulnerability and support contingency planning. Effective professional analysis combines quantitative evidence, business understanding, scepticism, ethical conduct and clear communication.

Key Terms

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

Horizontal analysis: Measurement of changes in financial statement items across periods.

Vertical analysis: Expression of statement items as percentages of a common base.

Common-size statement: A statement in which items are shown as percentages of a relevant total.

Profitability: The capacity to generate profit relative to sales, assets or equity.

Liquidity: The capacity to meet obligations as they fall due.

Solvency: The capacity to meet long-term obligations and remain financially viable.

Working capital: Current operating resources, commonly current assets less current liabilities.

Cash conversion cycle: Receivables days plus inventory days less payables days.

Operating cash flow: Cash generated from principal revenue-producing activities.

Free cash flow: An analytical measure commonly defined as operating cash flow less capital expenditure.

DuPont analysis: Decomposition of return on equity into margin, asset turnover and leverage.

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

Accrual: Recognition of income or expense before the related cash movement.

Forecast: A reasoned estimate of future financial outcomes.

Sensitivity analysis: Testing the effect of changing one assumption at a time.

Scenario analysis: Testing a coherent combination of changed assumptions.

Enterprise value: Value attributed to the operating business before considering the allocation between debt and equity.

Covenant: A contractual financial or operational condition imposed by a lender.

Professional scepticism: A questioning mindset that critically evaluates evidence and estimates.

Review Questions

Short Answer Questions

1. Distinguish horizontal analysis from vertical analysis.
2. Why may average assets be preferable to year-end assets when calculating return on assets?
3. Define the cash conversion cycle.
4. What does the equity multiplier represent in DuPont analysis?
5. Give two indicators of potentially weak earnings quality.

Long Answer Questions

1. Explain how profitability, liquidity and solvency analysis answer different decision-maker questions.
2. Discuss the strengths and limitations of ratio analysis for cross-company comparison.
3. Explain how operating cash flow can differ materially from net profit.
4. Describe the assumptions and limitations of a discounted cash-flow valuation.
5. Evaluate the ethical responsibilities of an analyst reporting an optimistic forecast.

Analytical / Application Questions

1. A company reports revenue of CU100 million, cost of sales of CU60 million, operating profit of CU12 million and profit after tax of CU7.2 million. Calculate gross margin, operating margin and net margin, then interpret the results.
2. Average receivables are CU8 million, revenue is CU48 million, average inventory is CU9 million, cost of sales is CU30 million and average payables are CU6 million. Calculate receivables days, inventory days, payables days and the cash conversion cycle using 365 days.
3. A prospective borrower shows rising profit but falling operating cash flow, increasing receivables days and declining interest cover. Recommend the additional evidence and safeguards a lender should require before approving finance.

Multiple Choice Questions with Answers

Question 1

Revenue rises from CU10 million to CU12 million. What is the percentage increase?

A. 2%

B. 12%

C. 20%

D. 120%

Correct Answer: C. 20%

Question 2

Which ratio most directly measures the time cash is tied up in the operating cycle?

A. Debt-to-equity ratio

B. Cash conversion cycle

C. Net profit margin

D. Equity multiplier

Correct Answer: B. Cash conversion cycle

Question 3

A company has net profit margin of 5%, asset turnover of 2 times and an equity multiplier of 1.5. What is ROE under the three-part DuPont model?

A. 7.5%

B. 10%

C. 15%

D. 30%

Correct Answer: C. 15%

Question 4

Which finding is most suggestive of a cash-conversion concern?

A. Operating cash flow consistently exceeds profit

B. Receivables days decline while sales remain stable

C. Profit rises while operating cash flow persistently falls

D. Capital expenditure is funded from operating cash flow

Correct Answer: C. Profit rises while operating cash flow persistently falls

Question 5

If revenue is CU50 million and average receivables are CU5 million, using 365 days, receivables days are:

A. 18.25 days

B. 36.5 days

C. 50 days

D. 73 days

Correct Answer: B. 36.5 days

Question 6

Which item is normally excluded from the quick ratio?

A. Cash

B. Trade receivables

C. Short-term investments

D. Inventory

Correct Answer: D. Inventory

Question 7

In a perpetual-growth terminal-value model, which condition is essential?

A. Growth must exceed WACC

B. WACC must exceed growth

C. Growth must equal inflation exactly

D. WACC must be zero

Correct Answer: B. WACC must exceed growth

Question 8

What does sensitivity analysis normally do?

A. Changes one assumption while holding others constant

B. Eliminates forecast uncertainty

C. Changes all assumptions randomly

D. Replaces financial statements

Correct Answer: A. Changes one assumption while holding others constant

Question 9

A business has operating cash flow of CU4 million and capital expenditure of CU1.5 million. Its analytical free cash flow is:

A. CU2.5 million

B. CU5.5 million

C. CU1.5 million

D. CU4 million

Correct Answer: A. CU2.5 million

Question 10

Which action best reflects professional scepticism?

A. Accepting management’s forecast without testing

B. Ignoring the notes because ratios are sufficient

C. Investigating unusual receivables growth and checking subsequent collections

D. Selecting only the most favourable scenario

Correct Answer: C. Investigating unusual receivables growth and checking subsequent collections