Financial Calculations

Before calculating profit margins or assessing investment returns, a business must calculate its profit in absolute terms. The Edexcel specification requires two profit figures: gross profit and net profit.

Gross profit formula: Gross profit = Revenue − Cost of goods sold (COGS)

Net profit formula: Net profit = Gross profit − Expenses (overheads)

Cost of goods sold (COGS) — also called cost of sales — includes the direct costs of producing what the business sells: raw materials, manufacturing labour, packaging. It does not include overheads.

Expenses (overheads) include all other running costs: rent, utilities, marketing, admin salaries, insurance. These are deducted after gross profit to arrive at net profit.

Why both figures matter:

• Gross profit shows whether the core trading activity — buying and selling — is profitable before overhead costs
• Net profit is the "bottom line": what actually remains after all costs are paid

A business can have a healthy gross profit but a net loss if its overheads are excessive. Separating the two helps managers identify where cost problems lie.

Scenario: A sports equipment retailer reports the following annual figures.

	£
Revenue	500,000
Cost of goods sold	300,000
Expenses (overheads)	120,000

Step 1 — Gross profit:

$\text{Gross profit}=\pounds 500,000-\pounds 300,000=\pounds 200,000$

Step 2 — Net profit:

$\text{Net profit}=\pounds 200,000-\pounds 120,000=\pounds 80,000$

Interpretation:

The retailer generates £200,000 from its core trading before overheads. After paying rent, salaries, and other expenses totalling £120,000, it retains £80,000 in net profit. If the overhead figure were £210,000 instead, the business would make a net loss of £10,000 — even though its gross profit remains positive.

Exam tip: Always show two separate steps: gross profit first, then deduct expenses to find net profit. Do not jump straight to subtracting all costs from revenue in one step — the examiner wants to see you know the difference.

Absolute profit figures (£200,000 gross profit) only tell part of the story. A business earning £200,000 gross profit on revenue of £10,000,000 is far less efficient than one earning the same gross profit on £500,000 revenue. Profit margins express profit as a percentage of revenue, allowing comparison across businesses and over time.

Gross profit margin formula: $\text{Gross profit margin}=\frac{\text{Gross profit}}{\text{Revenue}}\times 100$

Net profit margin formula: $\text{Net profit margin}=\frac{\text{Net profit}}{\text{Revenue}}\times 100$

Using the figures from the worked example:

$\text{Gross profit margin}=\frac{\pounds 200,000}{\pounds 500,000}\times 100=40\%$

$\text{Net profit margin}=\frac{\pounds 80,000}{\pounds 500,000}\times 100=16\%$

What these percentages mean:

• A 40% gross profit margin means the business keeps 40p in gross profit for every £1 of revenue
• A 16% net profit margin means the business keeps 16p in net profit for every £1 of revenue after all costs
• The gap between 40% and 16% reflects the overhead burden (24 percentage points)

Formula	What it measures	What a higher value means
Gross profit margin	Efficiency of core trading relative to revenue	Better control of production/purchasing costs
Net profit margin	Overall profitability relative to revenue	Better control of both direct and overhead costs
Average rate of return (ARR)	Annual return on an investment as a %	More profitable use of the capital invested

When a business considers investing in new equipment, opening a new site, or launching a product line, it needs to assess whether the investment is worth making. The average rate of return (ARR) compares the average annual profit generated by an investment against the cost of making it.

ARR formula: $\text{ARR}=\frac{\text{Average annual profit}}{\text{Cost of investment}}\times 100$

where $\text{Average annual profit}=\frac{\text{Total profit over investment period}}{\text{Number of years}}$

ARR is expressed as a percentage. A higher ARR means the investment generates a better return per pound invested. Businesses typically compare ARR to a minimum required return (or to a bank interest rate) to decide whether to proceed.

A business invests £200,000 in new production equipment. Over 4 years, the equipment generates total additional profit of £80,000.

Step 1 — Average annual profit:

$\text{Average annual profit}=\frac{\pounds 80,000}{4}=\pounds 20,000\text{ per year}$

Step 2 — ARR:

$\text{ARR}=\frac{\pounds 20,000}{\pounds 200,000}\times 100=10\%$

Interpretation: The equipment generates a 10% annual return on the £200,000 invested. If the business's minimum required return is 8%, this investment exceeds the threshold and should be considered. If the bank offers 12% on deposits, the investment underperforms the alternative — and the decision requires further thought.

A café owner invests £60,000 in a kitchen refurbishment. Over 3 years, total additional profit is £27,000.

Step 1 — Average annual profit:

$\text{Average annual profit}=\frac{\pounds 27,000}{3}=\pounds 9,000\text{ per year}$

Step 2 — ARR:

$\text{ARR}=\frac{\pounds 9,000}{\pounds 60,000}\times 100=15\%$

Interpretation: A 15% ARR. If the owner's alternative was leaving the money in a savings account earning 3%, the refurbishment is substantially more profitable per pound invested. However, ARR does not account for the timing of cash flows — profit earned in year 3 is treated the same as profit earned in year 1, which understates the real cost of waiting.

Exam tip: If asked to "assess" or "evaluate" an ARR figure, state what the percentage means in plain English, compare it to an alternative (a benchmark or savings rate), and acknowledge a limitation — for example, ARR ignores the timing of cash flows and does not account for the risk of the investment.

Calculation checklist for financial questions:

1. Label every step

Write the formula, substitute the numbers, then write the answer with units. Do not skip straight to the answer — method marks are available even if arithmetic goes wrong.

2. Net profit uses gross profit as the starting point

Net profit = Gross profit − Expenses. Do not subtract expenses from revenue directly unless you are combining both steps — and even then, show them separately.

3. ARR needs the average annual figure — not total profit

A common error is dividing total profit by total revenue, or forgetting to divide total profit by the number of years. Always compute average annual profit first, then divide by the investment cost.

4. Margin vs absolute profit

A rising profit in £ terms may still reflect a falling margin if revenue has grown faster. An examiner may give both sets of numbers and ask you to assess performance — calculate and compare both.

Common error	Correct approach
Using total profit (not average annual profit) in ARR	Divide total profit by number of years first, then divide by investment
Forgetting to multiply by 100 in margin formulas	The formula gives a decimal — multiply by 100 to express as a percentage
Skipping gross profit and going straight to net profit	Gross profit and net profit are separate calculations — show both
Treating a high margin as always good	Context matters — compare to prior year, competitors, or industry average