Accounting Ratio Analysis Formula & Interpretation Guide

Core Purposes of Ratio Analysis

Ratio analysis evaluates financial statements by comparing figures to assess business performance over time or against industry benchmarks. In examinations and real-world evaluation, calculating the correct number is only the first step. High marks depend on explaining what the figures signify, why they shifted, and how management should respond.

To build a comprehensive revision schedule alongside this guide, review our curated resources and core syllabus notes on /a-level-accounting.

---

1. Profitability Ratios

Profitability ratios measure the ability of a business to generate profit relative to sales revenue, assets, or invested capital.

Gross Profit Margin

• Formula: $(\text{Gross Profit} / \text{Revenue}) \times 100$
• Definition: Measures the percentage of revenue remaining after subtracting cost of sales.
• Key Drivers: Changes in selling prices, purchase costs of raw materials, trade discounts, or production efficiency.

Mark-Up on Cost

• Formula: $(\text{Gross Profit} / \text{Cost of Sales}) \times 100$
• Definition: Measures the profit added onto the cost price of goods sold.
• Key Drivers: Pricing policies, supplier cost adjustments, and direct production expenses.

Profit for the Year Margin (Net Profit Margin)

• Formula: $(\text{Profit for the Year} / \text{Revenue}) \times 100$
• Definition: Indicates how much net profit is generated per dollar of revenue after deducting all operating expenses.
• Key Drivers: Control of administrative expenses, distribution costs, rent, utilities, and changes in gross profit.

Return on Capital Employed (ROCE)

• Formula: $(\text{Operating Profit} / \text{Capital Employed}) \times 100$
• Capital Employed Definition: Total Equity + Non-Current Liabilities (or Non-Current Assets + Working Capital).
• Operating Profit: Profit before interest and tax (PBIT).
• Significance: Measures the efficiency with which all long-term capital providers' funds are used to produce returns.

---

2. Liquidity Ratios

Liquidity ratios determine whether a firm has sufficient short-term assets to settle its current liabilities as they fall due.

Current Ratio (Working Capital Ratio)

• Formula: $\text{Current Assets} : \text{Current Liabilities}$
• Definition: Evaluates the buffer of short-term resources available to satisfy short-term obligations.
• Target Range: Traditionally viewed around $1.5:1$ to $2.0:1$, though ideal values vary by industry model.

Liquid Ratio (Acid Test / Quick Ratio)

• Formula: $(\text{Current Assets} - \text{Inventory}) : \text{Current Liabilities}$
• Definition: Excludes inventory because stock cannot always be converted into cash quickly without deep discounts.
• Target Range: Often benchmarked near $1.0:1$. A ratio significantly below $1:1$ indicates potential risk of immediate insolvency.

---

3. Efficiency and Working Capital Ratios

Efficiency ratios highlight how productively a business manages its operating cycle and assets.

Inventory Turnover Rate

• Times per year: $\text{Cost of Sales} / \text{Average Inventory}$
• Days in year: $(\text{Average Inventory} / \text{Cost of Sales}) \times 365$
• Significance: Measures how rapidly stock sells. A rising number of days suggests obsolete stock or slowing demand.

Trade Receivables Turnover (Collection Period)

• Formula: $(\text{Trade Receivables} / \text{Credit Sales}) \times 365$
• Significance: Shows the average number of days taken to collect cash from credit customers. Extended periods raise bad debt risks.

Trade Payables Turnover (Payment Period)

• Formula: $(\text{Trade Payables} / \text{Credit Purchases}) \times 365$
• Significance: Reflects how long the business takes to pay its trade suppliers. Taking too long harms credit ratings and supplier goodwill.

---

4. Solvency and Gearing Ratios

Gearing Ratio

• Formula (Standard Capital Structure): $[\text{Non-Current Liabilities} / (\text{Total Equity} + \text{Non-Current Liabilities})] \times 100$
• Alternative Method: $(\text{Non-Current Liabilities} / \text{Total Equity}) \times 100$
• Interpretation: Evaluates financial risk. A gearing ratio above 50% indicates that the business relies heavily on fixed-cost debt, leaving it vulnerable to interest rate hikes.

---

How to Comment on Ratio Results (The 4-Step Method)

Examiners award the highest evaluation marks when answers move beyond restating calculations. Use this four-step process for commentary:

1. Identify the Movement: State clearly whether the ratio improved, deteriorated, or stayed constant, noting the exact numeric change.
2. Isolate the Underlying Causes: Avoid generic assertions. State the specific accounting component causing the shift (e.g., higher administrative overheads rather than lower sales).
3. Examine the Business Impact: Explain how the change affects stakeholders, cash flow, credit terms, or loan covenants.
4. Propose Balanced Solutions or Limitations: Suggest practical remedial actions (e.g., offering early settlement discounts) while mentioning the drawbacks (e.g., margin erosion).

If you find yourself struggling with qualitative evaluations or need targeted exam support, consider working with a dedicated Cambridge A Level Accounting tutor.

---

Worked Example: Calculating and Interpreting Changes

Financial Data for Swift Retail Ltd

Item	Year 1 ($)	Year 2 ($)
Revenue	200,000	250,000
Cost of Sales	120,000	165,000
Gross Profit	80,000	85,000
Operating Expenses	40,000	55,000
Profit for the Year	40,000	30,000
Inventory	20,000	33,000
Trade Receivables	18,000	32,000
Bank Balance	12,000	(5,000) [Overdraft]
Trade Payables	25,000	45,000

1. Ratio Calculations

• Gross Profit Margin:
  • Year 1: $(80,000 / 200,000) \times 100 = 40.0%$
  • Year 2: $(85,000 / 250,000) \times 100 = 34.0%$
• Profit for the Year Margin:
  • Year 1: $(40,000 / 200,000) \times 100 = 20.0%$
  • Year 2: $(30,000 / 250,000) \times 100 = 12.0%$
• Current Ratio:
  • Year 1: $(20,000 + 18,000 + 12,000) / 25,000 = 50,000 / 25,000 = 2.00:1$
  • Year 2: $(33,000 + 32,000) / (45,000 + 5,000) = 65,000 / 50,000 = 1.30:1$
• Liquid Ratio (Acid Test):
  • Year 1: $(50,000 - 20,000) / 25,000 = 30,000 / 25,000 = 1.20:1$
  • Year 2: $(65,000 - 33,000) / 50,000 = 32,000 / 50,000 = 0.64:1$

2. Model Commentary

• Profitability: Swift Retail's gross profit margin dropped by 6 percentage points (from 40% to 34%), indicating that cost of sales rose faster than revenue. This may stem from price reductions used to win sales volume or unrecovered supplier price increases. Furthermore, profit for the year margin deteriorated sharply from 20% to 12%, showing that operating overheads also escalated as business expanded.
• Liquidity: The liquid ratio declined from a stable 1.20:1 to an alarming 0.64:1. The business has shifted into an overdraft position while accumulating substantial funds in unsold inventory ($33,000) and uncollected receivables ($32,000). Swift Retail faces an immediate cash squeeze and may fail to pay trade creditors on time if receipts do not accelerate.
• Recommendations: Management should enforce tighter credit controls to collect debts, liquidate slow-moving stock, and review supplier contracts before committing to further revenue expansion.

---

Practical Revision Checklist

Before concluding any ratio analysis task, verify the following:

• Have you labeled answers with correct units (%, days, or :1)?
• Did you use average inventory when both opening and closing balances are provided?
• If an overdraft exists, did you include it in current liabilities rather than deducting it from assets?
• Did you connect changes in the gross margin directly to cost of sales or pricing rather than operating expenses?
• Did you acknowledge the limitations of ratio analysis (historical cost convention, seasonal distortion, differences in accounting policies)?

Students preparing for upcoming assessments can explore past exam techniques in our A Level accounting past papers walkthrough, or consult our A Level accounting retake roadmap if revising under tight timelines. Those pursuing complementary subjects can also review our analytical materials for A Level Economics and A Level Business.