Financial Laboratory · Profit and statements
Profit and loss builder
What profit is left at each stage, from sales revenue to retained profit?
- IB 3.4 Final accounts
- SL and HL
- Layout of the guide’s financial statements
- Simulated data Example: Emberly Roasters, fictional
The layout and line names of the guide’s statement of profit or loss for a profit-making entity (figure 6, p. 59). The subtotals follow from its order; the formula sheet does not list them.
The calculator
Example figures: Emberly Roasters, a fictional business. Simulated data.
The calculator could not start. The worked example below uses the example figures.
The figures
- Sales revenue
- $958,800
- Opening stock
- $47,200
- Purchases
- $561,100
- Closing stock
- $66,800
- Expenses
- $332,100
- Interest
- $9,600
- Tax
- $18,900
- Dividends
- $20,000
Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.
Result
These results are for the last complete figures. Correct the figure marked in the inputs to update them.
Profit for period
$56,700
Retained profit $36,700; gross profit margin 43.52%
| Line | $ |
|---|---|
| Sales revenue | 958,800 |
| Cost of sales | (541,500) |
| Gross profit | 417,300 |
| Expenses | (332,100) |
| Profit before interest and tax | 85,200 |
| Interest | (9,600) |
| Profit before tax | 75,600 |
| Tax | (18,900) |
| Profit for period | 56,700 |
| Dividends | (20,000) |
| Retained profit | 36,700 |
Deductions and losses are in brackets, as in the guide’s layout (figure 6, p. 59).
- Gross profit margin
- 43.52%gross profit ÷ sales revenue × 100
- Profit margin
- 8.89%profit before interest and tax ÷ sales revenue × 100
- Share of sales taken by expenses
- 34.64%the gap between the two margins
- Cost of sales
- $541,500opening stock + purchases − closing stock
Section 01: The formula and the working
Each formula in the guide’s words, then the working with the figures above, step by step.
Cost of sales = opening stock + purchases − closing stock
For a business that buys goods to resell.
Gross profit = sales revenue − cost of sales
Each subtotal follows the order of the guide’s statement of profit or loss (figure 6, p. 59).
Profit before interest and tax = gross profit − expenses
Profit before tax = profit before interest and tax − interest
Profit for period = profit before tax − tax
Retained profit = profit for period − dividends
Cost of sales
- Given
- Opening stock: $47,200
- Purchases: $561,100
- Closing stock: $66,800
- Formula
- Cost of sales = opening stock + purchases − closing stock
- Substitution
- = $47,200 + $561,100 − $66,800
- Working
- 47,200 + 561,100 − 66,800 = 541,500
- Answer
- $541,500
Closing stock is taken away because it has not been sold yet; it appears again as a current asset in the statement of financial position.
- Unit
- $
- Interpretation
- The goods actually sold in the period cost $541,500.
- Business implication
- Only the cost of what was sold belongs in this year’s cost of sales, not everything bought.
Gross profit
- Given
- Sales revenue: $958,800
- Cost of sales: $541,500
- Formula
- Gross profit = sales revenue − cost of sales
- Substitution
- = $958,800 − $541,500
- Working
- 958,800 − 541,500 = 417,300
- Answer
- $417,300
- Unit
- $
- Interpretation
- Trading leaves $417,300 after the cost of the goods sold, 43.52% of sales revenue.
- Business implication
- This is what is left to pay the expenses of running the business.
Profit before interest and tax
- Given
- Gross profit: $417,300
- Expenses: $332,100
- Formula
- Profit before interest and tax = gross profit − expenses
- Substitution
- = $417,300 − $332,100
- Working
- 417,300 − 332,100 = 85,200
- Answer
- $85,200
- Unit
- $
- Interpretation
- Operations earn $85,200 before the cost of finance and tax, 8.89% of sales revenue.
- Business implication
- The profit margin and ROCE both start from this figure.
Profit before tax and profit for period
- Given
- Profit before interest and tax: $85,200
- Interest: $9,600
- Tax: $18,900
- Formula
- Profit before tax = profit before interest and tax − interest; profit for period = profit before tax − tax
- Substitution
- = $85,200 − $9,600; then − $18,900
- Working
- 85,200 − 9,600 = 75,60075,600 − 18,900 = 56,700
- Answer
- $56,700
- Unit
- $
- Interpretation
- After interest and tax, $56,700 belongs to the owners.
- Business implication
- Interest takes 11.3% of the operating profit.
Retained profit
- Given
- Profit for period: $56,700
- Dividends: $20,000
- Formula
- Retained profit = profit for period − dividends
- Substitution
- = $56,700 − $20,000
- Working
- 56,700 − 20,000 = 36,700
- Answer
- $36,700
- Unit
- $
- Interpretation
- $36,700 is kept in the business and adds to retained earnings.
- Business implication
- Retained profit is an internal source of finance (3.2) for the next year’s investment.
Gross profit margin
- Given
- Gross profit ($): 417,300
- Sales revenue ($): 958,800
- Formula
- Gross profit margin = (gross profit ÷ sales revenue) × 100
- Substitution
- = (417,300 ÷ 958,800) × 100
- Working
- 417,300 ÷ 958,800 = 0.43520.4352 × 100 = 43.52
- Answer
- 43.52%
- Unit
- per cent of sales revenue
- Interpretation
- 43.52% of each sale is left after the cost of sales.
- Business implication
- Worked in full, with two years, in the gross profit margin calculator.
Profit margin
- Given
- Profit before interest and tax ($): 85,200
- Sales revenue ($): 958,800
- Formula
- Profit margin = (profit before interest and tax ÷ sales revenue) × 100
- Substitution
- = (85,200 ÷ 958,800) × 100
- Working
- 85,200 ÷ 958,800 = 0.08890.0889 × 100 = 8.89
- Answer
- 8.89%
The guide uses profit before interest and tax, so the margin is not affected by how the business is financed.
- Unit
- per cent of sales revenue
- Interpretation
- 8.89% of each sale is left after all the costs of running the business.
- Business implication
- Worked in full, with two years, in the profit margin calculator.
Section 02: The chart
Drawn from the figures above, with every value also in a table.
The chart’s figures as a table
| Line | Amount | Kind |
|---|---|---|
| Sales revenue | 958,800 | Stage of profit |
| Cost of sales | (541,500) | Deduction |
| Gross profit | 417,300 | Stage of profit |
| Expenses | (332,100) | Deduction |
| Profit before interest and tax | 85,200 | Stage of profit |
| Interest | (9,600) | Deduction |
| Profit before tax | 75,600 | Stage of profit |
| Tax | (18,900) | Deduction |
| Profit for period | 56,700 | Stage of profit |
| Dividends | (20,000) | Deduction |
| Retained profit | 36,700 | Stage of profit |
Section 03: If sales revenue changes
Profit before interest and tax when sales revenue changes, assuming cost of sales moves in proportion and expenses stay the same. Interest, tax and dividends are left out, because they do not follow sales in a simple way.
| Change | Sales revenue | Gross profit | Profit before interest and tax | Profit margin | Change in profit |
|---|---|---|---|---|---|
| Sales −20% | $767,040 | $333,840 | $1,740 | 0.23% | −98.0% |
| Sales −10% | $862,920 | $375,570 | $43,470 | 5.04% | −49.0% |
| Sales −5% | $910,860 | $396,435 | $64,335 | 7.06% | −24.5% |
| As entered (the figures as entered) | $958,800 | $417,300 | $85,200 | 8.89% | as entered |
| Sales +5% | $1,006,740 | $438,165 | $106,065 | 10.54% | +24.5% |
| Sales +10% | $1,054,680 | $459,030 | $126,930 | 12.03% | +49.0% |
Reading. Because expenses stay the same while gross profit moves with sales, profit before interest and tax moves faster than sales: a 10% fall in sales cuts it by 49.0%, to $43,470.
Section 04: What it means
For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.
What the number means
From sales revenue of $958,800, the business keeps $417,300 after the cost of sales (gross profit, 43.52% of sales), $85,200 after expenses (profit before interest and tax, 8.89%) and $56,700 after interest and tax. It pays $20,000 in dividends and retains $36,700. The largest deduction is cost of sales.
What to compare it with
Compare each stage with the same statement for earlier years: the margins show whether prices and direct costs (gross profit margin) or overheads (the gap down to the profit margin) explain a change. Compare the margins with similar businesses, and retained profit with the business’s plans for investment.
Why benchmarks vary
A healthy statement looks different in every industry. A retailer has a large cost of sales and a thin margin; a consultancy has almost no cost of sales but large expenses, mostly salaries. Over time, a business that is investing may show lower profit for a while, and choices such as how fast assets are depreciated change the figures, so compare like with like.
What a manager might do
Options for a manager, not IB requirements; each has a cost or a risk to weigh.
- Expenses take 34.6% of sales: compare that share with earlier years and similar businesses before cutting, and protect the spending that wins sales.
- Weigh dividends against retained profit: owners want a return now, but retained profit is the cheapest finance for growth.
Section 05: Learn more
- Notes 3.4 Final accounts The full notes for the subtopic.
- Formula sheet The formula sheet The formulae the examination provides, and the ones to learn, on one printable page.
- Practice Profit or loss, a practice question Fresh fictional figures, checked as you answer, with the working and the usual slips. Paper 2 style, the platform’s own.
- On a case Ratio desk (Halden Distribution’s accounts) The same idea worked on a fictional case at the Finance Desk.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/lab/profit-and-loss/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.