Cambridge AS & A Level9706

Analysis and communication of accounting information (A Level)

Accounting 9706 Chapter Notes

What this chapter covers

Analysis and communication of accounting information (A Level)
ShareWhatsAppPost
Analysis and communication of accounting information (A Level) notes

Unable to load PDF

The notes viewer could not load. Please refresh the page.

Read online free. Download a watermarked copy with a free account.

Read the notes

The full Analysis and communication of accounting information (A Level) notes as text: skim, search, and jump between subtopics.

~19 min read

1. Introduction to Ratio Analysis

Ratio analysis is the process of comparing line items in a company's financial statements (like the Statement of Profit or Loss and the Statement of Financial Position) to gain insights into its performance. Think of it as a financial health check. By calculating ratios, stakeholders such as managers, investors, and lenders can assess a company's profitability, its ability to pay its bills (liquidity), how efficiently it uses its resources, and the returns it provides to shareholders. Ratios are most powerful when compared over time (trend analysis) or against other companies in the same industry (cross-sectional analysis).

Key term

Ratio Analysis: A quantitative method of gaining insight into a company's liquidity, operational efficiency, and profitability by studying its financial statements.

Examiner insight

Examiners reward students who go beyond simple calculation and use ratios to support a wider analysis of a business's performance over time or against competitors.

Worked example 14 marks

Explain two reasons why a potential investor would use ratio analysis before buying shares in a company.

  1. 1

    Reason 1: To assess profitability. An investor would calculate ratios like Return on Capital Employed (ROCE) and profit margins to see how effectively the company is generating profit from its operations and capital. A history of strong and improving profitability suggests a healthy company and a potentially good investment.

  2. 2

    Reason 2: To evaluate investment returns and risk. An investor would use ratios like Earnings Per Share (EPS), Dividend Yield, and the P/E ratio to assess the potential return on their investment. For example, a high dividend yield indicates a good income stream, while EPS growth shows the company is becoming more profitable for each shareholder. These ratios help compare the company's value and returns against other potential investments.

Recap

  • Ratio analysis uses financial statement data to assess a company's performance.
  • It helps various stakeholders, including investors and managers, make informed decisions.
  • The main categories of ratios are profitability, liquidity, efficiency, and investor ratios.
  • Ratios are most useful when compared over several years or against industry competitors.
  • Analysis should always go beyond calculation to interpret what the ratios mean for the business.

Quick check

  1. List the four main categories of accounting ratios.2 marks
  2. What is the difference between trend analysis and cross-sectional analysis?2 marks

2. Measuring Profitability

Profitability ratios measure a company's ability to generate profit from its sales and resources. They are a key indicator of performance. The main profitability ratios are:

  1. Gross Profit Margin (GPM): This shows the profit made on sales after accounting for the cost of the goods sold. A high GPM indicates the company is efficient in its production or purchasing. Formula: (Gross Profit / Revenue) × 100.
  2. Profit Margin for the year: This shows the percentage of revenue left after all expenses, including operating costs, interest, and tax, have been deducted. It measures overall profitability. Formula: (Profit for the year / Revenue) × 100.
  3. Return on Capital Employed (ROCE): This is a crucial ratio that measures how efficiently a company is using its long-term funds to generate profit. It shows the return generated for every dollar of capital invested. Formula: (Profit from operations / Capital Employed) × 100, where Capital Employed = Total Assets - Current Liabilities OR Shareholders' Funds + Non-current Liabilities.

Gross Profit Margin (%) = (Gross Profit / Revenue) × 100

Profit Margin for the year (%) = (Profit for the year / Revenue) × 100

Return on Capital Employed (ROCE) (%) = (Profit from operations / (Shareholders' Funds + Non-current Liabilities)) × 100

Key term

Return on Capital Employed (ROCE): A financial ratio that measures a company's profitability and the efficiency with which its capital is employed to generate profits.

Common pitfall

Using 'profit for the year' when calculating ROCE. You must use 'profit from operations' as it reflects the profit generated before accounting for how the business is financed (interest).

Worked example 16 marks

Below are extracts from the financial statements of Z plc for the year ended 31 December 2023. Revenue: $800,000 Gross Profit: $320,000 Profit from operations: $120,000 Profit for the year: $88,000 Shareholders' Funds: $500,000 Non-current Liabilities: $300,000

Calculate the(i) Gross Profit Margin,(ii) Profit Margin for the year, and(iii) ROCE.

  1. 1

    Step 1: Calculate Gross Profit Margin (GPM). GPM = (Gross Profit / Revenue) × 100 GPM = ($320,000 / $800,000) × 100 = 40%.

  2. 2

    Step 2: Calculate Profit Margin for the year. Profit Margin = (Profit for the year / Revenue) × 100 Profit Margin = ($88,000 / $800,000) × 100 = 11%.

  3. 3

    Step 3: Calculate Capital Employed. Capital Employed = Shareholders' Funds + Non-current Liabilities Capital Employed = $500,000 + $300,000 = $800,000.

  4. 4

    Step 4: Calculate Return on Capital Employed (ROCE). ROCE = (Profit from operations / Capital Employed) × 100 ROCE = ($120,000 / $800,000) × 100 = 15%.

Recap

  • Profitability ratios measure a company's ability to generate earnings.
  • Gross Profit Margin assesses profitability from basic trading activities.
  • Profit Margin for the year measures overall profitability after all expenses.
  • ROCE is a key measure of how efficiently capital is used to generate profit.
  • A higher profitability ratio is generally better, but must be compared with context.

Quick check

  1. A company has revenue of $500,000 and gross profit of $200,000. Calculate the gross profit margin.2 marks
  2. Why is 'profit from operations' used to calculate ROCE instead of 'profit for the year'?2 marks

3. Assessing Liquidity

Liquidity refers to a company's ability to meet its short-term financial obligations (debts due within one year). Poor liquidity can lead to business failure, even if the company is profitable. Two key ratios are used to assess this:

  1. Current Ratio: This compares current assets (cash, receivables, inventory) to current liabilities (payables, overdrafts). A ratio of 1.5:1 to 2:1 is often considered healthy, suggesting the company has $1.50 to $2.00 of current assets for every $1 of current liabilities. Formula: Current Assets / Current Liabilities.
  2. Acid Test Ratio (or Quick Ratio): This is a stricter test of liquidity because it excludes inventory from current assets. Inventory can be difficult to sell quickly, so this ratio shows if a company can pay its current debts without relying on selling stock. A ratio of 1:1 is often seen as ideal. Formula: (Current Assets - Inventory) / Current Liabilities.

Current Ratio = Current Assets / Current Liabilities

Acid Test Ratio = (Current Assets - Inventory) / Current Liabilities

Key term

Liquidity: The ability of a business to meet its short-term debts as they fall due.

Examiner insight

Marks are often awarded for explaining *why* a ratio has changed, for example, linking a fall in the current ratio to an increase in trade payables or a purchase of non-current assets for cash.

Worked example 15 marks

A company's Statement of Financial Position shows the following: Inventory: $50,000 Trade Receivables: $70,000 Cash at Bank: $10,000 Trade Payables: $60,000 Bank Overdraft: $20,000

Calculate the current ratio and the acid test ratio, and briefly comment on the company's liquidity position.

  1. 1

    Step 1: Calculate Total Current Assets. Current Assets = Inventory + Trade Receivables + Cash at Bank Current Assets = $50,000 + $70,000 + $10,000 = $130,000.

  2. 2

    Step 2: Calculate Total Current Liabilities. Current Liabilities = Trade Payables + Bank Overdraft Current Liabilities = $60,000 + $20,000 = $80,000.

  3. 3

    Step 3: Calculate the Current Ratio. Current Ratio = Current Assets / Current Liabilities Current Ratio = $130,000 / $80,000 = 1.625:1.

  4. 4

    Step 4: Calculate the Acid Test Ratio. Acid Test Ratio = (Current Assets - Inventory) / Current Liabilities Acid Test Ratio = ($130,000 - $50,000) / $80,000 = $80,000 / $80,000 = 1:1.

  5. 5

    Step 5: Comment on the liquidity position. The current ratio of 1.625:1 is within the healthy range, suggesting the company can cover its short-term debts. The acid test ratio of 1:1 is ideal, indicating that the company has enough liquid assets to meet its current liabilities without needing to sell any inventory. Overall, the liquidity position appears strong.

Recap

  • Liquidity is the ability to pay short-term debts.
  • The current ratio compares all current assets to current liabilities.
  • The acid test ratio is a stricter measure that excludes inventory.
  • A current ratio between 1.5:1 and 2:1 is generally considered safe.
  • An acid test ratio of 1:1 is often considered ideal.
  • A ratio that is too high may suggest inefficient use of assets.

Quick check

  1. Why is inventory excluded from the acid test ratio calculation?1 mark

4. Evaluating Operational Efficiency

Efficiency ratios, also known as activity or turnover ratios, measure how well a company utilizes its assets and manages its liabilities. They provide insight into the company's operational performance and management of working capital.

  1. Inventory Turnover (days): Measures the average number of days it takes for a company to sell its inventory. A lower number is generally better, as it means inventory is not sitting idle for long. Formula: (Average Inventory / Cost of Sales) × 365.
  2. Trade Receivables Turnover (days): Shows the average number of days it takes for a company to collect cash from its credit customers. A shorter collection period is preferable as it improves cash flow. Formula: (Trade Receivables / Credit Revenue) × 365.
  3. Trade Payables Turnover (days): Indicates the average number of days it takes for a company to pay its credit suppliers. A longer period can be beneficial for cash flow, but stretching it too far can damage supplier relationships. Formula: (Trade Payables / Credit Purchases) × 365.

Inventory Turnover (days) = (Average Inventory / Cost of Sales) × 365

Trade Receivables Turnover (days) = (Trade Receivables / Credit Revenue) × 365

Trade Payables Turnover (days) = (Trade Payables / Credit Purchases) × 365

Non-current Asset Turnover = Revenue / Non-current Assets

Key term

Working Capital Cycle: The time lag between paying for raw materials and receiving cash from the sale of finished goods.

Common pitfall

Forgetting to use average figures for inventory, receivables or payables when both opening and closing balances are provided. Using the closing figure only is a common error.

Worked example 16 marks

Data for PQR Ltd: Revenue (all on credit): $900,000 Cost of Sales: $540,000 Credit Purchases: $450,000 Inventory: $60,000 Trade Receivables: $75,000 Trade Payables: $50,000 Assume inventory is constant throughout the year. Calculate the(i) inventory turnover,(ii) trade receivables turnover, and(iii) trade payables turnover.

  1. 1

    Step 1: Calculate Inventory Turnover in days. Inventory Turnover = (Inventory / Cost of Sales) × 365 Inventory Turnover = ($60,000 / $540,000) × 365 = 40.6 days. (Round to 41 days).

  2. 2

    Step 2: Calculate Trade Receivables Turnover in days. Trade Receivables Turnover = (Trade Receivables / Credit Revenue) × 365 Trade Receivables Turnover = ($75,000 / $900,000) × 365 = 30.4 days. (Round to 30 days).

  3. 3

    Step 3: Calculate Trade Payables Turnover in days. Trade Payables Turnover = (Trade Payables / Credit Purchases) × 365 Trade Payables Turnover = ($50,000 / $450,000) × 365 = 40.6 days. (Round to 41 days).

  4. 4

    Step 4: Interpretation (optional for calculation question, but good practice). The company holds inventory for 41 days, takes 30 days to collect cash from customers, and takes 41 days to pay its suppliers. The working capital cycle is 41 + 30 - 41 = 30 days. This means there is a 30-day gap between paying suppliers and receiving cash from customers that needs to be financed.

Recap

  • Efficiency ratios measure how well a company manages its assets and liabilities.
  • Inventory turnover shows how quickly stock is sold.
  • Receivables turnover indicates the speed of cash collection from customers.
  • Payables turnover shows how long the company takes to pay its suppliers.
  • These ratios are crucial for managing the working capital cycle and cash flow.
  • If opening and closing figures are available, always use the average for inventory, receivables, and payables.

Quick check

  1. A business has trade receivables of $30,000 and credit sales of $365,000. Calculate the trade receivables turnover in days.2 marks

5. Analysing Investor Returns

Investor ratios, or shareholder ratios, are vital for current and potential shareholders to assess the financial return and attractiveness of an investment in a company. They help answer questions like 'How much profit does the company make per share?' and 'What is the return on my investment?'.

  1. Earnings Per Share (EPS): This shows the amount of profit for the year attributable to each ordinary share. A rising EPS is a positive sign of growing profitability. Formula: (Profit for the year - Preference Dividends) / Number of Ordinary Shares.
  2. Price/Earnings (P/E) Ratio: This compares the company's market share price to its EPS. It indicates how many years it would take for the company's earnings to cover the share price. A high P/E ratio can suggest that investors expect high future growth. Formula: Market Price per Share / Earnings Per Share.
  3. Dividend Yield: This expresses the annual dividend per share as a percentage of the current market price. It measures the rate of return an investor gets from dividends. Formula: (Dividend per Share / Market Price per Share) × 100.
  4. Dividend Cover: This measures how many times the company's earnings can pay the total ordinary dividend. A high cover (e.g., 2 or more) is safe, suggesting dividends are sustainable. A low cover (e.g., below 1.5) may indicate risk. Formula: (Profit for the year - Preference Dividends) / Total Ordinary Dividends.

Earnings Per Share (EPS) = (Profit for the year - Preference Dividends) / Number of Ordinary Shares Issued

Price/Earnings (P/E) Ratio = Market Price per Share / Earnings Per Share

Dividend Yield (%) = (Dividend per Share / Market Price per Share) × 100

Dividend Cover = (Profit for the year - Preference Dividends) / Total Ordinary Dividends Paid

Key term

Earnings Per Share (EPS): The portion of a company's profit allocated to each issued ordinary share, serving as a key indicator of a company's profitability on a per-share basis.

Fun fact

A high P/E ratio can indicate that investors are expecting high future growth in earnings, which is why technology companies often have very high P/E ratios compared to established utility companies.

Worked example 18 marks

Alpha plc has a profit for the year of $250,000. It has 1,000,000 issued ordinary shares and paid no preference dividends. The total ordinary dividend paid was $100,000. The current market price of one share is $3.00. Calculate the(i) EPS,(ii) P/E ratio,(iii) Dividend Yield, and(iv) Dividend Cover.

  1. 1

    Step 1: Calculate Earnings Per Share (EPS). EPS = Profit for the year / Number of Ordinary Shares EPS = $250,000 / 1,000,000 = $0.25 per share.

  2. 2

    Step 2: Calculate Price/Earnings (P/E) Ratio. P/E Ratio = Market Price per Share / EPS P/E Ratio = $3.00 / $0.25 = 12.

  3. 3

    Step 3: Calculate Dividend per Share (DPS) first, then Dividend Yield. DPS = Total Ordinary Dividends / Number of Ordinary Shares = $100,000 / 1,000,000 = $0.10 per share. Dividend Yield = (DPS / Market Price per Share) × 100 = ($0.10 / $3.00) × 100 = 3.33%.

  4. 4

    Step 4: Calculate Dividend Cover. Dividend Cover = Profit for the year / Total Ordinary Dividends Dividend Cover = $250,000 / $100,000 = 2.5 times.

Recap

  • Investor ratios help shareholders assess the return and risk of their investment.
  • EPS shows the profit attributable to each ordinary share.
  • P/E ratio indicates market confidence and growth expectations.
  • Dividend yield shows the cash return on a share as a percentage of its price.
  • Dividend cover measures the sustainability of dividend payments.

Quick check

  1. What does a P/E ratio of 15 signify?2 marks
  2. A company has a dividend cover of 1.2. What does this suggest about its dividend policy?2 marks

6. Limitations of Ratio Analysis

While extremely useful, ratio analysis has significant limitations that must be considered to avoid drawing misleading conclusions. Ratios are tools, not answers in themselves. Key limitations include:

  • Historical Data: Ratios are calculated using past figures from financial statements. They do not guarantee future performance.
  • Inflation: Over time, inflation can distort figures, making comparisons between different years misleading unless adjustments are made.
  • Different Accounting Policies: Two companies may use different methods for things like depreciation (e.g., straight-line vs reducing balance) or inventory valuation (e.g., FIFO vs AVCO). This makes a direct comparison of their ratios unreliable.
  • Window Dressing: Management may manipulate financial statements to make them look more favourable around the reporting date. For example, delaying payments to suppliers to improve liquidity ratios.
  • Industry Differences: A 'good' ratio for a supermarket (low margins, high volume) would be a 'bad' ratio for a luxury jeweller (high margins, low volume). Comparisons are only meaningful within the same industry.
  • Qualitative Factors: Ratios ignore crucial non-financial information such as the quality of management, employee morale, brand reputation, customer loyalty, and economic conditions. A company with great ratios could still be at risk if its key product is about to become obsolete.

Key term

Window Dressing: Actions taken by a company's management to make its financial statements appear more attractive than they actually are, particularly at the end of an accounting period.

Examiner insight

Top-level answers demonstrate evaluation by discussing the limitations of the data provided and suggesting what other information would be needed to make a more informed decision.

Worked example 14 marks

An analyst is comparing the performance of a supermarket chain with a high-end car manufacturer using ratio analysis. Discuss two limitations the analyst will face.

  1. 1

    Limitation 1: Industry Differences. The business models are fundamentally different. The supermarket will have very low profit margins but extremely high inventory turnover. The car manufacturer will have very high profit margins but low inventory turnover. Comparing their respective margin and turnover ratios directly would be meaningless and lead to incorrect conclusions about which is 'more efficient' or 'more profitable'.

  2. 2

    Limitation 2: Different Capital Structures. The car manufacturer will have huge investments in non-current assets (factories, machinery), leading to a different asset structure and likely a different ROCE profile compared to the supermarket, which may lease its stores. This makes a like-for-like comparison of ratios like ROCE or asset turnover difficult without significant adjustments and understanding of the industry norms for each sector.

Recap

  • Ratio analysis is based on historical data and may not predict the future.
  • Comparisons can be distorted by inflation and different accounting policies.
  • Be aware of 'window dressing' where companies manipulate year-end figures.
  • Ratios are only meaningful when compared to industry averages or historical trends.
  • Ratio analysis ignores important non-financial (qualitative) factors.

Quick check

  1. State two non-financial factors that could affect a company's performance but are not reflected in accounting ratios.2 marks

7. Structuring Your Analysis and Communication

In A-Level Accounting, simply calculating ratios is not enough. You must analyse and communicate your findings effectively to earn high marks. This involves telling the 'story' behind the numbers. A good structure for a written analysis question is the 'CACE' framework: Calculate, Analyse, Compare, Evaluate.

  1. Calculate: Begin by accurately calculating a range of relevant ratios for the question. Always show your formulas and workings clearly.
  2. Analyse: For each ratio calculated, state what it shows and explain the potential reasons for its value or for any change over time. For example, don't just say 'The GPM fell from 40% to 35%'. Instead, say 'The GPM fell from 40% to 35%, which suggests either the selling price was reduced to boost sales, or the cost of sales increased, perhaps due to higher raw material prices. This has reduced the profitability of each sale.'
  3. Compare: Place the ratios in context. Compare them year-on-year (trend analysis) to identify improvements or deteriorations. If data is provided, compare them to a competitor or industry averages (cross-sectional analysis).
  4. Evaluate and Conclude: This is the most important step. Synthesise your points. Discuss the overall picture – is the company's performance improving or declining? Acknowledge the limitations of your analysis (e.g., 'This analysis is based only on financial data and ignores staff morale...'). Finally, provide a clear, justified conclusion or recommendation that directly answers the question asked (e.g., 'advise the investor', 'recommend whether to grant the loan').

Key term

Stakeholder: Any individual, group, or party that has an interest in an organization and the outcomes of its actions, such as investors, employees, customers, and suppliers.

Examiner insight

A common mistake is to simply list calculated ratios. To earn analysis and evaluation marks, students must interpret the ratios in the context of the business scenario and use them to build an argument.

Worked example 16 marks

A potential investor is considering buying shares in B plc. They have provided you with the company's ROCE for the last two years: 2022: 18%, 2023: 14%. Advise the investor on what this change in ROCE indicates.

  1. 1

    Step 1 (Identify the trend): The Return on Capital Employed (ROCE) has declined from 18% in 2022 to 14% in 2023. This is a negative trend.

  2. 2

    Step 2 (Analyse the components of the ratio): ROCE is calculated as (Profit from Operations / Capital Employed). The decline could be due to two main reasons, or a combination of both:(a) a fall in operating profit, or(b) an increase in capital employed without a proportional increase in profit.

  3. 3

    Step 3 (Provide specific reasons): A fall in operating profit could be caused by lower gross profit margins (due to higher costs or lower prices) or an increase in operating expenses like administration or marketing. An increase in capital employed could be due to significant investment in new non-current assets or an increase in working capital, with the returns from these investments not yet being fully realised.

  4. 4

    Step 4 (Advise the investor): The investor should be concerned by this decline as it indicates the company is becoming less efficient at generating profits from its capital. Before investing, they should investigate the cause. If the fall is due to a long-term investment that will generate future profits, it may be less worrying. However, if it's due to falling margins and poor cost control, it signals a decline in core performance and increases the risk of the investment.

Recap

  • Use the CACE framework: Calculate, Analyse, Compare, Evaluate.
  • Always show your formulas and workings for calculations.
  • Analyse means explaining the reasons behind the numbers.
  • Compare ratios over time (trends) and against competitors (benchmarking).
  • Your evaluation should consider limitations and non-financial factors.
  • End with a clear conclusion that directly answers the specific question asked.

Quick check

  1. What is the difference between analysis and evaluation in an accounting context?2 marks

End-of-chapter exercise

Test yourself on the whole chapter. Work through these before moving on.

  1. From the data provided, calculate the (i) current ratio and (ii) acid test ratio. Current Assets: $150,000; Inventory: $60,000; Current Liabilities: $75,000.4 marks
  2. Explain the purpose of the Return on Capital Employed (ROCE) ratio and why it is considered a primary measure of profitability.4 marks
  3. A company's gross profit margin has increased from 30% to 35%, but its profit for the year margin has decreased from 12% to 9%. Suggest two distinct reasons that could explain this situation.4 marks
  4. Calculate the (i) inventory turnover in days, (ii) trade receivables turnover in days, and (iii) trade payables turnover in days from the following information. Cost of Sales: $400,000; Credit Revenue: $650,000; Credit Purchases: $380,000; Average Inventory: $50,000; Trade Receivables: $80,000; Trade Payables: $45,000.6 marks
  5. Discuss two limitations of using ratio analysis to assess a company's financial performance over a five-year period.6 marks
  6. A company has profit for the year of $500,000 after paying preference dividends of $50,000. It has 2,000,000 ordinary shares in issue with a market price of $4.50 each. It paid a total ordinary dividend of $225,000. Calculate the (i) Earnings Per Share, (ii) P/E Ratio, and (iii) Dividend Cover.7 marks
  7. Analyse the usefulness of investor ratios (such as EPS and Dividend Yield) to a potential shareholder compared to a long-term lender like a bank.8 marks
  8. Company A has a current ratio of 2.5:1 and an acid test ratio of 0.8:1. Company B has a current ratio of 1.4:1 and an acid test ratio of 1.2:1. Both companies are in the retail industry. Analyse the liquidity position of both companies and advise which company appears to be managing its working capital more effectively.10 marks
  9. 'Ratio analysis is a pointless exercise unless non-financial factors are also considered.' To what extent do you agree with this statement? Justify your answer with examples.12 marks
  10. You are a financial analyst advising a client who is considering selling their shares in either Company X or Company Y. Using the financial data provided below for both companies, calculate at least two profitability ratios and two investor ratios for each. Conclude with a justified recommendation on which company's shares the client should sell. Data for both companies: Revenue, Profit from Operations, Profit for the Year, Share Capital, Market Price per Share, Dividends Paid.15 marks

Go deeper

Practise and revise with member-only material for this chapter.

Free notes are just the start.

Unlock every Workbook and Chapter at a Glance, and generate your own worksheets and predicted papers.

Explore plans

Related chapters