Advanced financial analysis · Beyond the IB course
Financial performance dashboard
What has driven the return to the owners over several years, and how far can each measure be trusted?
Back to 3.5 Profitability and liquidity ratio analysis Also for 3.6 Efficiency ratio analysis (HL)
- Beyond the IB course
- Builds on IB 3.5, 3.6
- Undergraduate, MBA, professional and teacher
- Simulated data Example: Emberly Roasters, fictional
The dashboard
Example figures: Emberly Roasters, a fictional business. Simulated data.
The dashboard could not start. The worked example below uses the example figures.
The accounts
| Line | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|
| Stock at the start of 2022 | $27,400 | |||
| Sales revenue | $640,000 | $742,000 | $855,600 | $958,800 |
| Cost of sales | $332,000 | $393,000 | $462,000 | $541,500 |
| Expenses | $230,000 | $262,000 | $298,500 | $332,100 |
| Interest | $4,500 | $4,000 | $3,200 | $9,600 |
| Tax | $18,375 | $20,750 | $23,000 | $18,900 |
| Dividends | $18,000 | $20,000 | $24,000 | $20,000 |
| Property, plant and equipment | $210,000 | $260,000 | $336,000 | $486,000 |
| Accumulated depreciation | $44,000 | $68,000 | $96,000 | $128,000 |
| Cash | $2,250 | $7,900 | $11,400 | $8,400 |
| Debtors | $52,000 | $62,000 | $72,700 | $97,300 |
| Stock | $31,600 | $38,900 | $47,200 | $66,800 |
| Bank overdraft | $0 | $0 | $0 | $0 |
| Trade creditors | $33,800 | $41,500 | $52,100 | $72,600 |
| Other short-term loans | $10,000 | $14,000 | $19,000 | $41,000 |
| Long-term borrowings | $75,000 | $70,000 | $80,000 | $160,000 |
| Share capital | $100,000 | $100,000 | $100,000 | $100,000 |
| Retained earnings | $33,050 | $75,300 | $120,200 | $156,900 |
Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the accounts above.
Your figures are kept in this browser once you change them. Nothing is sent anywhere.
Result
These results are for the last complete figures. Correct the figure marked in the accounts to update them.
Return on equity, 2025
22.1%
down from 41.4% in 2022
The accounts agree
Every year’s statement of financial position balances, and retained earnings carry from each year to the next.
- Net profit margin, 2025 Beyond the IB course
- 5.9%2024: 8.1%
- Asset turnover, 2025 Beyond the IB course
- 1.81 times2024: 2.30 times
- Equity multiplier, 2025 Beyond the IB course
- 2.07 times2024: 1.69 times
- Cash conversion cycle, 2025 Beyond the IB course
- 26.5 days2024: 23.9 days
- Interest cover, 2025 Beyond the IB course
- 8.9 times2024: 29.7 times
- Gearing, 2025 IB HL
- 38.4%the IB’s formula (3.6, HL)
Section 01: Return on equity, taken apart
The DuPont identity: net profit margin × asset turnover × equity multiplier, and the margin split further into tax, interest and operations.
| Measure | Standing | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Return on equity (ROE) | Beyond the IB course | 41.4% | 35.5% | 31.3% | 22.1% |
| = Net profit margin | Beyond the IB course | 8.6% | 8.4% | 8.1% | 5.9% |
| × Asset turnover | Beyond the IB course | 2.5412 | 2.4668 | 2.3043 | 1.8074 |
| × Equity multiplier | Beyond the IB course | 1.8929 | 1.7159 | 1.6862 | 2.0650 |
| Net profit margin = tax burden | Beyond the IB course | 0.7500 | 0.7500 | 0.7497 | 0.7500 |
| × Interest burden | Beyond the IB course | 0.9423 | 0.9540 | 0.9664 | 0.8873 |
| × Operating margin (the IB’s profit margin) | IB | 12.2% | 11.7% | 11.1% | 8.9% |
Check, 2025: 5.9136% × 1.8074 × 2.0650 = 22.07%, the ROE of 22.07%. Sales revenue and total assets cancel, which is why the three always multiply to ROE.
The chart’s figures as a table
| Year | ROE | Net margin | Asset turnover | Equity multiplier |
|---|---|---|---|---|
| 2022 | 41.4% | 8.6% | 2.54 | 1.89 |
| 2023 | 35.5% | 8.4% | 2.47 | 1.72 |
| 2024 | 31.3% | 8.1% | 2.30 | 1.69 |
| 2025 | 22.1% | 5.9% | 1.81 | 2.07 |
How much of each change each factor accounts for
| Change | ROE change | Net margin | Asset turnover | Equity multiplier |
|---|---|---|---|---|
| 2022 to 2023 | −5.92 | −1.01 | −1.14 | −3.77 |
| 2023 to 2024 | −4.22 | −1.37 | −2.27 | −0.58 |
| 2024 to 2025 | −9.22 | −8.16 | −6.42 | +5.35 |
| 2022 to 2025 | −19.36 | −11.56 | −10.48 | +2.68 |
Each factor’s part is its proportional change, measured in logarithms, weighted so that the three parts add up exactly to the change in ROE. The order in which the factors are taken makes no difference.
Reading. ROE fell by 9.2 points from 2024 to 2025: the lower net margin accounts for 8.2 points of the fall and the lower asset turnover for 6.4 points; the higher equity multiplier (more leverage) added 5.4 points back. ROE fell by 19.4 points from 2022 to 2025: the lower net margin accounts for 11.6 points of the fall and the lower asset turnover for 10.5 points; the higher equity multiplier (more leverage) added 2.7 points back.
Section 02: The cash conversion cycle
Days of stock plus days of credit to customers, less days of credit from suppliers: how long cash is tied up in trading.
| Measure | Standing | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stock days (average stock) | IB HL | 32.4 | 32.7 | 34.0 | 38.4 |
| + Debtor days | IB HL | 29.7 | 30.5 | 31.0 | 37.0 |
| − Creditor days | IB HL | 37.2 | 38.5 | 41.2 | 48.9 |
| = Cash conversion cycle, days | Beyond the IB course | 24.9 | 24.7 | 23.9 | 26.5 |
| One day of cost of sales | Beyond the IB course | $910 | $1,077 | $1,266 | $1,484 |
The chart’s figures as a table
| Year | Stock days | Debtor days | Creditor days | Cycle |
|---|---|---|---|---|
| 2022 | 32.4 | 29.7 | 37.2 | 24.9 |
| 2023 | 32.7 | 30.5 | 38.5 | 24.7 |
| 2024 | 34.0 | 31.0 | 41.2 | 23.9 |
| 2025 | 38.4 | 37.0 | 48.9 | 26.5 |
Section 03: Interest cover and gearing
How comfortably profit covers interest, and how much of the business is financed by borrowing.
| Measure | Standing | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Interest cover (times) | Beyond the IB course | 17.3 | 21.8 | 29.7 | 8.9 |
| Gearing (non-current liabilities ÷ capital employed) | IB HL | 36.0% | 28.5% | 26.6% | 38.4% |
| All borrowing ÷ equity | Beyond the IB course | 63.9% | 47.9% | 45.0% | 78.2% |
The chart’s figures as a table
| Year | Interest cover | Gearing (IB) | All borrowing ÷ equity |
|---|---|---|---|
| 2022 | 17.3 times | 36.0% | 63.9% |
| 2023 | 21.8 times | 28.5% | 47.9% |
| 2024 | 29.7 times | 26.6% | 45.0% |
| 2025 | 8.9 times | 38.4% | 78.2% |
Section 04: Reading each measure
What each movement means for these figures, and where each measure stops.
Return on equity Beyond the IB course
ROE fell by 19.4 points from 2022 to 2025: the lower net margin accounts for 11.6 points of the fall and the lower asset turnover for 10.5 points; the higher equity multiplier (more leverage) added 2.7 points back. In 2025 more leverage held ROE up while the business earned less on each sale and on its assets: a weaker kind of return than the figure alone suggests.
Where it stops. ROE rises with borrowing as well as with better trading, so a higher ROE can mean more risk rather than better performance. Book equity reflects past profits and accounting choices, not what the shares are worth, and with small or negative equity the ratio means little.
Net profit margin Beyond the IB course
Profit for the year was 5.9% of sales revenue in 2025, against 8.6% in 2022. Within it, the operating margin (the IB’s profit margin) fell from 12.2% to 8.9%, and the interest burden fell from 0.942 to 0.887: interest took a larger share of the operating profit.
Where it stops. It is struck after interest and tax, so financing and tax decisions move it as well as trading. Margins differ widely between industries, so compare it with the business’s own past and with businesses in the same industry.
Asset turnover Beyond the IB course
Each $1 of assets produced $2.54 of sales revenue in 2022 and $1.81 in 2025: the assets grew faster than the sales they produce, as happens while new investment is still to earn its keep. Sales revenue grew 50% over the period and total assets 111%.
Where it stops. Old, heavily depreciated assets make turnover look high, and new investment makes it fall before the sales it was bought for arrive. Year-end assets may not represent the year, and assets that are leased or not on the statement change the picture.
Equity multiplier Beyond the IB course
Total assets were 1.89 times equity in 2022 and 2.07 times in 2025: a larger share of the assets is now financed by liabilities, which lifts ROE while profits hold but deepens any fall.
Where it stops. It counts every liability, trade creditors included, not only borrowing, so read it beside gearing and interest cover.
Cash conversion cycle Beyond the IB course
The cycle rose from 24.9 days to 26.5 days. Stock days rose from 32.4 to 38.4, debtor days rose from 29.7 to 37.0 and creditor days rose from 37.2 to 48.9. Stock and customers now take 13.4 more days between them, and 88% of that has been funded by paying suppliers 11.8 days later: the cycle looks steadier than the business behind it. In 2025 one day of the cycle ties up about $1,484, a day of cost of sales.
Where it stops. It is built from year-end balances, so a seasonal business can look better or worse than it is. A short cycle bought by paying suppliers late can cost discounts and goodwill. The IB’s creditor days divide by cost of sales, not by purchases, and stock days here use average stock, as the guide does.
Interest cover Beyond the IB course
Profit before interest and tax covered the interest 17.3 times in 2022 and 8.9 times in 2025. Profit could fall by 89% before it no longer covered the interest, against 94% in 2022: the cushion for lenders is thinner.
Where it stops. Profit is not cash, and cover ignores the repayments of the loans themselves, which also need cash; one year’s profit can be unusual. Lenders often write a minimum cover into a loan agreement, so a fall can matter before the interest becomes hard to pay.
Gearing IB HL
The IB’s gearing ratio, long-term borrowing as a share of capital employed, rose from 36.0% to 38.4%. Counting short-term loans and any overdraft too, borrowing rose from 63.9% to 78.2% of equity.
Where it stops. The guide’s ratio counts only non-current liabilities, so short-term loans and an overdraft, which can be large, are left out; both measures use book values, not what the debt or the business would fetch.
Section 05: The IB’s ratios, for comparison
The same years through the ratios the IB course uses, with the guide’s formulas.
| Measure | Standing | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gross profit margin | IB | 48.1% | 47.0% | 46.0% | 43.5% |
| Profit margin | IB | 12.2% | 11.7% | 11.1% | 8.9% |
| ROCE | IB | 37.5% | 35.5% | 31.7% | 20.4% |
| Current ratio | IB | 1.96 | 1.96 | 1.85 | 1.52 |
| Acid test ratio | IB | 1.24 | 1.26 | 1.18 | 0.93 |
| Stock turnover, days | IB HL | 32.4 | 32.7 | 34.0 | 38.4 |
| Debtor days | IB HL | 29.7 | 30.5 | 31.0 | 37.0 |
| Creditor days | IB HL | 37.2 | 38.5 | 41.2 | 48.9 |
| Gearing ratio | IB HL | 36.0% | 28.5% | 26.6% | 38.4% |
Section 06: Where the IB course stops
What this tool takes from the IB course, and what it adds beyond it.
IB What the IB course uses
- 3.5 Profitability and liquidity ratio analysis SL and HL The gross profit margin, the profit margin, ROCE, the current ratio and the acid test ratio. Guide, p. 29; formula sheet p. 64
- 3.6 Efficiency ratio analysis HL only Stock turnover, debtor days, creditor days and the gearing ratio, with the guide’s definitions of average stock and capital employed. Guide, p. 29; formula sheet p. 64
Beyond the IB course What this tool adds
- Return on equity, and the DuPont split into net profit margin, asset turnover and the equity multiplier, with the extended split of the margin.
- How much of each change in return on equity each factor accounts for.
- The cash conversion cycle: stock days plus debtor days less creditor days.
- Interest cover, and all borrowing as a share of equity beside the guide’s gearing ratio.
The course’s content is described in the platform’s words from the Business management guide (first assessment 2024), checked against the guide on 29 October 2026; see the claims register. The formulas the guide gives are on the formula sheet. Nothing on this page is an IB method unless it is marked IB, and no question here is an IB question.
Section 07: Sources
The method rests on standard references, cited here and in the source register. They were not opened for this release; the explanations are the platform’s own.
- A cash conversion cycle approach to liquidity analysis Verlyn D. Richards and Eugene J. Laughlin, Financial Management, volume 9, number 1, pages 32 to 38, 1980
- Valuation: Measuring and Managing the Value of Companies, 7th edition Tim Koller, Marc Goedhart and David Wessels (McKinsey & Company), John Wiley & Sons, 2020
- Business management guide, first assessment 2024 (published February 2022, updated May 2022) International Baccalaureate Organization, 2022
- How the advanced mode's example figures were built Arjun Agrawal | The Business Brief, 2026
Section 08: The IB parts, worked on their own
The Financial Laboratory and the Finance Desk work the parts the IB course uses, with the guide’s formulas and layouts.
- Laboratory Return on capital employed (ROCE) IB 3.5, SL and HL. What return does the long-term finance in the business earn?
- Laboratory Profit margin IB 3.5, SL and HL. What share of each sale is left after all the costs of running the business?
- Laboratory Gearing ratio IB 3.6, HL only. How much of the long-term finance is borrowed?
- Laboratory Debtor days IB 3.6, HL only. How long do customers take to pay?
- Laboratory Creditor days IB 3.6, HL only. How long does the business take to pay its suppliers?
- Laboratory Stock turnover IB 3.6, HL only. How quickly does stock sell? (Also called inventory turnover.)
- On a case Ratio desk (Halden Distribution) The same ideas worked on a fictional case at the Finance Desk.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/advanced/performance-dashboard/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.