Using Financial Data for Decision Making

This lesson covers the final part of AQA A-Level Business topic 3.5 — using financial data to support strategic and operational decision-making. You will learn how to interpret financial data, understand its limitations, and link financial analysis to broader business strategy.

---

The Role of Financial Data in Business Decisions

Financial data is at the heart of business decision-making. Managers, investors, and other stakeholders use financial information to:

• Assess performance: Is the business meeting its financial objectives?
• Compare alternatives: Which investment, project, or strategy offers the best return?
• Identify problems: Where is the business underperforming?
• Plan for the future: What resources will be needed? What financing is required?
• Communicate with stakeholders: Reports to shareholders, banks, and regulators rely on financial data.

Key Principle: Financial data provides the quantitative foundation for decision-making — but it must always be interpreted in context and supplemented with qualitative judgement.

---

Key Financial Tools and Their Uses

Tool	What It Tells You	Typical Decision
Break-even analysis	The output needed to cover costs	Whether to launch a new product; pricing decisions
Cash flow forecasts	Expected future cash position	Whether to arrange an overdraft; timing of major purchases
Budgets and variance analysis	Whether performance is on track	Whether to cut spending or invest more in high-performing areas
Profitability ratios	How efficiently the business converts revenue to profit	Whether to raise prices, cut costs, or change strategy
ROI	The return generated by an investment	Whether to proceed with a capital project
Working capital analysis	The business's ability to meet short-term obligations	Whether to tighten credit control or reduce inventory

---

Interpreting Financial Data: A Systematic Approach

When analysing financial data in an exam, use this structured approach:

Step 1: Calculate the Relevant Figures

Perform the necessary calculations — ratios, break-even output, variances, margins, etc. Show your working clearly.

Step 2: Identify Trends and Patterns

Look for changes over time:

Pattern	Possible Interpretation
Revenue rising, profit falling	Costs are rising faster than revenue — efficiency problem
Gross margin stable, operating margin falling	Overheads are increasing — investigate administrative and marketing costs
Cash flow negative despite positive profit	Timing issue — receivables too high, capital expenditure draining cash
Favourable revenue variance, adverse cost variance	Additional sales may have required extra spending (marketing, overtime)

Step 3: Diagnose the Cause

Financial data tells you what is happening but not always why. You must link the data to the business context:

• Has a new competitor entered the market?
• Have input costs risen due to supply chain disruption?
• Is the business overtrading due to rapid growth?
• Has a key customer been lost?

Step 4: Recommend Actions

Based on your analysis, recommend specific, justified actions:

• If gross margins are falling: negotiate with suppliers, improve production efficiency, consider raising prices.
• If cash flow is negative: tighten credit control, reduce inventory, arrange overdraft.
• If ROI is below target: reconsider the investment, explore ways to increase returns, or reallocate resources.

Step 5: Evaluate

Consider the limitations of your analysis and the risks of your recommendations.

---

Worked Example: Integrated Financial Analysis

A furniture manufacturer provides the following data:

	Year 1 (£)	Year 2 (£)
Revenue	2,000,000	2,400,000
Cost of sales	1,200,000	1,560,000
Gross profit	800,000	840,000
Operating expenses	500,000	620,000
Operating profit	300,000	220,000
Interest	20,000	50,000
Net profit	280,000	170,000

Ratio analysis:

Ratio	Year 1	Year 2	Change
Gross profit margin	40.0%	35.0%	-5.0 pp
Operating profit margin	15.0%	9.2%	-5.8 pp
Net profit margin	14.0%	7.1%	-6.9 pp

Interpretation: