Advanced financial analysis · Beyond the IB course
Integrated forecast
Will the plan make a profit, and can the business pay for it, year by year?
Back to 3.4 Final accounts Also for 3.7 Cash flow, 3.5 Profitability and liquidity ratio analysis and 3.6 Efficiency ratio analysis (HL)
- Beyond the IB course
- Builds on IB 3.4, 3.5, 3.6, 3.7
- Undergraduate, MBA, professional and teacher
- Simulated data Example: Emberly Roasters, fictional
The forecast
Example figures: Emberly Roasters, a fictional business. Simulated data.
The forecast could not start. The worked example below uses the example figures.
The drivers and the opening position
- Years
- 5, from 2026
- Units sold in year one
- 43,200
- Growth in units, a year
- 4%
- Selling price per unit, year one
- $24
- Price rise, a year
- 2%
- Variable cost per unit, year one
- $14.40
- Fixed costs, year one
- $348,000
- Cost inflation, a year
- 2.50%
- Capital expenditure, each year
- $15,000
- Life of new assets, years
- 8
- Years left in the assets owned now
- 10
- Debtor days
- 37
- Stock days
- 45
- Creditor days
- 49
- Interest rate
- 6%
- Borrowing repaid each year
- $40,200
- Tax rate
- 25%
- Dividends, share of profit
- 35%
- Opening: non-current assets (net book value)
- $358,000
- Opening: stock
- $66,800
- Opening: debtors
- $97,300
- Opening: cash (negative if overdrawn)
- $8,400
- Opening: trade creditors
- $72,600
- Opening: borrowings
- $201,000
- Opening: share capital
- $100,000
- Upside: units sold
- +3%
- Upside: growth in units, percentage points
- +1.5 points
- Upside: selling price
- +1%
- Upside: variable cost per unit
- 0%
- Upside: fixed costs
- 0%
- Downside: units sold
- −5%
- Downside: growth in units, percentage points
- −2 points
- Downside: selling price
- −1%
- Downside: variable cost per unit
- +1%
- Downside: fixed costs
- 0%
- Alternative A
- Automate the packing
- Automate the packing: investment in year one
- $180,000
- Automate the packing: new borrowing in year one
- $150,000
- Automate the packing: change in variable cost per unit
- −$1.10
- Automate the packing: change in fixed costs, a year
- $9,000
- Automate the packing: change in units sold
- 0%
- Alternative B
- Outsource the packing
- Outsource the packing: investment in year one
- $0
- Outsource the packing: new borrowing in year one
- $0
- Outsource the packing: change in variable cost per unit
- $0.50
- Outsource the packing: change in fixed costs, a year
- −$40,800
- Outsource the packing: change in units sold
- 0%
Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures 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 inputs to update them.
Showing the Base case: Making no change.
Lowest year-end cash
−$14,425
an overdraft at the end of 2027; overdrawn at 4 of 5 year-ends
- Profit for the year, 2026
- $12,7392030: $58,575
- Profit over 5 years
- $172,806
- Cash at the end of 2030
- $19,054in the bank
- Net cash at the end of 2030
- $19,054cash less borrowing and any overdraft
- ROCE, 2030 IB
- 21.8%the IB’s formula, on closing capital employed
- Balance check
- Balances every yearassets − liabilities = equity
Section 01: The three statements
The statement of profit or loss, the statement of cash flows and the statement of financial position for the case in view, linked year by year.
| $ | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Sales revenue | 1,036,800 | 1,099,837 | 1,166,723 | 1,237,689 | 1,312,977 |
| Cost of sales (variable costs) | (622,080) | (663,137) | (706,949) | (753,693) | (803,049) |
| Gross profit | 414,720 | 436,700 | 459,774 | 483,996 | 509,928 |
| Fixed costs | (348,000) | (356,700) | (365,618) | (374,758) | (384,127) |
| Depreciation | (37,675) | (39,550) | (41,425) | (43,300) | (45,175) |
| Profit before interest and tax | 29,045 | 40,450 | 52,731 | 65,938 | 80,626 |
| Interest | (12,060) | (10,106) | (8,102) | (5,589) | (2,526) |
| Profit before tax | 16,985 | 30,344 | 44,629 | 60,349 | 78,100 |
| Tax | (4,246) | (7,586) | (11,157) | (15,087) | (19,525) |
| Profit for the year | 12,739 | 22,758 | 33,472 | 45,262 | 58,575 |
| Dividends | (4,459) | (7,965) | (11,715) | (15,842) | (20,501) |
| Retained profit | 8,280 | 14,793 | 21,757 | 29,420 | 38,074 |
| $ | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Cash flows from operating activities | |||||
| Profit for the year | 12,739 | 22,758 | 33,472 | 45,262 | 58,575 |
| Add back depreciation | 37,675 | 39,550 | 41,425 | 43,300 | 45,175 |
| (Increase) or decrease in stock | (9,895) | (5,062) | (5,401) | (5,763) | (6,085) |
| (Increase) or decrease in debtors | (7,800) | (6,390) | (6,781) | (7,193) | (7,632) |
| Increase or (decrease) in trade creditors | 10,912 | 5,512 | 5,881 | 6,276 | 6,626 |
| Net cash from operating activities | 43,631 | 56,368 | 68,596 | 81,882 | 96,659 |
| Cash flows from investing activities | |||||
| Purchase of non-current assets | (15,000) | (15,000) | (15,000) | (15,000) | (15,000) |
| Net cash used in investing activities | (15,000) | (15,000) | (15,000) | (15,000) | (15,000) |
| Cash flows from financing activities | |||||
| New borrowing | 0 | 0 | 0 | 0 | 0 |
| Borrowing repaid | (40,200) | (40,200) | (40,200) | (40,200) | (40,200) |
| Dividends paid | (4,459) | (7,965) | (11,715) | (15,842) | (20,501) |
| Net cash from financing activities | (44,659) | (48,165) | (51,915) | (56,042) | (60,701) |
| Net change in cash | (16,028) | (6,797) | 1,681 | 10,840 | 20,958 |
| Cash at the start of the year | 8,400 | (7,628) | (14,425) | (12,744) | (1,904) |
| Cash at the end of the year | (7,628) | (14,425) | (12,744) | (1,904) | 19,054 |
Negative figures in brackets, as in the guide’s layouts. Interest and tax are paid in the year they are charged, so they sit inside the profit for the year; a published statement of cash flows would show them on lines of their own.
| $ | Start of 2026 | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|---|
| Non-current assets (net book value) | 358,000 | 335,325 | 310,775 | 284,350 | 256,050 | 225,875 |
| Current assets | ||||||
| Cash | 8,400 | 0 | 0 | 0 | 0 | 19,054 |
| Debtors | 97,300 | 105,100 | 111,490 | 118,271 | 125,464 | 133,096 |
| Stock | 66,800 | 76,695 | 81,757 | 87,158 | 92,921 | 99,006 |
| Total current assets | 172,500 | 181,795 | 193,247 | 205,429 | 218,385 | 251,156 |
| Total assets | 530,500 | 517,120 | 504,022 | 489,779 | 474,435 | 477,031 |
| Current liabilities | ||||||
| Bank overdraft | 0 | 7,628 | 14,425 | 12,744 | 1,904 | 0 |
| Trade creditors | 72,600 | 83,512 | 89,024 | 94,905 | 101,181 | 107,807 |
| Total current liabilities | 72,600 | 91,140 | 103,449 | 107,649 | 103,085 | 107,807 |
| Non-current liabilities: borrowings | 201,000 | 160,800 | 120,600 | 80,400 | 40,200 | 0 |
| Total liabilities | 273,600 | 251,940 | 224,049 | 188,049 | 143,285 | 107,807 |
| Net assets | 256,900 | 265,180 | 279,973 | 301,730 | 331,150 | 369,224 |
| Equity | ||||||
| Share capital | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 |
| Retained earnings | 156,900 | 165,180 | 179,973 | 201,730 | 231,150 | 269,224 |
| Total equity | 256,900 | 265,180 | 279,973 | 301,730 | 331,150 | 369,224 |
Section 02: Measures year by year
The IB’s ratios where the course has them, and measures beyond it, for the case in view.
| Measure | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Units sold | 43,200 | 44,928 | 46,725 | 48,594 | 50,538 |
| Gross margin | 40.0% | 39.7% | 39.4% | 39.1% | 38.8% |
| Profit margin (IB 3.5) | 2.8% | 3.7% | 4.5% | 5.3% | 6.1% |
| ROCE (IB 3.5) | 6.8% | 10.1% | 13.8% | 17.8% | 21.8% |
| Gearing (IB 3.6, HL) | 37.7% | 30.1% | 21.0% | 10.8% | 0.0% |
| Current ratio (IB 3.5) | 1.99 | 1.87 | 1.91 | 2.12 | 2.33 |
| Interest cover | 2.4 times | 4.0 times | 6.5 times | 11.8 times | 31.9 times |
| Break-even units, before interest | 40,175 | 40,767 | 41,367 | 41,974 | 42,548 |
| Degree of operating leverage | 14.28 | 10.80 | 8.72 | 7.34 | 6.32 |
| Net debt (negative: net cash) | $168,428 | $135,025 | $93,144 | $42,104 | −$19,054 |
Section 03: Base, upside and downside
The same plan with the drivers moved: how far profit and cash move with them, for the option in view.
| Measure | Base case | Upside | Downside |
|---|---|---|---|
| Sales revenue, 2030 | $1,312,977 | $1,446,428 | $1,142,560 |
| Profit for the year, 2026 | $12,739 | $30,079 | −$19,347 |
| Profit for the year, 2030 | $58,575 | $104,107 | −$9,777 |
| Profit over 5 years | $172,806 | $327,416 | −$74,238 |
| Lowest year-end cash | −$14,425 (2027) | −$389 (2026) | −$151,221 (2030) |
| Cash at the end of 2030 | $19,054 | $106,821 | −$151,221 |
| Net debt at the end of 2030 (negative: net cash) | −$19,054 | −$106,821 | $151,221 |
| ROCE, 2030 | 21.8% | 30.1% | 0.1% |
The chart’s figures as a table
| Year | Base case | Upside | Downside |
|---|---|---|---|
| 2026 | −$7,628 | −$389 | −$29,279 |
| 2027 | −$14,425 | $6,282 | −$65,735 |
| 2028 | −$12,744 | $25,792 | −$98,487 |
| 2029 | −$1,904 | $58,857 | −$127,236 |
| 2030 | $19,054 | $106,821 | −$151,221 |
Reading. Profit over the 5 years is −$74,238 in the downside, $172,806 in the base case and $327,416 in the upside. The swing is wide because the margin is thin: in 2026 the base case’s degree of operating leverage is 14.3, so a 1% change in units sold, at the same prices and costs, moves profit before interest and tax by about 14.3%. In the downside the overdraft reaches $151,221 at the end of 2030: the size of the facility, or the new finance, the plan would need if things go badly. Scenarios are not predictions: they show how far the result moves when the drivers do, so the board knows which assumptions the plan depends on.
Section 04: Two strategic alternatives, side by side
Each alternative run through every statement, then every scenario with every option.
| Measure | Making no change | Automate the packing | Outsource the packing |
|---|---|---|---|
| Investment in 2026 | $0 | $180,000 | $0 |
| Break-even units, 2026 | 40,175 | 38,989 | 37,899 |
| Operating leverage, 2026 | 14.28 | 10.26 | 8.15 |
| Profit for the year, 2026 | $12,739 | $18,004 | $27,139 |
| Profit for the year, 2030 | $58,575 | $73,448 | $71,212 |
| Profit over 5 years | $172,806 | $223,903 | $242,787 |
| Lowest year-end cash | −$14,425 (2027) | −$12,225 (2026) | $1,969 (2026) |
| Net debt at the end of 2030 (negative: net cash) | −$19,054 | $15,904 | −$64,852 |
| ROCE, 2030 | 21.8% | 19.8% | 23.5% |
The chart’s figures as a table
| Year | Making no change | Automate the packing | Outsource the packing |
|---|---|---|---|
| 2026 | $12,739 | $18,004 | $27,139 |
| 2027 | $22,758 | $30,083 | $37,281 |
| 2028 | $33,472 | $44,056 | $48,048 |
| 2029 | $45,262 | $58,312 | $59,107 |
| 2030 | $58,575 | $73,448 | $71,212 |
Reading. Base case: the most profit over the 5 years comes from Outsource the packing, $242,787, against $223,903 (Automate the packing) and $172,806 (Making no change). But Automate the packing earns the most in 2030 ($73,448, against $71,212): it is catching up, and over a longer horizon the order could change. Automate the packing needs $180,000 in 2026, $150,000 of it borrowed; its net debt at the end of 2030 is $15,904. Outsource the packing puts the least strain on cash: its lowest year-end balance is $1,969.
Every scenario with every option
| Option | Base case | Upside | Downside |
|---|---|---|---|
| Making no change | $172,806 | $327,416 | −$74,238 |
| Automate the packing | $223,903 | $389,871 | −$23,728 |
| Outsource the packing | $242,787 | $390,009 | $29,224 |
Reading. On profit over the whole forecast, Outsource the packing comes first in every scenario: a choice that wins whichever way the drivers move is robust. Its narrowest lead is in the upside, $138 over Automate the packing, so a small change in the drivers could reverse it.
Section 05: What it means
For the case in view: the reading, then what a forecast like this cannot tell you.
The reading
In the case shown (Base case: Making no change), sales revenue moves from $1,036,800 in 2026 to $1,312,977 in 2030, and the profit for the year from $12,739 to $58,575: $172,806 over the 5 years. The profit margin, the IB’s profit before interest and tax as a share of sales revenue, moves from 2.8% to 6.1%.
Cash is lowest at the end of 2027, an overdraft of $14,425 (overdrawn at 4 of 5 year-ends), and 2030 ends with $19,054 in the bank. All the borrowing has been repaid by then.
Profit is not cash. Over the 5 years the business earns $172,806 of profit and generates $347,136 of cash from its operations: the profit, plus $207,125 of depreciation (a cost that uses no cash), less $32,795 tied up in more stock and debtors than extra supplier credit pays for. Capital expenditure of $75,000, the repayments and the dividends then come out of that cash.
The statement of financial position balances in every year: assets less liabilities equal equity, because the cash on it is the cash the statement of cash flows arrives at.
Where a forecast stops
- A forecast is only as good as its drivers, and small errors compound: a growth rate a point too high adds up over five years.
- Scenarios are not probabilities. In practice the drivers move together, and a downside often brings lower prices and lower volume at once.
- Year-end figures hide what happens within a year: a business can run out of cash in March and look healthy in December. A cash flow forecast by month, such as the Financial Laboratory’s, shows the months.
- The forecast stops after a few years, so an investment that pays off later looks worse here than over its life. Value it over its whole life with the capital budgeting comparator.
- Interest, tax and dividends are simplified, and all borrowing sits on one line.
Section 06: How the model works
The assumptions behind every figure, stated so they can be challenged.
- Units sold grow by the growth rate from year two; the price rises by its own rate; the variable cost per unit and the fixed costs rise with cost inflation. Every figure is rounded to a whole unit of money as it is worked out, so every total adds up exactly.
- Cost of sales is every cost that varies with output. For Emberly Roasters that includes delivery, so its gross margin is not directly comparable with the 2025 accounts, whose cost of sales leaves delivery among the expenses.
- Depreciation is straight line: the assets owned at the start over the years left in them, and each year’s capital expenditure over its life, with a full year’s charge in the year of purchase.
- Year-end debtors are sales revenue × debtor days ÷ 365; stock and trade creditors are cost of sales × days ÷ 365. The IB’s stock turnover uses average stock; a forecast sets the closing balance instead.
- Interest is charged on the borrowing and any overdraft at the start of each year, with new borrowing drawn at the start of year one. Tax is a rate on profit before tax, none on a loss; both are paid in the year. Dividends are a share of the profit for the year, none from a loss.
- The first year uses the Financial Laboratory’s month of 2026 for twelve months: a price of $24.00 a bag, a variable cost of $14.40 and fixed costs of $29,000 a month. The opening position is the lab’s statement of financial position at 31 December 2025, with its short-term loans and long-term borrowing on one line.
Section 07: 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.4 Final accounts SL and HL The statement of profit or loss and the statement of financial position, and their layouts. Guide, p. 29; layouts pp. 59 to 63
- 3.4 Final accounts HL only Depreciation by the straight line method, used here for every asset. Guide, p. 29
- 3.7 Cash flow SL and HL The difference between profit and cash flow, working capital, cash flow forecasts, and the relationship between investment, profit and cash flow. Guide, p. 29
- 3.5 Profitability and liquidity ratio analysis SL and HL The profit margin, ROCE and the current ratio, reported for each forecast year. Guide, p. 29
- 3.6 Efficiency ratio analysis HL only Debtor days, creditor days and stock turnover in days, used here to set the year-end balances; the gearing ratio. Guide, p. 29
Beyond the IB course What this tool adds
- A statement of cash flows built from profit (the indirect method). The IB’s cash flow forecast lists receipts and payments instead.
- Linking the three statements so that the balance sheet balances in every year.
- Forecasting several years from drivers: volume, price, growth, costs, capital expenditure and working capital days.
- Base, upside and downside scenarios, and two strategic alternatives compared through every statement.
- Interest cover, net debt and the degree of operating leverage for each year.
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 08: 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.
- Valuation: Measuring and Managing the Value of Companies, 7th edition Tim Koller, Marc Goedhart and David Wessels (McKinsey & Company), John Wiley & Sons, 2020
- Principles of Corporate Finance, 13th edition Richard A. Brealey, Stewart C. Myers and Franklin Allen, McGraw-Hill Education, 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 09: 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 Profit and loss builder IB 3.4, SL and HL. What profit is left at each stage, from sales revenue to retained profit?
- Laboratory Cash flow forecast IB 3.7, SL and HL. Will the business have enough cash at the end of each month?
- 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 Cash flow lab (Atelier Barro) The same ideas worked on a fictional case at the Finance Desk.
- 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/integrated-forecast/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.