Analysis of accounts

1. Overview

Analysis of accounts transforms raw financial data from the Income Statement and Statement of Financial Position into meaningful information used to judge a business's success, efficiency, and financial stability. It allows managers, investors, and creditors to move beyond looking at isolated figures like "Total Profit" and instead evaluate how effectively a business uses its resources to generate wealth and whether it possesses the cash flow necessary to survive. Without ratio analysis, a profit of $10,000 looks the same whether it took $50,000 or $500,000 of investment to achieve it; analysis provides the context required for informed decision-making.

---

Key Definitions

• Ratio Analysis: A mathematical technique of comparing two related items from financial statements to evaluate a business’s performance and financial health.
• Profitability: A measure of how much profit a business generates relative to its size, sales revenue, or the amount of capital invested in it.
• Liquidity: The ability of a business to meet its short-term financial obligations (debts) using its current assets.
• Gross Profit Margin (GPM): A ratio expressing gross profit as a percentage of sales revenue, showing the efficiency of the core trading activity.
• Profit Margin (Net): A ratio expressing the final profit (after all expenses) as a percentage of sales revenue.
• Return on Capital Employed (ROCE): A percentage ratio that measures the profit generated relative to the total long-term capital invested in the business.
• Current Ratio: A liquidity ratio that measures the ability to pay current liabilities using all current assets (Cash + Debtors + Inventory).
• Acid Test Ratio (Quick Ratio): A stricter liquidity measure that excludes inventory from current assets, as inventory is not guaranteed to be sold quickly.
• Capital Employed: The total value of long-term funds used by the business, calculated as Shareholders’ Equity + Non-current Liabilities.

---

Core Content

A. Profitability Ratios

Profitability ratios do not just look at the "amount" of profit, but the "quality" of profit relative to other factors.

1. Gross Profit Margin (GPM)

• Focus: Measures the percentage of every $1 of sales that is left after paying for the direct cost of goods sold (COGS).
• Significance: A high GPM suggests the business has a strong brand (allowing high prices) or efficient purchasing/production.
• Trend Analysis: If GPM falls while sales rise, the business may be facing higher raw material costs or using heavy discounts to attract customers.

2. Profit Margin (Net)

• Focus: Measures the percentage of sales revenue remaining after all costs (COGS plus overheads like rent, salaries, and marketing) are paid.
• Significance: This is the ultimate measure of how well a business controls its overheads.
• Comparison: A business with a high GPM but a very low Profit Margin is likely suffering from excessive administrative or indirect costs.

3. Return on Capital Employed (ROCE)

• Focus: The "investor’s ratio." It shows the percentage return for every dollar of long-term capital put into the business.
• Significance: It allows for comparison across different industries. If a bank offers 5% interest and a business has a ROCE of 3%, the owners are technically losing money compared to a risk-free investment.
• Improvement: To increase ROCE, a business must either increase profit (without increasing capital) or reduce the capital employed (e.g., by paying off long-term loans) while maintaining profit levels.

Worked example 1 — Profitability Analysis

Question: A business, "Z-Tech," provides the following data for 2023:

• Revenue: $500,000
• Gross Profit: $200,000
• Profit for the year: $50,000
• Capital Employed: $250,000

Calculate the Profit Margin and ROCE for Z-Tech.

Model Answer:

1. Profit Margin:

   • Formula: $(\text{Profit} / \text{Revenue}) \times 100$
   • Calculation: $($50,000 / $500,000) \times 100 = \mathbf{10%}$
   • Explanation: For every $1 of sales, Z-Tech keeps 10 cents as final profit after all expenses are paid.

2. ROCE:

   • Formula: $(\text{Profit} / \text{Capital Employed}) \times 100$
   • Calculation: $($50,000 / $250,000) \times 100 = \mathbf{20%}$
   • Explanation: This is a strong return, as the business generates 20 cents of profit for every $1 of long-term investment, likely outperforming standard bank interest rates.

B. Liquidity Ratios

Liquidity is about survival. A business can be profitable on paper but fail because its cash is "locked up" in unsold stock or owed by slow-paying customers.

1. Current Ratio

• Formula: $\text{Current Assets} / \text{Current Liabilities}$
• Interpretation: A ratio of 2:1 is often considered ideal. It means the business has $2 of liquid assets for every $1 of debt due within the year.
• Risk: If the ratio is below 1:1, the business is technically insolvent in the short term and may struggle to pay suppliers or staff.

2. Acid Test Ratio

• Formula: $(\text{Current Assets} - \text{Inventory}) / \text{Current Liabilities}$
• Interpretation: This is the "emergency" ratio. It assumes the business cannot sell any more stock. A ratio of 1:1 is the target.
• Context: For a business like Dairy Dreams (selling perishable milk), inventory cannot be relied upon to pay long-term debts because it spoils. Therefore, the Acid Test is a more realistic measure of their safety than the Current Ratio.

Worked example 2 — Evaluating Liquidity and Decision-Making

Question: "Build-It Ltd" has a Current Ratio of 2.5:1 but an Acid Test Ratio of 0.4:1. Explain what these ratios suggest about the business and recommend whether a supplier should offer them credit.

Model Answer:

• Analysis: The large gap between the Current Ratio (2.5) and the Acid Test (0.4) indicates that Build-It Ltd is holding a massive amount of inventory. While they have many assets, most of those assets are "illiquid" (stuck in the warehouse).
• Impact: An Acid Test of 0.4:1 is dangerous. It means for every $1 they owe to suppliers this month, they only have 40 cents in cash or debtors to pay it. They are reliant on selling their stock to survive.
• Recommendation: A supplier should be cautious. If there is a market downturn and Build-It Ltd cannot sell its inventory, they will likely default on their payments. The supplier should perhaps demand "cash on delivery" rather than offering 30 days of credit.

C. The Role of Analysis in Decision-Making

Analysis of accounts is not just an accounting exercise; it drives business strategy:

• Attracting Investment: High ROCE and Profit Margins attract shareholders who want dividends and capital growth.
• Securing Loans: Banks will only lend to businesses with a healthy Current Ratio, as it proves the business can meet interest repayments.
• Operational Changes: If GPM is falling, managers may decide to switch to a cheaper supplier or automate production to reduce direct costs.
• Expansion Decisions: A business with high liquidity may decide to use its "excess" cash to buy out a competitor or open a new branch.

D. Advantages and Disadvantages of Ratio Analysis

Advantages:

• Comparison over time (Intra-firm): Allows a business to see if performance is improving or declining compared to last year.
• Comparison with rivals (Inter-firm): Helps a business see if it is more or less efficient than the industry average.
• Simplification: Turns complex financial statements into simple percentages that are easy for non-financial managers to understand.
• Target Setting: Ratios can be used as Key Performance Indicators (KPIs) for department managers.

Disadvantages/Limitations:

• Historical Data: Ratios are based on past performance. They do not guarantee future success or account for sudden market changes.
• Qualitative Factors: Ratios ignore staff morale, brand reputation, and environmental impact—all of which affect long-term profit.
• Window Dressing: Businesses may take actions just before the end of the year (like selling an asset) to make their ratios look better than they actually are.
• Inflation: Rising prices can distort the value of assets and sales, making comparisons between years misleading.

---

Extended Content (Extended Analysis)

In the Extended curriculum, you must be able to compare businesses of different scales.

The Efficiency Paradox: Consider a Small Luxury Jeweller vs. a Mass-Market Supermarket.

• Jeweller: High GPM (80%) because each ring has a huge markup. However, they sell very few items, so their ROCE might be low (8%) because they have high rent and low volume.
• Supermarket: Low GPM (10%) because they sell bread and milk at tiny margins. However, because they sell millions of items every day, their Asset Turnover is high, leading to a much higher ROCE (25%).
• Conclusion: A "low" margin is not always bad if the volume of sales is high enough to generate a strong return on the capital invested.

---

Key Equations

Ratio	Formula	Format
Gross Profit Margin	$\frac{\text{Gross Profit}}{\text{Revenue}} \times 100$	%
Profit Margin	$\frac{\text{Profit for the year}}{\text{Revenue}} \times 100$	%
ROCE	$\frac{\text{Operating Profit}}{\text{Capital Employed}} \times 100$	%
Current Ratio	$\frac{\text{Current Assets}}{\text{Current Liabilities}}$	X : 1
Acid Test Ratio	$\frac{\text{Current Assets} - \text{Inventory}}{\text{Current Liabilities}}$	X : 1

---

Common Mistakes to Avoid

• ❌ Ignoring the "Why": Don't just say "The GPM increased." You must explain why (e.g., "The GPM increased, suggesting the business successfully negotiated lower prices with its raw material suppliers").
• ❌ Reversing the Argument: Avoid saying "A high ratio is good, so a low ratio is bad." Instead, explain the specific consequence (e.g., "A low Current Ratio of 0.8:1 means the business may be forced to take out expensive short-term loans to pay its immediate bills").
• ❌ Mixing Units: Never express Profitability as a ratio (e.g., 0.2:1) or Liquidity as a percentage (e.g., 200%). Profitability is always %; Liquidity is always X:1.
• ❌ Forgetting Inventory: In the Acid Test, you must subtract inventory. If you forget this, you are just calculating the Current Ratio again.

---

Exam Tips

• Show Your Workings: In "Calculate" questions, write down the formula first. If you make a calculator error but the formula is right, you will still earn "method marks."
• Contextualize: If the case study mentions the business sells perishable goods (like fruit or flowers), emphasize the Acid Test Ratio. If the business has high fixed costs (like a factory), focus on the Profit Margin vs. GPM.
• The "Interest Rate" Benchmark: When evaluating ROCE, always compare it to the prevailing bank interest rate. If ROCE is 2% and bank interest is 4%, the business is a poor use of capital.
• Window Dressing: If a question asks about the limitations of these accounts, mention "Window Dressing." For example, a business might delay paying its suppliers until the first day of the new financial year to make its cash balance look higher on the Statement of Financial Position.
• Chain of Reasoning: For 6-mark or 12-mark questions, use the "This leads to..." approach.
  • Example: "A falling Profit Margin leads to lower retained profits, which means the business has less internal finance for expansion, resulting in a need for more expensive external debt."

---

Exam-Style Questions

Practice these original exam-style questions to test your understanding. Each question mirrors the style, structure, and mark allocation of real Cambridge 0450 papers.

Exam-Style Question 1 — Short Answer [6 marks] (Paper 2 - Calculator Allowed)

Question:

Fashion Forward (FF) is a clothing retailer. Their Gross Profit Margin has fallen from 45% in 2022 to 38% in 2023.

(a) Define 'Gross Profit Margin'. [2]

(b) Outline two possible reasons for the fall in Fashion Forward's Gross Profit Margin. [4]

Worked Solution:

(a)

1. Gross Profit Margin is a profitability ratio. [Identifying the type of ratio]
2. It measures the percentage of revenue that remains after deducting the cost of goods sold. [Explaining what the ratio measures]

How to earn full marks: Define the type of ratio, then clearly explain what it measures in business terms.

(b)

1. Increased Cost of Goods Sold (COGS): FF may have experienced higher costs for raw materials or manufacturing due to inflation or supply chain issues. This increases COGS, leading to a lower gross profit and therefore a lower gross profit margin. [Explaining the impact of increased COGS]
2. Decreased Selling Price: To remain competitive, FF might have lowered selling prices. This could be due to increased competition from other retailers or a decrease in consumer demand for their products. Lower selling prices, without a corresponding decrease in COGS, will decrease the gross profit margin. [Explaining the impact of decreased selling price]

How to earn full marks: Don't just state a reason; explain how it affects the Gross Profit Margin, linking the cause to the effect.

Common Pitfall: Many students simply state that COGS increased or selling price decreased. To get full marks, you need to explain how these changes affect the gross profit margin. Don't just state the obvious; explain the consequences.

Exam-Style Question 2 — Short Answer [6 marks] (Paper 2 - Calculator Allowed)

Question:

Tech Solutions Ltd. is a software development company. They are considering taking out a loan to finance a new office building.

(a) Define 'Liquidity Ratios'. [2]

(b) Explain one reason why calculating liquidity ratios would be important for Tech Solutions Ltd. before applying for the loan. [4]

Worked Solution:

(a)

1. Liquidity ratios are financial ratios. [Identifying the type of ratio]
2. They measure a business's ability to meet its short-term debts. [Explaining what the ratio measures]

How to earn full marks: Start by stating the type of ratio, then give a precise definition using business terminology.

(b)

1. Liquidity ratios, such as the current ratio or acid test ratio, help Tech Solutions assess their ability to pay back the loan installments in the short term. [Identifying the purpose of liquidity ratios in this context]
2. If the ratios indicate poor liquidity (e.g., current ratio below 1), it suggests they may struggle to meet their short-term financial obligations, including loan repayments. [Explaining the consequence of poor liquidity]
3. This information is crucial for the company to decide whether they can realistically afford the loan and avoid potential financial distress. It also informs lenders about the risk of lending to Tech Solutions. [Explaining the importance for both the company and the lender]

How to earn full marks: Explain the importance of the ratios in the context of the question, linking them to the specific situation (loan application).

Common Pitfall: Don't just say liquidity ratios are important. Explain why they are important in the specific context of taking out a loan. Focus on the ability to repay the loan and the implications for both the business and the lender.

Exam-Style Question 3 — Extended Response [12 marks] (Paper 2 - Calculator Allowed)

Question:

GreenGrocer is a local grocery store. Their accountant has calculated the following for 2023:

• Gross Profit Margin: 25%
• Net Profit Margin: 5%
• Return on Capital Employed (ROCE): 8%

The owner, Mr. Jones, is disappointed with the ROCE and is considering several options to improve it, including increasing prices or reducing operating expenses.

(a) Explain how increasing prices could improve GreenGrocer's ROCE. [6]

(b) Explain how reducing operating expenses could improve GreenGrocer's ROCE. [6]

Worked Solution:

(a)

1. Increasing prices will directly increase GreenGrocer's revenue. [Stating the direct impact of price increase]
2. Assuming cost of goods sold (COGS) remains relatively stable, a higher revenue leads to a higher gross profit. $[Gross\ Profit = Revenue - COGS]$ [Explaining the impact on gross profit]
3. A higher gross profit, after deducting operating expenses, will result in a higher net profit. $[Net\ Profit = Gross\ Profit - Operating\ Expenses]$ [Explaining the impact on net profit]
4. ROCE is calculated as: $ROCE = \frac{Net\ Profit}{Capital\ Employed} \times 100$ [Stating the ROCE formula]
5. If net profit increases while capital employed remains the same, the ROCE will increase. [Explaining the relationship between net profit and ROCE]
6. Therefore, increasing prices can lead to a higher net profit and, consequently, a higher ROCE, indicating a more efficient use of capital. [Concluding the impact on ROCE and its implication]

How to earn full marks: Trace the impact of the action (price increase) all the way through to the ROCE, showing how each step affects the next.

(b)

1. Operating expenses include costs like rent, utilities, salaries, and marketing. [Identifying examples of operating expenses]
2. Reducing these expenses directly increases net profit. $[Net\ Profit = Gross\ Profit - Operating\ Expenses]$ [Explaining the impact on net profit]
3. For example, negotiating lower rent, implementing energy-efficient measures, or streamlining staffing can all reduce operating expenses. [Providing examples of cost reduction strategies]
4. ROCE is calculated as: $ROCE = \frac{Net\ Profit}{Capital\ Employed} \times 100$ [Stating the ROCE formula]
5. If operating expenses decrease, net profit increases, and capital employed remains constant, ROCE will increase. [Explaining the relationship between operating expenses, net profit, and ROCE]
6. Therefore, effectively managing and reducing operating expenses is crucial for improving GreenGrocer's ROCE, indicating better profitability relative to its capital investment. [Concluding the impact on ROCE and its implication]

How to earn full marks: Provide specific examples of operating expenses and how they can be reduced to boost net profit and ROCE.

Common Pitfall: Many students simply state the ROCE formula without explaining why increasing prices or reducing expenses leads to a higher ROCE. Make sure you clearly link the actions to the resulting changes in net profit and, consequently, ROCE.

Exam-Style Question 4 — Extended Response [12 marks] (Paper 3 - No Calculator)

Question:

Dairy Dreams Ltd. produces and sells a variety of dairy products. They have been operating for five years. The management team is reviewing the company's financial performance. They have access to detailed financial statements, including income statements and balance sheets for the past three years. Some managers believe that relying solely on ratio analysis is sufficient for evaluating the business, while others argue that it is essential to consider other factors.

To what extent should Dairy Dreams Ltd. rely on ratio analysis when evaluating the performance of the business? [12]

Worked Solution:

1. Arguments for relying on ratio analysis: Ratio analysis provides a structured way to assess financial performance. [Introducing the benefits of ratio analysis]
2. Ratios like gross profit margin, net profit margin, and ROCE allow for comparison of profitability over time and against competitors. This helps identify trends and areas for improvement. [Explaining the benefits of profitability ratios]
3. Liquidity ratios like the current ratio and quick ratio help assess the company's ability to meet short-term obligations, indicating financial stability. [Explaining the benefits of liquidity ratios]
4. Efficiency ratios, such as inventory turnover, can highlight how efficiently Dairy Dreams Ltd. is managing its assets, particularly important for perishable goods. [Explaining the benefits of efficiency ratios, specific to the business]
5. Ratio analysis can also assist in identifying potential financial problems early, such as declining profitability or increasing debt levels, allowing management to take corrective action. [Explaining the proactive benefits of ratio analysis]
6. Arguments against relying solely on ratio analysis: Ratios are based on historical data, which may not be indicative of future performance. External factors, such as changes in consumer preferences or economic conditions, are not directly reflected in ratio analysis. [Introducing the limitations of ratio analysis]
7. Ratio analysis may not capture qualitative aspects of the business, such as brand reputation, customer satisfaction, or employee morale, which can significantly impact performance. [Explaining the limitations in capturing qualitative factors]
8. Ratios can be manipulated through accounting practices, making comparisons difficult. For example, Dairy Dreams Ltd. could delay payments to suppliers to improve its current ratio temporarily. [Explaining the potential for manipulation]
9. Ratio analysis provides limited insights into the reasons behind the numbers. For example, a declining gross profit margin might be due to increased raw material costs (milk prices), increased competition, or a combination of factors, which requires further investigation. [Explaining the limitations in providing context]
10. Judgement: While ratio analysis provides valuable insights into Dairy Dreams Ltd.'s financial performance, it should not be the sole basis for evaluation. [Stating the overall judgement]
11. The management team should consider a range of factors, including market trends, competitive landscape, customer feedback, employee satisfaction, and the impact of weather on milk production, to gain a comprehensive understanding of the business. Combining ratio analysis with qualitative information and forward-looking projections will lead to more informed decision-making and a more accurate assessment of overall performance. [Explaining the need for a holistic approach]

How to earn full marks: Present a balanced argument, discussing both the strengths and weaknesses of ratio analysis, and then reach a clear, well-supported conclusion.

Common Pitfall: Don't just list the pros and cons of ratio analysis in general. Relate your points back to the specific business (Dairy Dreams Ltd.) and its industry (dairy products). For example, mention the importance of inventory turnover for perishable goods like milk and cheese.