Finance Desk
The numbers, and what they mean
Finance is where a business decision becomes a number you can test. The desk has three parts: a laboratory for your own figures, case workspaces where the numbers belong to a business in a situation, and the notes and formulas behind both. Every figure comes from one set of tested functions, shown with its working and what it means.
Your own figures
The Financial Laboratory
20 calculators for break-even, statements, ratios, cash flow, budgets and investment appraisal. Each shows the formula in the guide’s notation, the working step by step, a chart, a sensitivity table and what a manager might do. The example figures belong to Emberly Roasters, a fictional coffee roaster.
- Costs and break-even 5 calculators
- Profit and statements 1 calculator
- Ratios 9 calculators
- Cash and budgets 2 calculators
- Investment 3 calculators
- Break-even quantity
- 3,021 bags a month exactly 3,020.83, rounded up
- Gross profit margin, latest year
- 43.52% −2.48 percentage points on the previous year; worse
- Lowest closing balance
- −$25,700.00 March; beyond the overdraft limit
- Net present value at 8%
- $5,736 the returns are worth more today than the cost
- Data
- Emberly Roasters: fictional, simulated data.
Section 01: The case workspaces
Six desks, each working part of the course on a fictional case with simulated data, so the numbers have a business and a decision behind them.
-
Costs and revenue
Classify costs by behaviour and by traceability, then calculate revenue, total cost and profit.
-
Break-even
Contribution, break-even quantity and revenue, margin of safety, and the output or price for a target profit, with a live chart.
-
Contribution decisions HL
Judge a special order on contribution, and see when the rule of thumb fails because capacity runs out.
-
Ratio analysis
Profitability and liquidity ratios, and at HL the efficiency ratios and gearing, from two years of accounts in the IB layout, with strategies to try.
-
Cash flow
A six-month forecast in the IB layout: find when the cash runs short, reconcile profit with cash, and test ways of paying for a new kiln.
-
Investment appraisal
Payback period and average rate of return, and at HL net present value with the guide’s discount factors, on two projects you can change.
HL The contribution decisions desk is HL-only material, hidden while you are viewing SL content.
Section 02: The subtopics
Unit 3, Finance and accounts, and subtopic 5.5, Break-even analysis: where each is explained and where it is practised.
Notes are written one subtopic at a time and only when complete; a subtopic without them has a page with what the course asks, its key terms and diagrams.
Section 03: The formulas
The formula sheet on one printable page, and every calculation on the platform with its formula and where it is worked.
Formula sheet
The formulae the examination provides (Business management guide, pp. 64 to 65), and the standard ones it does not list but questions use, with the HL-only formulae marked.
| Calculation | Formula | Level | IB | Your figures |
|---|---|---|---|---|
| Total revenue | Total revenue = selling price per unit × quantity sold | SL and HL | 3.3 | Not in the laboratory |
| Total cost | Total cost = total fixed costs + (variable cost per unit × output) | SL and HL | 3.3 | Not in the laboratory |
| Profit or loss | Profit = total revenue − total cost | SL and HL | 3.3, 5.5 | Contribution per unit and total contribution |
| Contribution per unit | Contribution per unit = selling price per unit − variable cost per unit | SL and HL | 5.5 | Contribution per unit and total contribution |
| Total contribution | Total contribution = contribution per unit × quantity sold | SL and HL | 5.5 | Contribution per unit and total contribution |
| Break-even quantity | Break-even quantity = total fixed costs ÷ contribution per unit | SL and HL | 5.5 | Break-even quantity |
| Break-even revenue | Break-even revenue = break-even quantity × selling price per unit | SL and HL | 5.5 | Break-even revenue |
| Margin of safety | Margin of safety = actual or forecast output − break-even output | SL and HL | 5.5 | Margin of safety |
| Target profit output | Target profit output = (total fixed costs + target profit) ÷ contribution per unit | SL and HL | 5.5 | Output for a target profit |
| Target price | Target price = ((total fixed costs + target profit) ÷ expected sales) + variable cost per unit | SL and HL | 5.5 | Output for a target profit |
| Special order (contribution) | Change in profit = (order price − variable cost per unit) × order size − extra fixed costs caused by the order | HL only | 5.5 | Not in the laboratory |
| Labour turnover | Labour turnover = (number of employees leaving ÷ average number of employees) × 100 | HL only | 2.4 | Not in the laboratory |
| Expected value (decision trees) | Expected value = Σ (probability of outcome × payoff of outcome) − cost of the option | SL and HL | 1.5 | Not in the laboratory |
| Gross profit margin | Gross profit margin = (gross profit ÷ sales revenue) × 100 | SL and HL | 3.5 | Gross profit margin |
| Profit margin | Profit margin = (profit before interest and tax ÷ sales revenue) × 100 | SL and HL | 3.5 | Profit margin |
| Return on capital employed (ROCE) | ROCE = (profit before interest and tax ÷ capital employed) × 100, where capital employed = non-current liabilities + equity | SL and HL | 3.5 | Return on capital employed (ROCE) |
| Current ratio | Current ratio = current assets ÷ current liabilities | SL and HL | 3.5 | Current ratio |
| Acid test (quick) ratio | Acid test (quick) ratio = (current assets − stock) ÷ current liabilities | SL and HL | 3.5 | Acid test (quick) ratio |
| Stock turnover (number of times) | Stock turnover (number of times) = cost of sales ÷ average stock, where average stock = (opening stock + closing stock) ÷ 2 | HL only | 3.6 | Stock turnover |
| Stock turnover (number of days) | Stock turnover (number of days) = (average stock ÷ cost of sales) × 365 | HL only | 3.6 | Stock turnover |
| Debtor days | Debtor days = (debtors ÷ total sales revenue) × 365 | HL only | 3.6 | Debtor days |
| Creditor days | Creditor days = (creditors ÷ cost of sales) × 365 | HL only | 3.6 | Creditor days |
| Gearing ratio | Gearing ratio = (non-current liabilities ÷ capital employed) × 100, where capital employed = non-current liabilities + equity | HL only | 3.6 | Gearing ratio |
| Net cash flow | Net cash flow = total cash inflows − total cash outflows | SL and HL | 3.7 | Cash flow forecast |
| Closing balance | Closing balance = opening balance + net cash flow | SL and HL | 3.7 | Cash flow forecast |
| Payback period | Payback period = years before the cost is recovered + (amount still to recover ÷ net cash flow in the payback year) × 12 months | SL and HL | 3.8 | Payback period |
| Average rate of return (ARR) | ARR = ((total returns − capital cost) ÷ years of use) ÷ capital cost × 100 | SL and HL | 3.8 | Average rate of return (ARR) |
| Net present value (NPV) | NPV = sum of the present values of the returns − original cost | HL only | 3.8 | Net present value (NPV) |
The formulas are standard business arithmetic. Where a calculation sits in the IB syllabus is marked, with its verification status, on its card in the case workspaces.
Beyond the IB course For undergraduates, MBA students, professionals and teachers
Advanced financial analysis
Four tools that take the desk past the IB course: a forecast whose three statements link and balance, a capital budgeting comparator, break-even scenarios and a performance dashboard. Not needed for the IB and not assessed by it; each page says which parts the course uses.
- Integrated forecast Will the plan make a profit, and can the business pay for it, year by year?
- Capital budgeting comparator Which project adds most value, and how much do the answers depend on the estimates and the discount rate?
- Break-even scenarios Which cost structure earns more, at what volume does the answer change, and which carries more risk?
- Financial performance dashboard What has driven the return to the owners over several years, and how far can each measure be trusted?
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.