Ratio Analysis and Cash Flow Analysis

Introduction and Context

Financial statements describe an organisation’s financial position and performance, but their absolute figures are often difficult to interpret in isolation. Ratio analysis converts accounting data into relationships that support comparison, diagnosis and decision-making. Cash flow analysis complements ratio analysis by showing how cash is generated and used. This distinction is essential: a company may report accounting profit while experiencing serious cash shortages, or may report low profit while generating strong cash flows because of non-cash expenses or working-capital changes.

For MBA managers, the purpose of analysis is not merely to calculate ratios. It is to determine whether observed results are economically sustainable, identify the drivers of performance, compare the organisation with relevant benchmarks and translate findings into decisions about pricing, investment, financing, working capital and risk.

Learning Objectives

After studying this chapter, you should be able to:

1. Explain the purpose, assumptions and limitations of financial ratio analysis.
2. Calculate and interpret profitability, liquidity, efficiency, solvency and market-performance ratios.
3. Apply DuPont analysis to explain return on equity.
4. Prepare and interpret operating, investing and financing cash flows.
5. Use benchmarking and trend analysis appropriately.
6. Integrate ratios and cash-flow information in managerial decisions.
7. Evaluate ethical, technological and governance issues affecting financial analysis.

1. Foundations of Ratio Analysis

A ratio is a mathematically expressed relationship between two or more accounting quantities. Ratios are useful because they standardise information across periods and firms of different sizes. A ratio does not, however, provide an automatic conclusion. Interpretation depends on industry economics, accounting policies, business strategy, inflation, seasonality and the quality of the underlying data.

1.1 Comparative bases

Three comparison bases are especially important:

• Trend analysis: compares a firm with itself over time. It reveals direction and stability.
• Cross-sectional analysis: compares firms at the same date, commonly against competitors.
• Benchmark analysis: compares performance with a target, industry median, best-in-class organisation or covenant requirement.

The denominator must be economically meaningful. For example, sales growth may be compared with asset growth, while interest expense should be assessed against operating income or cash available for debt service. Analysts should normally use average balance-sheet amounts when an income-statement flow is related to a balance-sheet stock:

This is appropriate when activity occurs throughout the period and beginning and ending balances are representative. If business is highly seasonal, monthly or quarterly averages are preferable.

1.2 Common-size analysis

Common-size statements express each item as a percentage of a base. In an income statement, each item is commonly expressed as a percentage of revenue. In a balance sheet, assets may be expressed as a percentage of total assets and liabilities and equity as a percentage of total financing. Common-size analysis helps identify structural changes even when total size changes substantially.

2. Profitability Analysis

Profitability ratios evaluate the organisation’s ability to generate returns from sales, assets and owners’ investment. They should be interpreted alongside growth, risk and cash generation.

2.1 Gross profit margin

Gross profit equals revenue less cost of goods sold. The margin indicates the amount available to cover operating expenses, financing costs and tax after direct production or purchase costs. A falling margin may reflect price reductions, input-cost inflation, adverse product mix or inefficiency. Service firms may use contribution margin or operating margin instead because conventional cost-of-goods classifications differ.

2.2 Operating profit margin

This measures profit from core operations before interest and tax. It is useful for comparing operating performance independently of capital structure and tax jurisdiction. It should not be interpreted as a complete measure of value creation because it ignores the capital invested to generate the operating profit.

2.3 Net profit margin

The net margin reflects the combined effects of operating performance, financing, tax and non-operating items. A higher margin is generally favourable, but managers must investigate whether it arises from recurring operations or from a one-time gain.

2.4 Return on assets

ROA measures the return generated by the asset base. Comparisons are most meaningful among firms with similar asset intensity and accounting policies. An alternative operating perspective is:

The analyst must state which definition is used; otherwise comparisons may be misleading.

2.5 Return on equity

ROE measures the return earned on shareholders’ book investment. It can increase because of stronger margins, better asset utilisation or greater financial leverage. High ROE is not automatically desirable if it results from excessive debt or a very small equity base.

3. Liquidity Analysis

Liquidity is the ability to meet obligations as they fall due without unacceptable losses. Liquidity ratios focus mainly on current assets and current liabilities, but ratios alone cannot establish whether payments will actually be made. Timing of receipts and payments is crucial.

3.1 Current ratio

A ratio of 1.8 means the firm reports 1.80 monetary units of current assets for each monetary unit of current liabilities. A high ratio may indicate safety, but it can also signal excess inventory, slow receivables or idle cash. Industry norms and the quality of current assets determine its meaning.

3.2 Quick ratio

The quick ratio excludes inventory and other less-liquid current assets. It is more conservative where inventory is difficult to sell. Receivables should not automatically be treated as cash-like: overdue, disputed or concentrated receivables may have low realisable value.

3.3 Cash ratio

This is the most restrictive conventional liquidity ratio. It is particularly relevant during financial stress, although holding excessive cash may reduce returns.

3.4 Operating cash flow ratio

This ratio uses realised operating cash rather than potentially subjective accrual amounts. It is affected by payment timing and seasonality, so a single year should be interpreted cautiously.

4. Efficiency and Activity Analysis

Efficiency ratios examine how effectively resources are managed. They link income-statement flows to working-capital or asset balances.

4.1 Receivables turnover and collection period

If credit sales are unavailable, total revenue may be used with an explicit limitation. The approximate collection period is:

A lengthening period may indicate weak credit control, customer distress or a deliberate relaxation of credit terms to stimulate sales.

4.2 Inventory turnover and days inventory

Higher turnover can indicate efficient inventory management, but an excessively high figure may indicate stock-outs and lost sales. Comparisons require similar valuation methods and product characteristics.

4.3 Payables period

Credit purchases are preferable to cost of goods sold. If purchases are unavailable, analysts may use cost of goods sold as an approximation, but this should be disclosed. A longer period may improve cash retention but may damage supplier relationships or cause loss of early-payment discounts.

4.4 Total asset turnover

This indicates how many monetary units of revenue are generated per monetary unit invested in assets. Asset turnover is influenced by business model, capacity utilisation, asset age and depreciation policy.

4.5 Cash conversion cycle

The cash conversion cycle estimates the time between cash paid to suppliers and cash collected from customers:

A shorter cycle generally reduces financing needs, provided service quality and supplier relationships are maintained. A negative cycle, common in some retail models, means customers pay before suppliers are paid.

5. Solvency and Financial Risk

Solvency concerns the ability to meet long-term obligations and remain financially viable. Solvency analysis considers leverage, interest burden, debt maturity and cash-flow capacity.

5.1 Debt-to-equity ratio

Definitions vary: some analysts include only borrowings, while others include all liabilities. The chosen definition must be stated. Higher leverage can increase ROE when operating returns exceed the after-tax cost of debt, but it also increases financial distress risk.

5.2 Debt ratio

This describes the proportion of assets financed by liabilities. It is not identical to debt-to-equity because total liabilities include non-interest-bearing obligations such as trade payables.

5.3 Interest coverage

A low result indicates limited protection for lenders. EBIT-based coverage ignores taxes, capital expenditure and principal repayments. A cash-based measure may therefore be more informative:

The exact definition should be aligned with the lender’s covenant and the accounting classification of interest paid.

5.4 Debt service coverage

A common version is:

Because definitions of cash available differ, DSCR should never be compared without examining the covenant wording. Debt maturity concentration and refinancing risk may matter more than a satisfactory annual average.

6. Market-Performance Ratios

Market ratios connect accounting information with share-market prices. They are relevant mainly to listed firms and are affected by investor expectations, interest rates and market sentiment.

6.1 Earnings per share

Weighted-average shares are required when shares are issued or repurchased during the period. Diluted EPS additionally reflects instruments that could increase ordinary shares, such as options or convertible securities, when dilution is applicable.

6.2 Price–earnings ratio

A high P/E may indicate strong expected growth, low perceived risk or temporarily depressed earnings. A low P/E may indicate undervaluation, weak prospects or high risk. P/E is not meaningful when earnings are negative.

6.3 Dividend yield and payout

The payout ratio must be interpreted with free cash flow, reinvestment opportunities and debt commitments. Dividends cannot be sustainably maintained if they consistently exceed distributable cash generation.

7. DuPont Analysis

DuPont analysis decomposes ROE into drivers rather than treating it as a single outcome. The three-step model is:

Thus:

The identity follows because revenue and average assets cancel algebraically. The components represent profitability, efficiency and financial leverage. The model assumes consistent definitions and compatible periods.

A four-step version separates operating performance from financing and tax effects, while a five-step version may distinguish tax burden, interest burden, operating margin, asset turnover and leverage. These decompositions are diagnostic, not causal proof. For example, a high asset turnover may result from underinvestment rather than superior management.

Illustration. Suppose net margin is 6%, asset turnover is 1.5 times and the equity multiplier is 2.0. Then:

Management can examine whether improving margins, using assets more productively or changing financing would create value, while considering the risk attached to each action.

8. Cash Flow Analysis

Cash-flow analysis classifies cash movements into operating, investing and financing activities. Under international reporting practice, the cash-flow statement reconciles opening and closing cash and cash equivalents. Cash equivalents are short-term, highly liquid investments readily convertible to known amounts of cash and subject to insignificant risk of changes in value; classification must follow the applicable reporting framework.

8.1 Operating activities

Operating cash flows arise from the principal revenue-producing activities of the entity. Cash receipts from customers and payments to suppliers and employees are typical examples. Positive operating cash flow over time is normally essential for a sustainable business.

The direct method reports major classes of gross cash receipts and payments. The indirect method begins with profit and adjusts for non-cash items and changes in operating working capital. A simplified indirect reconciliation is:

An increase in trade receivables is subtracted because revenue has been recognised without receiving cash. An increase in inventory is subtracted because cash has been invested in stock. An increase in trade payables is added because expenses or purchases have been recognised while payment has not yet occurred. Non-cash depreciation is added back because it reduced profit but not cash.

8.2 Investing activities

Investing cash flows concern acquisition and disposal of long-term assets and investments. Capital expenditure is usually a cash outflow, while proceeds from selling property, plant and equipment are inflows. Sustained negative investing cash flow may indicate expansion, but it may also indicate acquisitions that fail to generate adequate returns.

8.3 Financing activities

Financing cash flows arise from transactions with providers of capital. Borrowing and issuing shares are inflows; repayment of borrowings, share repurchases and dividends are outflows, subject to the applicable reporting framework and classification policies.

8.4 Free cash flow

A commonly used managerial measure is:

This is not a single universally mandated accounting measure. Analysts must define whether capital expenditure means purchases of property, plant and equipment only, or includes software, acquisitions and other investment. Free cash flow indicates cash potentially available for debt reduction, dividends, acquisitions or reinvestment, but it is not identical to cash available for distribution.

9. Integrated Worked Example

Assume Delta Manufacturing reports the following amounts for the year (currency units): revenue 1,000; cost of goods sold 600; operating profit 120; profit after tax 72; average assets 800; average equity 400; current assets 300; current liabilities 200; cash and equivalents 60; trade receivables 120; average inventory 180; average payables 100; credit sales 900; credit purchases 500; operating cash flow 110; capital expenditure 70; interest expense 20.

Selected calculations are:

The current ratio appears reasonable, but the quick ratio below one indicates reliance on inventory or continuing cash receipts to meet current liabilities. The 85-day cash conversion cycle ties cash up for a substantial period. Operating cash flow is positive and exceeds capital expenditure, which is encouraging, but managers should assess whether the capital expenditure is sufficient to maintain productive capacity. The 18% ROE should be decomposed through DuPont analysis before concluding that performance is strong.

10. Benchmarking and Interpretation

Benchmarking should compare like with like. A premium retailer, a regulated utility and a software platform will naturally have different margins, asset structures and working-capital cycles. Useful benchmarks include:

• the firm’s historical median rather than one unusual year;
• competitors with comparable products and accounting policies;
• industry quartiles or sector databases;
• budgets and strategic targets;
• lender covenants and minimum liquidity thresholds.

Managers should investigate both favourable and unfavourable variances. A margin above the industry average may reflect genuine advantage, underinvestment in research, or temporary pricing conditions. A low current ratio may be efficient for a cash-generative retailer but dangerous for a construction company with long collection cycles.

11. Limitations, Ethics and Governance

Ratio and cash-flow analysis has significant limitations:

1. Accounting-policy differences: depreciation methods, inventory valuation, leasing treatment and provisions affect comparability.
2. Historical-cost measurement: reported assets may not reflect current economic values, especially during inflation.
3. Seasonality: year-end balances may not represent normal conditions.
4. Aggregation: ratios conceal differences among products, customers and regions.
5. Inflation and currency changes: nominal figures may distort trends and international comparisons.
6. Window dressing: delaying payments, accelerating collections or making temporary borrowings near year-end can improve reported ratios.
7. One-off items: restructuring gains, asset sales or litigation costs may distort margins.
8. Denominator problems: negative equity, negative earnings or near-zero denominators can make ratios meaningless.
9. Causality: ratios identify associations and symptoms; they do not prove why performance changed.
10. Off-balance-sheet exposure: guarantees, commitments and some contractual risks may not be visible in conventional ratios.

Ethical analysis requires faithful representation, transparent definitions and avoidance of selective benchmarking. Analysts should not alter definitions merely to achieve a desired conclusion. Audit committees and boards should review non-GAAP measures, covenant calculations and unusual working-capital movements. Regulatory reporting standards provide a foundation, but managerial analysis also requires reconciliation to audited statements and disclosure of assumptions.

Digital reporting systems and AI tools can accelerate extraction, trend detection and anomaly screening. Nevertheless, AI-generated analysis may misclassify transactions, reproduce biased benchmarks or mistake correlation for causation. Human review, source reconciliation, access controls, model documentation and explainable calculations remain essential. Technology improves speed; it does not replace professional judgement.

12. Applied Case: Orion Foods Ltd. (Illustrative)

Background

Orion Foods has grown revenue by 18% over two years. Its reported net profit has also increased, and management proposes further expansion financed by short-term borrowing.

Problem

The board is concerned that operating cash flow fell from 90 to 35 million currency units while profit increased from 50 to 62 million. The current ratio declined from 1.7 to 1.1, receivable days rose from 42 to 68, and inventory days rose from 70 to 105.

Analysis

The apparent profit improvement is not converting into cash. The increase in receivables indicates that sales have been recognised faster than cash has been collected. Higher inventory days suggest production exceeded sales or that obsolete stock is accumulating. The cash conversion cycle has lengthened substantially. Short-term borrowing may temporarily fund the gap, but it increases refinancing and interest risk. DuPont analysis shows that asset turnover has fallen despite revenue growth, indicating that assets are expanding faster than sales.

Approach and solution

The board should require a customer-level receivables review, revised credit limits, collection incentives and an ageing-based expected-credit-loss assessment. Inventory should be segmented using demand forecasts, with purchasing and production aligned to sell-through. Expansion should be staged until operating cash flow improves. Management should monitor weekly cash forecasts, operating cash flow, collection days, inventory days, covenant headroom and free cash flow.

Outcome

After six months, receivable days fall to 52 and inventory days to 82. Operating cash flow rises to 78 million, while expansion proceeds only after debt-service capacity is demonstrated. The case illustrates why profit growth, liquidity, efficiency and cash flow must be analysed together.

Learning points

• Growth can consume cash when working capital expands.
• A current ratio does not reveal the timing or quality of current assets.
• Cash-flow analysis tests the sustainability of reported profit.
• Ratio trends are most useful when linked to operational actions.

Best-Practice Analytical Process

A disciplined analyst should:

1. Obtain audited statements, notes, accounting policies and segment information.
2. Define every ratio consistently and record numerator and denominator choices.
3. Use average balances where appropriate and adjust for seasonality.
4. Examine trends, peer benchmarks and strategic targets together.
5. Reconcile profit to operating cash flow and investigate large adjustments.
6. Separate recurring from non-recurring items.
7. Analyse working-capital movements and debt maturities.
8. Perform sensitivity analysis under weaker sales, slower collections or higher interest rates.
9. Present conclusions with evidence, assumptions and uncertainty.
10. Convert findings into accountable decisions and monitoring indicators.

Chapter Summary

Ratio analysis transforms financial-statement data into measures of profitability, liquidity, efficiency, solvency and market performance. Profitability ratios assess returns from sales, assets and equity; liquidity ratios assess short-term payment capacity; efficiency ratios evaluate working-capital and asset utilisation; solvency ratios assess leverage and debt-service capacity; and market ratios connect accounting performance with investor valuation. DuPont analysis decomposes ROE into margin, asset turnover and leverage, helping managers identify performance drivers. Cash-flow analysis classifies cash movements into operating, investing and financing activities and tests whether accounting profit is supported by cash. Benchmarking is valuable only when firms, periods, definitions and business models are comparable. Because ratios are affected by accounting policy, seasonality, inflation, one-off items and possible manipulation, they must be interpreted critically and integrated with cash forecasts, strategy, governance and professional judgement.

Key Terms

Ratio analysis: Examination of relationships among financial-statement amounts.

Trend analysis: Comparison of financial measures across time.

Benchmarking: Comparison with targets, peers, industry norms or best practice.

Gross profit margin: Gross profit expressed as a percentage of revenue.

Operating profit margin: Operating profit expressed as a percentage of revenue.

ROA: Profitability generated by average assets.

ROE: Return earned on shareholders’ equity.

Liquidity: Capacity to meet obligations as they fall due.

Current ratio: Current assets divided by current liabilities.

Quick ratio: Highly liquid current assets divided by current liabilities.

Receivables turnover: Credit sales relative to average receivables.

Inventory turnover: Cost of goods sold relative to average inventory.

Cash conversion cycle: Time cash is tied up between supplier payment and customer collection.

Solvency: Ability to meet long-term obligations and remain viable.

Interest coverage: EBIT divided by interest expense.

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

Operating cash flow: Cash generated or consumed by principal operating activities.

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

Window dressing: Temporary actions that improve reported financial measures near a reporting date.

Review Questions

5 Short Answer Questions

1. Why are average balance-sheet amounts often used with income-statement flows?
2. Distinguish the current ratio from the quick ratio.
3. What does the cash conversion cycle measure?
4. Why can a high ROE be associated with high risk?
5. Identify the three categories in a cash-flow statement.

5 Long Answer Questions

1. Explain the purpose, calculation and interpretation of profitability ratios.
2. Discuss how liquidity and efficiency ratios should be interpreted together.
3. Explain the three-step DuPont model and its managerial value.
4. Compare the direct and indirect methods of presenting operating cash flows.
5. Critically evaluate the limitations of ratio analysis for cross-company comparison.

3 Analytical / Application Questions

1. A firm reports revenue of 2,000, profit after tax of 120, average assets of 1,000 and average equity of 500. Calculate net margin, ROA and ROE, and explain why the three results provide different information.
2. A company’s receivable days rise from 35 to 60 while revenue grows by 20% and operating cash flow falls. Diagnose possible causes and recommend three management actions.
3. A business has positive profit, negative operating cash flow and a rapidly increasing current ratio. Explain how these outcomes can occur and design a short-term investigative plan.

Multiple Choice Questions with Answers

Question 1

Which ratio primarily measures the return earned on ordinary shareholders’ book investment?

A. Current ratio

B. Return on equity

C. Inventory turnover

D. Interest coverage

Correct Answer: B. Return on equity

Question 2

A company has current assets of 500 and current liabilities of 250. Its current ratio is:

A. 0.5

B. 1.0

C. 2.0

D. 2.5

Correct Answer: C. 2.0

Question 3

Which item is normally added back in an indirect operating cash-flow reconciliation because it reduces profit but not cash?

A. Trade receivables

B. Inventory purchases

C. Depreciation expense

D. Dividend payment

Correct Answer: C. Depreciation expense

Question 4

If net profit margin is 5%, asset turnover is 2 times and the equity multiplier is 3, DuPont ROE equals:

A. 10%

B. 15%

C. 30%

D. 60%

Correct Answer: C. 30%

Question 5

The cash conversion cycle is calculated as:

A. Inventory days + receivable days − payable days

B. Inventory days − receivable days + payable days

C. Receivable days + payable days − inventory days

D. Payable days − inventory days − receivable days

Correct Answer: A. Inventory days + receivable days − payable days

Question 6

Which ratio is most directly concerned with the ability to cover interest from operating earnings?

A. Gross margin

B. Interest coverage

C. Quick ratio

D. Dividend yield

Correct Answer: B. Interest coverage

Question 7

A rise in trade receivables, with all else equal, generally causes operating cash flow under the indirect method to:

A. Increase

B. Remain unchanged

C. Decrease

D. Become equal to profit

Correct Answer: C. Decrease

Question 8

Which is a common limitation of cross-company ratio comparison?

A. Ratios always include market prices

B. Accounting policies may differ between firms

C. Ratios cannot be calculated from statements

D. Ratios measure only cash transactions

Correct Answer: B. Accounting policies may differ between firms

Question 9

Free cash flow as defined in this chapter is:

A. Profit after tax plus dividends

B. Operating cash flow minus capital expenditure

C. Revenue minus operating expenses

D. Cash borrowings minus interest

Correct Answer: B. Operating cash flow minus capital expenditure

Question 10

A high asset turnover most directly indicates that a firm:

A. Generates relatively high revenue from its asset base

B. Has no financial risk

C. Has a high cash ratio

D. Must have a high gross margin

Correct Answer: A. Generates relatively high revenue from its asset base