Cambridge O Level7707

Calculation and understanding of accounting ratios

Accounting 7707 Chapter Notes

What this chapter covers

Calculation and understanding of accounting ratiosInterpretation of accounting ratiosInter-business comparisonInterested partiesLimitations of accounting statements
ShareWhatsAppPost
Calculation and understanding of accounting ratios 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 Calculation and understanding of accounting ratios notes as text: skim, search, and jump between subtopics.

~11 min read

1. Measuring Profitability: Gross and Profit Margins

Profitability ratios measure a business's ability to generate profit from its sales. The Gross Profit Margin shows the profit made on the goods sold, before considering other expenses. It tells you how much profit is generated for every $1 of revenue from the core trading activity. The Profit Margin (or Net Profit Margin) is a more comprehensive measure. It shows the percentage of revenue that is left after ALL expenses, including overheads like rent and salaries, have been deducted. A large difference between the gross and profit margins can indicate high operating expenses.

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

Profit Margin (%) = (Profit for the Year / Revenue) x 100

Key term

Profitability: A measure of a business's ability to generate profit relative to its revenue, assets, or equity.

Examiner insight

Examiners often ask for reasons for a change in margins. A fall in gross margin could be due to higher purchase costs or lower selling prices. A fall in profit margin could be due to increased overheads like rent or advertising.

Common pitfall

Using 'Profit for the Year' when calculating Gross Margin, or 'Gross Profit' when calculating Profit Margin. Always use the correct profit figure for the corresponding ratio.

Worked example 14 marks

An income statement shows Revenue of $200,000, Cost of Sales of $120,000, and Expenses of $50,000. Calculate the Gross Margin and Profit Margin.

  1. 1

    Step 1: Calculate Gross Profit. Gross Profit = Revenue - Cost of Sales = $200,000 - $120,000 = $80,000.

  2. 2

    Step 2: Calculate Gross Margin. Gross Margin = (Gross Profit / Revenue) x 100 = ($80,000 / $200,000) x 100 = 40%.

  3. 3

    Step 3: Calculate Profit for the Year. Profit for the Year = Gross Profit - Expenses = $80,000 - $50,000 = $30,000.

  4. 4

    Step 4: Calculate Profit Margin. Profit Margin = (Profit for the Year / Revenue) x 100 = ($30,000 / $200,000) x 100 = 15%.

Recap

  • Gross margin measures profitability from trading activities only.
  • Profit margin measures overall profitability after all expenses.
  • Both ratios are expressed as a percentage of revenue.
  • Comparing the two margins reveals how well a business controls its overheads.
  • A higher percentage for both ratios is generally better.

Quick check

  1. What is the formula for calculating the Gross Profit Margin?1 mark
  2. If a business has a gross margin of 60% and a profit margin of 10%, what does this suggest about its expenses?2 marks

2. Assessing Efficiency: Return on Capital Employed (ROCE)

Return on Capital Employed (ROCE) is a crucial profitability ratio that measures how effectively a business is using its long-term funds to generate profits. It shows the profit generated for every $100 of capital invested in the business. 'Capital Employed' represents the total long-term capital from both owners (equity) and lenders (non-current liabilities). A higher ROCE is desirable as it indicates more efficient use of capital. It is often compared with the previous year's ROCE or the interest rates available from a bank to judge performance.

ROCE (%) = (Profit from Operations / Capital Employed) x 100

Capital Employed = Total Equity + Non-current Liabilities

Key term

Capital Employed: The total long-term funds invested in a business used to finance its assets, calculated as Total Equity plus Non-current Liabilities.

Examiner insight

Candidates who clearly show their calculation for Capital Employed before calculating the final ROCE percentage are more likely to gain full marks, even if a small arithmetic error is made later.

Common pitfall

Using 'Profit for the Year' instead of 'Profit from Operations' (profit before interest). Interest is a return to providers of debt capital, so it's added back to the profit to see the total return generated by all capital.

Worked example 13 marks

A business has Profit from Operations of $50,000. Its Statement of Financial Position shows Total Equity of $300,000 and a Bank Loan (non-current liability) of $100,000. Calculate the ROCE.

  1. 1

    Step 1: Calculate Capital Employed. Capital Employed = Total Equity + Non-current Liabilities = $300,000 + $100,000 = $400,000.

  2. 2

    Step 2: Calculate ROCE. ROCE = (Profit from Operations / Capital Employed) x 100 = ($50,000 / $400,000) x 100 = 12.5%.

Recap

  • ROCE measures how efficiently a business uses its long-term capital to make a profit.
  • Capital Employed is the sum of equity and non-current liabilities.
  • The profit figure used is 'Profit from Operations', which is profit before interest and tax.
  • A higher ROCE indicates greater efficiency and is generally preferred by investors.
  • ROCE is useful for comparing the performance of different businesses or the same business over time.

Quick check

  1. Name the two components of Capital Employed.2 marks
  2. Why is ROCE considered a primary measure of performance by investors?1 mark

3. Can the Business Pay its Bills? Liquidity Ratios

Liquidity ratios assess a business's ability to meet its short-term debts (current liabilities) as they become due. The Current Ratio compares all current assets with all current liabilities. A commonly accepted 'safe' ratio is between 1.5:1 and 2:1, meaning the business has $1.50 to $2.00 of current assets for every $1 of current liabilities. The Liquid Ratio, also known as the Acid Test Ratio, is a stricter test. It removes inventory from current assets because inventory can be difficult to sell quickly. A ratio of 1:1 is often considered ideal, showing the business can pay its immediate debts without relying on selling stock.

Current Ratio = Current Assets / Current Liabilities

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

Key term

Liquidity: The ability of a business to convert its assets into cash to pay its short-term debts and other liabilities.

Common pitfall

Forgetting to express the final answer in the correct format, which is 'X : 1'. For example, an answer of 1.5 should be written as 1.5:1.

Fun fact

The term 'acid test' comes from the old practice of using acid to test for gold. A 'true' acid test would distinguish real gold from base metals, just as the liquid ratio distinguishes a truly liquid business from one that merely looks good on paper.

Worked example 15 marks

A business has Current Assets of $50,000 (including Inventory of $20,000) and Current Liabilities of $25,000. Calculate and comment on its liquidity.

  1. 1

    Step 1: Calculate the Current Ratio. Current Ratio = $50,000 / $25,000 = 2:1.

  2. 2

    Step 2: Calculate the Liquid Ratio. Liquid Ratio = ($50,000 - $20,000) / $25,000 = $30,000 / $25,000 = 1.2:1.

  3. 3

    Step 3: Comment on the results. The current ratio of 2:1 is healthy, suggesting the business can cover its short-term debts. The liquid ratio of 1.2:1 is also strong, indicating it can meet its obligations even without selling any inventory.

Recap

  • Liquidity is about meeting short-term debts.
  • The Current Ratio compares current assets to current liabilities.
  • The Liquid (Acid Test) Ratio is a stricter test that excludes inventory.
  • An ideal current ratio is often cited as 1.5:1 to 2:1.
  • An ideal liquid ratio is often cited as 1:1.
  • These ratios are expressed as 'X : 1'.

Quick check

  1. Why is inventory excluded from the liquid ratio calculation?1 mark
  2. A business has a current ratio of 0.8:1. What does this indicate?1 mark

4. Managing Stock: Rate of Inventory Turnover

The Rate of Inventory Turnover is an efficiency ratio that measures how many times a business sells and replaces its inventory over a specific period, usually a year. It indicates how efficiently the business is managing its stock. A high turnover rate is generally good, suggesting strong sales and less money tied up in inventory. However, a rate that is too high might lead to stock-outs and lost sales. A low turnover rate can indicate poor sales, obsolescence, or over-stocking. To get a more accurate picture, we use average inventory in the calculation.

Rate of Inventory Turnover (times) = Cost of Sales / Average Inventory

Average Inventory = (Opening Inventory + Closing Inventory) / 2

Key term

Inventory Turnover: An efficiency ratio that measures the number of times inventory is sold or used in a time period such as a year.

Examiner insight

When asked to comment, students should consider the type of business. A supermarket will have a very high inventory turnover, while a car dealership will have a much lower one. Context is key to good analysis.

Common pitfall

Using Revenue instead of Cost of Sales in the numerator. The ratio compares the cost of the goods sold with the cost of the inventory held, so both figures must be at cost price.

Worked example 13 marks

A company had opening inventory of $30,000 and closing inventory of $50,000. Its cost of sales for the year was $400,000. Calculate the rate of inventory turnover.

  1. 1

    Step 1: Calculate Average Inventory. Average Inventory = (Opening Inventory + Closing Inventory) / 2 = ($30,000 + $50,000) / 2 = $40,000.

  2. 2

    Step 2: Calculate the Rate of Inventory Turnover. Rate of Inventory Turnover = Cost of Sales / Average Inventory = $400,000 / $40,000 = 10 times.

Recap

  • Inventory turnover measures how quickly stock is being sold.
  • The formula is Cost of Sales divided by Average Inventory.
  • Average inventory is calculated by adding opening and closing inventory and dividing by two.
  • A high turnover is usually desirable but carries risks of stock-outs.
  • A low turnover may indicate slow-moving or obsolete stock.

Quick check

  1. What does a rate of inventory turnover of '4 times' mean?1 mark
  2. If only closing inventory is provided in an exam question, what should you do?1 mark

5. Managing Cash: Receivables and Payables Turnover

These efficiency ratios focus on the management of credit with customers and suppliers. The Trade Receivables Turnover (in days) calculates the average number of days it takes for a business to collect cash from its credit customers. A lower number is better, as it means cash is coming into the business more quickly. The Trade Payables Turnover (in days) calculates the average number of days a business takes to pay its credit suppliers. A higher number can be beneficial as it means the business holds onto its cash for longer, improving its cash flow. However, paying too late can damage relationships with suppliers and risk losing credit facilities. Ideally, a business should collect from receivables faster than it pays its payables.

Trade Receivables Turnover (days) = (Trade Receivables / Credit Sales) x 365

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

Key term

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

Examiner insight

Marks are often awarded for comparing the two ratios. A good answer will state that the business is collecting cash faster than it is paying it out (or vice versa) and explain the implication for the business's cash flow.

Common pitfall

Using total sales or total purchases in the calculation. These ratios are specifically about managing credit, so only credit transactions should be included. If not given, you may have to assume all sales/purchases are on credit, but you must state this assumption.

Worked example 15 marks

A business has Trade Receivables of $40,000 and Credit Sales of $320,000. It also has Trade Payables of $30,000 and Credit Purchases of $180,000. Calculate the turnover periods in days.

  1. 1

    Step 1: Calculate Trade Receivables Turnover. Turnover (days) = (Trade Receivables / Credit Sales) x 365 = ($40,000 / $320,000) x 365 = 45.6 days. (Round to 46 days).

  2. 2

    Step 2: Calculate Trade Payables Turnover. Turnover (days) = (Trade Payables / Credit Purchases) x 365 = ($30,000 / $180,000) x 365 = 60.8 days. (Round to 61 days).

  3. 3

    Step 3: Comment on the results. The business takes an average of 46 days to collect cash from customers but takes 61 days to pay its suppliers. This is a favourable position as it receives cash before it has to pay it out, which benefits its working capital.

Recap

  • Receivables turnover measures how long it takes customers to pay.
  • Payables turnover measures how long the business takes to pay suppliers.
  • A short receivables period and a long payables period is generally good for cash flow.
  • Always use credit sales and credit purchases, not total sales and purchases.
  • The answer is expressed in days (or sometimes weeks or months).

Quick check

  1. What is the formula for trade receivables turnover in days?1 mark
  2. Is it always good for a business to have a very long trade payables turnover period? Explain your answer.2 marks

End-of-chapter exercise

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

  1. From the following figures, calculate the profit margin to one decimal place: Revenue $500,000; Gross Profit $200,000; Profit for the Year $75,000.2 marks
  2. A business has current assets of $80,000 and a current ratio of 2.5:1. Calculate the value of its current liabilities.2 marks
  3. Explain the difference between the current ratio and the liquid (acid test) ratio, and state why this difference is important.3 marks
  4. A company's Statement of Financial Position shows: Equity $450,000; Non-current Liabilities $150,000. Its income statement shows Profit from Operations of $90,000. Calculate the Return on Capital Employed (ROCE).3 marks
  5. A business has a trade receivables turnover of 30 days and a trade payables turnover of 50 days. Explain whether this is a favourable or unfavourable situation for the business's cash flow.4 marks
  6. Given the following information: Revenue $600,000; Cost of Sales $350,000; Expenses $180,000. Calculate (a) the gross margin and (b) the profit margin.4 marks
  7. A retailer's cost of sales was $800,000. Opening inventory was $90,000 and closing inventory was $110,000. Calculate the rate of inventory turnover in times.3 marks
  8. A business has credit sales of $730,000 and its trade receivables at the year-end are $80,000. Calculate the trade receivables turnover period in days.2 marks
  9. The ROCE for a business fell from 15% to 11%. Suggest two different reasons that could explain this fall in profitability.4 marks
  10. A company provides the following data: Current Assets $120,000; Inventory $50,000; Current Liabilities $80,000. Calculate the current ratio and the liquid (acid test) ratio, and briefly comment on the company's liquidity position.5 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