Interpretation of accounting ratios
To compare a business's performance over time, you must prepare comparative financial statements. This involves taking the figures from the current year and placing them alongside the figures from previous years (e.g., Year 1 vs. Year 2).
Why do we do this?
A single year's profit figure tells us nothing about the trend. Is the business growing or shrinking? Comparative statements allow us to calculate variances (absolute changes) and percentages (relative changes) to identify trends in profitability, liquidity, and efficiency.
Preparation Steps:
- List the key figures (Revenue, Gross Profit, Profit for the Year, Current Assets, etc.) for each year side-by-side.
- Calculate the absolute change: \text{Change} = \text{Current Year Figure} - \text{Previous Year Figure}.
- Calculate the percentage change: \text{Percentage Change} = \left( \frac{\text{Change}}{\text{Previous Year Figure}} \right) \times 100.
Commenting:
When commenting, you must state what changed and whether it improved or deteriorated. For example, 'Gross profit increased by 20%, indicating an improvement in core trading performance.'
Learning Objective 2: How to interpret the ratios calculated.
Ratios are mathematical relationships between two financial figures. They standardize data, allowing you to compare businesses of different sizes or the same business over time.
The Four Key Categories:
- Profitability: Can the business generate profit? (e.g., Gross Profit Margin, Net Profit Margin, ROCE).
- Liquidity: Can the business pay its short-term debts? (e.g., Current Ratio, Acid Test Ratio).
- Efficiency/Trading Ratios: How well is the business managing its assets? (e.g., Inventory Turnover, Receivables Collection Period).
- Investor Ratios: Is the business a good investment? (e.g., Price/Earnings ratio - though less common in basic syllabi).
Interpretation Logic:
- Higher is not always better. For example, a very high liquidity ratio might mean the business is holding too much cash that could be invested elsewhere.
- Context is key. Compare ratios against:
- Previous years (trend analysis).
- Competitors (benchmarking).
- Industry averages.
1. Gross Profit Margin
This measures the efficiency of production/purchasing. It shows how much profit is made on each dollar of sales after covering the direct costs of goods sold.
\text{Gross Profit Margin} = \left( \frac{\text{Gross Profit}}{\text{Revenue}} \right) \times 100
- Gross Profit = Revenue - Cost of Sales (Opening Inventory + Purchases - Closing Inventory).
- Interpretation: A rising margin suggests better control over costs or higher selling prices. A falling margin suggests increased costs or price cuts.
2. Net Profit Margin (Profit Margin)
In Cambridge Accounting, unless specified as 'Gross', 'Profit Margin' refers to Net Profit Margin. It measures the overall efficiency of the business after ALL expenses.
\text{Net Profit Margin} = \left( \frac{\text{Profit for the Year}}{\text{Revenue}} \right) \times 100
- Profit for the Year = Gross Profit - Operating Expenses + Other Income - Finance Costs.
- Interpretation: This is the bottom line. It shows how much of every dollar earned is kept as actual profit.
Note on Notation: Always distinguish between Gross Profit (trading result) and Profit for the Year (overall result). Confusing these variables is a common error.
Learning Objective 5: How gross profit for the year can be affected by inventory valuation, sales quantity, and price changes.
Gross Profit is driven by Revenue and Cost of Sales. Changes in any of these components will alter the margin.
1. Valuation of Inventory (Costing Method)
If prices are rising (inflation), different inventory costing methods yield different results:
- FIFO (First-In, First-Out): Older, cheaper stock is sold first. Cost of Sales is lower, so Gross Profit is higher.
- LIFO (Last-In, First-Out): Newer, expensive stock is sold first. Cost of Sales is higher, so Gross Profit is lower.
Note: IFRS prohibits LIFO, but understanding the impact is crucial for analysis.
2. Sales Quantity
- Economies of Scale: If sales quantity increases significantly, fixed costs per unit might drop (though this affects Net Profit more), or bulk purchasing discounts might lower Cost of Sales, improving Gross Profit.
- Sales Mix: Selling more high-margin items (e.g., luxury goods) vs. low-margin items (e.g., basic staples) changes the overall weighted average Gross Profit Margin.
3. Changes in Prices
- Selling Price Increase: If Revenue increases while Cost of Sales stays constant, Gross Profit and Margin increase.
- Purchasing Price Increase: If the cost to buy goods rises but selling prices remain unchanged, Cost of Sales increases, so Gross Profit and Margin decrease.
Learning Objective 6: How profit for the year can be affected by changes in gross profit, other income, and expenses.
Profit for the Year is the final result. It is sensitive to three main areas:
1. Changes in Gross Profit
- If Gross Profit falls (due to lower margins), Profit for the Year will fall unless expenses are reduced proportionally more.
2. Other Income
- This includes rent received, interest earned, or profit on sale of assets.
- An increase in other income directly increases Profit for the Year without affecting Gross Profit.
3. Operating Expenses
- Fixed vs. Variable: Fixed expenses (rent, salaries) do not change with sales volume. If sales drop, fixed expenses remain high, causing a disproportionate fall in Profit for the Year.
- Controllable Expenses: Advertising, marketing, and administrative costs can be managed. Increasing advertising might boost Revenue (and Gross Profit) but will reduce Net Profit Margin in the short term if the revenue increase doesn't cover the cost.
Profit is an accounting concept; Cash is a reality. A business can be profitable but run out of cash (insolvent), or have cash but make no profit.
Key Reasons for Differences:
- Non-Cash Expenses: Depreciation reduces Profit but does not involve cash leaving the bank. Therefore, Profit < Cash Flow from operations (before working capital changes).
- Credit Sales/Purchases:
- Revenue is recorded when goods are sold on credit, not when cash is received. If receivables increase, Profit > Cash Inflow.
- Purchases are recorded when received, not when paid. If payables increase, Cash Outflow < Cost of Sales.
- Capital vs. Revenue Expenditure:
- Buying a machine costs cash immediately but is capitalized (not an expense). So, Cash decreases significantly, but Profit is unaffected (except for future depreciation).
- Drawings/Dividends: These reduce Cash but are not expenses in the Income Statement, so they do not affect Profit.
Conclusion: Always analyze both the Income Statement (Profit) and Statement of Financial Position/Cash Flow to get the full picture.
Learning Objective 3: Make suggestions and recommendations for improving profitability, liquidity, and working capital.
When asked to 'suggest' or 'advise', you must link the problem (identified via ratios) to a solution and explain the benefit.
A. Improving Profitability
- Problem: Low Gross Profit Margin.
- Suggestion: Renegotiate purchase prices with suppliers or switch to cheaper suppliers.
- Benefit: Reduces Cost of Sales, directly increasing Gross Profit.
- Alternative Suggestion: Increase selling prices (if demand is inelastic).
- Problem: Low Net Profit Margin.
- Suggestion: Reduce operating expenses (e.g., cut unnecessary advertising, renegotiate rent).
- Benefit: Directly increases Profit for the Year.
B. Improving Liquidity & Working Capital
- Problem: Low Current Ratio / Acid Test Ratio (Liquidity crisis).
- Suggestion: Improve receivables collection (e.g., offer cash discounts for early payment, tighten credit terms).
- Benefit: Converts receivables to cash faster, improving liquidity.
- Suggestion: Reduce inventory levels (just-in-time ordering).
- Benefit: Frees up cash tied up in stock.
- Problem: High Inventory Turnover Days.
- Suggestion: Improve marketing or discount slow-moving stock.
- Benefit: Reduces storage costs and risk of obsolescence, freeing cash.
C. General Working Capital Management
- Suggestion: Negotiate longer payment terms with trade payables.
- Benefit: Holds onto cash longer (interest-free loan from suppliers), improving short-term liquidity.
Mistake 1: Describing without Interpreting
- Error: 'The current ratio increased from 1.5 to 2.0.'
- Correction: You must state if this is good or bad. 'The current ratio improved, indicating better short-term solvency, BUT it may suggest inefficient use of cash (too much idle liquidity).'
Mistake 2: Confusing Gross and Net Profit
- Error: Using 'Profit for the Year' in the Gross Profit Margin formula.
- Correction: Gross Profit Margin uses Gross Profit. Net Profit Margin uses Profit for the Year. Check the question carefully. If it says 'Profit Margin', assume Net unless context implies otherwise.
Mistake 3: Ignoring Competitors/Industry Standards
- Error: Saying 'The margin is high' without reference.
- Correction: A 10% margin might be excellent for a supermarket but terrible for a software company. Always compare to industry averages or competitors if data is available.
Mistake 4: Assuming Higher Liquidity is Always Better
- Error: 'The business has plenty of cash, so it is healthy.'
- Correction: Excess cash earns no return. It should be invested in assets or returned to owners. High liquidity can indicate poor investment decisions.
Tip 1: Use Precise Terminology in Recommendations
When asked to suggest improvements, avoid vague phrases like 'do better'. Use specific accounting terms.
- Context: When suggesting ways to improve liquidity.
- Accepted Phrase: 'Implement stricter credit control policies' or 'Offer early settlement discounts.'
- Why it works: Examiners look for specific mechanisms that affect working capital cycles. 'Do better' gets no marks; 'Tighten credit terms' shows understanding of the receivables management process.
Tip 2: Link Ratios to Business Objectives
When advising on profitability vs. liquidity, acknowledge the trade-off.
- Context: When a business has high profit but low cash.
- Accepted Phrase: 'While profitability is strong, the low liquidity poses a risk of insolvency. The owner should consider converting non-current assets to cash or securing an overdraft facility.'
- Why it works: It demonstrates holistic understanding. Profitability and liquidity are often conflicting goals. Acknowledging this balance shows higher-level analysis.
Tip 3: Distinguish Between 'Cause' and 'Effect'
When explaining changes in ratios, be precise about the driver.
- Context: Explaining a fall in Gross Profit Margin.
- Accepted Phrase: 'The decrease is likely due to an increase in the cost of raw materials (Cost of Sales) outpacing any increase in selling prices.'
- Why it works: It directly addresses the components of the formula (\frac{GP}{Revenue}). Vague answers like 'sales dropped' are insufficient because sales volume doesn't necessarily change margin unless costs or prices change.
- Increase in Cost of Sales: The cost of purchasing goods may have increased (e.g., supplier price hikes) while selling prices remained constant.
- Decrease in Selling Prices: The business may have reduced prices to boost sales volume, thereby reducing the margin per unit.
- High Receivables: The business may have made many credit sales (recognizing revenue/profit) but has not yet collected the cash.
- Inventory Build-up: Cash was spent on purchasing stock that has not yet been sold, reducing cash flow without affecting profit until sale.
- Capital Expenditure: Large purchases of non-current assets reduce cash immediately but are not expensed in the Income Statement.
To improve Net Profit Margin, the owner should:
- Reduce Operating Expenses: Cut unnecessary costs such as marketing or administrative overheads.
- Increase Revenue without Proportional Cost Increase: Raise selling prices (if demand allows) or sell higher-margin products.
- Increase Other Income: Generate more income from investments or rent to boost the bottom line.