Subject: Business | Level: GCSE | Exam Board: AQA
Master the art of Data Interpretation, a crucial skill across all GCSE Business exam boards. Learn how to translate financial figures, market research, and graphs into strategic business decisions that secure top marks.
Revision Notes & Key Concepts
Key Terms & Definitions
- Gross Profit Margin
- A profitability ratio that measures the percentage of revenue left after deducting the direct costs of producing goods or services (Cost of Sales).
- Net Profit Margin
- A profitability ratio that measures the percentage of revenue remaining after all operating expenses, interest, and taxes have been deducted.
- Average Rate of Return (ARR)
- A method of evaluating investment appraisal that calculates the average annual profit of an investment as a percentage of its initial cost.
- Cash Flow Forecast
- A forward-looking financial document that estimates the cash inflows and outflows of a business over a specific period, usually monthly.
- Market Share
- The proportion of total sales in a particular market held by one specific business or brand, expressed as a percentage.
- Quantitative Data
- Information that can be measured and written down with numbers.
Worked Examples
Worked Example
Question: Table 1 shows the financial data for Business A. Revenue: £400,000. Cost of Sales: £150,000. Other Expenses: £100,000. Calculate the Net Profit Margin for Business A. State the formula used and show your workings. (4 marks)
Solution: **Formula**: Net Profit Margin = (Net Profit / Revenue) × 100 **Step 1 - Calculate Gross Profit**: Revenue (£400,000) - Cost of Sales (£150,000) = £250,000 **Step 2 - Calculate Net Profit**: Gross Profit (£250,000) - Other Expenses (£100,000) = £150,000 **Step 3 - Calculate NPM**: (£150,000 / £400,000) × 100 = 37.5% **Answer**: 37.5%
Worked Example
Question: Using the cash flow forecast provided in Figure 2, explain one problem the business faces in March and recommend one solution. (6 marks)
Solution: **Problem Identification**: The cash flow forecast shows a negative closing balance of -£15,000 in March. This is a liquidity problem, meaning the business has more cash flowing out than coming in during that month, largely due to the sudden £25,000 outflow for new equipment. **Impact**: If this deficit is not addressed, the business may be unable to pay its day-to-day operational expenses, such as staff wages or supplier invoices, which could halt production. **Recommended Solution**: The business should arrange a short-term bank overdraft facility before March. This would provide a flexible buffer to cover the £15,000 shortfall, allowing operations to continue smoothly until cash inflows improve in April.
Worked Example
Question: Evaluate whether Business B should proceed with a proposed marketing campaign, given the market research data in Extract C. (12 marks)
Solution: **Introduction**: The decision to proceed with the £50,000 marketing campaign depends on whether the projected increase in market share outweighs the significant upfront cost. **Argument For**: Extract C shows that 68% of surveyed consumers in the target demographic are currently unaware of Business B's core product. Furthermore, the data indicates the overall market size is growing by 8% annually. Proceeding with the campaign allows the business to capture this expanding market. If the campaign successfully converts just 10% of the unaware demographic, the projected revenue increase of £120,000 would comfortably cover the £50,000 cost, improving overall profitability. **Argument Against**: However, the market research in Extract C is based on a sample size of only 200 people, which may not be representative of the entire national market. Additionally, the data shows competitor prices have recently fallen by 5%. If competitors continue to cut prices, Business B's marketing campaign may fail to generate the expected sales volume, resulting in a sunk cost of £50,000 that could severely impact their cash flow. **Conclusion**: Overall, Business B should proceed with the campaign, but with caution. While the potential return on investment is strong given the 8% market growth, the reliability of the small sample size is a risk. They should perhaps test the campaign regionally first to gather more robust data before committing the full £50,000 budget.
Practice Questions
Question: A business has fixed costs of £50,000, variable costs of £10 per unit, and a selling price of £25 per unit. Calculate the break-even point in units. (2 marks)
Answer:
Question: Analyse the impact on a business's Net Profit Margin if its supplier increases raw material prices by 15%, assuming the business does not change its selling price. (6 marks)
Answer:
Question: Using the data provided (Revenue: £1.2m, Net Profit: £180,000), calculate the Net Profit Margin. (2 marks)
Answer:
Question: Explain one limitation of using a cash flow forecast for business planning. (3 marks)
Answer:
Question: A business is considering investing £100,000 in a new IT system. It expects total profit over 5 years to be £60,000. Calculate the Average Rate of Return (ARR). (4 marks)
Answer:
