prepare and comment on simple statements showing comparison of results for different years

6.2 Interpretation of Accounting Ratios

Learning Objectives

By the end of this section you will be able to:

  • Prepare a simple statement that compares the financial results of a business for two (or more) years.
  • Calculate the eight ratios required by the Cambridge IGCSE Accounting (0452) syllabus.
  • Interpret what a high or low figure for each ratio indicates about the business.
  • Make a specific, sensible recommendation linked to each ratio.
  • Use the ratios to compare the business with a competitor or an industry benchmark.
  • Identify which external parties use each ratio and why.

Why Ratios Are Useful

  • They condense large amounts of financial data into a single, comparable figure.
  • They enable two types of comparison:
    • Trend analysis – across different years of the same business.
    • Inter‑firm analysis – with another business or the industry average.
  • They highlight strengths, weaknesses and emerging trends – essential for decision‑making.

Key Ratios (Cambridge IGCSE 0452)

Formulas are shown in LaTeX between $…$ for inline use.

Ratio (syllabus name) Formula What a high/low figure indicates
Gross margin $\displaystyle \frac{\text{Gross profit}}{\text{Sales}}\times100\%$ High – good control of production/stock costs.
Low – cost of sales is too high relative to sales.
Profit margin $\displaystyle \frac{\text{Net profit}}{\text{Sales}}\times100\%$ High – overall profitability is strong.
Low – operating expenses, interest or tax are eroding profit.
Return on Capital Employed (ROCE) $\displaystyle \frac{\text{Operating profit}}{\text{Capital employed}}\times100\%$ High – efficient use of the capital invested.
Low – capital is not generating sufficient operating profit.
Current ratio $\displaystyle \frac{\text{Current assets}}{\text{Current liabilities}}$ High – good short‑term solvency (but may indicate excess cash).
Low – risk of being unable to meet current obligations.
Acid‑test (quick) ratio $\displaystyle \frac{\text{Current assets} - \text{Inventories}}{\text{Current liabilities}}$ High – can meet short‑term liabilities without relying on stock.
Low – heavy reliance on inventory to cover current debts.
Inventory turnover $\displaystyle \frac{\text{Cost of sales}}{\text{Average inventory}}$ High – inventory is sold quickly, freeing cash.
Low – stock may be obsolete or over‑stocked.
Receivables turnover $\displaystyle \frac{\text{Credit sales}}{\text{Average trade receivables}}$ High – customers pay promptly, improving cash flow.
Low – collection is slow, tying up cash.
Payables turnover $\displaystyle \frac{\text{Credit purchases}}{\text{Average trade payables}}$ High – the business pays suppliers quickly (may reduce cash).
Low – the business is stretching credit (may improve cash but risk supplier relations).

Who Uses the Ratios and Why?

Interested Party Key Ratios Used Purpose of Use
Owners / Shareholders Gross margin, profit margin, ROCE, current ratio Assess profitability, return on investment and short‑term solvency.
Managers All eight ratios Monitor performance, set targets and control working‑capital.
Bank / Lender Current ratio, acid‑test ratio, payables turnover Decide on credit limits and assess repayment ability.
Potential Investors ROCE, profit margin, current ratio Judge growth potential and risk profile.
Suppliers Payables turnover, current ratio Determine whether to offer trade credit and on what terms.

Limitations of Ratio Analysis

  • Ratios are based on historic cost data; they do not reflect current market values.
  • Different accounting policies (e.g., inventory valuation, depreciation methods) can make comparisons misleading.
  • Ratios ignore qualitative factors such as management competence, brand strength, or economic conditions.
  • Seasonal businesses may show distorted ratios if the periods compared are not season‑adjusted.

Step‑by‑Step: Preparing a Comparison Statement

  1. Gather data – extract the required figures from the income statement and balance sheet for each year.
  2. Calculate the eight ratios for every year under review (use average balances for turnover ratios).
  3. Present the results in a clear, labelled table.
  4. Write commentary that:
    • Identifies significant changes (increase or decrease).
    • Explains possible reasons (e.g., higher sales, tighter credit policy, new borrowing).
    • Considers the impact on different stakeholders.
    • Provides a specific recommendation linked to each ratio.
  5. Optional – Inter‑firm comparison – add a column showing an industry benchmark or a competitor’s figure and comment on the relative performance.

Worked Example – Two‑Year Ratio Comparison

All figures are in £’000 unless otherwise stated.

Item Year 1 Year 2
Sales500600
Cost of sales300360
Gross profit200240
Net profit8096
Operating profit120144
Current assets150180
Inventories (closing)5060
Average inventories4555
Current liabilities100110
Trade receivables (closing)4048
Average trade receivables3544
Trade payables (closing)3038
Average trade payables2834
Capital employed400420
Credit sales (assumed = total sales)500600
Credit purchases (assumed = cost of sales)300360

Calculated Ratios

Ratio Year 1 Year 2
Gross margin40 %40 %
Profit margin16 %16 %
ROCE30.0 %34.3 %
Current ratio1.501.64
Acid‑test ratio1.001.09
Inventory turnover6.67 times6.55 times
Receivables turnover14.29 times13.64 times
Payables turnover10.71 times10.59 times

Sample Commentary Linked to Each Ratio

Gross margin (40 % → 40 %) – No change despite a 20 % rise in sales, indicating that the cost of sales has risen in line with revenue. Recommendation: Review purchasing contracts or consider alternative suppliers to lower the cost of sales and lift the margin.

Profit margin (16 % → 16 %) – The gap between gross and profit margins remains 24 %, showing that operating expenses, interest and tax have increased proportionally with sales. Recommendation: Conduct an expense audit; target overheads that have grown faster than sales (e.g., utilities, admin salaries).

ROCE (30.0 % → 34.3 %) – Improvement reflects higher operating profit with only a modest increase in capital employed. Recommendation: Prioritise projects that generate a return above 34 %; avoid capital‑intensive ventures with lower yields.

Current ratio (1.50 → 1.64) – A healthier short‑term position, mainly because current assets grew faster than current liabilities. Recommendation: Keep a cash buffer of at least 20 % of current liabilities to protect against unexpected outflows.

Acid‑test ratio (1.00 → 1.09) – Liquidity improves even when inventories are excluded, showing that cash and receivables are sufficient to meet current debts. Recommendation: Maintain the current level of liquid assets; avoid converting too much cash into non‑liquid stock.

Inventory turnover (6.67 → 6.55 times) – A slight slowdown indicates cash is being tied up in stock. Recommendation: Implement tighter stock‑control procedures or adopt a just‑in‑time ordering system.

Receivables turnover (14.29 → 13.64 times) – The decline shows slower collection of credit sales. Recommendation: Strengthen credit control – introduce early‑payment discounts or stricter credit limits for slow‑paying customers.

Payables turnover (10.71 → 10.59 times) – The business is paying suppliers marginally faster, which can strain cash. Recommendation: Negotiate longer credit periods with key suppliers where possible, without harming relationships.

Inter‑Firm Comparison (Industry Benchmark)

Ratio Company (Year 2) Industry average
Gross margin40 %38 %
Profit margin16 %12 %
ROCE34.3 %30 %
Current ratio1.641.30
Acid‑test ratio1.090.95
Inventory turnover6.557.20
Receivables turnover13.6415.00
Payables turnover10.5911.50

The company outperforms the industry on profitability and liquidity but lags on inventory and receivables turnover. Improving stock‑control and credit‑policy would free up cash and bring the business in line with industry efficiency.

Checklist for a Good Ratio Comparison Statement

  • All figures are taken from the same source (income statement or balance sheet) and refer to the same accounting periods.
  • Ratios are calculated correctly, using average balances where required, and rounded appropriately (usually two decimal places for percentages, two for ratios).
  • Tables are clearly labelled with year headings, ratio names and units (% or times).
  • Commentary:
    • Identifies the direction and magnitude of change for each ratio.
    • Links changes to specific business events (price changes, credit policy, new borrowing, seasonality).
    • Considers the impact on each stakeholder group.
    • Provides at least one actionable recommendation that is directly tied to the ratio being discussed.
  • If an inter‑firm comparison is included, the benchmark figures are sourced (industry report, competitor’s published accounts) and the relative performance is explained.

Create an account or Login to take a Quiz

42 views
0 improvement suggestions

Log in to suggest improvements to this note.