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.

  1. Costs and break-even 5 calculators
  2. Profit and statements 1 calculator
  3. Ratios 9 calculators
  4. Cash and budgets 2 calculators
  5. Investment 3 calculators

Open the laboratory

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.

  1. Costs and revenue

    Classify costs by behaviour and by traceability, then calculate revenue, total cost and profit.

    Case
    Atelier Barro
    IB
    3.3
    Interaction
    Cost classifier
  2. Break-even

    Contribution, break-even quantity and revenue, margin of safety, and the output or price for a target profit, with a live chart.

    Case
    Atelier Barro
    IB
    5.5
    Interaction
    Break-even workspace and error diagnosis
  3. Contribution decisions HL

    Judge a special order on contribution, and see when the rule of thumb fails because capacity runs out.

    Case
    Atelier Barro
    IB
    5.5
    Interaction
    Special order panel
  4. 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.

    Case
    Halden Distribution
    IB
    3.4, 3.5, 3.6
    Interaction
    Ratio desk
  5. 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.

    Case
    Atelier Barro
    IB
    3.7
    Interaction
    Cash flow lab
  6. 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.

    Case
    Halden Distribution
    IB
    3.8
    Interaction
    Investment appraisal desk

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.

Each subtopic with its notes, case workspaces and calculators
Subtopic Level Learn Practise on a case Calculators
3.1 Introduction to finance SL and HL Notes None yet None yet
3.2 Sources of finance SL and HL Notes None yet None yet
3.3 Costs and revenues SL and HL Subtopic page Costs and revenue None yet
3.4 Final accounts SL and HL Notes Ratio analysis Profit and loss builder
3.5 Profitability and liquidity ratio analysis SL and HL Notes Ratio analysis Gross profit margin , Profit margin , Return on capital employed (ROCE) , Current ratio , Acid test (quick) ratio
3.6 Efficiency ratio analysis HL only Notes Ratio analysis Gearing ratio , Stock turnover , Debtor days , Creditor days
3.7 Cash flow SL and HL Notes Cash flow Cash flow forecast
3.8 Investment appraisal SL and HL Notes Investment appraisal Payback period , Average rate of return (ARR) , Net present value (NPV)
3.9 Budgets HL only Notes None yet Budget variances
5.5 Break-even analysis SL and HL Notes Break-even
Contribution decisions
Break-even quantity , Break-even revenue , Margin of safety , Contribution per unit and total contribution , Output for a target profit

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.

Open the formula sheet
The calculation register: each calculation, its formula, its level, its subtopic and the calculator that works it with your own figures
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.

Open advanced financial analysis